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-05-22 12:29:06')
AND FIND_IN_SET(2, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
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 p.update_date DESC
LIMIT 0, 120
17件見つかりました
1ページ中1ページ目
1
¥5,720
RIPNDIP
T-Shirt
¥6,380
RIPNDIP
T-Shirt
完売
¥33,000 → 16,500
RIPNDIP
Jacket
M 残り1点
¥16,500
RIPNDIP
Pullover
M 残り1点
¥22,000
RIPNDIP
Pants
完売
¥13,200
RIPNDIP
Pants
完売
¥6,600
RIPNDIP
S/S T-Shirt
完売
¥6,380
RIPNDIP
T-Shirts
M 残り1点
¥7,480
RIPNDIP
T-Shirt
完売
¥5,940
RIPNDIP
T-Shirt
完売
¥12,100
RIPNDIP
Shorts
完売
¥15,400
RIPNDIP
Bottoms
完売
¥7,480
RIPNDIP
L/S T-Shirt
M 残り1点
¥5,940
RIPNDIP
T-Shirt
M 残り1点
¥5,940
RIPNDIP
T-Shirt
完売
¥12,100
RIPNDIP
Pullover
完売
¥22,000 → 11,000
RIPNDIP
Jacket
17件見つかりました
1ページ中1ページ目
1
64267 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Gray)
64266 RIPNDIP (リップンディップ) Lord Nermal Pocket tee (Black Mineral Wash)
66848 RIPNDIP (リップンディップ) Neon Cat Puffer Jacket Black
66856 RIPNDIP (リップンディップ) Ripnlit Hoodie Charcoal Faded Wash
67904 RIPNDIP (リップンディップ) Family Tree Wide Leg Cotton Twill Pants (Black)
67905 RIPNDIP (リップンディップ) Family Tree Swim Shorts (Black)
67882 RIPNDIP (リップンディップ) Charanerm Tee Charcoal
66860 RIPNDIP (リップンディップ) Already Won Tee Charcoal
65435 RIPNDIP (リップンディップ) OG Prisma Short Sleeve Tee (Slate Grey)
64263 RIPNDIP (リップンディップ) Nerm Jam (Black Mineral Wash)
64286 RIPNDIP (リップンディップ) Nerm Doodle Twill Shorts (Chocolate)
64288 RIPNDIP (リップンディップ) Nerm Doodle Cotton Twill Pants (Chocolate)
64271 RIPNDIP (リップンディップ) Lullaby Long Sleeve (Black Mineral Wash)
64262 RIPNDIP (リップンディップ) Nerm Cruiser Tee (Black Mineral Wash)
64264 RIPNDIP (リップンディップ) Abduction Tee (Black Mineral Wash)
64276 RIPNDIP (リップンディップ) Nerm Cruiser Hoodie (Ash Heather)
64281 RIPNDIP (リップンディップ) Nerm Doodle Work Jacket (Chocolate)