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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-18 03:41:11')
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
71727 SABBAT13(サバトサーティーン) SMOKY GIRL Tee BLACK
71728 SABBAT13(サバトサーティーン) SMOKY GIRL Tee WHITE
71729 SABBAT13(サバトサーティーン) SMOKY GIRL Tee SMOKY PINK
71730 SABBAT13(サバトサーティーン) SPOOK LOGO Tee BLACK
71731 SABBAT13(サバトサーティーン) SPOOK LOGO Tee WHITE
71732 SABBAT13(サバトサーティーン) SPOOK LOGO Tee GREEN
65014 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BG)
68016 【BanG Dream! ×ゲキクロ 2023 ver.】宇田川あこ×SABBAT13 コラボ Tシャツ
68439 SABBAT13(サバトサーティーン) SCAPEGOAT T (WHITE)
68440 SABBAT13(サバトサーティーン) SCAPEGOAT T (BLACK)
68388 SABBAT13(サバトサーティーン) FATE T (ASH)
68387 SABBAT13(サバトサーティーン) FATE T (SMOKE BLACK)
68386 SABBAT13(サバトサーティーン) PLAY SONG T (LIGHT BEIGE)
68385 SABBAT13(サバトサーティーン) PLAY SONG T (MOSS GRAY)
68384 SABBAT13(サバトサーティーン) PLAY SONG T (BLACK)
65604 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (BK)
65606 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (GR)
65605 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (WH)
65023 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (BG)
65021 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (GR)
65020 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (SMOKE)
64504 SABBAT13(サバトサーティーン) FRIEND T (WH)
64505 SABBAT13(サバトサーティーン) FRIEND T (BK)
64146 SABBAT13(サバトサーティーン) FRIEND T (GD)
64502 SABBAT13(サバトサーティーン) GOD T (WH)