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-25 09:23:18')
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 180, 60
23722 SILLENT FROM ME HOOKY -Cuffed Track Pants- BLACK
23723 SILLENT FROM ME HOOKY -Cuffed Track Pants- WHITE
23724 SILLENT FROM ME NORM -Wide Rain Coat- BLACK
23725 SILLENT FROM ME NORM -Wide Rain Coat- WHITE
23807 SILLENT FROM ME RITUAL-Ziphood- BLACK
23808 SILLENT FROM ME RITUAL-Ziphood- WHITE
23809 SILLENT FROM ME VOICE-Snapback- WHITE
23810 SILLENT FROM ME VOICE-Snapback- BLACK
23907 SILLENT FROM ME ANACHRONIC BLACK
23908 SILLENT FROM ME ANACHRONIC WHITE
24177 SILLENT FROM ME CREST-Crew Sweat- BLK
24178 SILLENT FROM ME CREST-Crew Sweat- WHITE
24179 SILLENT FROM ME NORM -Long Shirts- BLACK
24180 SILLENT FROM ME NORM -Long Shirts- WHITE
24182 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- BLACK
24184 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- 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
24331 SILLENT FROM ME D&C BLACK
24332 SILLENT FROM ME D&C WHITE
24333 SILLENT FROM ME SIN -Back Pack- BLACK
24334 SILLENT FROM ME SIN -Back Pack- WHITE
24378 SILLENT FROM ME BRAIN-Hood Shirts- BLK
24379 SILLENT FROM ME BRAIN-Hood Shirts- WHT
24380 SILLENT FROM ME LOSE-Snapback- BLK
24381 SILLENT FROM ME LOSE-Snapback- WHT
24427 SILLENT FROM ME CIRCLE BLACK
24428 SILLENT FROM ME CIRCLE WHITE
24430 SILLENT FROM ME TRIANGLE BLACK
24431 SILLENT FROM ME TRIANGLE WHITE
24433 SILLENT FROM ME SQUARE WHITE
24546 SILLENT FROM ME DEPRESSED BLACK
24547 SILLENT FROM ME DEPRESSED WHITE
24548 SILLENT FROM ME 771#-Pocket- BLACK
24549 SILLENT FROM ME 771#-Pocket- 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
24573 SILLENT FROM ME RITUAL WHITE
24574 SILLENT FROM ME RITUAL BLACK
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
24841 SILLENT FROM ME "20"MINOR LEAGUE Collaboration WHITE
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
25469 SILLENT FROM ME HOOKY -Wide Half Sleeve- BLACK
25471 SILLENT FROM ME HOOKY -Wide Half Sleeve- WHITE
25472 SILLENT FROM ME LOSE BLACK
25474 SILLENT FROM ME LOSE WHITE
25475 SILLENT FROM ME CRYPTIC -Drape Tee- BLACK
25477 SILLENT FROM ME CRYPTIC -Drape Tee- WHITE
25478 SILLENT FROM ME ANACHRONIC -Dolman Onepiece-
25480 SILLENT FROM ME ICON -Charm-
25481 SILLENT FROM ME RAY -Compact Mirror-