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 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-05-12 15:54:37')
AND FIND_IN_SET(2, p.color)
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
LIMIT 0, 120
13件見つかりました
1ページ中1ページ目
1
¥330
RUDIE'S
Badge
M 残り1点
¥14,300
RUDIE'S
Pullover
完売
¥16,500
RUDIE'S
Happy bag
完売
¥11,000
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥16,500 → 8,250
RUDIE'S
Bottoms
完売
¥9,900
RUDIE'S
Pullover
¥22,000
RUDIE'S
Happy bag
完売
¥6,050
RUDIE'S×SABBAT13
7/S T-Shirt
¥12,000
愛本りんく × RUDIE'S
Zip Hoodie
完売
¥12,100
RUDIE'S
Zip Hoodie
フリー 残り1点
¥6,050
RUDIE'S
Cap
¥7,150
RUDIE'S
L/S T-Shirt
13件見つかりました
1ページ中1ページ目
1
36568 RUDIE'S (ルーディーズ) CAN BADGE SOLID PHAT GRAY
56027 RUDIE'S (ルーディーズ) PHAT HIGHNECK HOOD SWEAT GRAY
56912 RUDIE'S 2021 NEW YEAR PACK
57094 RUDIE'S RUDIE'S x BYRD / LOOK SLICK HOOD SWEAT GRAY
57376 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT GRAY
60263 RUDIE'S (ルーディーズ) PHAT OVERALL BLUEGRAY
60341 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT GRAY
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
65601 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S RAGLAN T" (BK/GY)
67405 愛本りんく × RUDIE'S コラボ限定ジップアップパーカー
67458 RUDIE'S(ルーディーズ) SHADOW LOGO ZIP PARKA SGY
67472 RUDIE'S(ルーディーズ) SHADOW LOGO SNAPBACK CAP DGY/BLK
69489 RUDIE'S (ルーディーズ) THICK PHAT LSTEE ASH