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 'natural AND (pr.in_stock && 1 = 1) AND pr.productID IN(754,756' at line 17
SELECT pr.productID as productID, pr.`name_ru` AS name, pr.Price, pr.slug, pr.brief_description_ru, ABS(pr.Price - rel.Price) as absPrice FROM SC_products AS pr JOIN SC_products AS rel ON (rel.`productID` = pr.`productID`) WHERE pr.`categoryID`=578 AND pr.enabled = 1 AND pr.productID <> 2955-103-cbb-natural AND (pr.in_stock && 1 = 1) AND pr.productID IN(754,756,807,810,911,913,926,956,967,969,979,993,1002,1165,1166,1167,1168,1177,1178,1180,1217,1218,1220,1328,1527,1595,1679,2101,2112,2114,2115,2118,2119,2125,2126,2128,2149,2204,2209,2238,2347,2418,2419,2436,2445,2449,2472,2476,2517,2673,2683,2703,2707,2713,2725,2734,2749,2767,2788,2812,2823,2829,2831,2838,2841,2859,2911,2917,2926,2930,2947,2948,2955,2956,2957,2958,2959,2965,2966,2994,2996,2999,3014,3028,3031,3033,3035,3036,3037,3038,3040,3089,3092,3099,3100,3107,3141,3142,3143,3145,3153,3161,3168,3173,3178,3179,3183,3189,3216,3229,3255,3265,3267,3336,3338,3339,3347,3348,3359,3409,3417,3420,3421,3422,3423,3424,3425,3426,3427,3429,3431,3432,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,3447,3448,3449,3450,3451,3452,3454,3459,3460,3469,3470,3471) ORDER BY absPrice ASC LIMIT 12