# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1554977477 -7200
# Node ID ddc4d54b8331cf9d47518f83d52b406ea0654534
# Parent  f394e828a6d2a995dde980418f110626785e0cec
Remove unnecessary subselect

diff -r f394e828a6d2 -r ddc4d54b8331 schema/geoserver_views.sql
--- a/schema/geoserver_views.sql	Thu Apr 11 12:01:27 2019 +0200
+++ b/schema/geoserver_views.sql	Thu Apr 11 12:11:17 2019 +0200
@@ -14,10 +14,9 @@
         json_strip_nulls(json_object_agg(coalesce(r.depth_reference,'empty'),
                                                   r.value))
             AS reference_water_levels
-    FROM waterway.gauges g LEFT JOIN LATERAL (
-            SELECT gauge_id, depth_reference, value
-            FROM waterway.gauges_reference_water_levels
-            ) r ON r.gauge_id = g.location
+    FROM waterway.gauges g
+        LEFT JOIN waterway.gauges_reference_water_levels r
+            ON r.gauge_id = g.location
     GROUP BY g.location;
 
 CREATE OR REPLACE VIEW waterway.distance_marks_geoserver AS