Loading

Failed to run query SELECT SQL_CALC_FOUND_ROWS DISTINCT nid, title, type, node.language, field_price_value*if(currencies.rate IS NULL,1.0,currencies.rate) AS cad_price FROM silkway_drupal.node JOIN silkway_drupal.field_data_field_price ON field_data_field_price.entity_id=node.nid LEFT JOIN silkway_drupal.field_data_field_currency ON node.nid=field_data_field_currency.entity_id LEFT JOIN silkway_admin.currencies ON currencies.code=field_data_field_currency.field_currency_value LEFT JOIN silkway_drupal.field_data_field_valid_from ON node.nid=field_data_field_valid_from.entity_id LEFT JOIN silkway_drupal.field_data_field_valid_to ON node.nid=field_data_field_valid_to.entity_id JOIN silkway_drupal.field_data_body ON node.nid=field_data_body.entity_id JOIN silkway_drupal.field_data_field_destination_city ON field_data_field_destination_city.entity_id=node.nid WHERE node.status=1 AND (field_data_field_valid_from.field_valid_from_value IS NULL OR field_data_field_valid_from.field_valid_from_value<='2017-10-20') AND (field_data_field_valid_to.field_valid_to_value IS NULL OR field_data_field_valid_to.field_valid_to_value>='2017-10-20') AND field_data_body.language='en' AND (type='air_hotel' OR type='cruise' OR type='exotic' OR type='themed_travel' OR type='tours') AND field_data_field_destination_city.entity_type='node' AND field_data_field_destination_city.field_destination_city_value='1098' ORDER BY cad_price DESC, field_data_field_nights.field_nights_value DESC LIMIT 0,12: (1054)Unknown column 'field_data_field_nights.field_nights_value' in 'order clause'