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-22 19:29:33')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 159)
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
68000 【BanG Dream! ×ゲキクロ 2023 ver.】ロック×acOlaSia コラボ L/S Tシャツ
65930 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・パーカー The Scream BLACK
65932 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -100g- BLACK
65933 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -12g- BLACK
63237 acOlaSia (アコレイジア) Hungry L/S BLACK
62183 acOlaSia (アコレイジア) GAMING hoodie BLACK
62185 acOlaSia (アコレイジア) DOPE hoodie BLACK
61818 acOlaSia (アコレイジア) VxC hoodie BLACK
60247 acOlaSia NEXT IS YOU TEE BLACK
60239 acOlaSia VICTIM TEE BLACK
60241 acOlaSia FRIDAY BACK PRINT TEE BLACK
60243 acOlaSia I DON'T GIVE A SHIT TEE BLACK
60245 acOlaSia MEDAMAYAKI TEE BLACK
58612 acOlaSia 浮世映 パーカー BLACK
58618 acOlaSia ILLUMINATI パーカー BLACK
58382 acOlaSia Angel pic hoodie BLACK
57182 acOlaSia poison hoodie BLACK
57185 acOlaSia 煙仄 L/S BLACK
56605 acOlaSia MAD DOG PULLOVER BLACK
56604 acOlaSia INSANE L/S BLACK
56602 acOlaSia HOMINIDAE L/S BLACK
56086 acOlaSia SKULL SKATE tee black
55999 acOlaSia LOSING MY MIND TEE BLACK
56001 acOlaSia MARLBONALD TEE BLACK
54129 acOlaSia ENCHANT MARROW INSTILL L/S