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-24 17:26:45')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.classcategory_id1 IN( 13,35,44)
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)
LIMIT 0, 100
17件見つかりました
1ページ中1ページ目
1
M 残り1点
¥5,500
RUDIE'S
7/S T-Shirt
M 残り1点
¥5,500
RUDIE'S
T-Shirt
M 残り1点
¥5,500
RUDIE'S
T-Shirt
M 残り1点
¥5,500
RUDIE'S
T-Shirt
¥5,500
RUDIE'S
T-Shirt
M 残り1点
¥6,600
RUDIE'S
L/S T-Shirt
M 残り1点
¥6,600
RUDIE'S
L/S T-Shirt
M 残り1点
¥7,150
RUDIE'S
L/S T-Shirt
M 残り1点
¥7,150
RUDIE'S
L/S T-Shirt
M 残り1点
¥7,150
RUDIE'S
L/S T-Shirt
M 残り1点
¥7,150
RUDIE'S
L/S T-Shirt
M 残り1点
¥7,150
RUDIE'S
L/S T-Shirt
M 残り1点
¥7,700
RUDIE'S
Shorts
¥7,700
旭 那由多×RUDIE'S
L/S T-Shirt
M 残り1点
¥7,700
RUDIE'S
Shorts
M 残り1点
¥9,900
RUDIE'S
Pullover
¥9,900
RUDIE'S x CRAYON SHINCHAN
Sweatshirt
17件見つかりました
1ページ中1ページ目
1
8108 RUDIE'S (ルーディーズ) SPARK 3/4 RAGLAN BLACK/BLACK
68293 RUDIE'S (ルーディーズ) EXTRA DRAWING-T WHITE
68294 RUDIE'S (ルーディーズ) EXTRA DRAWING-T BLACK
68458 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T BLACK
68459 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T WHITE
52992 RUDIE'S (ルーディーズ) SPARK LS-T BLACK
52993 RUDIE'S (ルーディーズ) SPARK LS-T WHITE
69939 RUDIE'S (ルーディーズ) BLOCK COLLEGE BIGSILHOUETTE LSTEE WHITE
69940 RUDIE'S (ルーディーズ) BLOCK COLLEGE BIGSILHOUETTE LSTEE GREEN
69941 RUDIE'S (ルーディーズ) BLOCK COLLEGE BIGSILHOUETTE LSTEE BLACK
69942 RUDIE'S (ルーディーズ) MIGHTY MIC BIGSILHOUETTE LSTEE WHITE
69943 RUDIE'S (ルーディーズ) MIGHTY MIC BIGSILHOUETTE LSTEE BLACK
68457 RUDIE'S (ルーディーズ) CURVY SHORTS BLACK
68777 旭 那由多×RUDIE'S コラボ限定ロングTシャツ
68928 RUDIE'S (ルーディーズ) THICK PHAT SHORTS CAMO
58003 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT PINK
66709 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN RABBIT CREW SWEAT BLACK