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-26 02:24:14')
AND pc.stock > 0
AND FIND_IN_SET(6, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 240)
AND pc.del_flg = 0
GROUP BY p.product_id
LIMIT 0, 120
8件見つかりました
1ページ中1ページ目
1
L 残り1点
¥11,000
MISHKA
T-Shirt
¥17,600
MISHKA
Pullover
¥8,800
MISHKA
T-Shirt
¥19,800
MISHKA
L/S Shirt
¥14,300
MISHKA
Shorts
¥19,800
MISHKA
Knit
¥35,200
MISHKA
Jacket
M 残り1点
¥52,800
MISHKA
Jacket
8件見つかりました
1ページ中1ページ目
1
68413 MISHKA (ミシカ) WASHEDKEEP WATCH TEE (KHAKI/M21200007KHAKI)
69287 MISHKA (ミシカ) M61200404 Embroidery Hoodie Beige
69290 MISHKA (ミシカ) M61200052 Embroidery Tee Ivory
69293 MISHKA (ミシカ) Jacquard Long Sleeve Shirt Beige
69294 MISHKA (ミシカ) Jacquard Woven Shorts Beige
70144 MISHKA (ミシカ) LOGO HALF ZIP KNIT BEIGE
70151 MISHKA (ミシカ) CHECK SHIRT JKT BEIGE
70154 MISHKA (ミシカ) MONOGRAM DOWN JACKET BEIGE