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-22 22:44:38')
AND pc.price02 > 9090
AND price02 <= 13636
AND FIND_IN_SET(1, 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
ORDER BY MAX(price02) DESC
LIMIT 0, 120
19件見つかりました
1ページ中1ページ目
1
完売
¥14,300
RUDIE'S
Jacket
完売
¥14,300
RUDIE'S
Shorts
M 残り1点
¥14,300
RUDIE'S
Pullover
¥14,300
RUDIE'S
Jacket
完売
¥13,000
A’×RUDIE'S×GEKIROCK CLOTHING
Pullover
完売
¥12,100
RUDIE'S×SABBAT13
Pullover
¥12,100
RUDIE'S
Zip Hoodie
¥12,000
旭 那由多×RUDIE'S
Zip Hoodie
¥11,000
RUDIE'S
Coach Jacket
¥11,000
RUDIE'S
Coach Jacket
¥11,000
RUDIE'S
Pullover
完売
¥11,000
RUDIE'S
Happy bag
完売
¥11,000
RUDIE'S
Coach Jacket
完売
¥11,000
RUDIE'S
Pullover
¥11,000
RUDIE'S x CRAYON SHINCHAN
Pullover
完売
¥11,000
RUDIE'S
L/S Shirt
XL 残り1点
¥11,000
RUDIE'S
Sweatshirt
¥11,000
RUDIE'S
Sweatshirt
¥10,450
RUDIE'S
Zip Hoodie
19件見つかりました
1ページ中1ページ目
1
53131 RUDIE'S SLICK HALFZIPHOOD JACKET BLACK
54078 RUDIE'S (ルーディーズ) TUSK SHORTS BLACK
56026 RUDIE'S (ルーディーズ) PHAT HIGHNECK HOOD SWEAT BLACK
67451 RUDIE'S (ルーディーズ) SHADOW LOGO MODS-COAT
60827 A’×RUDIE'S×GEKIROCK CLOTHING コラボ・パーカー
65599 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S HOOD SWEAT" (BK)
67456 RUDIE'S(ルーディーズ) SHADOW LOGO ZIP PARKA BLACK
68775 旭 那由多×RUDIE'S 限定コラボ・ジップアップパーカー
22865 RUDIE'S (ルーディーズ) DRAWING COACH JKT BLACK
29128 RUDIE'S (ルーディーズ) SPARK COACH JACKET BLACK
32031 RUDIE'S (ルーディーズ) SPARK HOOD SWEAT BLACK
52520 RUDIE’S 2020 NEWYEAR PACK
52939 RUDIE'S TUSK COACH JACKET BLACK
57093 RUDIE'S RUDIE'S x BYRD / LOOK SLICK HOOD SWEAT BLACK
66713 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN RABBIT HOOD SWEAT BLACK
67454 RUDIE'S(ルーディーズ) SHADOW LOGO WORK SHIRTS
67461 RUDIE'S(ルーディーズ) SHADOW LOGO CREW SWEAT BLACK
67463 RUDIE'S(ルーディーズ) SHADOW LOGO CREW SWEAT DGY
29130 RUDIE'S (ルーディーズ) SPARK ZIPHOOD SWEAT BLACK/WHITE