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 '-37, 51' at line 10
SELECT pov1.option_value_ru brand, pov2.option_value_ru model, rev.*,
prod.*, cat.enabled as category_enabled
FROM `SC_reviews` AS rev
INNER JOIN `SC_products` AS prod on rev.productID = prod.productID
JOIN `SC_categories` AS cat on cat.categoryID = prod.categoryID
LEFT JOIN SC_product_options_values pov1 on prod.productID = pov1.productID and pov1.optionID = 217
LEFT JOIN SC_product_options_values pov2 on prod.productID = pov2.productID and pov2.optionID = 218
WHERE 1=1 AND rev.enabled = 1
ORDER BY rev.review_date DESC
LIMIT -37, 51