LANVIN MODERN PRINCESS COF 90ML+BL+M

Categories: LANVIN

Public Price 1242000LBP
Sale Price 900,000LBP
Add to Cart
Comments


Related Item


select p.ID, p.Title, p.code, p.image_path, p.price, p.price_2, (select title from brands where ID=p.brands_id) as brand, (select rate from brands where ID=p.brands_id) as rate , (select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-05-08') as offer_price, if(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-05-08') * (select rate from brands where ID=p.brands_id)) is null, ((p.price_2)*(select rate from brands where ID=p.brands_id)),((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-05-08') * (select rate from brands where ID=p.brands_id)) ) as final_price from products p where p.code IN( select related_product_code from simullar_product where prod_code='28495' ) or p.code IN( select prod_code from simullar_product where related_product_code='28495' ) and p.status=1 and p.ID!='2239' ORDER BY date DESC LIMIT 4