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(3534,17' 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`=606 AND pr.enabled = 1 AND pr.productID <> 2924a-a-301-3-pt-natural AND (pr.in_stock && 1 = 1) AND pr.productID IN(3534,1732,1734,1739,1767,1768,1769,1770,1830,1978,1979,1980,1981,1982,1984,2004,2009,2010,2011,2014,2396,2526,2701,2746,2749,2755,2756,2757,2829,2853,2854,2855,2874,2875,2876,2922,2923,2924,2930,2931,2934,2935,2936,2952,2972,2976,2977,2978,2979,2980,2981,2982,2983,3018,3020,3564,3022,3023,3098,3109,3110,3111,3117,3119,3120,3121,3131,3134,3140,3163,3567,3186,3209,3211,3235,3236,3238,3239,3243,3245,3246,3247,3248,3256,3290,3337,3346,3353,3354,3365,3368,3370,3371,3376,3377,3378,3412,3413,3462,3463,3464,3465,3467,3468,3472,3473,3474,3475,3476,3478,3479,3491,3496,3497,3498,3499,3500,3533,3535,3548,3550,3552,3557,3558,3571,3573,3574,3575,3576,3577,3579,3580,3581,3586) ORDER BY absPrice ASC LIMIT 12