# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1553188784 -3600
# Node ID a06d11d1f0b391989e80d1594b3f88f0e2e941b1
# Parent  f95ec0bb565c0d7a2829f7766e06a8b631c67478
Fixed gauge selection in Nash Sutcliffe calculation.

diff -r f95ec0bb565c -r a06d11d1f0b3 pkg/controllers/gauges.go
--- a/pkg/controllers/gauges.go	Thu Mar 21 18:07:49 2019 +0100
+++ b/pkg/controllers/gauges.go	Thu Mar 21 18:19:44 2019 +0100
@@ -43,11 +43,11 @@
      a.predicted AND NOT b.predicted
 WHERE
   a.fk_gauge_id = (
-    $1::char(1),
-	$2::char(2),
-	$3::char(3),
-	$4::char(4),
-	$5::int
+    $1::char(2),
+    $2::char(3),
+    $3::char(5),
+    $4::char(5),
+    $5::int
   ) AND
   a.measure_date BETWEEN
     $6::timestamp AND $6::timestamp - '72hours'::interval
@@ -76,9 +76,9 @@
     $4::char(5),
     $5::int
   ) 
-  AND
-    measure_date BETWEEN
-	  $6::timestamp with time zone AND $7::timestamp with time zone
+  AND measure_date BETWEEN
+    $6::timestamp with time zone AND
+    $7::timestamp with time zone
 ORDER BY measure_date
 `
 )