The complete audio-book catalog from Le cherche-Midi Editions
1054 - Unknown column 'p.manufacturers_id' in 'on clause'
select count(p.products_id) as total from products p, products_description pd, supports_description sd, editeurs e left join manufacturers m on p.manufacturers_id = m.manufacturers_id
left join specials s on p.products_id = s.products_id
where p.products_status >= '1'
and p.products_editeur_id = e.editeurs_id
and pd.products_id = p.products_id
and pd.language_id = '1'
and p.products_support_id = sd.supports_id
and sd.language_id = '1' and e.editeurs_id = '161' and p.products_support_id != 11
