Unknown column 'bsn' in 'where clause'
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`=577 AND pr.enabled = 1 AND pr.productID <> 2214-bsn-122-01-fire-red AND (pr.in_stock && 1 = 1) AND pr.productID IN(776,777,2201,2202,2203,2204,2209,2214,2238,2252,2260,2291,2622,2623,2675,2713,2714,2725,2812,2932,2950,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3052,3081,3114,3116,3141,3142,3143,3144,3145,3180,3185,3190,3250,3338,3339,3357,3373,3452) ORDER BY absPrice ASC LIMIT 12