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-19 12:51:13')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(2, p.color)
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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 p.update_date DESC
LIMIT 0, 120
10件見つかりました
1ページ中1ページ目
1
フリー 残り1点
¥7,480
VIRGOwearworks
Cap
完売
¥4,950 → 2,475
VIRGOwearworks
Accessory
完売
¥4,950
VIRGOwearworks
Accessory
完売
¥9,900
VIRGOwearworks
Wallet
完売
¥7,480
VIRGOwearworks
Hat
完売
¥4,950
VIRGOwearworks
Cap
完売
¥6,050
VIRGOwearworks
Beanie
完売
¥4,950
VIRGOwearworks
Bag
完売
¥9,680
VIRGOwearworks
Accessory
完売
¥4,950
VIRGOwearworks
Beanie
10件見つかりました
1ページ中1ページ目
1
59198 VIRGO CROSS V WOOL CAP GRAY
59201 VIRGO DEFOLIATION GLOVES SAX×GRY
59202 VIRGO DEFOLIATION GLOVES GRY×KHA
57038 VIRGO Little giant wallet GRAY
37187 VIRGO ASSIMILATION BERET GRAY
37190 VIRGO SIMPLE KNIT GRAY
38564 VIRGO Big Waffle Knit Cap Gray
41707 VIRGO VGW Imaginary world Squash Gray
44807 VIRGO VG-GD-569 FAT V SNOOD GRAY
45774 VIRGO VG-GD-580 V WAKE KNIT CAP CHARCOAL