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-26 23:58:01')
AND pc.price02 > 2727
AND price02 <= 4545
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
58767 SILLENT FROM ME FILLM -Pocket- BLACK
58766 SILLENT FROM ME FILLM -Pocket- WHITE
58765 SILLENT FROM ME WORDS BLACK
58486 SILLENT FROM ME SPELL -Patterned Cutsew-BLACK/BLACK
58488 SILLENT FROM ME FILLM -Loose Long Sleeve- BLACK
58345 SILLENT FROM ME DRESS -Minimal Bag- CLEAR
56533 SILLENT FROM ME VEIN -Cable Knit Beanie- MIXED
20457 SILLENT FROM ME ARTIFICIAL -Broad Shirts- WHITE
20458 SILLENT FROM ME ARTIFICIAL -Broad Shirts- BLACK
21167 SILLENT FROM ME CIRCLE -Longsleeve- 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
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
21854 SILLENT FROM ME MEOW -Pullover-
22175 SILLENT FROM ME DIVISION -Pullover- WHT
22176 SILLENT FROM ME DIVISION -Pullover- BLK
22364 SILLENT FROM ME DUAL -Clutch Bag- WHITE/BLACK
22365 SILLENT FROM ME DUAL -Clutch Bag- BLACK/WHITE
22366 SILLENT FROM ME DUAL -Clutch Bag- BLACK
22383 SILLENT FROM ME SPELL -Longsleeve- WHT
22384 SILLENT FROM ME SPELL -Longsleeve- BLK
22530 DEADHEARTZ x SILLENT FROM ME SINNER SNAPBACK BLACK
22531 DEADHEARTZ X SILLENT FROM ME SINNER SNAPBACK DARK
22732 SILLENT FROM ME SINNER -Snapback-
22877 SILLENT FROM ME DEPRESSED-Pullover- BLACK
22878 SILLENT FROM ME DEPRESSED-Pullover- WHITE
22879 SILLENT FROM ME VOICE-Crew Sweat- BLACK
22880 SILLENT FROM ME VOICE-Crew Sweat- WHITE
22944 SILLENT FROM ME BRAIN -Long Sleeve- BLK
22945 SILLENT FROM ME BRAIN -Long Sleeve- WHT
23421 SILLENT FROM ME LOSE-Pullover- BLACK
23422 SILLENT FROM ME LOSE-Pullover- WHITE
23424 SILLENT FROM ME LOSE-Beanie- BLACK/WHITE
23721 SILLENT FROM ME NORM-Tereko Long Tee- WHITE
24177 SILLENT FROM ME CREST-Crew Sweat- BLK
24178 SILLENT FROM ME CREST-Crew Sweat- WHITE
24569 SILLENT FROM ME CREST BLACK
24570 SILLENT FROM ME CREST WHITE
24571 SILLENT FROM ME STARVE -Ring Belt- BLACK
24572 SILLENT FROM ME STARVE -Ring Belt- WHITE
24575 SILLENT FROM ME MORON -Bum Bag- BLACK
24576 SILLENT FROM ME MORON -Bum Bag- WHITE
24840 SILLENT FROM ME "20"MINOR LEAGUE Collaboration BLACK
25469 SILLENT FROM ME HOOKY -Wide Half Sleeve- BLACK
25471 SILLENT FROM ME HOOKY -Wide Half Sleeve- WHITE
28899 SILLENT FROM ME NORM-Tereko Long Tee- BLK/WHT
28900 SILLENT FROM ME NORM-Tereko Long Tee- BLK
28901 SILLENT FROM ME HUNGED -Long Sleeve- BLK
28902 SILLENT FROM ME HUNGED -Long Sleeve- WHT
29137 SILLENT FROM ME SPELL -Crew Sweat- BLACK
29138 SILLENT FROM ME SPELL -Crew Sweat- WHITE
31808 SILLENT FROM ME ENCRYPTION -Crew Sweat- BLACK
31809 SILLENT FROM ME ENCRYPTION -Crew Sweat- WHITE
32039 SILLENT FROM ME NORM -Waffle Pullover- WHITE
32040 SILLENT FROM ME NORM -Waffle Pullover- BLACK