SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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 =394
)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-05-18 11:01:22')
AND FIND_IN_SET(2, p.color)
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
13件見つかりました
1ページ中1ページ目
1
完売
¥17,380 → 5,214
SUPPLIER
Knit
完売
¥10,780
GALFY
Knit
完売
¥11,000
over print
Knit
完売
¥11,880
GALFY
Knit
完売
¥13,200
over print
Knit
完売
¥13,200
over print
Knit
完売
¥14,300
MISHKA
Happy bag
完売
¥14,799
ROLLING CRADLE
Cardigan
¥16,000
AILE VIVANTES
Knit
XL 残り1点
¥18,700
Subciety
Cardigan
XL 残り1点
¥18,700
Subciety
Cardigan
完売
¥19,580
VIRGOwearworks
Cardigan
完売
¥30,800
Zephyren
Happy bag
13件見つかりました
1ページ中1ページ目
1
57348 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT CHARCOAL
60421 GALFY わんわん大学セーター T.GRAY
69792 over print (オーバープリント) BOADER COTTON KNIT (GRAY)
61201 GALFY 炎の体育会セーター GRAY
70163 over print (オーバープリント) KNIT BLOUSON (GRAY)
70166 over print (オーバープリント) POP ART JQ KNIT VER:1 (GRAY)
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60458 ROLLING CRADLE LEOPARD CARDIGAN / BROWN
71230 AILE VIVANTES (エイルヴィヴァンテス) HIGH NECK PUNK
65640 Subciety (サブサエティ) MOHAIR CARDIGAN GRAY
65785 Subciety (サブサエティ) FLEECE ZIP CARDIGAN GRAY
55390 VIRGO KURT MOHAIR CARDIGAN - GRAY
61271 Zephyren 2022 NEW YEAR BAG