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 20:25:08')
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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
56874 SILLENT FROM ME EVIDENCE -Extra Wide Poncho- GRAY
58490 SILLENT FROM ME EYE -Snapback-
57829 SILLENT FROM ME EYE -Beanie-
56259 SILLENT FROM ME SILLENT FROM ME ODIN -Ear Muff Beanie-
58345 SILLENT FROM ME DRESS -Minimal Bag- CLEAR
58346 SILLENT FROM ME DRESS -Minimal Bag- WHITE
58347 SILLENT FROM ME DRESS -Minimal Bag- BLACK
56050 SILLENT FROM ME CULTISM -Socks- BLACK&WHITE
50394 SILLENT FROM ME SMILE -Ziphood- WHITE
50395 SILLENT FROM ME SMILE -Ziphood- BLACK
56875 SILLENT FROM ME EVIDENCE -Extra Wide Poncho- BLACK
56524 SILLENT FROM ME VEIN -Cable Knit Snood- BLACK
56525 SILLENT FROM ME VEIN -Cable Knit Snood- WHITE
56526 SILLENT FROM ME VEIN -Cable Knit Snood- MIXED
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
56533 SILLENT FROM ME VEIN -Cable Knit Beanie- MIXED
56253 SILLENT FROM ME HARRIET -6pockets Wrap Skirt- GRAY CHECK
56255 SILLENT FROM ME HARRIET -6pockets Wrap Skirt- BLACK CHECK
56256 SILLENT FROM ME HARRIET -6pockets Wrap Skirt- BLACK
56121 SILLENT FROM ME DOUGLAS Fuzzy Tank Top
52980 SILLENT FROM ME SHEARS -Acrylic Pendant- BLACK
52981 SILLENT FROM ME SHEARS -Acrylic Pendant- WHITE
52979 SILLENT FROM ME SHEARS -Acrylic Pendant- CLEAR
20230 SILLENT FROM ME CRYPTIC -Snapback- BLK
20231 SILLENT FROM ME CRYPTIC -Snapback- WHT
20232 SILLENT FROM ME ICON -Beanie-
20233 SILLENT FROM ME MEOW -Shoulder Bag-
20234 SILLENT FROM ME MEOW -Bandana-
20235 SILLENT FROM ME LIP -Bandana-
20459 SILLENT FROM ME ALEX -Sunglass- BLACK/CLEAR
20460 SILLENT FROM ME ALEX -Sunglass- BLACK/BLACK
20461 SILLENT FROM ME ALEX -Sunglass- WHITE/BLACK
21305 SILLENT FROM ME D&C -Snapback- White
21306 SILLENT FROM ME D&C -Snapback- Black
21517 SILLENT FROM ME CRYPTIC -Beanie- WHITE
21518 SILLENT FROM ME CRYPTIC -Beanie- BLACK
21655 SILLENT FROM ME CRYPTIC -Cloak-
21858 SILLENT FROM ME QUIET -Snapback- BLACK
21859 SILLENT FROM ME QUIET -Snapback- WHITE
21860 SILLENT FROM ME NORM -Bucket Hat- BLACK
21861 SILLENT FROM ME NORM -Bucket Hat- WHITE
21862 SILLENT FROM ME QUIET -Shoulder Bag-
22043 SILLENT FROM ME SHHH -iphone6/6s Case-
22205 SILLENT FROM ME NORM -Beanie- BLACK/WHITE
22207 SILLENT FROM ME NORM -Beanie- BLACK/BLACK
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
22530 DEADHEARTZ x SILLENT FROM ME SINNER SNAPBACK BLACK
22531 DEADHEARTZ X SILLENT FROM ME SINNER SNAPBACK DARK
22732 SILLENT FROM ME SINNER -Snapback-
22883 SILLENT FROM ME VOICE-Beanie- BLACK/BLACK
22884 SILLENT FROM ME VOICE-Beanie- BLACK/WHITE
22885 SILLENT FROM ME BRAIN -Bandana- BLACK
22886 SILLENT FROM ME ELEMENTS -IC Card Sticker-
22946 SILLENT FROM ME D&C-Beanie- WHT
22947 SILLENT FROM ME D&C-Beanie- BLK/WHT
22948 SILLENT FROM ME D&C-Beanie- BLK.BLK
23424 SILLENT FROM ME LOSE-Beanie- BLACK/WHITE
23425 SILLENT FROM ME LOSE-Beanie- WHITE
23809 SILLENT FROM ME VOICE-Snapback- WHITE
23810 SILLENT FROM ME VOICE-Snapback- BLACK
24177 SILLENT FROM ME CREST-Crew Sweat- BLK
24178 SILLENT FROM ME CREST-Crew Sweat- WHITE
24213 SILLENT FROM ME×激ロック COLLABORATION BADGE DEPRESSED WHT
24214 SILLENT FROM ME×激ロック COLLABORATION BADGE DEPRESSED BLK
24215 SILLENT FROM ME×激ロック COLLABORATION BADGE ROCK BLK
24216 SILLENT FROM ME×激ロック COLLABORATION BADGE ROCK WHT
24333 SILLENT FROM ME SIN -Back Pack- BLACK
24334 SILLENT FROM ME SIN -Back Pack- WHITE
24380 SILLENT FROM ME LOSE-Snapback- BLK
24381 SILLENT FROM ME LOSE-Snapback- WHT
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
24850 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration BLACK
24851 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration WHITE
25478 SILLENT FROM ME ANACHRONIC -Dolman Onepiece-
25480 SILLENT FROM ME ICON -Charm-
25481 SILLENT FROM ME RAY -Compact Mirror-
26222 SILLENT FROM ME SPELL -Snapback- WHITE
26223 SILLENT FROM ME SPELL -Snapback- BLACK
26619 SILLENT FROM ME CRYPTIC -Neck Strap-
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
28806 SILLENT FROM ME EPITAPH -5 Panel- BLACK
29855 SILLENT FROM ME WHISPER -Beanie-
31810 SILLENT FROM ME SPELL -Cord Cap-
32330 SILLENT FROM ME BILLOW -Polo Cap- BLK
32333 SILLENT FROM ME BILLOW -Polo Cap- WHT
32501 SILLENT FROM ME HUMANE -Beanie- WHT
32502 SILLENT FROM ME HUMANE -Beanie- BLK
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
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
35060 SILLENT FROM ME CRYPTIC -Beret- BLK/BLK
35061 SILLENT FROM ME CRYPTIC -Beret- BLK/WHT
35062 SILLENT FROM ME Sunglass
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