CH BAD BOY LE PARFUM EDP 50ML

Categories: CAROLINA HERRERA

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