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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =392
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-05-02 06:46:23')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 95)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
12件見つかりました
1ページ中1ページ目
1
完売
¥29,700
RUDIE'S
Jacket
完売
¥29,700
RUDIE'S
Jacket
完売
¥20,900
RUDIE'S
Jacket
完売
¥20,900
RUDIE'S
Jacket
完売
¥20,900
RUDIE'S
Jacket
¥14,300
RUDIE'S
Jacket
完売
¥24,200 → 7,260
RUDIE'S
Jacket
完売
¥22,000 → 6,600
RUDIE'S
Jacket
完売
¥22,000 → 6,600
RUDIE'S
Jacket
完売
¥19,800 → 5,940
RUDIE'S
Jacket
完売
¥17,600 → 5,280
RUDIE'S
Jacket
完売
¥17,600 → 5,280
RUDIE'S
Jacket
12件見つかりました
1ページ中1ページ目
1
56752 RUDIE'S (ルーディーズ) PHAT MOUNTAIN JACKET BLACK
56753 RUDIE'S PHAT MOUNTAIN JACKET KHAKI
56968 RUDIE'S PHAT FLEECE JACKET BLACK
56969 RUDIE'S PHAT FLEECE JACKET NATURAL/NAVY
60783 RUDIE'S (ルーディーズ) SLICK FLEECE JACKET BLACK/BEIGE
67451 RUDIE'S (ルーディーズ) SHADOW LOGO MODS-COAT
60782 RUDIE'S (ルーディーズ) PHAT MA-1 BLACK
56851 RUDIE'S (ルーディーズ) PHAT COACH JACKET NAVY
56852 RUDIE'S (ルーディーズ) PHAT COACH JACKET BLACK
62192 RUDIE'S (ルーディーズ) PHAT REFLECT HOOD JACKET BLACK
60648 RUDIE'S (ルーディーズ) PHAT EXTREME JACKET BLACK
60649 RUDIE'S (ルーディーズ) PHAT EXTREME JACKET WHITE