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 '-26, 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.productID IN (2346,2351,2352,2356,2369,2389,2390,2399,2401,2413,2437,2453,2471,2479,2502,2510,2546,2567,2568,2573,2574,2580,2581,2653,2654,2670,2671,2672,2673,2675,2688,2691,2695,2715,2724,2725,2726,2737,2741,2773) AND rev.enabled = 1 ORDER BY rev.review_date DESC LIMIT -26, 51