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-18 20:10:00')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(7, 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 p.update_date DESC
LIMIT 0, 25
12件見つかりました
1ページ中1ページ目
1
¥22,000
RUDIE'S
Happy bag
完売
¥1,650
RUDIE'S x CRAYON SHINCHAN
Keyholder
完売
¥4,400 → 1,320
RUDIE'S x CRAYON SHINCHAN
Accessory
完売
¥9,900
RUDIE'S
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥4,400
RUDIE'S
Accessory
完売
¥2,750 → 825
RUDIE'S
Bag
完売
¥9,900
RUDIE'S
Pullover
完売
¥15,400
RUDIE'S
L/S Shirt
¥4,400
RUDIE'S
Accessory
完売
¥11,000
RUDIE'S
Happy bag
完売
¥4,620
RUDIE'S
T-Shirt
12件見つかりました
1ページ中1ページ目
1
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
62812 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BROOMGUITAR KEYHOLDER
62811 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BROOMGUITAR CUSHION
61821 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT RED
60697 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT RED
60360 RUDIE'S SLICK HAIRBAND RED
60257 RUDIE'S (ルーディーズ) PHAT SHOPPINGBAG RED
56276 RUDIE'S SLICK HOOD SWEAT BURGUNDY
56029 RUDIE'S PHAT CHECK SHIRTS RED
42989 RUDIE'S PHAT iQOS PROTECTOR BLUE RED
52520 RUDIE’S 2020 NEWYEAR PACK
53134 RUDIE'S DRAWING-T BURGUNDY