select p.ID, p.Title,p.out_of_stock,p.is_new,p.is_best_seller, p.code, p.image_path, p.price, p.price_2, b.rate, b.title as brand_title, b.ID as brand_id, ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-07-30')* b.rate) as offer_price,((p.price_2)*b.rate ) as lbp_price, ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-07-30') * b.rate) is null, ((p.price_2)*b.rate ), ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-07-30') * b.rate))) as final_price from products p, brands b where b.ID=p.brands_id and p.status=1 and p.sub_category_id =9 order by p.date DESC LIMIT 0, 16