Acumendia is the first ever Internet-enabled grocery wholesaler servicing the United Kingdom & the Republic of Ireland.
Cart Total:  Sign In   
Browse
Currencies
Information

All Products

You must ADD YOUR PRODUCTS to your cart (by pressing the ADD TO CART button at the bottom of each page) before you move on to the next page!

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 200' at line 1

select distinct p.products_model, p.products_pack, p.products_case, p.products_tax_class_id, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(sm.status, sm.specials_new_products_price, IF(s.status, s.specials_new_products_price, NULL)) as specials_new_products_price, IF(sm.status, sm.specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price)) as final_price from ((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id left join specials_managers sm on p.products_id = sm.products_id, categories c, products_to_categories p2c where p.products_status = '1' and ((p.products_price - s.specials_new_products_price) >= 0 || s.specials_new_products_price IS NULL) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_status = '0' and ((pd.products_name like '%%%%' or p.products_model like '%%%%' or m.manufacturers_name like '%%%%') ) order by limit 0, 200

[TEP STOP]