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