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 =393
)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-03-29 11:08:50')
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
17件見つかりました
1ページ中1ページ目
1
完売
¥19,580 → 9,790
GALFY
Set up
完売
¥9,900
over print
Zip Hoodie
¥9,299
NieR
Zip Hoodie
完売
¥7,200
NieR
Zip Hoodie
完売
¥7,200
NieR
Zip Hoodie
完売
¥6,500
NieR
Zip Hoodie
完売
¥6,500
NieR
Zip Hoodie
完売
¥6,390
NieR
Zip Hoodie
完売
¥18,480 → 5,544
ANIMALIA
Zip Hoodie
完売
¥18,480 → 9,240
ANIMALIA
Zip Hoodie
完売
¥7,920
NieR
Jacket
完売
¥8,360
SO SO HAPPY
Hoodie
完売
¥8,360
SO SO HAPPY
Hoodie
完売
¥7,150
Zephyren
Zip Hoodie
完売
¥6,926
Gluttonous Slaughter
Zip Hoodie
完売
¥6,930
Drug Honey
Zip Hoodie
完売
¥8,910
Drug Honey
Zip Hoodie
17件見つかりました
1ページ中1ページ目
1
65735 GALFY (ガルフィー) 久々賛否両論 SET UP SAX
65905 over print(オーバープリント) Melodic Zip Hoodie (blue)
65814 NieR (ニーア) 袖リブ付き着物風袖ブロッキングシャツ【Night sky】
62955 NieR (ニーア) 2WAY OFF-Shoulder 長袖ZIP PARKA【彼岸花 ターコイズブルー】
61499 NieR (ニーア) AEGIS ZIP OUTER【PURPLE×BLUE】
60088 NieR (ニーア) REAL BUTTERFLY ZIP PARKA BLUE
60091 NieR (ニーア) HALF SLEEVE ZIP OUTER【BLUE SPLASH】
58681 NieR (ニーア) WIND BREAKER【NieR PAINT】
58330 ANIMALIA AN21S-SW03 INDIGO Z/U HOODIE -CHIMAYO L.DENIM
58329 ANIMALIA AN21S-SW03 INDIGO Z/U HOODIE -CHIMAYO INDIGO
57082 NieR (ニーア) SHINY NieR HIP ZIP OUTER
1293 SO SO HAPPY Ozzie Hoodie In Blue
14571 SO SO HAPPY Tribe Hoodie In Blue
26895 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE- BLACKxBLUE
28548 Gluttonous Slaughter (グラトナス・スローター) lnversion of Christ ZIP HOODIE BLUE
50228 Drug Honey スケルトンチェシャ総柄パーカー BLUE
50842 Drug Honey 「Darknight Sanctuary」 ヘムカットパーカー ブルーグレー