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-04-28 06:37:25')
AND pc.classcategory_id1 IN( 13,35,44)
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 MAX(price02)
LIMIT 0, 120
25475 SILLENT FROM ME CRYPTIC -Drape Tee- BLACK
25477 SILLENT FROM ME CRYPTIC -Drape Tee- WHITE
20226 SILLENT FROM ME ARTIFICIAL WHT
20227 SILLENT FROM ME ARTIFICIAL BLK
20228 SILLENT FROM ME SPELL BLK
20229 SILLENT FROM ME SPELL WHT
20455 SILLENT FROM ME DIVISION BLACK
20456 SILLENT FROM ME DIVISION WHITE
23907 SILLENT FROM ME ANACHRONIC BLACK
23908 SILLENT FROM ME ANACHRONIC WHITE
24573 SILLENT FROM ME RITUAL WHITE
24574 SILLENT FROM ME RITUAL BLACK
25472 SILLENT FROM ME LOSE BLACK
25474 SILLENT FROM ME LOSE WHITE
20221 SILLENT FROM ME CRYPTIC BLK
20222 SILLENT FROM ME CRYPTIC WHT
20223 SILLENT FROM ME VOICE BLK
20224 SILLENT FROM ME VOICE WHT
20453 SILLENT FROM ME QUIET BLACK
20454 SILLENT FROM ME QUIET WHITE
24331 SILLENT FROM ME D&C BLACK
24332 SILLENT FROM ME D&C WHITE
24427 SILLENT FROM ME CIRCLE BLACK
24428 SILLENT FROM ME CIRCLE WHITE
24430 SILLENT FROM ME TRIANGLE BLACK
24431 SILLENT FROM ME TRIANGLE WHITE
24433 SILLENT FROM ME SQUARE WHITE
24546 SILLENT FROM ME DEPRESSED BLACK
24547 SILLENT FROM ME DEPRESSED WHITE
26220 SILLENT FROM ME DROUGHT BLACK
26221 SILLENT FROM ME DROUGHT WHITE
24548 SILLENT FROM ME 771#-Pocket- BLACK
24549 SILLENT FROM ME 771#-Pocket- WHITE
24841 SILLENT FROM ME "20"MINOR LEAGUE Collaboration WHITE
28434 SILLENT FROM ME ENCRYPTION WHT
28435 SILLENT FROM ME ENCRYPTION BLK
28436 SILLENT FROM ME TEAR WHT
28437 SILLENT FROM ME TEAR BLK
28684 SILLENT FROM ME DENSE BLACK
28685 SILLENT FROM ME DENSE WHTE
36452 SILLENT FROM ME DIVINITY BLACK
36453 SILLENT FROM ME DIVINITY WHITE
42750 SILLENT FROM ME ILLNESS BLACK
42751 SILLENT FROM ME ILLNESS WHITE
24845 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration BLACK
24847 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration WHITE
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
29135 SILLENT FROM ME MARTYR -Side Slit- BLACK
29136 SILLENT FROM ME MARTYR -Side Slit- WHITE
21855 SILLENT FROM ME NORM -Waffle- BLACK
21856 SILLENT FROM ME NORM -Waffle- WHITE
21167 SILLENT FROM ME CIRCLE -Longsleeve- WHITE
22383 SILLENT FROM ME SPELL -Longsleeve- WHT
22384 SILLENT FROM ME SPELL -Longsleeve- BLK
22944 SILLENT FROM ME BRAIN -Long Sleeve- BLK
22945 SILLENT FROM ME BRAIN -Long Sleeve- WHT
32340 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- BLK
32341 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- WHT
58766 SILLENT FROM ME FILLM -Pocket- WHITE
58767 SILLENT FROM ME FILLM -Pocket- BLACK
28901 SILLENT FROM ME HUNGED -Long Sleeve- BLK
28902 SILLENT FROM ME HUNGED -Long Sleeve- WHT
33606 SILLENT FROM ME DREAMS -Long Sleeve- BLACK
33607 SILLENT FROM ME DREAMS -Long Sleeve- WHITE
34205 SILLENT FROM ME HUMANE -Long Sleeve- WHITE
34206 SILLENT FROM ME HUMANE -Long Sleeve- BLACK
36924 SILLENT FROM ME HAUBERK -Net Cutsaw- BLACK
36925 SILLENT FROM ME HAUBERK -Net Cutsaw- WHITE
40639 SILLENT FROM ME SACRIFICE -Long Sleeve- BLACK
40640 SILLENT FROM ME SACRIFICE -Long Sleeve- WHITE
42976 SILLENT FROM ME METAPHOR -Long Sleeve- White
42977 SILLENT FROM ME METAPHOR -Long Sleeve- Black
47062 SILLENT FROM ME STIGMA -Long Sleeve- WHITE
23721 SILLENT FROM ME NORM-Tereko Long Tee- WHITE
25469 SILLENT FROM ME HOOKY -Wide Half Sleeve- BLACK
25471 SILLENT FROM ME HOOKY -Wide Half Sleeve- WHITE
28899 SILLENT FROM ME NORM-Tereko Long Tee- BLK/WHT
28900 SILLENT FROM ME NORM-Tereko Long Tee- BLK
32337 SILLENT FROM ME BALANCE -Long Sleeve- BLK
32339 SILLENT FROM ME BALANCE -Long Sleeve- WHT
58488 SILLENT FROM ME FILLM -Loose Long Sleeve- BLACK
21850 SILLENT FROM ME CRYPTIC -Crew Sweat- BLACK
21851 SILLENT FROM ME CRYPTIC -Crew Sweat- WHITE
21852 SILLENT FROM ME VOICE -Crew Sweat- BLACK
21853 SILLENT FROM ME VOICE -Crew Sweat- WHITE
32039 SILLENT FROM ME NORM -Waffle Pullover- WHITE
32040 SILLENT FROM ME NORM -Waffle Pullover- BLACK
58486 SILLENT FROM ME SPELL -Patterned Cutsew-BLACK/BLACK
22879 SILLENT FROM ME VOICE-Crew Sweat- BLACK
22880 SILLENT FROM ME VOICE-Crew Sweat- WHITE
29137 SILLENT FROM ME SPELL -Crew Sweat- BLACK
29138 SILLENT FROM ME SPELL -Crew Sweat- WHITE
31808 SILLENT FROM ME ENCRYPTION -Crew Sweat- BLACK
31809 SILLENT FROM ME ENCRYPTION -Crew Sweat- WHITE
39101 SILLENT FROM ME DIVINITY -Crew Sweat- BLACK
39102 SILLENT FROM ME DIVINITY -Crew Sweat- WHITE
21511 SILLENT FROM ME QUIET -Pullover- BLACK
21512 SILLENT FROM ME QUIET -Pullover- WHITE
21513 SILLENT FROM ME D&C -Pullover- BLACK
21514 SILLENT FROM ME D&C -Pullover- WHITE
22175 SILLENT FROM ME DIVISION -Pullover- WHT
22176 SILLENT FROM ME DIVISION -Pullover- BLK
23421 SILLENT FROM ME LOSE-Pullover- BLACK
23422 SILLENT FROM ME LOSE-Pullover- WHITE
22877 SILLENT FROM ME DEPRESSED-Pullover- BLACK
22878 SILLENT FROM ME DEPRESSED-Pullover- WHITE
24840 SILLENT FROM ME "20"MINOR LEAGUE Collaboration BLACK
36709 SILLENT FROM ME DREAMS -Ziphood- BLACK
38715 SILLENT FROM ME SILLENT FROM ME GAZE -Pullover-
39556 SILLENT FROM ME CRY -Pullover- WHITE
39557 SILLENT FROM ME CRY -Pullover- BLACK
39980 SILLENT FROM ME MESS -Pullover- White
43263 SILLENT FROM ME STIGMA -Pullover- BLACK
44300 SILLENT FROM ME ILLNESS -Pullover- WHITE
21170 SILLENT FROM ME SQUARE -Ziphood- BLACK
21171 SILLENT FROM ME SQUARE -Ziphood- WHITE
21309 SILLENT FROM ME FU-Ziphood- White
21311 SILLENT FROM ME FU-Ziphood- Black
23807 SILLENT FROM ME RITUAL-Ziphood- BLACK