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