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 17:45:58')
AND FIND_IN_SET(13, p.color)
AND pc.classcategory_id1 IN( 11)
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
17件見つかりました
1ページ中1ページ目
1
¥11,000
RUDIE'S
Coach Jacket
完売
¥22,000
RUDIE'S
Happy bag
XL 残り1点
¥6,050
RUDIE'S×SABBAT13
7/S T-Shirt
完売
¥4,620
RUDIE'S
T-Shirt
完売
¥6,600
RUDIE'S
L/S T-Shirt
完売
¥16,500
RUDIE'S
Happy bag
完売
¥22,000 → 6,600
RUDIE'S
Jacket
完売
¥9,900
RUDIE'S
Hoodie
完売
¥9,350
RUDIE'S
Pullover
完売
¥22,000
RUDIE'S
Jacket
完売
¥11,000
RUDIE'S
Coach Jacket
完売
¥9,900
RUDIE'S
Hoodie
完売
¥4,620
RUDIE'S
T-Shirts
完売
¥4,620
RUDIE'S
T-Shirt
完売
¥18,700
RUDIE'S
Pullover
完売
¥20,900
RUDIE'S
Jacket
完売
¥5,500
RUDIE'S
T-Shirt
17件見つかりました
1ページ中1ページ目
1
22867 RUDIE'S (ルーディーズ) DRAWING COACH JKT NAVY
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
65603 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S RAGLAN T" (NV/WH)
63183 RUDIE'S (ルーディーズ) HELLO-T NAVY
60355 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T GRADATION LOGO NAVY
56912 RUDIE'S 2021 NEW YEAR PACK
56851 RUDIE'S (ルーディーズ) PHAT COACH JACKET NAVY
22211 RUDIE'S EDDY HOODSW NAVY
38148 RUDIE'S SOLID PHAT HOOD SWEAT NAVY
39343 RUDIE'S DRAWING DENIM BLOUSON LIGHT DENIM
39350 RUDIE'S ID COACH JACKET NAVY
39550 RUDIE'S PHAT HOOD SWEAT NAVY
40494 RUDIE'S PHAT-T NAVY
43153 RUDIE'S DRAWING-T NAVY
43924 RUDIE'S COLLEGE BOA HALFZIPHOOD NAVY
46346 RUDIE'S PHAT ANORAK DENIM
47368 RUDIE'S MONSTER-T NAVY