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 (694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,693)) AND ( enabled=1) ORDER BY is_buy DESC, is_price DESC, is_stock DESC, sort_order, _name_sort ASC LIMIT 0,10