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-17 17:46:48')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND pc.point_rate >1
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) DESC
LIMIT 0, 240
13件見つかりました
1ページ中1ページ目
1
S 残り1点
¥15,400
RIPNDIP
Bottoms
¥13,200
RIPNDIP
Pullover
S 残り1点
¥12,100
RIPNDIP
Shorts
US 8 (25.5cm) 残り1点
¥12,100
RIPNDIP
Shoes
M 残り1点
¥11,000
RIPNDIP
S/S Shirt
M 残り1点
¥9,900
RIPNDIP
Shorts
¥9,130
RIPNDIP
Shoes
¥8,800
RIPNDIP
Shorts
フリー 残り1点
¥6,600
RIPNDIP
Cap
¥6,380
RIPNDIP
T-Shirt
M 残り1点
¥5,940
RIPNDIP
T-Shirt
M 残り1点
¥5,940
RIPNDIP
T-Shirt
¥3,300
RIPNDIP
Mask
13件見つかりました
1ページ中1ページ目
1
64288 RIPNDIP (リップンディップ) Nerm Doodle Cotton Twill Pants (Chocolate)
64274 RIPNDIP (リップンディップ) Summer Revenge Rhinestone Hoodie (Black)
64286 RIPNDIP (リップンディップ) Nerm Doodle Twill Shorts (Chocolate)
64301 RIPNDIP (リップンディップ) We Out Here High Top Shoe (Black)
64268 RIPNDIP (リップンディップ) Aloha Nerm Short Sleeve Button Up (Black)
64284 RIPNDIP (リップンディップ) Aloha Nerm Sweatshorts (Lavender)
60645 RIPNDIP Marker Slip On Shoes
64287 RIPNDIP (リップンディップ) Aloha Nerm Swim Shorts (Black)
64290 RIPNDIP (リップンディップ) Summer Revenge 6 Panel (Black)
64306 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Black)
64262 RIPNDIP (リップンディップ) Nerm Cruiser Tee (Black Mineral Wash)
64264 RIPNDIP (リップンディップ) Abduction Tee (Black Mineral Wash)
60641 RIPNDIP Scribble Face Mask (Green)