1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY r.`reviews_rating` DESC' at line 3
in:
[SELECT r.`reviews_rating` FROM reviews r WHERE r.`status` = 1 AND r.`products_id` = ORDER BY r.`reviews_rating` DESC]