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 =588
)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-01 20:01:00')
AND pc.price03 IS NOT NULL
AND pc.classcategory_id1 IN( 11)
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, 120
14件見つかりました
1ページ中1ページ目
1
完売
¥9,900 → 4,950
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 4,950
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
14件見つかりました
1ページ中1ページ目
1
65857 RUDIE'S (ルーディーズ) DONUTS PHAT HOOD SWEAT
61820 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT BLACK
62166 RUDIE'S (ルーディーズ) COLLEGE HOOD SWEAT BLACK
62163 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT LIGHT BLUE
62164 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT BLACK
60340 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT BLACK
60696 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT BLACK
60697 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT RED
60698 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT WHITE
58001 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT BLACK
58002 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT BLUE
57376 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT GRAY
57377 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT PURPLE
57378 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK