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 =572
)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-20 02:20:02')
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 p.update_date DESC
LIMIT 0, 120
13件見つかりました
1ページ中1ページ目
1
¥7,700
RUDIE'S
Shorts
¥7,700
RUDIE'S
Shorts
完売
¥15,400 → 4,620
RUDIE'S
Bottoms
完売
¥14,300
RUDIE'S
Shorts
完売
¥14,300
RUDIE'S
Bottoms
完売
¥15,400
RUDIE'S
Bottoms
完売
¥9,900
RUDIE'S
Shorts
完売
¥13,200
RUDIE'S
Shorts
完売
¥13,200
RUDIE'S
Shorts
完売
¥14,300
RUDIE'S
Shorts
完売
¥14,300
RUDIE'S
Shorts
完売
¥14,300
RUDIE'S
Shorts
完売
¥14,300
RUDIE'S
Shorts
13件見つかりました
1ページ中1ページ目
1
68457 RUDIE'S (ルーディーズ) CURVY SHORTS BLACK
68456 RUDIE'S (ルーディーズ) THICK PHAT SHORTS BLACK
26213 RUDIE'S (ルーディーズ) SAVANNA SHORTS BLACK
47360 RUDIE'S (ルーディーズ) PHAT SHORTS BLACK
24567 RUDIE'S EXTREME SHORTS BLACK
26412 RUDIE'S SPARK MESH SHORTS BLACK
26620 RUDIE'S DRAWING SW SHORTS BLACK
34204 RUDIE'S PAISLEY WORK SHORTS BLACK
41015 RUDIE'S PHAT SHORTS PAISLEY
47362 RUDIE'S PHAT SHORTS DENIM
47363 RUDIE'S HOOK WORK SHORTS BLACK
49211 RUDIE'S 84486 SHORTS BLACK
54078 RUDIE'S (ルーディーズ) TUSK SHORTS BLACK