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

select pd.products_name from products p, products_description pd left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '1' and pp.currencies_id = '0' where p.products_status = 1 and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) and p.products_id = '20724' and p.products_id = pd.products_id and pd.language_id = '1'

[TEP STOP]