QUERY ERROR: 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 p.products_id = p2c.products_id AND p.products_status = 1 ' at line 13
Query was:SELECT mi.manufacturers_promo_sentence , cd.categories_promo_sentence FROM ( products p , products_to_categories p2c ) LEFT JOIN categories_description cd on p2c.categories_id = cd.categories_id and cd.language_id = 7 LEFT JOIN manufacturers_info mi on p.manufacturers_id = mi.manufacturers_id and mi.languages_id = 7 WHERE p.products_id = AND p.products_id = p2c.products_id AND p.products_status = 1 AND p.products_id = p2c.products_id GROUP BY p2c.products_id