SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.type AS node_type, node.vid AS node_vid, node.sticky AS
     node_sticky
  FROM node node INNER JOIN content_field_accommodation node_data_field_accommodation ON node.vid =
     node_data_field_accommodation.vid INNER JOIN content_field_corporate_capacity node_data_field_corporate_capacity ON
     node.vid = node_data_field_corporate_capacity.vid INNER JOIN content_field_cottage_capacity
     node_data_field_cottage_capacity ON node.vid = node_data_field_cottage_capacity.vid INNER JOIN content_field_transit_time
     node_data_field_transit_time ON node.vid = node_data_field_transit_time.vid INNER JOIN content_field_child_infrastructure
     node_data_field_child_infrastructure_value_0 ON node.vid = node_data_field_child_infrastructure_value_0.vid AND
     node_data_field_child_infrastructure_value_0.field_child_infrastructure_value = 1 INNER JOIN
     content_field_child_infrastructure node_data_field_child_infrastructure_value_1 ON node.vid =
     node_data_field_child_infrastructure_value_1.vid AND
     node_data_field_child_infrastructure_value_1.field_child_infrastructure_value = 2 INNER JOIN
     content_field_child_infrastructure node_data_field_child_infrastructure_value_2 ON node.vid =
     node_data_field_child_infrastructure_value_2.vid AND
     node_data_field_child_infrastructure_value_2.field_child_infrastructure_value = 3 INNER JOIN
     content_field_child_infrastructure node_data_field_child_infrastructure_value_3 ON node.vid =
     node_data_field_child_infrastructure_value_3.vid AND
     node_data_field_child_infrastructure_value_3.field_child_infrastructure_value = 4 INNER JOIN
     content_field_child_infrastructure node_data_field_child_infrastructure_value_4 ON node.vid =
     node_data_field_child_infrastructure_value_4.vid AND
     node_data_field_child_infrastructure_value_4.field_child_infrastructure_value = 5 INNER JOIN
     content_field_child_infrastructure node_data_field_child_infrastructure_value_5 ON node.vid =
     node_data_field_child_infrastructure_value_5.vid AND
     node_data_field_child_infrastructure_value_5.field_child_infrastructure_value = 6 INNER JOIN
     content_field_child_infrastructure node_data_field_child_infrastructure_value_6 ON node.vid =
     node_data_field_child_infrastructure_value_6.vid AND
     node_data_field_child_infrastructure_value_6.field_child_infrastructure_value = 7 INNER JOIN
     content_field_cottage_infrastructure node_data_field_cottage_infrastructure_value_0 ON node.vid =
     node_data_field_cottage_infrastructure_value_0.vid AND
     node_data_field_cottage_infrastructure_value_0.field_cottage_infrastructure_value = 1 INNER JOIN
     content_field_room_infrastructure node_data_field_room_infrastructure_value_0 ON node.vid =
     node_data_field_room_infrastructure_value_0.vid AND
     node_data_field_room_infrastructure_value_0.field_room_infrastructure_value = 1 INNER JOIN
     content_field_room_infrastructure node_data_field_room_infrastructure_value_1 ON node.vid =
     node_data_field_room_infrastructure_value_1.vid AND
     node_data_field_room_infrastructure_value_1.field_room_infrastructure_value = 2 INNER JOIN
     content_field_room_infrastructure node_data_field_room_infrastructure_value_2 ON node.vid =
     node_data_field_room_infrastructure_value_2.vid AND
     node_data_field_room_infrastructure_value_2.field_room_infrastructure_value = 3 INNER JOIN
     content_field_room_infrastructure node_data_field_room_infrastructure_value_3 ON node.vid =
     node_data_field_room_infrastructure_value_3.vid AND
