SELECT SQL_CALC_FOUND_ROWS coupons.*, categories.*, subcategories.*, stores.*, users.user_name AS author_name, (SELECT COUNT(*) FROM likes WHERE likes.item = coupons.coupon_id AND likes.rating = 'like') AS total_likes, (SELECT COUNT(*) FROM likes WHERE likes.item = coupons.coupon_id AND likes.rating = 'deslike') AS total_deslikes FROM coupons LEFT JOIN categories ON coupon_category = categories.category_id LEFT JOIN stores ON coupon_store = stores.store_id LEFT JOIN users ON coupon_author = users.user_id LEFT JOIN subcategories ON coupon_subcategory = subcategories.subcategory_id WHERE coupons.coupon_status = 1 AND coupons.coupon_start <= '2024-04-27 12:10' AND ('2024-04-27 12:10' < coupons.coupon_expire OR coupons.coupon_expire IS NULL OR coupons.coupon_expire = '') AND coupons.coupon_category = (SELECT categories.category_id FROM categories WHERE categories.category_slug = 'food-drink' LIMIT 1) GROUP BY coupons.coupon_id ORDER BY coupons.coupon_created DESC LIMIT 0, 6
4 Results
$15 Off + Free Worldwide Shipping on $50+

$15 Off + Free Worldwide Shipping on $50+

Online Only!

  • Verified
  • Exclusive
15% Off For Students

15% Off For Students

  • Verified
  • Exclusive
5% Cash Back For New Customers

5% Cash Back For New Customers

Tag Line

  • Verified
2 Cream Coffes For $10

2 Cream Coffes For $10

Tag Line

  • Verified