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-25 17:35:49')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 490)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 240, 60
26220 SILLENT FROM ME DROUGHT BLACK
26221 SILLENT FROM ME DROUGHT WHITE
26222 SILLENT FROM ME SPELL -Snapback- WHITE
26223 SILLENT FROM ME SPELL -Snapback- BLACK
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
26619 SILLENT FROM ME CRYPTIC -Neck Strap-
28434 SILLENT FROM ME ENCRYPTION WHT
28435 SILLENT FROM ME ENCRYPTION BLK
28436 SILLENT FROM ME TEAR WHT
28437 SILLENT FROM ME TEAR BLK
28438 SILLENT FROM ME ENCRYPTION -Snapback- WHT
28439 SILLENT FROM ME ENCRYPTION -Snapback- BLK/BLK
28441 SILLENT FROM ME ENCRYPTION -Snapback- BLK
28442 SILLENT FROM ME WHISPER -Polo Cap- WHT
28443 SILLENT FROM ME WHISPER -Polo Cap- BLK
28684 SILLENT FROM ME DENSE BLACK
28685 SILLENT FROM ME DENSE WHTE
28802 SILLENT FROM ME DROUGHT -Ziphood- BLACK
28803 SILLENT FROM ME DROUGHT -Ziphood- WHITE
28804 SILLENT FROM ME VOICE -Coach Jkt- BLACK
28805 SILLENT FROM ME VOICE -Coach Jkt- WHITE
28806 SILLENT FROM ME EPITAPH -5 Panel- BLACK
28899 SILLENT FROM ME NORM-Tereko Long Tee- BLK/WHT
28900 SILLENT FROM ME NORM-Tereko Long Tee- BLK
28901 SILLENT FROM ME HUNGED -Long Sleeve- BLK
28902 SILLENT FROM ME HUNGED -Long Sleeve- WHT
29094 SILLENT FROM ME LINT -Wide Flannel Shirts-
29135 SILLENT FROM ME MARTYR -Side Slit- BLACK
29136 SILLENT FROM ME MARTYR -Side Slit- WHITE
29137 SILLENT FROM ME SPELL -Crew Sweat- BLACK
29138 SILLENT FROM ME SPELL -Crew Sweat- WHITE
29854 SILLENT FROM ME MARTYR -Flight Jkt- BLACK
29855 SILLENT FROM ME WHISPER -Beanie-
30014 SILLENT FROM ME VENOM -Biker Pants- BLACK
30015 SILLENT FROM ME VENOM -Biker Pants- WHITE
30016 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK/WHITE
30017 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK
30019 SILLENT FROM ME MIMICRY -Knit Sweater- WHITE
31806 SILLENT FROM ME EPITAPH -Pullover- WHITE
31807 SILLENT FROM ME EPITAPH -Pullover- BLACK
31808 SILLENT FROM ME ENCRYPTION -Crew Sweat- BLACK
31809 SILLENT FROM ME ENCRYPTION -Crew Sweat- WHITE
31810 SILLENT FROM ME SPELL -Cord Cap-
32039 SILLENT FROM ME NORM -Waffle Pullover- WHITE
32040 SILLENT FROM ME NORM -Waffle Pullover- BLACK
32041 SILLENT FROM ME HUNGED -Pullover- BLACK
32042 SILLENT FROM ME HUNGED -Pullover- WHITE
32327 SILLENT FROM ME ENCRYPTION -Ziphood- BLK
32328 SILLENT FROM ME ENCRYPTION -Ziphood- WHT
32330 SILLENT FROM ME BILLOW -Polo Cap- BLK
32333 SILLENT FROM ME BILLOW -Polo Cap- WHT
32337 SILLENT FROM ME BALANCE -Long Sleeve- BLK
32339 SILLENT FROM ME BALANCE -Long Sleeve- WHT
32340 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- BLK
32341 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- WHT
32497 SILLENT FROM ME HUMANE -Coach Jkt- WHT
32498 SILLENT FROM ME HUMANE -Coach Jkt- BLK
32499 SILLENT FROM ME TEAR -Crew Sweat- BLK
32500 SILLENT FROM ME TEAR -Crew Sweat- WHT