All
Best Seller
Gift Set
Features
select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, 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>='2022-09-24')* b.rate) as offer_price,
ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2022-09-24') * 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>='2022-09-24') * b.rate))) as final_price
from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, 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>='2022-09-24')* b.rate) as offer_price,
ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2022-09-24') * 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>='2022-09-24') * b.rate))) as final_price
from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, 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>='2022-09-24')* b.rate) as offer_price,
ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2022-09-24') * 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>='2022-09-24') * b.rate))) as final_price
from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, 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>='2022-09-24')* b.rate) as offer_price,
ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2022-09-24') * 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>='2022-09-24') * b.rate))) as final_price
from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
