# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1557409341 -7200
# Node ID 9e087a495f41fd2184049bf99bfc2a9a32c92673
# Parent  83e8e1ea0affa38e92cbfce7b94480e6d149763d
Fixed SQL statements. Got broken when migrated to new filter builder.

diff -r 83e8e1ea0aff -r 9e087a495f41 pkg/controllers/gauges.go
--- a/pkg/controllers/gauges.go	Thu May 09 15:14:12 2019 +0200
+++ b/pkg/controllers/gauges.go	Thu May 09 15:42:21 2019 +0200
@@ -642,7 +642,7 @@
 			buildFilterTerm(
 				`date_issue = (
                  SELECT max(date_issue) FROM waterway.gauge_measurements
-                 WHERE fk_gauge_id = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int)`,
+                 WHERE fk_gauge_id = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int))`,
 				isrs.CountryCode,
 				isrs.LoCode,
 				isrs.FairwaySection,
diff -r 83e8e1ea0aff -r 9e087a495f41 pkg/controllers/printtemplates.go
--- a/pkg/controllers/printtemplates.go	Thu May 09 15:14:12 2019 +0200
+++ b/pkg/controllers/printtemplates.go	Thu May 09 15:42:21 2019 +0200
@@ -37,6 +37,7 @@
   date_info,
   country
 FROM users.templates
+WHERE
 `
 
 	hasPrintTemplateSQL = `