1054 - Unknown column 'p.manufacturers_id' in 'on clause'
select count(*) as total from products p, products_description pd left join manufacturers m on (p.manufacturers_id = m.manufacturers_id) where (p.products_status = '1') and (p.products_id = pd.products_id) and (pd.language_id = '6')