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-18 18:11:35')
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
16671 LILWHITE. -HOPE- COACH JKT WHITE
16672 LILWHITE. -HOPE- COACH JKT BLACK
16681 LILWHITE. -REVERSE CROSS- CHAMPION GUM SHORTS
17908 LILWHITE. -WHITELOGO-SNAP BACK BLACK
17910 LILWHITE. -REVERSE CROSS- BUCKET HAT BLACK
17911 LILWHITE. -REVERSE CROSS- BUCKET HAT WHITE
17912 LILWHITE. PAISLEY BUCKET HAT BLACK
18919 LILWHITE. HDL TANK BLACK
18921 LILWHITE. HDL SHORTS GRAY
19991 LILWHITE. -SYMBOL-MUFFLER TOWEL
19993 LILWHITE. -FLAG-BEACH TOWEL
19995 LILWHITE. -SYMBOL-SUNGLASS(BLKxBLK)
19996 LILWHITE. -SYMBOL-SUNGLASS(BLKxWHT)
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
21548 LILWHITE. 1st ANIV Zip Hoodie
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