SELECT SQL_CALC_FOUND_ROWS 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-20 00:21:57')
AND pc.stock > 0
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 MAX(price02)
LIMIT 0, 25
68393 SABBAT13(サバトサーティーン) POSTHUMOUS LUNCH BAG (BLACK)
19088 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6plus WHITE
19089 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6+ BLACK
19091 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ GREEN
34996 SABBAT13 BEAST iPhone CASE (ブラック) BLACK
34997 SABBAT13 BEAST iPhone CASE (ホワイト) WHITE
60618 SABBAT13 PARADISE LOST TOTE BAG BEIGE
65606 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (GR)
69990 SABBAT13(サバトサーティーン) SPOOK KNIT CAP BLACK
69991 SABBAT13(サバトサーティーン) SPOOK KNIT CAP NAVY
69992 SABBAT13(サバトサーティーン) SPOOK KNIT CAP GRAY
69993 SABBAT13(サバトサーティーン) SPOOK KNIT CAP MOCHA
65912 SABBAT13(サバトサーティーン) SPOOK BOA NECK WARMER (BK)
63258 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt WHITE
63259 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt BLACK
63260 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt ORANGE
63261 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt PURPLE
68384 SABBAT13(サバトサーティーン) PLAY SONG T (BLACK)
68386 SABBAT13(サバトサーティーン) PLAY SONG T (LIGHT BEIGE)
68387 SABBAT13(サバトサーティーン) FATE T (SMOKE BLACK)
68388 SABBAT13(サバトサーティーン) FATE T (ASH)
68392 SABBAT13(サバトサーティーン) POSTHUMOUS BUCKET HAT (BEIGE)
68439 SABBAT13(サバトサーティーン) SCAPEGOAT T (WHITE)
68440 SABBAT13(サバトサーティーン) SCAPEGOAT T (BLACK)
65601 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S RAGLAN T" (BK/GY)