Products on Special Offer
There has been an error with this page
Please report this error to ACA Sports by emailing them at info@acasports.co.uk
select p.products_id, p.products_date_added, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, pd.products_description, p.products_retail_price, p.products_status, p.products_price1,p.products_price2,p.products_price3,p.products_price4,p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty,p.products_qty_blocks, p.products_tax_class_id, p.products_sort_order,IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, if(p.products_tax_class_id=0, s.specials_new_products_price, ((1 + (tr.tax_rate / 100)) * s.specials_new_products_price)), if(p.products_tax_class_id=0, p.products_price, ((1 + (tr.tax_rate / 100)) * p.products_price))) as final_price from products p, products_description pd, specials s, tax_rates tr, products_to_categories ptc where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' and ptc.products_id = p.products_id and ( ptc.categories_id = 863 or ptc.categories_id = 864) order by pd.products_name limit -12, 12
Please report this error to ACA Sports by emailing them at info@acasports.co.uk
select p.products_id, p.products_date_added, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, pd.products_description, p.products_retail_price, p.products_status, p.products_price1,p.products_price2,p.products_price3,p.products_price4,p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty,p.products_qty_blocks, p.products_tax_class_id, p.products_sort_order,IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, if(p.products_tax_class_id=0, s.specials_new_products_price, ((1 + (tr.tax_rate / 100)) * s.specials_new_products_price)), if(p.products_tax_class_id=0, p.products_price, ((1 + (tr.tax_rate / 100)) * p.products_price))) as final_price from products p, products_description pd, specials s, tax_rates tr, products_to_categories ptc where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' and ptc.products_id = p.products_id and ( ptc.categories_id = 863 or ptc.categories_id = 864) order by pd.products_name limit -12, 12