1054 - Unknown column 'p.products_id' in 'on clause'

select distinct m.manufacturers_id as id, m.manufacturers_name as name from products p, products_to_categories p2c, manufacturers m left join prod_tags pt on p.products_id = pt.prod_id left join categories c on c.categories_id=p2c.categories_id where p.products_status = '1' and c.status_categ = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '25' group by m.manufacturers_id order by m.manufacturers_name