Results 1 to 6 of 6

Thread: need SQL query for pruning old ads

  1. #1
    Thread Starter
    muhabat's Avatar
    Join Date
    Jul 2010
    Posts
    110
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Question need SQL query for pruning old ads

    HI,
    I want to prune old ads but with 0 views. What i need an sql query to prune ads older than x days but with zero views.

    Any help will be of great value.

    Best Regards,

  2. #2
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    36,082
    Thanks
    158
    Thanked 2,884 Times in 2,760 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.

  3. #3
    Thread Starter
    muhabat's Avatar
    Join Date
    Jul 2010
    Posts
    110
    Thanks
    2
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    Thread Starter
    muhabat's Avatar
    Join Date
    Jul 2010
    Posts
    110
    Thanks
    2
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #5
    Thread Starter
    muhabat's Avatar
    Join Date
    Jul 2010
    Posts
    110
    Thanks
    2
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. #6
    Thread Starter
    muhabat's Avatar
    Join Date
    Jul 2010
    Posts
    110
    Thanks
    2
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. What to expect from 'Ad Pruning'/Cron.
    By igorsandee in forum Report ClassiPress Bugs
    Replies: 1
    Last Post: February 21st, 2011, 11:54 PM
  2. Pruning Ads but not Blogs
    By saltspring in forum Report ClassiPress Bugs
    Replies: 1
    Last Post: October 11th, 2010, 08:20 PM
  3. Ad Pruning Question
    By jschodde in forum ClassiPress General Discussion
    Replies: 0
    Last Post: July 18th, 2009, 03:13 PM