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 '-0, MAX_DISPLAY_NEW_REVIEWS' at line 11
in:
[SELECT r.reviews_id, rd.reviews_text as reviews_text, r.reviews_rating, r.date_added, r.customers_name FROM reviews r, reviews_description rd WHERE r.products_id = 589 AND r.reviews_id = rd.reviews_id AND rd.languages_id = 1 and r.status = 1 ORDER BY r.date_added desc limit -0, MAX_DISPLAY_NEW_REVIEWS]