WP Plugin To Remove Posts With 0 Views?

briannz

Junior Member
Joined
Mar 18, 2010
Messages
119
Reaction score
23
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.
 
Back
Top