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 a.manufacturers_id
ORDER BY a.manufacturers_name' at line 8
SELECT a.manufacturers_name,a.manufacturers_id
FROM manufacturers a,products b,products_to_categories c
WHERE b.products_status = '1'
AND a.manufacturers_id = b.manufacturers_id
AND b.products_id = c.products_id
AND b.group_permission_1 = 1
AND c.categories_id =
GROUP BY a.manufacturers_id
ORDER BY a.manufacturers_name
[XT SQL Error]
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 a.manufacturers_id
ORDER BY a.manufacturers_name' at line 8
SELECT a.manufacturers_name,a.manufacturers_id
FROM manufacturers a,products b,products_to_categories c
WHERE b.products_status = '1'
AND a.manufacturers_id = b.manufacturers_id
AND b.products_id = c.products_id
AND b.group_permission_1 = 1
AND c.categories_id =
GROUP BY a.manufacturers_id
ORDER BY a.manufacturers_name
