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 =97
)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-18 19:30:16')
AND pc.stock > 0
AND FIND_IN_SET(1, 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 MAX(price02)
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
¥6,600
RUDIE'S
L/S T-Shirt
¥6,600
RUDIE'S
L/S T-Shirt
¥6,600
RUDIE'S
L/S T-Shirt
XL 残り1点
¥6,600
RUDIE'S
L/S T-Shirt
¥6,600
RUDIE'S
L/S T-Shirt
¥7,150
RUDIE'S
L/S T-Shirt
¥7,150
RUDIE'S
L/S T-Shirt
¥7,150
RUDIE'S
L/S T-Shirt
¥7,700
B.O.L.T×RUDIE'S×GEKIROCK CLOTHING
L/S T-Shirt
¥7,700
B.O.L.T×RUDIE'S×GEKIROCK CLOTHING
L/S T-Shirt
¥22,000
RUDIE'S
Happy bag
11件見つかりました
1ページ中1ページ目
1
52992 RUDIE'S (ルーディーズ) SPARK LS-T BLACK
65796 RUDIE'S (ルーディーズ) BRINK PHAT LS-T-ブラック
65799 RUDIE'S (ルーディーズ) COLLEGE LS-T-BLACK
67466 RUDIE'S(ルーディーズ) SHADOW LOGO LS TEE BLACK
67467 RUDIE'S(ルーディーズ) SHADOW LOGO LS TEE DGY
69488 RUDIE'S (ルーディーズ) THICK PHAT LSTEE BLACK
69941 RUDIE'S (ルーディーズ) BLOCK COLLEGE BIGSILHOUETTE LSTEE BLACK
69943 RUDIE'S (ルーディーズ) MIGHTY MIC BIGSILHOUETTE LSTEE BLACK
63830 B.O.L.T×RUDIE'S×GEKIROCK CLOTHING コラボ・ロングTシャツ PINK×BLACK
63832 B.O.L.T×RUDIE'S×GEKIROCK CLOTHING コラボ・ロングTシャツ YELLOW×BLACK
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-