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-01 23:57:35')
AND FIND_IN_SET(11, 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
9件見つかりました
1ページ中1ページ目
1
¥22,000
RUDIE'S
Happy bag
完売
¥6,600
RUDIE'S
L/S T-Shirt
完売
¥5,500
RUDIE'S x CRAYON SHINCHAN
T-Shirt
完売
¥6,600 → 4,620
RUDIE'S
L/S T-Shirt
¥4,400
RUDIE'S
Accessory
完売
¥4,400 → 3,080
RUDIE'S
Accessory
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥2,750 → 825
RUDIE'S
Bag
フリー 残り1点
¥330
RUDIE'S
Badge
9件見つかりました
1ページ中1ページ目
1
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
58336 RUDIE'S GOOD VIBRATION LS-T LAVENDER
58080 RUDIE'S x CRAYON SHINCHAN ACTIONKAMEN-T LAVENDER
60356 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T GRADATION LOGO LAVENDER
36701 RUDIE'S (ルーディーズ) SPARK GALAXY iQOS PROTECTOR
60361 RUDIE'S (ルーディーズ) SLICK HAIRBAND LAVENDER
57377 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT PURPLE
60256 RUDIE'S (ルーディーズ) PHAT SHOPPINGBAG BLUE
36570 RUDIE'S (ルーディーズ) CAN BADGE BRILLIANT GALAXY BLACK