1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

WP Plugin To Remove Posts With 0 Views?

Discussion in 'Blogging' started by briannz, Jan 7, 2012.

  1. briannz

    briannz Junior Member

    Joined:
    Mar 18, 2010
    Messages:
    119
    Likes Received:
    22
    Location:
    Aotearoa
    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.