CLINIQUE AROMATIC ELIXIR BLACK 100 ML

Categories: CLINIQUE PERFUMES

Public Price 2117404LBP
Sale Price 1,600,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='14712' ) or p.code IN( select prod_code from simullar_product where related_product_code='14712' ) and p.status=1 and p.ID!='219' ORDER BY date DESC LIMIT 4