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-05-01 20:27:41')
AND FIND_IN_SET(3, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 647)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
69374 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・ロンT RED
69373 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・ロンT BLUE
69169 acOlaSia (アコレイジア)Thanatos tee White
69167 acOlaSia (アコレイジア)Melancholy Twins tee White
65929 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・パーカー The Scream WHITE
65931 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -100g- WHITE
65934 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -12g- WHITE
63235 acOlaSia (アコレイジア) Hungry L/S WHITE
62184 acOlaSia (アコレイジア) GAMING hoodie WHITE
62186 acOlaSia (アコレイジア) DOPE hoodie WHITE
61819 acOlaSia (アコレイジア) VxC hoodie WHITE
60240 acOlaSia VICTIM TEE WHITE
60242 acOlaSia FRIDAY BACK PRINT TEE WHITE
60244 acOlaSia I DON'T GIVE A SHIT TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
60248 acOlaSia NEXT IS YOU TEE WHITE
58617 acOlaSia 浮世映 パーカー WHITE
58621 acOlaSia ILLUMINATI パーカー WHITE
52429 acOlaSia Marlbonald パーカー WHITE
58381 acOlaSia Angel pic hoodie WHITE
57183 acOlaSia STAFF L/S WHITE
57178 acOlaSia Camphell's コーチジャケット WHITE
57181 acOlaSia poison hoodie WHITE
57186 acOlaSia 煙仄 L/S WHITE
57188 acOlaSia SMILE MOON BEANIE WHITE