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 15:34:07')
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)
LIMIT 120, 120
36452 SILLENT FROM ME DIVINITY BLACK
36453 SILLENT FROM ME DIVINITY WHITE
36454 SILLENT FROM ME GAZE WHITE
36455 SILLENT FROM ME GAZE BLACK
36458 SILLENT FROM ME CHAOSTIAN -Braid Cap- WHITE
36459 SILLENT FROM ME CHAOSTIAN -Braid Cap- BLACK
36460 SILLENT FROM ME ICHABOD -Sunglass-
36710 SILLENT FROM ME DOLAN -Sunglass- BLACK/CLEAR
36711 SILLENT FROM ME DOLAN -Sunglass- BLACK/BLACK
36712 SILLENT FROM ME MATILDA Sunglass- BLACK
36713 SILLENT FROM ME MATILDA Sunglass- CLEAR
39005 SILLENT FROM ME CHAOSTIAN -Jeep Cap- BK/WH
39006 SILLENT FROM ME CHAOSTIAN -Jeep Cap- BK/BK
39551 SILLENT FROM ME MARCIE -Sunglass- CLR
39552 SILLENT FROM ME MARCIE -Sunglass- BLK
40829 SILLENT FROM ME BOYHOOD BLACK
40830 SILLENT FROM ME BOYHOOD WHITE
40831 SILLENT FROM ME CRY BLACK
40832 SILLENT FROM ME CRY WHITE
40833 SILLENT FROM ME MESS BLACK
40834 SILLENT FROM ME MESS WHITE
40835 SILLENT FROM ME OLIVER -Sunglass- BLACK
40836 SILLENT FROM ME OLIVER -Sunglass- CLEAR
42750 SILLENT FROM ME ILLNESS BLACK
42751 SILLENT FROM ME ILLNESS WHITE
42755 SILLENT FROM ME STIGMA -Snapback- BLACK
42757 SILLENT FROM ME SHEARS -Smart Phone Case-
42978 SILLENT FROM ME SMILE -Polo Cap- BLACK
42979 SILLENT FROM ME SMILE -Polo Cap- WHITE
44303 SILLENT FROM ME STIGMA -Beanie-
46201 SILLENT FROM ME SELENA -Sunglass- BLACK
47372 SILLENT FROM ME QUERY BLACK
47373 SILLENT FROM ME QUERY WHITE
48106 SILLENT FROM ME FEEL BLACK
48107 SILLENT FROM ME FEEL WHITE
48109 SILLENT FROM ME ZEDD -Sunglass- CLEAR
24845 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration BLACK
24847 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration WHITE
24850 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration BLACK
24851 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration WHITE
21305 SILLENT FROM ME D&C -Snapback- White
21306 SILLENT FROM ME D&C -Snapback- Black
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
29135 SILLENT FROM ME MARTYR -Side Slit- BLACK
29136 SILLENT FROM ME MARTYR -Side Slit- WHITE
36048 SILLENT FROM ME PYRAMID -Pocket- BLACK
36049 SILLENT FROM ME PYRAMID -Pocket- WHITE
21855 SILLENT FROM ME NORM -Waffle- BLACK
21856 SILLENT FROM ME NORM -Waffle- WHITE
31810 SILLENT FROM ME SPELL -Cord Cap-
35060 SILLENT FROM ME CRYPTIC -Beret- BLK/BLK
35061 SILLENT FROM ME CRYPTIC -Beret- BLK/WHT
36044 SILLENT FROM ME RICH -Coin Case- BLACK
36045 SILLENT FROM ME RICH -Coin Case- WHITE
39104 SILLENT FROM ME SHEARS -Cushion-
43107 SILLENT FROM ME RICH -Card Case- BLACK/BLACK
43108 SILLENT FROM ME RICH -Card Case- BLACK/WHITE
43109 SILLENT FROM ME RICH -Card Case- WHITE/BLACK
43110 SILLENT FROM ME RICH -Card Case- WHITE/WHITE
38768 SILLENT FROM ME CHAOSTIAN -Beret- BLK/WHT
38769 SILLENT FROM ME CHAOSTIAN -Beret- BLK/BLK
56050 SILLENT FROM ME CULTISM -Socks- BLACK&WHITE
21167 SILLENT FROM ME CIRCLE -Longsleeve- WHITE
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-
22944 SILLENT FROM ME BRAIN -Long Sleeve- BLK
22945 SILLENT FROM ME BRAIN -Long Sleeve- WHT
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
39007 SILLENT FROM ME REDEEM -Glove-
32340 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- BLK
32341 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- WHT
36446 SILLENT FROM ME MUCHINOCHI HYPOCRITE × SILLENTFROMME Collaboration WHITE
36447 SILLENT FROM ME MUCHINOCHI HYPOCRITE × SILLENTFROMME Collaboration BLACK
38770 SILLENT FROM ME CRYPTIC -Tactical Scarves BLK
38771 SILLENT FROM ME CRYPTIC -Tactical Scarves WHT
58765 SILLENT FROM ME WORDS BLACK
58766 SILLENT FROM ME FILLM -Pocket- WHITE
58767 SILLENT FROM ME FILLM -Pocket- BLACK
24569 SILLENT FROM ME CREST BLACK
24570 SILLENT FROM ME CREST WHITE
28901 SILLENT FROM ME HUNGED -Long Sleeve- BLK
28902 SILLENT FROM ME HUNGED -Long Sleeve- WHT
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
42746 SILLENT FROM ME HOLE WHITE
42747 SILLENT FROM ME HOLE BLACK
42748 SILLENT FROM ME SMILE BLACK
42749 SILLENT FROM ME SMILE WHITE
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
24571 SILLENT FROM ME STARVE -Ring Belt- BLACK
24572 SILLENT FROM ME STARVE -Ring Belt- WHITE
33606 SILLENT FROM ME DREAMS -Long Sleeve- BLACK
33607 SILLENT FROM ME DREAMS -Long Sleeve- WHITE
34205 SILLENT FROM ME HUMANE -Long Sleeve- WHITE
34206 SILLENT FROM ME HUMANE -Long Sleeve- BLACK
36443 SILLENT FROM ME CRYPTIC -Outsize- BLACK
36444 SILLENT FROM ME CRYPTIC -Outsize- WHITE
36924 SILLENT FROM ME HAUBERK -Net Cutsaw- BLACK
36925 SILLENT FROM ME HAUBERK -Net Cutsaw- WHITE
40639 SILLENT FROM ME SACRIFICE -Long Sleeve- BLACK
40640 SILLENT FROM ME SACRIFICE -Long Sleeve- WHITE
42976 SILLENT FROM ME METAPHOR -Long Sleeve- White
42977 SILLENT FROM ME METAPHOR -Long Sleeve- Black
47062 SILLENT FROM ME STIGMA -Long Sleeve- WHITE
47922 SILLENT FROM ME MIST -Net Tank Top- BLACK
47923 SILLENT FROM ME MIST -Net Tank Top- WHITE
23721 SILLENT FROM ME NORM-Tereko Long Tee- WHITE
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