If you have a site where people can submit posts for approval or any other similar setup you might find yourself one day with hundreds, maybe even thousands of pending posts created by robots. If this is the case (or you need to delete a lot of pending posts for any other reason) you’ll find that WordPress does not do a great job at giving you the tools to fix this. The best the WordPress admin interface will do is allow you to delete posts 20 at a time…

There is another option though. You can log in to your phpMyadmin and delete all pending posts from there in just a couple of minutes. This is the command you should run:

Remember to update the “wp_post” part of the command if your data base uses a different prefix than the WP standard.