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 '=O-Joo AND c.categories_id = cd.categories_id AND p.products_id = pc.' at line 3

SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_shop, c.categories_id, cd.categories_name, l.code language, count( * ) num FROM categories c, categories_description cd, manufacturers m, products p, products_to_categories pc, languages l WHERE m.manufacturers_id=307∏=O-Joo AND c.categories_id = cd.categories_id AND p.products_id = pc.products_id AND pc.categories_id = c.categories_id AND p.manufacturers_id = m.manufacturers_id AND p.products_status = 1 AND l.languages_id=cd.language_id GROUP BY m.manufacturers_id, cd.categories_id, l.code ORDER BY m.manufacturers_name, cd.categories_name