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 from reviews r, 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 = '3') where r.reviews_id = '4' and r.reviews_id = rd.reviews_id and p.products_status = '1'

[XT SQL Error]