Mass delete unapproved comments in WordPress 

1
DELETE FROM wp_comments WHERE comment_approved=0;