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

select rd.reviews_text, r.reviews_rating, r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, p.products_id, pd.products_name, p.products_image, m.manufacturers_name, p.products_model from reviews r, manufacturers m, reviews_description rd left join products p on (r.products_id = p.products_id) left join products_description pd on (p.products_id = pd.products_id and pd.language_id = '1') where r.reviews_id = '192' and r.reviews_id = rd.reviews_id and m.manufacturers_id = p.manufacturers_id

[TEP STOP]