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 18:19:42')
AND pc.classcategory_id1 IN( 14,61,35)
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 0, 120
56930 SILLENT FROM ME CRYPTIC -Flight Jacket-BLACK/WHITE
56945 SILLENT FROM ME CRYPTIC -Flight Jacket-BLACK/BLACK
44189 SILLENT FROM ME WANDER -Military Coat- GRAY
44190 SILLENT FROM ME WANDER -Military Coat- BLACK
44171 SILLENT FROM ME NOCTURNE -Leather Flight Jacket- BLACK/BLACK
37320 SILLENT FROM ME KINETIC -Anorac- WHITE
43938 SILLENT FROM ME LAX -Cord Anorak- BLACK
43939 SILLENT FROM ME LAX -Cord Anorak- BLACK/WHITE
56520 SILLENT FROM ME VEIN -Cable Knit Sweater- BLACK
56523 SILLENT FROM ME VEIN -Cable Knit Sweater- MIXED
51278 SILLENT FROM ME COCOON -Shaggy Knit Cardigan- BLACK
53092 SILLENT FROM ME ECLIPSE -Oversized Riders Jacket-
43540 SILLENT FROM ME GEMINAL -Reversible Boa Jacket- BLACK
43541 SILLENT FROM ME GEMINAL -Reversible Boa Jacket- WHITE
50493 SILLENT FROM ME RESULT -Half Snap Pullover- BLACK
50494 SILLENT FROM ME RESULT -Half Snap Pullover- WHITE
51277 SILLENT FROM ME COCOON -Switched Knit Cardigan- BLACK
50496 SILLENT FROM ME SHADOW -Deformed Pullover Shirts- BLACK
50497 SILLENT FROM ME SHADOW -Deformed Pullover Shirts- WHITE
50498 SILLENT FROM ME SHADOW -Deformed Pullover Shirts- STRIPE
50499 SILLENT FROM ME SHADOW -Deformed Pullover Shirts- CHECK
44305 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- WHITE
54068 SILLENT FROM ME SPELL -Patterned Stand Up Collar Shirts- BLACK
56115 SILLENT FROM ME CULTISM Long Length Shirts BLK
56117 SILLENT FROM ME CULTISM Long Length Shirts BK/WH
56257 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- GRAY CHECK
56258 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- BLACK CHECK
58339 SILLENT FROM ME LAWYER -Wide Slacks- BLACK CHECK
58484 SILLENT FROM ME LAWYER -Wide Slacks- GRAY CHECK
33438 SILLENT FROM ME NAP -Pattern Wide Shirts STRIPE
40626 SILLENT FROM ME CLIQUE -Track Jacket- White
51279 SILLENT FROM ME KNOWLEDGE -Wool Slacks- BLACK
54169 SILLENT FROM ME VICTOR -Slim Slacks- BLACK CHECK
37623 SILLENT FROM ME SHELTER -Stand Collar Coat- BLACK
37624 SILLENT FROM ME SHELTER -Stand Collar Coat- BLEACHED BLACK
43942 SILLENT FROM ME TEARING -Zip Veluor Parka- WHITE
50495 SILLENT FROM ME RESULT -Side Snap Track Pants- BLACK
54135 SILLENT FROM ME SHHH -Long Length Parka- BLACK
54136 SILLENT FROM ME SHHH -Long Length Parka- WHITE
37317 SILLENT FROM ME SICK -Modified Pullover- BLACK
23724 SILLENT FROM ME NORM -Wide Rain Coat- BLACK
23725 SILLENT FROM ME NORM -Wide Rain Coat- WHITE
37319 SILLENT FROM ME KINETIC -Anorac- BLACK
37321 SILLENT FROM ME KINETIC -Anorac- BLACK/WHITE
43267 SILLENT FROM ME VEXED -Nylon Pullover- BLACK
43940 SILLENT FROM ME LAX -Cord Anorak- WHITE
20464 SILLENT FROM ME LUST -Skinny- WHITE
54137 SILLENT FROM ME R.I.P -Long Length Cutsew- BLACK
54138 SILLENT FROM ME R.I.P -Long Length Cutsew- WHITE
56522 SILLENT FROM ME VEIN -Cable Knit Sweater- WHITE
30017 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK
30019 SILLENT FROM ME MIMICRY -Knit Sweater- WHITE
39553 SILLENT FROM ME VALKYRIE -Light MA1- GLASS
39554 SILLENT FROM ME VALKYRIE -Light MA1- BLACK
39555 SILLENT FROM ME VALKYRIE -Light MA1- WHITE
58483 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- GRAY CHECK
37468 SILLENT FROM ME GAZE -Coach Jkt- WHITE
39843 SILLENT FROM ME ALEXIA -Coach Jkt-
44304 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- BLACK
44306 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- BLACK CHIDORI
44307 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- WHITE CHIDORI
56116 SILLENT FROM ME CULTISM Long Length Shirts WHT
36922 SILLENT FROM ME MALCOLM -Zip Wide Shirts- BLACK
36923 SILLENT FROM ME MALCOLM -Zip Wide Shirts- BLACK CHECK
43105 SILLENT FROM ME ECHO -Zip Wide Shirts- BLACK
43106 SILLENT FROM ME ECHO -Zip Wide Shirts- GRAY
29094 SILLENT FROM ME LINT -Wide Flannel Shirts-
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
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
30014 SILLENT FROM ME VENOM -Biker Pants- BLACK
41016 SILLENT FROM ME FALLEN -Wide S/S Shirts- BLACK
41018 SILLENT FROM ME FALLEN -Wide S/S Shirts- CHECK
37318 SILLENT FROM ME SICK -Modified Pullover- WHITE
43274 SILLENT FROM ME EBONY -Damaged Side Zip Skinny- BLACK
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
43268 SILLENT FROM ME VEXED -Nylon Pullover- BLACK/WHITE
43269 SILLENT FROM ME VEXED -Nylon Pullover- 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
21653 SILLENT FROM ME DIVISION -NylonJkt-
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
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
22882 SILLENT FROM ME BRAIN-Coach Jkt- WHITE
37467 SILLENT FROM ME GAZE -Coach Jkt- BLACK
38774 SILLENT FROM ME DIVINITY -Coach Jacket- BLK
39844 SILLENT FROM ME ALEXIA -Coach Jkt- White
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
21170 SILLENT FROM ME SQUARE -Ziphood- BLACK
21171 SILLENT FROM ME SQUARE -Ziphood- WHITE
21309 SILLENT FROM ME FU-Ziphood- White