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-14 03:10:10')
AND FIND_IN_SET(14, 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
LIMIT 0, 180
10件見つかりました
1ページ中1ページ目
1
¥4,400
RUDIE'S
Accessory
完売
¥14,300
RUDIE'S
Pullover
完売
¥4,950
RUDIE'S
Cap
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥17,600 → 5,280
RUDIE'S
Backpack
完売
¥7,700 → 2,310
RUDIE'S
Bag
完売
¥9,900 → 4,950
RUDIE'S
Pullover
完売
¥5,500
RUDIE'S x CRAYON SHINCHAN
Hat
¥22,000
RUDIE'S
Happy bag
完売
¥19,000
渡月 麗×RUDIE'S
L/S Shirt
10件見つかりました
1ページ中1ページ目
1
42989 RUDIE'S PHAT iQOS PROTECTOR BLUE RED
56028 RUDIE'S PHAT HIGHNECK HOOD SWEAT BLUE
55328 RUDIE'S x CRAYON SHINCHAN DIVE PANELCAP DENIM
58002 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT BLUE
58492 RUDIE'S (ルーディーズ) SPARK BACKPACK NAVY
58494 RUDIE'S (ルーディーズ) SPARK WAISTBAG NAVY
62163 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT LIGHT BLUE
62819 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN MOSH METROHAT DENIM
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
65282 渡月 麗×RUDIE'S コラボ 限定 L/S シャツ