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 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-05-08 14:08:29')
AND pc.stock > 0
AND pc.point_rate >1
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 MAX(price02) DESC
LIMIT 0, 240
14件見つかりました
1ページ中1ページ目
1
L 残り1点
¥22,000
MISHKA
Jacket
M 残り1点
¥22,000
MISHKA
Jacket
M 残り1点
¥19,800
MISHKA
L/S Shirt
M 残り1点
¥19,800
MISHKA
L/S Shirt
M 残り1点
¥17,600
MISHKA
Pullover
L 残り1点
¥17,600
MISHKA
Pullover
¥16,500
MISHKA
Shorts
¥15,400
MISHKA
Shorts
S 残り1点
¥11,000
MISHKA
Shorts
S 残り1点
¥11,000
MISHKA
Shorts
M 残り1点
¥7,150
MISHKA
T-Shirt
M 残り1点
¥5,500
MISHKA
T-Shirt
M 残り1点
¥5,500
MISHKA
T-Shirt
¥2,420
MISHKA
Accessory
14件見つかりました
1ページ中1ページ目
1
61777 MISHKA (ミシカ) M21100512 JACKET
64933 MISHKA (ミシカ) M21100527 JACKET
61755 MISHKA (ミシカ) M21100290 SHIRT
63082 MISHKA (ミシカ) M21100201 SHIRT
58109 MISHKA M21000404 Pullover WHITE
58110 MISHKA M21000404 Pullover BLACK
58826 MISHKA(ミシカ) M21000823 SHORTS
58134 MISHKA M21000809 Shorts
64932 MISHKA (ミシカ) M21100908 SHORTS
64934 MISHKA (ミシカ) M21100902 SHORTS
57363 MISHKA M21000059 T-Shirt ORANGE
58744 MISHKA NEW WORLD ORDER TEE WHITE
58746 MISHKA NEW WORLD ORDER TEE BLUE
56891 MISHKA(ミシカ) TAPE SET