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-08 12:12:27')
AND FIND_IN_SET(7, p.color)
AND pc.classcategory_id1 IN( 12,44)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
17件見つかりました
1ページ中1ページ目
1
完売
¥23,100
glamb
Cardigan
¥25,600
SLEEPING TABLET
Knit
完売
¥10,780
GALFY
Knit
L 残り1点
¥23,100
glamb
Knit
L 残り1点
¥19,800
glamb
Knit
完売
¥14,080
GALFY
Knit
L 残り1点
¥12,100
RIPNDIP
Knit
L 残り1点
¥20,900
glamb
Cardigan
¥18,480
SUPPLIER×PLAYBOY
Knit
完売
¥14,300
MISHKA
Happy bag
完売
¥19,800
ROLLING CRADLE
Sweatshirt
完売
¥8,800 → 4,400
KILL STAR CLOTHING
Knit
完売
¥17,380 → 5,214
SUPPLIER
Knit
完売
¥24,200 → 12,100
MUSIC SAVED MY LIFE
Knit
完売
¥9,680 → 2,904
ROLLING CRADLE
Knit
完売
¥9,790
CIVARIZE
Knit
完売
¥22,000 → 6,600
Zephyren
Knit
17件見つかりました
1ページ中1ページ目
1
70642 glamb (グラム) Skeleton Cardigan/スケルトンカーディガン Red
68778 SLEEPING TABLET(スリーピング・タブレット) VOID [ COTTON KNIT SWEATER ] MIX RED
69558 GALFY (ガルフィー) ボロボロカートニット RED/BLACK
67750 glamb(グラム) GB0123/KNT10 : Hand Paint Knit/ハンドペイントニット RED
67050 glamb (グラム)GB0223/KNT05 : Openwork Border Knit / オープンワークボーダーニット - Red
65724 GALFY (ガルフィー) クレイジーわんわん大学セーターBLACK×RED
65432 RIPNDIP (リップンディップ) Nermhol Knit Sweater (Multi)
63504 glamb (グラム) Fuzzy Leopard Cardigan - Wine
63003 SUPPLIER (サプライヤー) PLAYBOY COLLEGE LOGO KNIT
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60547 ROLLING CRADLE FLUFFY CREWNECK / BLACK
58361 KILL STAR CLOTHING Mika Knit Sweater
57347 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT BURGUNDY
56848 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT BLACK
56105 ROLLING CRADLE BOUCLE TURTLE NECK / PINK
56201 CIVARIZE【シヴァーライズ】フェザーヤーンプルオーバーロングニット Black×Red
55034 Zephyren(ゼファレン)KNIT CHECK