Wedding venues (ranked by fit)

Custom SQL query returning more than 1,000 rows (hide)

SELECT name, country, fit_wedding, family, venue_type, rating_value,
       capacity_persons, rooms, city, lat, lng
FROM venues
WHERE fit_wedding >= 50
  AND (:min_guests = '' OR capacity_persons >= CAST(:min_guests AS INTEGER))
  AND (country = :country OR :country = '')
ORDER BY fit_wedding DESC, capacity_persons DESC

Query parameters

min_guests

country