# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1547221795 -3600
# Node ID 0a53c33bc7b2097de7fffea75fce3ff5af0968d7
# Parent  48791416bea5cfa8959550205b1aed45c423b81f
Fixed broken SQL statement (once again).

diff -r 48791416bea5 -r 0a53c33bc7b2 pkg/imports/agm.go
--- a/pkg/imports/agm.go	Fri Jan 11 16:48:14 2019 +0100
+++ b/pkg/imports/agm.go	Fri Jan 11 16:49:55 2019 +0100
@@ -75,7 +75,8 @@
 ),
 to_delete AS (
   SELECT o.id AS id
-  FROM waterway.gauge_measurements oJOIN waterway.gauge_measurements n
+  FROM waterway.gauge_measurements o
+  JOIN waterway.gauge_measurements n
     ON n.fk_gauge_id = o.fk_gauge_id AND n.measure_date = o.measure_date
     WHERE n.id     IN (SELECT key FROM staged)
 	  AND o.id NOT IN (SELECT key FROM staged)