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 ') group by p2.id order by p2.name' at line 1 select p2.* from shop1_products p1 join shop1_producers p2 on (p1.fk_producer=p2.id) where p1.fk in (1,2,3,4,5,8,6,9,28,29,) group by p2.id order by p2.name;

1.
Db -> post ( select p2.* from shop1_products p1 join shop1_producers p2 on (p1.fk_producer=p2.id) where p1.fk in (1,2,3,4,5,8,6,9,28,29,) group by p2.id order by p2.name;, )
/home/dveriopt/public_html/core/classes/db.class.php (Line: 103)

2.
Db -> query ( select p2.* from shop1_products p1 join shop1_producers p2 on (p1.fk_producer=p2.id) where p1.fk in (1,2,3,4,5,8,6,9,28,29,) group by p2.id order by p2.name; )
/home/dveriopt/public_html/application/models/products.model.php (Line: 176)

3.
ProductsModel :: getProducers ( Array )
/home/dveriopt/public_html/application/controllers/cat.php (Line: 71)

4.
CatController -> index ( )
/home/dveriopt/public_html/core/classes/dispatcher.class.php (Line: 35)

5.
Dispatcher -> process ( Array, Array )
/home/dveriopt/public_html/index.php (Line: 7)