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 =588
)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-01 13:37:07')
AND pc.price03 IS NOT NULL
AND FIND_IN_SET(11, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
完売
¥25,000 → 12,500
Anti Social Social Club
Pullover
完売
¥17,600 → 8,800
MISHKA
Pullover
完売
¥12,980 → 6,490
TRAVAS TOKYO
Pullover
完売
¥18,700 → 5,610
MISHKA
Pullover
完売
¥16,500 → 4,950
Subciety
Pullover
完売
¥15,290 → 4,587
RIPNDIP
Pullover
完売
¥12,980 → 3,894
TRAVAS TOKYO
Pullover
完売
¥11,550 → 3,465
MAGICAL MOSH MISFITS
Hoodie
完売
¥6,100 → 3,050
NieR
Pullover
完売
¥9,900 → 2,970
RUDIE'S
Pullover
完売
¥4,580 → 1,374
DXMOUVE
Pullover
11件見つかりました
1ページ中1ページ目
1
56204 Anti Social Social Club Headrush All Over White Hoodie
60280 MISHKA M61000411 HOODIE
61728 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー Pulple
60281 MISHKA M61000421 HOODIE
59011 Subciety (サブサエティ) Robin PARKA - PURPLE
60595 RIPNDIP Peeking Nermal Embroidered Hoodie (Purple Mineral Wash)
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
59393 MAGICAL MOSH MISFITS MxMxM パイル PARKA TEE PURPLE
64331 NieR (ニーア) HALF ZIP HOODIE【broken heart】
57377 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT PURPLE
63239 DXMOUVE(ドゥモーヴェ) ストレンジトイ切替半袖プルオーバー パープル