1054 - Unknown column 'pd.products_id' in 'where clause'

select count(*) as count from products p left join specials s on p.products_id = s.products_id, manufacturers m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '0' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '66'

[TEP STOP]