All Current Sale Items
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 ' )' at line 1

select count(*) as total from products p, products_description pd, categories c, categories_description cd, products_to_categories p2c, specials s where p.products_status='1' and s.products_id=p.products_id and p.products_id=pd.products_id and p.products_id=p2c.products_id and cd.categories_id=c.categories_id and p2c.categories_id=c.categories_id and pd.language_id='1' and s.status='1' and c.categories_id NOT IN (, )