Ever get bombarded by a spammer in your ExpressionEngine comment system and want to delete, say 16,747 pending comments all at once? Run the following query on your MySQL database and kiss that spam goodbye. (Please, make a backup on your database before doing this though!)
DELETE FROM exp_comments WHERE exp_comments.`status` = 'p';
Spam be gone.