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-05-08 14:43' AND ('2024-05-08 14:43' < coupons.coupon_expire OR coupons.coupon_expire IS NULL OR coupons.coupon_expire = '') AND coupons.coupon_store = (SELECT stores.store_id FROM stores WHERE stores.store_slug = 'aliexpress' LIMIT 1) GROUP BY coupons.coupon_id ORDER BY coupons.coupon_created DESC LIMIT 0, 6
