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-23 19:43:39')
AND pc.price02 > 2727
AND price02 <= 4545
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, 240
10件見つかりました
1ページ中1ページ目
1
完売
¥12,980 → 3,894
TRAVAS TOKYO
Pullover
完売
¥4,580
DXMOUVE
Pullover
完売
¥4,589
NieR
Pullover
完売
¥9,900 → 4,950
RUDIE'S
Pullover
完売
¥11,880 → 3,564
SABBAT13
Pullover
完売
¥15,290 → 4,587
RIPNDIP
Pullover
完売
¥5,500 → 3,850
NieR
Pullover
完売
¥16,500 → 4,950
Subciety
Pullover
完売
¥16,500 → 4,950
Subciety
Pullover
完売
¥11,000 → 3,300
PSYCHOLOGICAL METAMORPHOSIS
Pullover
10件見つかりました
1ページ中1ページ目
1
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
63245 DXMOUVE(ドゥモーヴェ) ぼろぼろベアのtomy切替半袖プルオーバー ブルー
62963 NieR (ニーア) 総柄フード付きプルオーバー BLUE
62163 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT LIGHT BLUE
60708 SABBAT13 WIND PRANK HOODIE BLUE
60589 RIPNDIP Stellar Hoodie (Purple/Blue Spiral Dye)
60464 NieR (ニーア) BIG POCKET MARINE PARKA
59010 Subciety (サブサエティ) Robin PARKA - BLUE
59013 Subciety (サブサエティ) PIGMENT PARKA - BLUE
53915 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLUE