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 01:43:50')
AND pc.stock > 0
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, 75
10件見つかりました
1ページ中1ページ目
1
¥14,080
VIRGOwearworks
Bag
¥5,940
VIRGOwearworks
Belt
¥5,940
VIRGOwearworks
Belt
フリー 残り1点
¥2,200
VIRGO
Socks
¥2,200
VIRGO
Socks
¥5,940
VIRGOwearworks
Belt
フリー 残り1点
¥14,080
VIRGOwearworks
Bag
¥7,480
VIRGOwearworks
Sunglasses
¥7,480
VIRGOwearworks
Sunglasses
フリー 残り1点
¥7,480
VIRGOwearworks
Cap
10件見つかりました
1ページ中1ページ目
1
69655 VIRGOwearworks (ヴァルゴウェアワークス) TECHNICAL MINI SHOULDER BAG BLACK
70881 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt OD
70880 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt NAVY
70265 VIRGO(ヴァルゴ) KANJI SOX GREEN
70266 VIRGO(ヴァルゴ) KANJI SOX WHITE
70879 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt BLACK
64044 VIRGO(ヴァルゴ)PUFF DOWN SHOULDER BAG KHAKI
64037 VIRGO(ヴァルゴ)BOSTONS BLACK-BLUE
64038 VIRGO(ヴァルゴ)BOSTONS BLACK-GRAY
59198 VIRGO CROSS V WOOL CAP GRAY