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-24 20:10:48')
AND pc.stock > 0
AND FIND_IN_SET(14, 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
ORDER BY p.update_date
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
M 残り1点
¥5,500
MISHKA
T-Shirt
L 残り1点
¥22,000
MISHKA
Jacket
M 残り1点
¥22,000
MISHKA
Jacket
¥24,200
MISHKA
Jacket
¥4,950
MISHKA
Cap
S 残り1点
¥11,000
MISHKA
Shorts
¥27,500
MISHKA
Jacket
S 残り1点
¥11,000
MISHKA
Shorts
M 残り1点
¥27,500
MISHKA
Jacket
¥20,900
MISHKA
Bottoms
¥28,600
MISHKA
Jacket
11件見つかりました
1ページ中1ページ目
1
58746 MISHKA NEW WORLD ORDER TEE BLUE
61777 MISHKA (ミシカ) M21100512 JACKET
64933 MISHKA (ミシカ) M21100527 JACKET
65661 MISHKA (ミシカ) M61100508 “MOP”刺繍JACKET
68402 MISHKA (ミシカ) BLUE & RED KEEP WATCH TRUCKER CAP
64932 MISHKA (ミシカ) M21100908 SHORTS
69292 MISHKA (ミシカ) Printed Jacquard Denim Jacket
64934 MISHKA (ミシカ) M21100902 SHORTS
68221 MISHKA (ミシカ) K.W GRAFF DAMAGED DENIM JACKET M21200504 BLUE
69298 MISHKA (ミシカ) Jacquard Jeans Denim Blue
68222 MISHKA (ミシカ)CROWN JACQUARD DENIM VARSITY JACKET M21200551 BLUE