1054 - Unknown column 'Subaru' in 'where clause'

SELECT straight_join p.manufacturers_id, ptc.categories_id, cd.categories_name, c.parent_id, m.manufacturers_name, A.categories_name as sub_cat FROM categories c LEFT JOIN categories_description A on A.categories_id = c.parent_id, products p, products_to_categories ptc, categories_description cd, manufacturers m WHERE p.products_id=ptc.products_id AND p.products_status=1 AND cd.language_id=1 AND c.categories_id=cd.categories_id AND ptc.categories_id=cd.categories_id AND m.manufacturers_id=p.manufacturers_id AND p.item_id=19/Subaru limit 1