Unknown column 'stockterm' in 'field list'
SELECT SQL_CALC_FOUND_ROWS p.*, IF(stockterm < 3, 1, 0 ) AS is_stock, IF(ordering_available > 0, 1, 0 ) AS is_buy, IF(Price > 0, 1, 0 ) AS is_price, name_ru AS _name_sort FROM SC_products p WHERE (categoryID IN (768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,805,802,803,804,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,767)) AND ( enabled=1) ORDER BY is_buy DESC, is_price DESC, is_stock DESC, sort_order, _name_sort ASC LIMIT 0,10