A fatal MySQL error occurred.

Query:
SELECT r.*, rt.rating, u.login FROM pmd_v1_reviews r LEFT JOIN pmd_v1_ratings rt ON r.id=rt.review_id LEFT JOIN pmd_v1_users u ON u.id=r.user_id WHERE r.id='320' AND status='active'

Error:
(1054) Unknown column 'rt.review_id' in 'on clause'