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 08:14:37')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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
LIMIT 0, 25
44923 【ゲキクロ限定】acOlaSia STAFF TEE WHITE[B]
52973 acOlaSia DDD L/S
52974 acOlaSia PHENOMENON HOODIE BLACK
52975 acOlaSia PHENOMENON HOODIE YELLOW
52976 acOlaSia ボディバッグ
54129 acOlaSia ENCHANT MARROW INSTILL L/S
54130 acOlaSia PIZZA MAD L/S BLACK
54131 acOlaSia PIZZA MAD L/S PURPLE
54730 acOlaSia “EXIT” big tee Black
54731 acOlaSia “EXIT” big tee White
54732 acOlaSia “KILL NOTICE” big tee Black
54733 acOlaSia “KILL NOTICE” big tee White
54734 acOlaSia “MONKEY BANANA” Tee
54735 acOlaSia “MONKEY BANANA” No sleeve
54737 acOlaSia “LOT””SKULL”ハイカットスニーカー SKULL
54499 【バンドリ!×ゲキクロ第1弾復刻】acOlaSia×今井リサコラボ 限定 キャップ
54498 【バンドリ!×ゲキクロ第1弾復刻】acOlaSia×今井リサコラボ 限定 Tシャツ
54497 【バンドリ!×ゲキクロ第1弾復刻】acOlaSia×今井リサコラボ 限定 パーカー
56000 acOlaSia MARLBONALD TEE WHITE
56001 acOlaSia MARLBONALD TEE BLACK
55998 acOlaSia LOSING MY MIND TEE WHITE
55999 acOlaSia LOSING MY MIND TEE BLACK
56083 acOlaSia SKULL BATTERY tee white
56084 acOlaSia SKULL BATTERY tee black
56085 acOlaSia SKULL SKATE tee white