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-24 05:45:57')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.classcategory_id1 IN( 14,61,35)
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) DESC
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
完売
¥15,180
VIRGOwearworks
Sandal
完売
¥15,180
VIRGOwearworks
Sandal
完売
¥6,600
VIRGOwearworks
T-Shirt
完売
¥6,050
VIRGOwearworks
T-Shirts
完売
¥6,050
VIRGOwearworks
T-Shirts
完売
¥6,050
VIRGOwearworks
T-Shirts
完売
¥6,050
VIRGOwearworks
T-Shirts
完売
¥6,050
VIRGOwearworks
T-Shirts
完売
¥6,050
VIRGOwearworks
T-Shirts
完売
¥3,056
BAND-MAID
T-Shirt
完売
¥3,056
BAND-MAID
T-Shirt
11件見つかりました
1ページ中1ページ目
1
41776 VIRGO VG-GD-548 Greece rubber sandal サンダル BLACK
41777 VIRGO VG-GD-548 Greece rubber sandal サンダル GRAY
34419 VIRGO COMPLETION TEE ”17” Black
28773 VIRGO VWV SST BLACK
28774 VIRGO VWV SST WHITE
28775 VIRGO VWV SST GRAY
28787 VIRGO UKS SST BLACK
28788 VIRGO UKS SST WHITE
28789 VIRGO UKS SST CHARCOAL
30119 BAND-MAID VIRGO Tシャツ(白)
30120 BAND-MAID VIRGO Tシャツ(黒)