I'm running the latest version of WP. I have a blog that has 39,263 comments waiting for moderation. Deleting them via the wp-admin interface sounds years of work.
Could somebody give me the SQL query to delete the awaiting for moderation comments?
And I do use Akismet. I installed it after I discovered the huge amount of spam. In 2.3 clicking to recheck the queue resulted in blank page. In 2.6 it says the queue is empty.