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-04-28 08:53:38')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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
12件見つかりました
1ページ中1ページ目
1
完売
¥14,850 → 4,455
VIRGOwearworks
S/S Shirt
完売
¥14,080
VIRGOwearworks
7/S T-shirt
完売
¥15,180
VIRGOwearworks
Shorts
完売
¥17,050
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
完売
¥29,700
VIRGOwearworks
Jacket
12件見つかりました
1ページ中1ページ目
1
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN
43155 VIRGO VG-CUT-372 PREFERENCE PLUS カットオフカットソー KHAKI
41713 VIRGO E.D.O Summer suit bottom Chacoarl
41710 VIRGO E.D.O Summer suit top Charcoal
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
50723 VIRGO VG-JKT-208 VGW DRAPE MODS COAT KHAKI
69482 VIRGOwearworks (ヴァルゴウェアワークス) CREW STUDIUM BLOUSON BROWN