SELECT SQL_CALC_FOUND_ROWS 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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =593
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-04-19 15:32:27')
AND pc.price02 > 2727
AND price02 <= 4545
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
完売
¥3,500
渡月 麗×RUDIE'S
Bag
フリー 残り1点
¥4,620
RUDIE'S
Bag
完売
¥3,850
RUDIE'S x CRAYON SHINCHAN
Bag
完売
¥3,850
RUDIE'S x CRAYON SHINCHAN
Bag
完売
¥4,400
RUDIE'S
Bag
完売
¥4,400
RUDIE'S
Bag
完売
¥4,400
RUDIE'S
bag
完売
¥4,400
RUDIE'S
bag
完売
¥3,850
RUDIE'S
bag
完売
¥3,850
RUDIE'S
bag
完売
¥3,850
RUDIE'S
bag
完売
¥3,850
RUDIE'S
Bag
完売
¥3,850
RUDIE'S
Bag
完売
¥3,850
RUDIE'S
Bag
完売
¥4,950
RUDIE'S
Bag
15件見つかりました
1ページ中1ページ目
1
65286 渡月 麗×RUDIE'S コラボ 限定 トートバッグ
67469 RUDIE'S (ルーディーズ) SHADOW LOGO SAKOSSHU
58087 RUDIE'S x CRAYON SHINCHAN PEACE TOTEBAG NATURAL
58086 RUDIE'S x CRAYON SHINCHAN PEACE TOTEBAG BLACK
18231 RUDIE'S SPARK LUNCH BAG GRAY
18233 RUDIE'S SPARK LUNCH BAG NATURAL
33625 RUDIE'S Nothing's Carved In Stone x RUDIE'S DRAWING TOTEBAG BLACK
33626 RUDIE'S Nothing's Carved In Stone x RUDIE'S DRAWING TOTEBAG NATURAL
35583 RUDIE'S PHAT TOTEBAG BLACK
35584 RUDIE'S PHAT TOTEBAG BLUE
35585 RUDIE'S PHAT Totebag Natural
37231 RUDIE'S SOLID PHAT TOTEBAG BLACK
37232 RUDIE'S SOLID PHAT TOTEBAG GRAY
37233 RUDIE'S SOLID PHAT TOTEBAG NAVY
54598 RUDIE'S x KiU DRAWING TRAVEL CASE