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-19 01:51:14')
AND FIND_IN_SET(4, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 628)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 25
8件見つかりました
1ページ中1ページ目
1
XL 残り1点
¥29,700
VIRGOwearworks
Jacket
L 残り1点
¥24,750
VIRGOwearworks
Knit
M 残り1点
¥22,880
VIRGOwearworks
Bottoms
完売
¥20,680
VIRGOwearworks
Bottoms
XL 残り1点
¥19,800
VIRGOwearworks
Bottoms
L 残り1点
¥19,800
VIRGOwearworks
L/S Shirt
完売
¥17,380
VIRGOwearworks
Shorts
完売
¥14,850 → 4,455
VIRGOwearworks
S/S Shirt
8件見つかりました
1ページ中1ページ目
1
69482 VIRGOwearworks (ヴァルゴウェアワークス) CREW STUDIUM BLOUSON BROWN
70066 VIRGOwearworks (ヴァルゴウェアワークス) LIGHTNING KANJI KNIT BEG×BRW
71384 VIRGOwearworks (ヴァルゴウェアワークス) Spark pants BROWN
69480 VIRGOwearworks (ヴァルゴウェアワークス) EXPLORATION FAT PANTS BROWN
66397 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers pants ブラウン
71385 VIRGOwearworks (ヴァルゴウェアワークス) Spark shirts BROWN
55447 VIRGO NINJAS CORDUROY - BEIGE
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN