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 13:06' AND ('2024-04-27 13:06' < 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 = 'health-fitness' LIMIT 1) GROUP BY coupons.coupon_id ORDER BY coupons.coupon_created DESC LIMIT 0, 6
