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 '*) as total from products p, products_description pd, specials s, products_to_c' at line 1

select count(distinct *) as total from products p, products_description pd, specials s, products_to_categories p2c 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 (not (p2c.categories_id in (44,49,125,79,82,95,110,119,176,179,525,209,212,230,267,269,278,282,423,347,419,405,406,407,417,411,465,482,526,547,555,558,563,564,585,619))) and pd.language_id = '1' and s.status = '1'

[TEP STOP]

Get Them While They're Hot!