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 =17
)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-27 09:55:51')
AND FIND_IN_SET(22, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
12件見つかりました
1ページ中1ページ目
1
完売
¥30,800
Zephyren
Happy bag
¥7,700
LONELY論理
Cap
フリー 残り1点
¥7,700
LONELY論理
Cap
完売
¥17,600
RIP DESIGN WORXX
Happy bag
完売
¥17,600
RIP DESIGN WORXX
Happy bag
完売
¥14,300
MISHKA
Happy bag
完売
¥7,480
Subciety
Cap
完売
¥8,800
MISHKA
Cap
完売
¥6,050
MISHKA
Cap
完売
¥6,050
MISHKA
Cap
完売
¥13,200
Zephyren
Happy bag
完売
¥6,050
MISHKA
Cap
12件見つかりました
1ページ中1ページ目
1
61271 Zephyren 2022 NEW YEAR BAG
65701 LONELY論理 ICON CHECK LOW CAP-BLACK
65702 LONELY論理 ICON CHECK LOW CAP-SAND
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
25565 Subciety PAISLEY SNAP BACK CAP
41942 MISHKA (ミシカ) MAW183230 CAP Red
49789 MISHKA MAW193253 CAP
50245 MISHKA MAW193223 CAP YELLOW
52417 Zephyren 2020 NEW YEAR BAG
54668 MISHKA(ミシカ) MSS203209 CAP