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-04-30 19:00:16')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 12,44)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 437)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
70478 SABBAT13(サバトサーティーン) SPOOK PUFF JKT (BK)
70482 SABBAT13(サバトサーティーン) BOA CARDIGAN (BK)
70480 SABBAT13(サバトサーティーン) SPOOK PUFF JKT (GY)
70479 SABBAT13(サバトサーティーン) BOA CARDIGAN (BG)
70481 SABBAT13(サバトサーティーン) SPOOK PUFF JKT (OL)
69989 SABBAT13(サバトサーティーン) COLLEGE WIDE SWEAT OLIVE
69988 SABBAT13(サバトサーティーン) COLLEGE WIDE SWEAT TURQUOISE
69987 SABBAT13(サバトサーティーン) COLLEGE WIDE SWEAT BLACK ASH
69519 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE BLACK
69520 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE ASH
69521 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE SAND
69524 SABBAT13(サバトサーティーン) POSTHUMOUS HOODIE BLACK
69525 SABBAT13(サバトサーティーン) POSTHUMOUS HOODIE SMOKY GREEN
69527 SABBAT13(サバトサーティーン) PLAY SONG HOODIE OLIVE
69532 SABBAT13(サバトサーティーン) DEATH HAWK L/S T BLACK
69533 SABBAT13(サバトサーティーン) DEATH HAWK L/S T WHITE
69535 SABBAT13(サバトサーティーン) BORED BIG L/S T BLACK
69536 SABBAT13(サバトサーティーン) BORED BIG L/S T WHITE
69537 SABBAT13(サバトサーティーン) BORED BIG L/S T GREEN
65684 SABBAT13(サバトサーティーン) SCAPEGOAT HOODIE BLACK
65914 SABBAT13(サバトサーティーン) SPOOK W-KNEE PANTS (GR)
65913 SABBAT13(サバトサーティーン) SPOOK W-KNEE PANTS (PL)
68015 【BanG Dream! ×ゲキクロ 2023 ver.】宇田川あこ×SABBAT13 コラボ プルオーバーパーカー
68594 SABBAT13(サバトサーティーン) SPOOK CUBA SHIRTS MAROON
68593 SABBAT13(サバトサーティーン) SPOOK CUBA SHIRTS GREEN