I have an autoblog which has over 9000 posts and I want to clean it ...
-
WP Plugin To Remove Posts With 0 Views?
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.
-
-
Similar Threads
-
By sampo1time in forum Black Hat SEO Tools
Replies: 4
Last Post: 01-30-2012, 08:03 PM
-
By theindiaphile in forum Black Hat SEO
Replies: 8
Last Post: 12-28-2011, 07:06 PM
-
By BlackMelvyn in forum Blogging
Replies: 147
Last Post: 02-04-2011, 12:28 PM
-
By ugly29 in forum Blogging
Replies: 0
Last Post: 01-13-2009, 08:37 AM
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks