# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1564756644 -7200
# Node ID 80e9cfb2be98fc5c4eb9273b101aab6755de5f54
# Parent  5466562cca6083e3ea4122c9da94f8ff7f51ff20
Fixed duplicates in list surveys endpoint.

diff -r 5466562cca60 -r 80e9cfb2be98 pkg/controllers/surveys.go
--- a/pkg/controllers/surveys.go	Fri Aug 02 16:10:42 2019 +0200
+++ b/pkg/controllers/surveys.go	Fri Aug 02 16:37:24 2019 +0200
@@ -38,7 +38,7 @@
   LEFT JOIN waterway.gauges_reference_water_levels AS r
     ON s.depth_reference = r.depth_reference
       AND g.location = r.location AND g.validity = r.validity
-WHERE b.objnam = $1`
+WHERE b.objnam = $1 AND s.date_info::timestamptz <@ b.validity`
 )
 
 func listSurveys(