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 19:11:48')
AND pc.price02 > 4545
AND price02 <= 9090
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
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
23808 SILLENT FROM ME RITUAL-Ziphood- WHITE
28802 SILLENT FROM ME DROUGHT -Ziphood- BLACK
28803 SILLENT FROM ME DROUGHT -Ziphood- WHITE
31806 SILLENT FROM ME EPITAPH -Pullover- WHITE
31807 SILLENT FROM ME EPITAPH -Pullover- BLACK
32041 SILLENT FROM ME HUNGED -Pullover- BLACK
32042 SILLENT FROM ME HUNGED -Pullover- WHITE
32327 SILLENT FROM ME ENCRYPTION -Ziphood- BLK
37621 SILLENT FROM ME KEEK -Pullover- BLACK
37622 SILLENT FROM ME KEEK -Pullover- WHITE
38713 SILLENT FROM ME PYRAMID -Ziphood- Black
21165 SILLENT FROM ME ICON -Hockey Shirts- WHITE
22532 DEADHEARTZ X SILLENT FROM ME ZIP HOODIE BLACK
22533 DEADHEARTZ x SILLENT FROM ME ZIP HOODIE DARK
21303 SILLENT FROM ME D&C -Coach Jkt- Black
21304 SILLENT FROM ME D&C -Coach Jkt- White
21515 SILLENT FROM ME CRYPTIC -Coach Jkt- BLACK
21516 SILLENT FROM ME CRYPTIC -Coach Jkt- WHITE
22881 SILLENT FROM ME BRAIN-Coach Jkt- BLACK
22882 SILLENT FROM ME BRAIN-Coach Jkt- WHITE
24378 SILLENT FROM ME BRAIN-Hood Shirts- BLK
24379 SILLENT FROM ME BRAIN-Hood Shirts- WHT
28804 SILLENT FROM ME VOICE -Coach Jkt- BLACK
28805 SILLENT FROM ME VOICE -Coach Jkt- WHITE
37467 SILLENT FROM ME GAZE -Coach Jkt- BLACK
38774 SILLENT FROM ME DIVINITY -Coach Jacket- BLK
38775 SILLENT FROM ME DIVINITY -Coach Jacket- WHT
39844 SILLENT FROM ME ALEXIA -Coach Jkt- White
44301 SILLENT FROM ME SACRIFICE -Ziphood- BLACK
44302 SILLENT FROM ME SACRIFICE -Ziphood- WHITE
46197 SILLENT FROM ME QUERY -Ziphood- BLACK
50123 SILLENT FROM ME SIGN -Snapback- WHITE
50124 SILLENT FROM ME SIGN -Snapback- BLACK/WHITE
50125 SILLENT FROM ME SIGN -Snapback- BLACK/BLACK
50129 SILLENT FROM ME KNOWN -G.I Web Belt- BLACK/WHITE
50130 SILLENT FROM ME KNOWN -G.I Web Belt- BLACK/BLACK
50131 SILLENT FROM ME CROSS WHITE
50132 SILLENT FROM ME CROSS BLACK/WHITE
50133 SILLENT FROM ME CROSS BLACK/BLACK
52980 SILLENT FROM ME SHEARS -Acrylic Pendant- BLACK
52981 SILLENT FROM ME SHEARS -Acrylic Pendant- WHITE
57829 SILLENT FROM ME EYE -Beanie-
58490 SILLENT FROM ME EYE -Snapback-
58341 SILLENT FROM ME CHEAP -Band collar Shirts- BLACK
22201 SILLENT FROM ME DOPE -Ziphood- BLACK
22203 SILLENT FROM ME DOPE -Ziphood- WHITE
23722 SILLENT FROM ME HOOKY -Cuffed Track Pants- BLACK
23723 SILLENT FROM ME HOOKY -Cuffed Track Pants- WHITE
32497 SILLENT FROM ME HUMANE -Coach Jkt- WHT
32498 SILLENT FROM ME HUMANE -Coach Jkt- BLK
42758 SILLENT FROM ME SACRIFICE -Mobile Battery-
47921 SILLENT FROM ME CRYPTIC -Square Sleeveless- BLACK/WHITE
48110 SILLENT FROM ME CRYPTIC -Square Sleeveless- BLACK/BLACK
48111 SILLENT FROM ME CRYPTIC -Square Sleeveless- WHITE
21653 SILLENT FROM ME DIVISION -NylonJkt-
39103 SILLENT FROM ME HIDDEN -Ziphood- GYFT by H>FRACTAL COLLABORATION
50392 SILLENT FROM ME SIGN -Beret- BLACK/WHITE
50393 SILLENT FROM ME SIGN -Beret- BLACK/BLACK
52899 SILLENT FROM ME 沈黙 -G.I Web Belt-
53964 SILLENT FROM ME 沈黙 BLACK
53965 SILLENT FROM ME 沈黙 WHITE
54419 SILLENT FROM ME PHILOSOPHY T-Shirt BLK
54420 SILLENT FROM ME PHILOSOPHY T-Shirt WHT
54421 SILLENT FROM ME SIGN -Pocket- T-Shirt BLK
54422 SILLENT FROM ME SIGN -Pocket- T-Shirt WHT
58760 SILLENT FROM ME EYE WHITE
58761 SILLENT FROM ME EYE BLACK
58762 SILLENT FROM ME HURT WHITE
58763 SILLENT FROM ME HURT BLACK
20462 SILLENT FROM ME LUST -Skinny- BLACK
20463 SILLENT FROM ME LUST -Skinny- BLACK/WHITE
24182 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- BLACK
24184 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- WHITE
37322 SILLENT FROM ME HOOKY -Legging Pants- BLACK/WHITE
37337 SILLENT FROM ME HOOKY -Legging Pants- BLACK
40641 SILLENT FROM ME CLIQUE -Track Pants- Black
41017 SILLENT FROM ME FALLEN -Slacks- CHECK
43273 SILLENT FROM ME EBONY -Side Zip Skinny- BLACK
47061 SILLENT FROM ME STIGMA -Long Sleeve- BLACK
58485 SILLENT FROM ME SPELL -Patterned Cutsew-BLACK/WHITE
58487 SILLENT FROM ME SPELL -Patterned Cutsew-WHITE
58338 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- BLACK CHECK
21314 SILLENT FROM ME ICON -Long Shirts- Black
21315 SILLENT FROM ME ICON -Long Shirts- Black/White
21316 SILLENT FROM ME ICON -Long Shirts- White
24179 SILLENT FROM ME NORM -Long Shirts- BLACK
24180 SILLENT FROM ME NORM -Long Shirts- WHITE
29854 SILLENT FROM ME MARTYR -Flight Jkt- BLACK
33443 SILLENT FROM ME NAP -Sarouel Pants- BLACK
39105 SILLENT FROM ME SCRIBBLE -Outsize Pullover- BLACK
39106 SILLENT FROM ME SCRIBBLE -Outsize Pullover- WHITE
43268 SILLENT FROM ME VEXED -Nylon Pullover- BLACK/WHITE
43269 SILLENT FROM ME VEXED -Nylon Pullover- WHITE
50126 SILLENT FROM ME KNOWN -Long Sleeve- WHITE
50127 SILLENT FROM ME KNOWN -Long Sleeve- BLACK/BLACK
50128 SILLENT FROM ME KNOWN -Long Sleeve- BLACK/WHITE
54069 SILLENT FROM ME TRAGEDY -Long Sleeve- WHITE
54070 SILLENT FROM ME TRAGEDY -Long Sleeve- BLACK
55986 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- BLACK
55987 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- WHITE
56530 SILLENT FROM ME VEIN -Cable Knit Beanie- BLACK
56532 SILLENT FROM ME VEIN -Cable Knit Beanie- WHITE
57825 SILLENT FROM ME EYE -Pullover- WHITE
58489 SILLENT FROM ME FILLM -Loose Long Sleeve- WHITE
21655 SILLENT FROM ME CRYPTIC -Cloak-
37318 SILLENT FROM ME SICK -Modified Pullover- WHITE
43274 SILLENT FROM ME EBONY -Damaged Side Zip Skinny- BLACK
50388 SILLENT FROM ME KNOWN CRYPTIC -Ring Belt- BLACK
50389 SILLENT FROM ME KNOWN CRYPTIC -Ring Belt- WHITE
56259 SILLENT FROM ME SILLENT FROM ME ODIN -Ear Muff Beanie-
24333 SILLENT FROM ME SIN -Back Pack- BLACK
24334 SILLENT FROM ME SIN -Back Pack- WHITE
30014 SILLENT FROM ME VENOM -Biker Pants- BLACK
30015 SILLENT FROM ME VENOM -Biker Pants- WHITE
37117 SILLENT FROM ME RUBRIC -Crew Sweat- BLACK