Results 1 to 6 of 6

Thread: need SQL query for pruning old ads

  1. August 3rd, 2011 #1
    muhabat
    muhabat is offline
    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,
    Reply With Quote Reply With Quote
  2. August 4th, 2011 #2
    jomarkosabel
    jomarkosabel is offline
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    40,697
    Thanks
    166
    Thanked 3,390 Times in 3,261 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.
    Reply With Quote Reply With Quote
  3. August 4th, 2011 #3
    muhabat
    muhabat is offline
    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!
    Reply With Quote Reply With Quote
  4. August 5th, 2011 #4
    muhabat
    muhabat is offline
    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!
    Reply With Quote Reply With Quote
  5. August 6th, 2011 #5
    muhabat
    muhabat is offline
    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!
    Reply With Quote Reply With Quote
  6. August 8th, 2011 #6
    muhabat
    muhabat is offline
    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!
    Reply With Quote Reply With Quote
« How to remove "title/alt" on drop down links? | Remove CP Facebook Photo's »

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, 10:54 PM
  2. Ad Pruning Question
    By jschodde in forum ClassiPress General Discussion
    Replies: 0
    Last Post: July 18th, 2009, 02:13 PM