I have an autoblog which has over 9000 posts and I want to clean it up. I thought that deleting all old posts which have had 0 views would be a good start. Does anyone know of a Worpdress plugin which will do this? I've done a search and can't seem to find one. I guess it would be just a matter of using a database query but I don't know where to start. I found this on a website but am unsure how to use it. SELECT * FROM `wp_posts` , `wp_postmeta` WHERE `post_type` = 'post' AND post_id = ID AND DATEDIFF( NOW( ) , `post_date` ) >400 AND meta_key = "views" AND meta_value =0; Any help would be appreciated.