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