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-23 00:01:01')
AND pc.price03 IS NOT NULL
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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, 120
15件見つかりました
1ページ中1ページ目
1
完売
¥1,650 → 1,155
RUDIE'S
Socks
完売
¥4,400 → 1,320
RUDIE'S x CRAYON SHINCHAN
Accessory
完売
¥4,400 → 1,320
RUDIE'S
Accessory
完売
¥4,400 → 1,320
RUDIE'S
Beanie
完売
¥4,400 → 3,080
RUDIE'S
Accessory
完売
¥2,750 → 825
RUDIE'S
Bag
完売
¥2,750 → 825
RUDIE'S
Bag
完売
¥2,750 → 825
RUDIE'S
Bag
完売
¥2,750 → 825
RUDIE'S
Bag
完売
¥17,600 → 5,280
RUDIE'S
Backpack
完売
¥17,600 → 5,280
RUDIE'S
Backpack
完売
¥7,700 → 2,310
RUDIE'S
Bag
完売
¥7,700 → 5,390
RUDIE'S
Bag
完売
¥2,750 → 1,925
RUDIE'S
Bag
完売
¥7,700 → 2,310
RUDIE'S
Bag
15件見つかりました
1ページ中1ページ目
1
63749 RUDIE'S (ルーディーズ) PHAT SOCKS WHITE
62811 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BROOMGUITAR CUSHION
60874 RUDIE'S (ルーディーズ) SLICK GLOVE BLACK
60699 RUDIE'S (ルーディーズ) BLANK KNITCAP NEON ORANGE
60361 RUDIE'S (ルーディーズ) SLICK HAIRBAND LAVENDER
60256 RUDIE'S (ルーディーズ) PHAT SHOPPINGBAG BLUE
60257 RUDIE'S (ルーディーズ) PHAT SHOPPINGBAG RED
60258 RUDIE'S (ルーディーズ) PHAT SHOPPINGBAG NEON GREEN
60259 RUDIE'S (ルーディーズ) PHAT SHOPPINGBAG NEON YELLOW
58492 RUDIE'S (ルーディーズ) SPARK BACKPACK NAVY
58493 RUDIE'S (ルーディーズ) SPARK BACKPACK BLACK
58494 RUDIE'S (ルーディーズ) SPARK WAISTBAG NAVY
58495 RUDIE'S (ルーディーズ) SPARK WAISTBAG BLACK
57381 RUDIE'S (ルーディーズ) DRAWING SHOPPING BAG BLACK/ORANGE
53133 RUDIE'S (ルーディーズ) TUSK WAISTBAG WHITE