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 14
in:
[select count(p.products_id) as total from products_description pd, products p, tvorba_ceny trc, wiewed_products w, manufacturers m, atribut_1 a where p.products_status = '1' and p.id_cenovej_skupiny = trc.id_cenovej_skupiny and p.products_id = w.products_id and p.manufacturers_id = m.manufacturers_id and p.products_id = pd.products_id and p.products_id = a.products_id and p.products_id IN()]