Мне нужно название продукта и название производителя
Select p.name, m.name from products as p Join products_manufacturers as pm On pm.products_id=p.id Join manufacturers as m On m.id=pm.manufacturers_id Where p.name=‘Носки’ And pm.manufacturers_id=9
Select p.name, m.name from products as p Join products_manufacturers as pm On pm.products_id=p.id Join manufacturers as m On m.id=pm.manufacturers_id Where p.name=‘Носки’ And pm.manufacturers_id=9