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 21:02:28')
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 240, 120
26220 SILLENT FROM ME DROUGHT BLACK
26221 SILLENT FROM ME DROUGHT WHITE
26222 SILLENT FROM ME SPELL -Snapback- WHITE
26223 SILLENT FROM ME SPELL -Snapback- BLACK
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
26619 SILLENT FROM ME CRYPTIC -Neck Strap-
28434 SILLENT FROM ME ENCRYPTION WHT
28435 SILLENT FROM ME ENCRYPTION BLK
28436 SILLENT FROM ME TEAR WHT
28437 SILLENT FROM ME TEAR BLK
28438 SILLENT FROM ME ENCRYPTION -Snapback- WHT
28439 SILLENT FROM ME ENCRYPTION -Snapback- BLK/BLK
28441 SILLENT FROM ME ENCRYPTION -Snapback- BLK
28442 SILLENT FROM ME WHISPER -Polo Cap- WHT
28443 SILLENT FROM ME WHISPER -Polo Cap- BLK
28684 SILLENT FROM ME DENSE BLACK
28685 SILLENT FROM ME DENSE WHTE
28802 SILLENT FROM ME DROUGHT -Ziphood- BLACK
28803 SILLENT FROM ME DROUGHT -Ziphood- WHITE
28804 SILLENT FROM ME VOICE -Coach Jkt- BLACK
28805 SILLENT FROM ME VOICE -Coach Jkt- WHITE
28806 SILLENT FROM ME EPITAPH -5 Panel- BLACK
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
29094 SILLENT FROM ME LINT -Wide Flannel Shirts-
29135 SILLENT FROM ME MARTYR -Side Slit- BLACK
29136 SILLENT FROM ME MARTYR -Side Slit- WHITE
29137 SILLENT FROM ME SPELL -Crew Sweat- BLACK
29138 SILLENT FROM ME SPELL -Crew Sweat- WHITE
29854 SILLENT FROM ME MARTYR -Flight Jkt- BLACK
29855 SILLENT FROM ME WHISPER -Beanie-
30014 SILLENT FROM ME VENOM -Biker Pants- BLACK
30015 SILLENT FROM ME VENOM -Biker Pants- WHITE
30016 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK/WHITE
30017 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK
30019 SILLENT FROM ME MIMICRY -Knit Sweater- WHITE
31806 SILLENT FROM ME EPITAPH -Pullover- WHITE
31807 SILLENT FROM ME EPITAPH -Pullover- BLACK
31808 SILLENT FROM ME ENCRYPTION -Crew Sweat- BLACK
31809 SILLENT FROM ME ENCRYPTION -Crew Sweat- WHITE
31810 SILLENT FROM ME SPELL -Cord Cap-
32039 SILLENT FROM ME NORM -Waffle Pullover- WHITE
32040 SILLENT FROM ME NORM -Waffle Pullover- BLACK
32041 SILLENT FROM ME HUNGED -Pullover- BLACK
32042 SILLENT FROM ME HUNGED -Pullover- WHITE
32327 SILLENT FROM ME ENCRYPTION -Ziphood- BLK
32328 SILLENT FROM ME ENCRYPTION -Ziphood- WHT
32330 SILLENT FROM ME BILLOW -Polo Cap- BLK
32333 SILLENT FROM ME BILLOW -Polo Cap- WHT
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
32497 SILLENT FROM ME HUMANE -Coach Jkt- WHT
32498 SILLENT FROM ME HUMANE -Coach Jkt- BLK
32499 SILLENT FROM ME TEAR -Crew Sweat- BLK
32500 SILLENT FROM ME TEAR -Crew Sweat- WHT
32501 SILLENT FROM ME HUMANE -Beanie- WHT
32502 SILLENT FROM ME HUMANE -Beanie- 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
33443 SILLENT FROM ME NAP -Sarouel Pants- BLACK
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
33921 SILLENT FROM ME CRYPTIC -W Cord Belt- BLACK
34095 SILLENT FROM ME BANDIT -Roll Bag- BLACK
34096 SILLENT FROM ME BANDIT -Roll Bag- WHITE
34097 SILLENT FROM ME LISBETH -Flip Day Pack- BLACK/WHITE
34098 SILLENT FROM ME LISBETH -Flip Day Pack- BLACK
34205 SILLENT FROM ME HUMANE -Long Sleeve- WHITE
34206 SILLENT FROM ME HUMANE -Long Sleeve- BLACK
34207 SILLENT FROM ME HUMANE -Snapback- BLACK
34208 SILLENT FROM ME HUMANE -Snapback- WHITE
35042 SILLENT FROM ME CRYDE -Outsize Series- BLK
35043 SILLENT FROM ME CRYDE -Outsize Series- WHT
35047 SILLENT FROM ME SCRIBBLE BLK
35048 SILLENT FROM ME SCRIBBLE WHT
35058 SILLENT FROM ME POSER BLK
35059 SILLENT FROM ME POSER WHT
35060 SILLENT FROM ME CRYPTIC -Beret- BLK/BLK
35061 SILLENT FROM ME CRYPTIC -Beret- BLK/WHT
35062 SILLENT FROM ME Sunglass
35495 SILLENT FROM ME MOAN TEE BLK
35496 SILLENT FROM ME MOAN TEE WHE
35497 SILLENT FROM ME BLACK LOCK -Key Ring-
35498 SILLENT FROM ME BLACK BOX -Aluminium Wallet-
35499 SILLENT FROM ME BILLOW -Polo Cap- BLK
35500 SILLENT FROM ME BILLOW -Polo Cap-
35587 SILLENT FROM ME KEEK -Outsize- BLACK
35588 SILLENT FROM ME KEEK -Outsize- WHITE
35592 SILLENT FROM ME SELMA -Sunglass- BLK/BLK
35593 SILLENT FROM ME SELMA -Sunglass- BLACK/CLEAR
35595 SILLENT FROM ME TALISMAN -Charm-
35597 SILLENT FROM ME DISTRESSED -G.I Shoulder Bag-
36044 SILLENT FROM ME RICH -Coin Case- BLACK
36045 SILLENT FROM ME RICH -Coin Case- WHITE
36046 SILLENT FROM ME PYRAMID -Snapback- BLACK
36047 SILLENT FROM ME PYRAMID -Snapback- WHITE
36048 SILLENT FROM ME PYRAMID -Pocket- BLACK
36049 SILLENT FROM ME PYRAMID -Pocket- 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
36448 SILLENT FROM ME ANTHONY -Sunglass- BLK/GOLD
36451 SILLENT FROM ME ANTHONY -Sunglass- WHITE/BLUE
36452 SILLENT FROM ME DIVINITY BLACK
36453 SILLENT FROM ME DIVINITY WHITE
36454 SILLENT FROM ME GAZE WHITE
36455 SILLENT FROM ME GAZE BLACK
36456 SILLENT FROM ME DIANA -Outsize Long Sleeve- BLACK
36457 SILLENT FROM ME DIANA -Outsize Long Sleeve- WHITE
36458 SILLENT FROM ME CHAOSTIAN -Braid Cap- WHITE