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-19 23:07:36')
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 p.update_date DESC
LIMIT 0, 60
58760 SILLENT FROM ME EYE WHITE
58762 SILLENT FROM ME HURT WHITE
58763 SILLENT FROM ME HURT BLACK
58761 SILLENT FROM ME EYE BLACK
58338 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- BLACK CHECK
58485 SILLENT FROM ME SPELL -Patterned Cutsew-BLACK/WHITE
58487 SILLENT FROM ME SPELL -Patterned Cutsew-WHITE
58489 SILLENT FROM ME FILLM -Loose Long Sleeve- WHITE
58340 SILLENT FROM ME CHEAP -Band collar Shirts- WHITE
58341 SILLENT FROM ME CHEAP -Band collar Shirts- BLACK
57827 SILLENT FROM ME WORDS -Crew Sweat- WHITE
57825 SILLENT FROM ME EYE -Pullover- WHITE
58490 SILLENT FROM ME EYE -Snapback-
57829 SILLENT FROM ME EYE -Beanie-
56259 SILLENT FROM ME SILLENT FROM ME ODIN -Ear Muff Beanie-
58346 SILLENT FROM ME DRESS -Minimal Bag- WHITE
58347 SILLENT FROM ME DRESS -Minimal Bag- BLACK
57828 SILLENT FROM ME WORDS -Crew Sweat- BLACK
43265 SILLENT FROM ME STIGMA -Pullover- WHITE
37626 SILLENT FROM ME PYRAMID -Crew Sweat- WHITE
39981 SILLENT FROM ME MESS -Pullover- Black
39846 SILLENT FROM ME ALEXIA -Crew Sweat- Black
56750 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- WHITE
56751 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- BLACK
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
56530 SILLENT FROM ME VEIN -Cable Knit Beanie- BLACK
56532 SILLENT FROM ME VEIN -Cable Knit Beanie- WHITE
53126 SILLENT FROM ME PHILOSOPHY -Crew Sweat- BLACK
56053 SILLENT FROM ME PHILOSOPHY -Crew Sweat- WHITE
55986 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- BLACK
55987 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- WHITE
52980 SILLENT FROM ME SHEARS -Acrylic Pendant- BLACK
52981 SILLENT FROM ME SHEARS -Acrylic Pendant- WHITE
20462 SILLENT FROM ME LUST -Skinny- BLACK
20463 SILLENT FROM ME LUST -Skinny- BLACK/WHITE
21165 SILLENT FROM ME ICON -Hockey Shirts- 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
21515 SILLENT FROM ME CRYPTIC -Coach Jkt- BLACK
21516 SILLENT FROM ME CRYPTIC -Coach Jkt- WHITE
21653 SILLENT FROM ME DIVISION -NylonJkt-
21655 SILLENT FROM ME CRYPTIC -Cloak-
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
23722 SILLENT FROM ME HOOKY -Cuffed Track Pants- BLACK
23723 SILLENT FROM ME HOOKY -Cuffed Track Pants- WHITE
23807 SILLENT FROM ME RITUAL-Ziphood- BLACK