SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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-05-01 20:15:36')
AND pc.classcategory_id1 IN( 11)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 454)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
21542 LILWHITE. STUDS Tee WHT
21543 LILWHITE. STUDS Tee BLK
21544 LILWHITE. BELIEF Coach JKT
21545 LILWHITE. 1st ANIV Varsity
21546 LILWHITE. STUDS Side zip Hoodie WHT
21547 LILWHITE. STUDS Side zip Hoodie BLK
21549 LILWHITE. WRATH Tee
21550 LILWHITE. BELIEF Tee WHT
21551 LILWHITE. BELIEF Tee BLK
21735 LILWHITE. 3D LOGO TEE BLACK
21736 LILWHITE. 3D LOGO TEE WHITE
21737 LILWHITE. 3D LOGO PARKA GREY
21738 LILWHITE. 3D LOGO PARKA BLACK
23952 LILWHITE. -CIRCLE-ZIP HOODIE BLK
23953 LILWHITE. -CIRCLE-ZIP HOODIE GRY
23954 LILWHITE. -CIRCLE-ZIP HOODIE WHT
23955 LILWHITE. -CIRCLE-LIGHT JKT BLK
23956 LILWHITE. -CIRCLE-LIGHT JKT WHT
23957 LILWHITE. -STAY FRESH-L/S Tee BLK
23958 LILWHITE. -STAY FRESH-L/S Tee WHT
23959 LILWHITE. -REVERSE CROSS-L/S Tee BLK
23960 LILWHITE. -REVERSE CROSS-L/S Tee WHT
23961 LILWHITE. -2YAT3-HOOD SHIRT BLK
23962 LILWHITE. -2YAT3-HOOD SHIRT WHT
23963 LILWHITE. Reincarnation BLK