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-27 06:03:13')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND FIND_IN_SET(14, 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
¥3,520
RIPNDIP
Pants
XL 残り1点
¥6,600
RIPNDIP
T-Shirts
¥6,600
RIPNDIP
S/S T-Shirt
¥9,130
RIPNDIP
Shoes
¥12,100
RIPNDIP
Knit
S 残り1点
¥12,100
RIPNDIP
Pants
¥14,300
RIPNDIP
S/S Shirts
¥16,500
RIPNDIP
Pullover
¥17,600
RIPNDIP
Pullover
¥19,800
RIPNDIP
Bottoms
¥22,000
RIPNDIP
Jacket
11件見つかりました
1ページ中1ページ目
1
65453 RIPNDIP(リップッディップ) Peek A Nermal Boxers (Cobalt Blue)
67842 RIPNDIP (リップンディップ) NERMA LISA POCKET TEE (LIGHT SLATE)
67884 RIPNDIP (リップンディップ) Astroworld Tee Cornflower Blue
60645 RIPNDIP Marker Slip On Shoes
65432 RIPNDIP (リップンディップ) Nermhol Knit Sweater (Multi)
68535 RIPNDIP (リップンディップ) Peek A Nerm Sweat Shorts PACIFIC BLUE
68532 RIPNDIP (リップンディップ) Pablo Button Up MISTY BLUE
68534 RIPNDIP (リップンディップ) Rubber Logo Hoodie PACIFIC BLUE
67903 RIPNDIP (リップンディップ) Waves Sherpa Hoodie (Light Slate)
69330 RIPNDIP (リップンディップ) KAWAII NERM WIDE LEG WOMENS PANTS MEDIUM WASH
66849 RIPNDIP (リップンディップ) Cosmic Meadow Sherpa Jacket Purple/Slate