Accommodation by sleep capacity (range)

Custom SQL query returning 243 rows (hide)

SELECT name, country, family, venue_type, rating_value, rating_scheme,
       capacity_persons, rooms, city, lat, lng
FROM venues
WHERE "group" = 'stay'
  AND capacity_persons >= CAST(:min_beds AS INTEGER)
  AND capacity_persons <= CAST(:max_beds AS INTEGER)
  AND (country = :country OR :country = '')
ORDER BY capacity_persons DESC

Query parameters

min_beds

max_beds

country