SELECT SQL_CALC_FOUND_ROWS p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM dtb_products AS p
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-04-19 18:29:21')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 238)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
2851 DROP DEAD CLOTHING Girls Chillin
3291 DROP DEAD CLOTHING WORN N TORN
3943 DROP DEAD CLOTHING WORN N TORN Girls Pants
4745 DROP DEAD CLOTHING MOMMY'S VERY ANGRY
4792 DROP DEAD CLOTHING LET'S FUCK
4794 DROP DEAD CLOTHING EYE HEART DROP DEAD
4795 DROP DEAD CLOTHING MONROE
5185 DROP DEAD CLOTHING TROPICANA EARRINGS
5191 DROP DEAD CLOTHING SWANKY CATZ
5293 DROP DEAD CLOTHING FLORAL LEGGINGS
6173 DROP DEAD CLOTHING Battered Laptop Case
6896 DROP DEAD CLOTHING PATCHWORK TROUSERS
7393 DROP DEAD CLOTHING CROSSING THE LINES FITTED HAT
7511 DROP DEAD CLOTHING LEOVEPARD TOP
7579 DROP DEAD CLOTHING KNEE VISION TIGHTS
8610 DROP DEAD CLOTHING YUM LEGGINGS
8615 DROP DEAD CLOTHING WOAH VAL CROP T-SHIRT
8875 DROP DEAD CLOTHING DOOM CARDIGAN
10161 DROP DEAD CLOTHING Death Bed Jacket Girls
10719 DROP DEAD CLOTHING HOME TOWN T-SHIRT GIRLS
10720 DROP DEAD CLOTHING DROP OUT T-SHIRT
10721 DROP DEAD CLOTHING YOU SUCK T-SHIRT
10730 DROP DEAD CLOTHING KILLER DRESS GIRLS
10738 DROP DEAD CLOTHING HAVARD SHIRT
10740 DROP DEAD CLOTHING PLAGUE SHIRT