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]