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 'AND
ptc.products_id = p.products_id AND
p.products_disab' at line 2
SELECT STRAIGHT_JOIN c2.categories_image, cd.categories_name FROM products p, products_to_categories ptc, categories c, categories c2, categories_description cd
WHERE p.manufacturers_id= AND
ptc.products_id = p.products_id AND
p.products_disabled=0 AND
p.products_status = 1 AND
c.categories_id = ptc.categories_id AND
c2.categories_id = c.parent_id AND
cd.categories_id = c.parent_id
GROUP BY c.parent_id
ORDER BY cd.categories_name
