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