The complete audio-book catalog read by Michelangelo Marchese
1054 - Unknown column 'p.products_id' in 'on clause'
select count(p.products_id) as total from products p, products_description pd, narrateurs n, supports_description sd, editeurs ed, products_to_narrateurs p2n
left join specials s on p.products_id = s.products_id
where p.products_status >= '1'
and p2n.products_id = p.products_id
and p.products_editeur_id = ed.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 p2n.narrateurs_id = n.narrateurs_id and n.narrateurs_id = '972'
