1054 - Unknown column 'p.products_id' in 'on clause'
select count(*) as total from reviews r, reviews_description rd, products p left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1' and pd1.affiliate_id = '3' LEFT join products_to_affiliates p2a on p.products_id = p2a.products_id and p2a.affiliate_id = '3' , products_description pd left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '0' and pp.currencies_id = '0' where status and p.products_status = 1 and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p2a.affiliate_id is not null and p.products_id = pd.products_id and pd.language_id = '1' and rd.languages_id = '1' and pd.affiliate_id = 0
