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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =326
)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-04-25 12:33:16')
AND pc.price02 > 13636
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 p.update_date DESC
LIMIT 0, 180
15件見つかりました
1ページ中1ページ目
1
完売
¥17,600
RUDIE'S
Backpack
完売
¥15,400
RUDIE'S
Bag
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥16,500
RUDIE'S
Backpack
完売
¥19,800
RUDIE'S
Backpack
完売
¥19,800
RUDIE'S
Backpack
完売
¥17,600
RUDIE'S
Backpack
完売
¥17,600
RUDIE'S
Backpack
15件見つかりました
1ページ中1ページ目
1
47067 RUDIE'S (ルーディーズ) SPARK BACKPACK RED
21224 RUDIE'S WLDFMS BOSTON BAG BLACK
24564 RUDIE'S SPARK BACK PACK BLACK
24565 RUDIE'S SPARK BACK PACK BLUE
24566 RUDIE'S SPARK BACK PACK CAMO
37607 RUDIE'S SPARK BACK PACK BLACK GALAXY
37608 RUDIE'S SPARK BACK PACK KHAOS
37609 RUDIE'S SPARK BACK PACK PAISLEY
37610 RUDIE'S SPARK BACK PACK GALAXY
37611 RUDIE'S SPARK BACK PACK TIEDYE
40633 RUDIE'S SPARK BACK PACK TIEDYE
43533 RUDIE'S PHAT SKATE BACKPACK BLACK
43534 RUDIE'S PHAT SKATE BACKPACK BLACK/GALAXY
47066 RUDIE'S SPARK BACKPACK BLACK
47068 RUDIE'S SPARK BACKPACK CAMO