Unknown column 'stockterm' in 'field list'<hr>SELECT SQL_CALC_FOUND_ROWS  p.*, IF(stockterm &lt; 3, 1, 0 ) AS is_stock, IF(ordering_available &gt; 0, 1, 0 ) AS is_buy, IF(Price &gt; 0, 1, 0 ) AS is_price, name_ru AS _name_sort FROM SC_products p WHERE (categoryID IN (755)) AND ( enabled=1) ORDER BY is_buy DESC, is_price DESC, is_stock DESC, sort_order, _name_sort ASC LIMIT 0,10