query failed:
  • errorno = 1054
  • error = Unknown column 'ORDER_FIELD' in 'order clause'
  • query = SELECT SQL_CALC_FOUND_ROWS `o`.`id`, `o`.`property_type`, `o`.`how_many_occupants`, `o`.`is_vip`, `o`.`min_price_day`, `o`.`min_price_week`, `o`.`min_price_day_person`, `o`.`stars`, `o`.`kitchen`, `o`.`inside`, `o`.`outside`, `o`.`suitable`, `o`.`spa`, `o`.`region_id`, `o`.`virtual_tour_url`, `o`.`images_count`, `o`.`promos_count`, `o`.`is_translated`, `o`.`created_in`, `ot`.`name`, `ot`.`web_site`, `ot`.`contact_tel`, `ot`.`description`, `ot`.`min_price_based_on`, `c`.`name` as city FROM offers o, offers_texts ot, cities c WHERE `o`.id = `ot`.`offer_id` AND `o`.`city_id` = `c`.`city_id` AND `ot`.language = 2 AND `c`.language = 2 AND `c`.country = 2 AND o.status in (1,4,5,6,7,8,9) AND o.property_type IN (3,4,7,9) AND (o.activate_date + INTERVAL `o`.`active_period` MONTH > now() OR status = 6) ORDER BY is_vip DESC, ORDER_FIELD, id DESC LIMIT 0, 10