Featured Site 1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, pd.products_url, pd.products_name from products p, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id left join products_description pd on p.products_id=pd.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_id = '47' and p.products_status = '1' and f.status = '1' and pd.language_id='1' order by f.featured_date_added desc

[TEP STOP]