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-20 04:39:03')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(7, 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
9件見つかりました
1ページ中1ページ目
1
完売
¥4,950
VIRGOwearworks
Accessory
完売
¥7,480
VIRGOwearworks
Beanie
完売
¥6,380
VIRGOwearworks
Accessory
完売
¥9,680
VIRGOwearworks
bag
完売
¥3,850
VIRGOwearworks
Accessory
完売
¥4,950
VIRGOwearworks
Bracelet
完売
¥9,680
VIRGOwearworks
Cap
完売
¥9,680
VIRGOwearworks
Accessory
完売
¥9,680
VIRGOwearworks
Accessory
9件見つかりました
1ページ中1ページ目
1
59203 VIRGO DEFOLIATION GLOVES BLU×RED
29657 VIRGO MOUNTAIN MOUTH DAMAGE KNIT RED
32012 VIRGO Blended Beads Bracelet RED
35214 VIRGO LANTANA ALOHA BAG RED
38561 VIRGO Layering groove RED
39120 VIRGO PERVERSE BRACELET RED
44329 VIRGO VG BOA FLYING CAP VG-GD-560 RED
44806 VIRGO VG-GD-569 FAT V SNOOD RED
52372 VIRGO VG-GD-614A DARK CHECK STALL RED