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 06:01:18')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(13, 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
14件見つかりました
1ページ中1ページ目
1
¥5,940
VIRGOwearworks
Belt
完売
¥7,480
VIRGOwearworks
Cap
完売
¥4,950
VIRGOwearworks
Cap
完売
¥3,850
VIRGOwearworks
Key Holder
完売
¥4,950
VIRGOwearworks
Cap
完売
¥7,480
VIRGOwearworks
Hat
完売
¥4,950
VIRGOwearworks
Cap
完売
¥6,050
VIRGOwearworks
Beanie
完売
¥7,480
VIRGOwearworks
Bag
完売
¥5,500
VIRGOwearworks
Beanie
完売
¥7,480
VIRGOwearworks
Cap
完売
¥4,950
VIRGOwearworks
Beanie
完売
¥9,680
VIRGOwearworks
Accessory
完売
¥9,680
VIRGOwearworks
Accessory
14件見つかりました
1ページ中1ページ目
1
70880 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt NAVY
28781 VIRGO VWW OLDSCHOOL WOOL CAP NAVY
32018 VIRGO Smiles CAP NAVY
33431 VIRGO Amulet key holder NAVY
36928 VIRGO VGW CAP NAVY
37188 VIRGO ASSIMILATION BERET NAVY
37191 VIRGO SIMPLE KNIT NAVY
38565 VIRGO Big Waffle Knit Cap Navy
39481 VIRGO VGW AWAY MINIBAG NAVY
39483 VIRGO CUSHION KNIT NAVY
43112 VIRGO VG-GD-561 VG BERET NAVY
45875 VIRGO VG-GD-580 V WAKE KNIT CAP NAVY
52370 VIRGO VG-GD-607 3WAY HEAD ROBE NAVY
52373 VIRGO VG-GD-614A DARK CHECK STALL NAVY