1054 - Unknown column 'p.authors_id' in 'on clause'

select pd.language_id, p.products_id, pd.products_name, p.products_model, pd.products_url, p.products_price, p.products_date_available, p.manufacturers_id, a.authors_name, p.isbn from products p, products_description pd left join authors a on p.authors_id = a.authors_id where p.products_id = '2902' and pd.products_id = '2902' and pd.language_id ='1'

[TEP STOP]