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-03-30 00:37:40')
AND FIND_IN_SET(7, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 721)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
9件見つかりました
1ページ中1ページ目
1
完売
¥5,280 → 2,640
SAMURAI CORE
Belt
M 残り1点
¥7,480
SAMURAI CORE
T-Shirt
M 残り1点
¥7,480
SAMURAI CORE
T-Shirt
完売
¥7,480
SAMURAI CORE
T-Shirt
完売
¥9,680
SAMURAI CORE
L/S T-Shirt
M 残り1点
¥15,180
SAMURAI CORE
Pullover
M 残り1点
¥16,280
SAMURAI CORE
Pullover
23cm 残り1点
¥2,200
SAMURAI CORE
Socks
完売
¥5,280
SAMURAI CORE
Belt
9件見つかりました
1ページ中1ページ目
1
65654 SAMURAI CORE(サムライコア) 初期衝動宣言BELT RED
54529 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE RED
53151 SAMURAI CORE 釈迦 TEE RED
53147 SAMURAI CORE 地震ー雷ー火事ーオヤジ TEE RED
53070 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE RED
53076 SAMURAI CORE 釈迦 HOODIE RED
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
54532 SAMURAI CORE SR-AC-031C 風車靴下 RED
54535 SAMURAI CORE SR-AC-032C 夜露死苦哀愁 ガチャベルト RED