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 dtb_products AS p
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-04-30 20:28:20')
AND FIND_IN_SET(7, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 664)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
完売
¥2,200 → 1,100
RIPNDIP
Sticker
完売
¥5,179
RIPNDIP
Accessory
完売
¥6,215
RIPNDIP
T-Shirt
完売
¥6,490
RIPNDIP
L/S T-Shirt
完売
¥7,150
RIPNDIP
T-Shirt
完売
¥7,865
RIPNDIP
L/S T-Shirt
完売
¥8,030
RIPNDIP
Shoes
¥8,800
RIPNDIP
Shoes
完売
¥11,990
RIPNDIP
Sweater
¥12,100
RIPNDIP
Knit
完売
¥15,290
RIPNDIP
Pullover
11件見つかりました
1ページ中1ページ目
1
64304 RIPNDIP (リップンディップ) Summer Break Sticker Pack
48346 RIPNDIP Paddle Up Paddle Ball Set
48344 RIPNDIP Lord Jermal Pocket Tee (Wine)
60606 RIPNDIP Lord Nermal Pocket Long Sleeve (Cherry Red)
60604 RIPNDIP OG Prisma Embroidered Tee (Red Tie Dye)
44881 RIPNDIP Lord Nermal Pocket L/S (Burgundy)
48350 RIPNDIP Lord Nermal Slides (Wine)
71291 RIPNDIP (リップンディップ) LORD NERMAL SLIDES (RED)
45757 RIPNDIP Nerm Camo Knit Sweater (Red Camo)
65432 RIPNDIP (リップンディップ) Nermhol Knit Sweater (Multi)
60587 RIPNDIP OG Prisma Embroidered Hoodie (Red Tie Dye)