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

select r.reviews_id, left(rd.reviews_text, 250) as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_price_on_demand, p.products_tax_class_id, r.reviews_rating as anzahl from reviews r, reviews_description rd, products p, products_description pd LEFT JOIN products_to_categories p2c ON (p.products_id = p2c.products_id), countries c where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '1' and rd.languages_id = '1' group by p.products_id order by anzahl DESC, r.date_added DESC LIMIT 750

[XT SQL Error]