node_data_field_room_infrastructure_value_3.field_room_infrastructure_value = 7 INNER JOIN content_field_openair
     node_data_field_openair ON node.vid = node_data_field_openair.vid INNER JOIN content_field_orientation
     node_data_field_orientation ON node.vid = node_data_field_orientation.vid INNER JOIN content_field_meals
     node_data_field_meals ON node.vid = node_data_field_meals.vid INNER JOIN content_field_animals node_data_field_animals ON
     node.vid = node_data_field_animals.vid INNER JOIN content_field_corporate_one_day node_data_field_corporate_one_day ON
     node.vid = node_data_field_corporate_one_day.vid INNER JOIN content_field_rent node_data_field_rent ON node.vid =
     node_data_field_rent.vid INNER JOIN content_field_relax node_data_field_relax ON node.vid = node_data_field_relax.vid
     INNER JOIN content_field_area node_data_field_area ON node.vid = node_data_field_area.vid INNER JOIN content_field_sports
     node_data_field_sports ON node.vid = node_data_field_sports.vid INNER JOIN content_field_audience
     node_data_field_audience_value_0 ON node.vid = node_data_field_audience_value_0.vid AND
     node_data_field_audience_value_0.field_audience_value = 1 INNER JOIN content_field_audience
     node_data_field_audience_value_1 ON node.vid = node_data_field_audience_value_1.vid AND
     node_data_field_audience_value_1.field_audience_value = 2 INNER JOIN content_field_audience
     node_data_field_audience_value_2 ON node.vid = node_data_field_audience_value_2.vid AND
     node_data_field_audience_value_2.field_audience_value = 3 INNER JOIN content_field_excursions node_data_field_excursions
     ON node.vid = node_data_field_excursions.vid INNER JOIN content_field_grade node_data_field_grade ON node.vid =
     node_data_field_grade.vid INNER JOIN content_field_internet node_data_field_internet ON node.vid =
     node_data_field_internet.vid
  WHERE (node.status <> 0) AND (node.type in ('object')) AND (node_data_field_accommodation.field_accommodation_value IN (1,
     2)) AND (node_data_field_corporate_capacity.field_corporate_capacity_value = 1) AND
     (node_data_field_cottage_capacity.field_cottage_capacity_value = 1) AND
     (node_data_field_transit_time.field_transit_time_value = 2) AND
     (node_data_field_child_infrastructure_value_0.field_child_infrastructure_value = 1 AND
     node_data_field_child_infrastructure_value_1.field_child_infrastructure_value = 2 AND
     node_data_field_child_infrastructure_value_2.field_child_infrastructure_value = 3 AND
     node_data_field_child_infrastructure_value_3.field_child_infrastructure_value = 4 AND
     node_data_field_child_infrastructure_value_4.field_child_infrastructure_value = 5 AND
     node_data_field_child_infrastructure_value_5.field_child_infrastructure_value = 6 AND
     node_data_field_child_infrastructure_value_6.field_child_infrastructure_value = 7) AND
     (node_data_field_cottage_infrastructure_value_0.field_cottage_infrastructure_value = 1) AND
     (node_data_field_room_infrastructure_value_0.field_room_infrastructure_value = 1 AND
     node_data_field_room_infrastructure_value_1.field_room_infrastructure_value = 2 AND
     node_data_field_room_infrastructure_value_2.field_room_infrastructure_value = 3 AND
     node_data_field_room_infrastructure_value_3.field_room_infrastructure_value = 7) AND
     (node_data_field_openair.field_openair_value = 1) AND (node_data_field_orientation.field_orientation_value IN (1, 2, 3,
     5, 8, 9)) AND (node_data_field_meals.field_meals_value = 3) AND (node_data_field_animals.field_animals_value = 1) AND
     (node_data_field_corporate_one_day.field_corporate_one_day_value = 1) AND (node_data_field_rent.field_rent_value IN (1,
     3, 4, 6)) AND (node_data_field_relax.field_relax_value IN (1, 2, 3)) AND (node_data_field_area.field_area_value = 1) AND
     (node_data_field_sports.field_sports_value IN (5, 6, 9)) AND (node_data_field_audience_value_0.field_audience_value = 1
     AND node_data_field_audience_value_1.field_audience_value = 2 AND node_data_field_audience_value_2.field_audience_value =
     3) AND (node_data_field_excursions.field_excursions_value = 1) AND (node_data_field_grade.field_grade_value = 2) AND
     (node_data_field_internet.field_internet_value = 1)
  ORDER BY node_sticky DESC, node_title ASC
  LIMIT 0, 8