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 =392
)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-26 16:39:42')
AND pc.price02 > 4545
AND price02 <= 9090
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
9件見つかりました
1ページ中1ページ目
1
完売
¥18,150 → 9,075
glamb
Jacket
完売
¥7,920
NieR
Jacket
完売
¥9,900
Zephyren
Jacket
完売
¥8,800
PUNK DRUNKERS
Jacket
完売
¥26,400 → 7,920
Zephyren
Jacket
完売
¥9,900
PUNK DRUNKERS
Jacket
完売
¥7,040
GALFY
Jacket
完売
¥18,480 → 5,544
FILA
Jacket
完売
¥18,700 → 5,610
mnml
Jacket
9件見つかりました
1ページ中1ページ目
1
61480 glamb (グラム) Old School Jersey BLUE
57082 NieR (ニーア) SHINY NieR HIP ZIP OUTER
30162 Zephyren(ゼファレン) DENIM SWEAT RIDERS JKT INDIGO
33450 PUNK DRUNKERS (パンクドランカーズ) Pジャン USED
41968 Zephyren(ゼファレン) DENIM JACKET HARD WASH II / BANNDANNA
43546 PUNK DRUNKERS 虎ナイロンJKT BLUE/PINK
43955 GALFY イヌGジャンBLUE
46753 FILA FM9546 Jacket Flame red
50446 mnml HOODED DENIM JACKET BLUE