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 12:36:07')
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) DESC
LIMIT 120, 120
39981 SILLENT FROM ME MESS -Pullover- Black
43265 SILLENT FROM ME STIGMA -Pullover- WHITE
44271 SILLENT FROM ME ILLNESS -Pullover- BLACK
45122 SILLENT FROM ME × つぶら CCXXVI-Crew Sweat-
46352 SILLENT FROM ME FEEL -Pullover- BLACK
46353 SILLENT FROM ME FEEL -Pullover- WHITE
47056 SILLENT FROM ME ELEGANT -Stand Up Collar Shirts- BLACK
47057 SILLENT FROM ME ELEGANT -Stand Up Collar Shirts- WHITE
47058 SILLENT FROM ME ELEGANT -Stand Up Collar Shirts- BLK STRIPE
47059 SILLENT FROM ME ELEGANT -Stand Up Collar Shirts- WHT STRIPE
47495 SILLENT FROM ME LAX -Hemline Half Sleeve Shirts- BLACK
47496 SILLENT FROM ME LAX -Hemline Half Sleeve Shirts- WHITE
47497 SILLENT FROM ME LAX -Hemline Half Sleeve Shirts- BLACK STRIPE
47498 SILLENT FROM ME LAX -Hemline Half Sleeve Shirts- WHITE STRIPE
47500 SILLENT FROM ME SHEARS -Patterned Short Sleeve- BLACK/WHITE
47501 SILLENT FROM ME SHEARS -Patterned Short Sleeve- WHITE
52900 SILLENT FROM ME 沈黙 -Loose Crew Sweat- BLACK
52901 SILLENT FROM ME 沈黙 -Loose Crew Sweat- WHITE
53126 SILLENT FROM ME PHILOSOPHY -Crew Sweat- BLACK
56053 SILLENT FROM ME PHILOSOPHY -Crew Sweat- WHITE
56750 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- WHITE
56751 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- BLACK
57827 SILLENT FROM ME WORDS -Crew Sweat- WHITE
57828 SILLENT FROM ME WORDS -Crew Sweat- BLACK
33436 SILLENT FROM ME NAP -Wide Shirts- BLACK
33437 SILLENT FROM ME NAP -Wide Shirts- WHITE
33439 SILLENT FROM ME NAP -Pattern Wide Shirts POLKA DOT
34097 SILLENT FROM ME LISBETH -Flip Day Pack- BLACK/WHITE
34098 SILLENT FROM ME LISBETH -Flip Day Pack- BLACK
37120 SILLENT FROM ME LISBETH -Flip Day Pack- WHITE
40627 SILLENT FROM ME CLIQUE -Track Jacket- Black
54170 SILLENT FROM ME VICTOR -Slim Slacks- GRAY CHECK
58340 SILLENT FROM ME CHEAP -Band collar Shirts- WHITE
51280 SILLENT FROM ME KNOWLEDGE -Wool Slacks- GRAY
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
37626 SILLENT FROM ME PYRAMID -Crew Sweat- WHITE
39846 SILLENT FROM ME ALEXIA -Crew Sweat- Black
41016 SILLENT FROM ME FALLEN -Wide S/S Shirts- BLACK
41018 SILLENT FROM ME FALLEN -Wide S/S Shirts- CHECK
56527 SILLENT FROM ME VEIN -Cable Knit Glove- BLACK
56528 SILLENT FROM ME VEIN -Cable Knit Glove- WHITE
56529 SILLENT FROM ME VEIN -Cable Knit Glove- MIXED
58346 SILLENT FROM ME DRESS -Minimal Bag- WHITE
58347 SILLENT FROM ME DRESS -Minimal Bag- BLACK
56259 SILLENT FROM ME SILLENT FROM ME ODIN -Ear Muff Beanie-
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
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
58338 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- BLACK CHECK
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
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
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
58341 SILLENT FROM ME CHEAP -Band collar Shirts- BLACK
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