SQLSTATE[42000]: Syntax error or access violation: 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 'GROUP BY category.id ORDER BY position DESC' at line 1<hr>SELECT category.id, category.name, category.parent, category.position FROM category, product WHERE category.id = product.categoryid AND parent =  GROUP BY category.id ORDER BY position DESC