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-20 01:28:57')
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 p.update_date DESC
LIMIT 0, 120
58484 SILLENT FROM ME LAWYER -Wide Slacks- GRAY CHECK
58483 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- GRAY CHECK
58338 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- BLACK CHECK
58340 SILLENT FROM ME CHEAP -Band collar Shirts- WHITE
58341 SILLENT FROM ME CHEAP -Band collar Shirts- BLACK
58339 SILLENT FROM ME LAWYER -Wide Slacks- BLACK CHECK
56945 SILLENT FROM ME CRYPTIC -Flight Jacket-BLACK/BLACK
56930 SILLENT FROM ME CRYPTIC -Flight Jacket-BLACK/WHITE
56520 SILLENT FROM ME VEIN -Cable Knit Sweater- BLACK
56522 SILLENT FROM ME VEIN -Cable Knit Sweater- WHITE
56523 SILLENT FROM ME VEIN -Cable Knit Sweater- MIXED
51279 SILLENT FROM ME KNOWLEDGE -Wool Slacks- BLACK
56257 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- GRAY CHECK
56258 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- BLACK CHECK
56115 SILLENT FROM ME CULTISM Long Length Shirts BLK
56116 SILLENT FROM ME CULTISM Long Length Shirts WHT
56117 SILLENT FROM ME CULTISM Long Length Shirts BK/WH
20223 SILLENT FROM ME VOICE BLK
20224 SILLENT FROM ME VOICE WHT
20226 SILLENT FROM ME ARTIFICIAL WHT
20227 SILLENT FROM ME ARTIFICIAL BLK
20453 SILLENT FROM ME QUIET BLACK
20454 SILLENT FROM ME QUIET WHITE
20455 SILLENT FROM ME DIVISION BLACK
20456 SILLENT FROM ME DIVISION WHITE
20462 SILLENT FROM ME LUST -Skinny- BLACK
20463 SILLENT FROM ME LUST -Skinny- BLACK/WHITE
20464 SILLENT FROM ME LUST -Skinny- WHITE
21165 SILLENT FROM ME ICON -Hockey Shirts- WHITE
21167 SILLENT FROM ME CIRCLE -Longsleeve- WHITE
21170 SILLENT FROM ME SQUARE -Ziphood- BLACK
21171 SILLENT FROM ME SQUARE -Ziphood- WHITE
21303 SILLENT FROM ME D&C -Coach Jkt- Black
21304 SILLENT FROM ME D&C -Coach Jkt- White
21309 SILLENT FROM ME FU-Ziphood- White
21311 SILLENT FROM ME FU-Ziphood- 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
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
21515 SILLENT FROM ME CRYPTIC -Coach Jkt- BLACK
21516 SILLENT FROM ME CRYPTIC -Coach Jkt- WHITE
21653 SILLENT FROM ME DIVISION -NylonJkt-
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
21855 SILLENT FROM ME NORM -Waffle- BLACK
21856 SILLENT FROM ME NORM -Waffle- WHITE
22175 SILLENT FROM ME DIVISION -Pullover- WHT
22176 SILLENT FROM ME DIVISION -Pullover- BLK
22201 SILLENT FROM ME DOPE -Ziphood- BLACK
22203 SILLENT FROM ME DOPE -Ziphood- WHITE
22532 DEADHEARTZ X SILLENT FROM ME ZIP HOODIE BLACK
22533 DEADHEARTZ x SILLENT FROM ME ZIP HOODIE DARK
22881 SILLENT FROM ME BRAIN-Coach Jkt- BLACK
22882 SILLENT FROM ME BRAIN-Coach Jkt- WHITE
23721 SILLENT FROM ME NORM-Tereko Long Tee- WHITE
23722 SILLENT FROM ME HOOKY -Cuffed Track Pants- BLACK
23723 SILLENT FROM ME HOOKY -Cuffed Track Pants- WHITE
23724 SILLENT FROM ME NORM -Wide Rain Coat- BLACK
23725 SILLENT FROM ME NORM -Wide Rain Coat- WHITE
24179 SILLENT FROM ME NORM -Long Shirts- BLACK
24180 SILLENT FROM ME NORM -Long Shirts- WHITE
24182 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- BLACK
24184 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- WHITE
24548 SILLENT FROM ME 771#-Pocket- BLACK
24549 SILLENT FROM ME 771#-Pocket- WHITE
24840 SILLENT FROM ME "20"MINOR LEAGUE Collaboration BLACK
24841 SILLENT FROM ME "20"MINOR LEAGUE Collaboration WHITE
25469 SILLENT FROM ME HOOKY -Wide Half Sleeve- BLACK
25471 SILLENT FROM ME HOOKY -Wide Half Sleeve- WHITE
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
28899 SILLENT FROM ME NORM-Tereko Long Tee- BLK/WHT
28900 SILLENT FROM ME NORM-Tereko Long Tee- BLK
29094 SILLENT FROM ME LINT -Wide Flannel Shirts-
29854 SILLENT FROM ME MARTYR -Flight Jkt- BLACK
30014 SILLENT FROM ME VENOM -Biker Pants- BLACK
30017 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK
30019 SILLENT FROM ME MIMICRY -Knit Sweater- WHITE
32040 SILLENT FROM ME NORM -Waffle Pullover- BLACK
32497 SILLENT FROM ME HUMANE -Coach Jkt- WHT
32498 SILLENT FROM ME HUMANE -Coach Jkt- BLK
33436 SILLENT FROM ME NAP -Wide Shirts- BLACK
33437 SILLENT FROM ME NAP -Wide Shirts- WHITE
33438 SILLENT FROM ME NAP -Pattern Wide Shirts STRIPE
33439 SILLENT FROM ME NAP -Pattern Wide Shirts POLKA DOT
36922 SILLENT FROM ME MALCOLM -Zip Wide Shirts- BLACK
36923 SILLENT FROM ME MALCOLM -Zip Wide Shirts- BLACK CHECK
36924 SILLENT FROM ME HAUBERK -Net Cutsaw- BLACK
36925 SILLENT FROM ME HAUBERK -Net Cutsaw- WHITE
37317 SILLENT FROM ME SICK -Modified Pullover- BLACK
37318 SILLENT FROM ME SICK -Modified Pullover- WHITE
37319 SILLENT FROM ME KINETIC -Anorac- BLACK
37320 SILLENT FROM ME KINETIC -Anorac- WHITE
37321 SILLENT FROM ME KINETIC -Anorac- BLACK/WHITE
37322 SILLENT FROM ME HOOKY -Legging Pants- BLACK/WHITE
37337 SILLENT FROM ME HOOKY -Legging Pants- BLACK
37467 SILLENT FROM ME GAZE -Coach Jkt- BLACK
37468 SILLENT FROM ME GAZE -Coach Jkt- WHITE
37623 SILLENT FROM ME SHELTER -Stand Collar Coat- BLACK
37624 SILLENT FROM ME SHELTER -Stand Collar Coat- BLEACHED BLACK
38774 SILLENT FROM ME DIVINITY -Coach Jacket- BLK
39553 SILLENT FROM ME VALKYRIE -Light MA1- GLASS
39554 SILLENT FROM ME VALKYRIE -Light MA1- BLACK
39555 SILLENT FROM ME VALKYRIE -Light MA1- WHITE
39843 SILLENT FROM ME ALEXIA -Coach Jkt-
39844 SILLENT FROM ME ALEXIA -Coach Jkt- White
40626 SILLENT FROM ME CLIQUE -Track Jacket- White
40627 SILLENT FROM ME CLIQUE -Track Jacket- Black
40641 SILLENT FROM ME CLIQUE -Track Pants- Black
41016 SILLENT FROM ME FALLEN -Wide S/S Shirts- BLACK
41017 SILLENT FROM ME FALLEN -Slacks- CHECK
41018 SILLENT FROM ME FALLEN -Wide S/S Shirts- CHECK
43105 SILLENT FROM ME ECHO -Zip Wide Shirts- BLACK
43106 SILLENT FROM ME ECHO -Zip Wide Shirts- GRAY