Results 1 to 2 of 2

Thread: Removing duplicate coupons HELP

  1. #1
    Thread Starter
    Senior Member mefindcoupon's Avatar
    Join Date
    Aug 2011
    Location
    United States
    Posts
    192
    Thanks
    31
    Thanked 9 Times in 8 Posts

    Removing duplicate coupons HELP

    I found this jquery to remove duplicate posts, how can I modify to remove coupons since it is a custom post type.

    DELETE bad_rows.*
    from wp_posts as bad_rows
    inner join (
    select post_title, MIN(id) as min_id
    from wp_posts
    group by post_title
    having count(*) > 1
    ) as good_rows on good_rows.post_title = bad_rows.post_title
    and good_rows.min_id <> bad_rows.id

  2. #2
    Thread Starter
    Senior Member mefindcoupon's Avatar
    Join Date
    Aug 2011
    Location
    United States
    Posts
    192
    Thanks
    31
    Thanked 9 Times in 8 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. anyway to find duplicate coupons
    By mefindcoupon in forum Report Clipper Bugs
    Replies: 3
    Last Post: June 4th, 2014, 04:22 PM
  2. Duplicate coupons with same clpr_id
    By ladybug in forum Report Clipper Bugs
    Replies: 21
    Last Post: September 25th, 2013, 07:05 PM
  3. Display popular coupons instead of new coupons on landing page
    By rbatt in forum Clipper General Discussion
    Replies: 7
    Last Post: March 4th, 2013, 09:17 AM
  4. Duplicate coupons
    By vulcain in forum Report Clipper Bugs
    Replies: 1
    Last Post: February 25th, 2012, 08:52 AM
  5. Replies: 14
    Last Post: January 18th, 2012, 07:55 AM