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 11:04:12')
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, 120
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
32337 SILLENT FROM ME BALANCE -Long Sleeve- BLK
32339 SILLENT FROM ME BALANCE -Long Sleeve- WHT
32340 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- BLK
32341 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- WHT
32499 SILLENT FROM ME TEAR -Crew Sweat- BLK
32500 SILLENT FROM ME TEAR -Crew Sweat- WHT
33601 SILLENT FROM ME EPITAPH -Crew Sweat- BLACK
33602 SILLENT FROM ME EPITAPH -Crew Sweat- WHITE
33606 SILLENT FROM ME DREAMS -Long Sleeve- BLACK
33607 SILLENT FROM ME DREAMS -Long Sleeve- WHITE
34095 SILLENT FROM ME BANDIT -Roll Bag- BLACK
34096 SILLENT FROM ME BANDIT -Roll Bag- WHITE
34205 SILLENT FROM ME HUMANE -Long Sleeve- WHITE
34206 SILLENT FROM ME HUMANE -Long Sleeve- BLACK
35042 SILLENT FROM ME CRYDE -Outsize Series- BLK
35043 SILLENT FROM ME CRYDE -Outsize Series- WHT
35587 SILLENT FROM ME KEEK -Outsize- BLACK
35588 SILLENT FROM ME KEEK -Outsize- WHITE
35597 SILLENT FROM ME DISTRESSED -G.I Shoulder Bag-
36047 SILLENT FROM ME PYRAMID -Snapback- WHITE
36443 SILLENT FROM ME CRYPTIC -Outsize- BLACK
36444 SILLENT FROM ME CRYPTIC -Outsize- WHITE
36446 SILLENT FROM ME MUCHINOCHI HYPOCRITE × SILLENTFROMME Collaboration WHITE
36447 SILLENT FROM ME MUCHINOCHI HYPOCRITE × SILLENTFROMME Collaboration BLACK
36451 SILLENT FROM ME ANTHONY -Sunglass- WHITE/BLUE
36456 SILLENT FROM ME DIANA -Outsize Long Sleeve- BLACK
36457 SILLENT FROM ME DIANA -Outsize Long Sleeve- WHITE
36709 SILLENT FROM ME DREAMS -Ziphood- BLACK
36920 SILLENT FROM ME CRYPTIC -Outsize Long Sleeve- BLACK
36921 SILLENT FROM ME CRYPTIC -Outsize Long Sleeve- WHITE
36924 SILLENT FROM ME HAUBERK -Net Cutsaw- BLACK
36925 SILLENT FROM ME HAUBERK -Net Cutsaw- WHITE
37118 SILLENT FROM ME RUBRIC -Crew Sweat- WHITE
37470 SILLENT FROM ME BILLOW -Beanie- WHITE
37625 SILLENT FROM ME PYRAMID -Crew Sweat- BLACK
38170 SILLENT FROM ME AVA -Trooper Cap- WHITE
38171 SILLENT FROM ME AVA -Trooper Cap- BLACK
38172 SILLENT FROM ME AVA -Trooper Cap- BLACK/WHITE
38176 SILLENT FROM ME CHAOSTIAN - Beanie- WHITE
38177 SILLENT FROM ME CHAOSTIAN - Beanie- BLACK
38715 SILLENT FROM ME SILLENT FROM ME GAZE -Pullover-
38770 SILLENT FROM ME CRYPTIC -Tactical Scarves BLK
38771 SILLENT FROM ME CRYPTIC -Tactical Scarves WHT
39004 SILLENT FROM ME CRYPTIC -Outsize Long Sleeve-
39007 SILLENT FROM ME REDEEM -Glove-
39101 SILLENT FROM ME DIVINITY -Crew Sweat- BLACK
39102 SILLENT FROM ME DIVINITY -Crew Sweat- WHITE
39556 SILLENT FROM ME CRY -Pullover- WHITE
39557 SILLENT FROM ME CRY -Pullover- BLACK
39845 SILLENT FROM ME ALEXIA -Crew Sweat- White
39980 SILLENT FROM ME MESS -Pullover- White
40639 SILLENT FROM ME SACRIFICE -Long Sleeve- BLACK
40640 SILLENT FROM ME SACRIFICE -Long Sleeve- WHITE
42746 SILLENT FROM ME HOLE WHITE
42747 SILLENT FROM ME HOLE BLACK
42748 SILLENT FROM ME SMILE BLACK
42749 SILLENT FROM ME SMILE WHITE
42756 SILLENT FROM ME STIGMA -Snapback- WHITE
42976 SILLENT FROM ME METAPHOR -Long Sleeve- White
42977 SILLENT FROM ME METAPHOR -Long Sleeve- Black