Under my account I clicked the Author link to see the titles I had authored and could some some titles I definitely did not author that are pending validation!

e.g.

15AS 20,000 Leagues Under the Sea (1954) <== TITLE PENDING VALIDATION
88C51-6111 ??? 1984.12.30 <== TITLE PENDING VALIDATION

This was working correctly a few days ago so this seems to be a problem that has occurred very recently.

Good catch.

I was also trying to list titles for which you have inserted a note/comment but somehow looking for pending titles was finding weird things.

I removed the note/comment part of the SQL statement and now you have rightly "author = validated + pending".

In your case: 589 = 402 + 187.

Julien