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 18:40:18')
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 75, 25
57189 acOlaSia SMILE MOON BEANIE RED
57190 acOlaSia SMILE MOON BEANIE PURPLE
57191 acOlaSia SMILE MOON BEANIE ORANGE
57192 acOlaSia LOGO BEANIE BLACK
57193 acOlaSia LOGO BEANIE WHITE
57194 acOlaSia LOGO BEANIE RED
57195 acOlaSia LOGO BEANIE PURPLE
57196 acOlaSia LOGO BEANIE ORANGE
55756 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 パーカー
55755 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 Tシャツ
55754 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 ニットキャップ
56607 acOlaSia MAD DOG PULLOVER YELLOW
56606 acOlaSia MAD DOG PULLOVER WHITE
56605 acOlaSia MAD DOG PULLOVER BLACK
56604 acOlaSia INSANE L/S BLACK
56603 acOlaSia INSANE L/S WHITE
56602 acOlaSia HOMINIDAE L/S BLACK
56601 acOlaSia HOMINIDAE L/S WHITE
56083 acOlaSia SKULL BATTERY tee white
56084 acOlaSia SKULL BATTERY tee black
56085 acOlaSia SKULL SKATE tee white
56086 acOlaSia SKULL SKATE tee black
55999 acOlaSia LOSING MY MIND TEE BLACK
55998 acOlaSia LOSING MY MIND TEE WHITE
56001 acOlaSia MARLBONALD TEE BLACK