Mercurial > gemma

comparison pkg/controllers/surveys.go @ 3656:2a079d0a71c1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Ensure sounding results are associated to matching bottleneck version
author Tom Gottfried <tom@intevation.de>
date Thu, 13 Jun 2019 19:13:42 +0200
parents 02951a62e8c6
children 02d5c2e17eb8
comparison
equal deleted inserted replaced
3649:fb8a53c7c6d3 3656:2a079d0a71c1
32 g.objname AS gauge_objname, 32 g.objname AS gauge_objname,
33 r.value AS waterlevel_value 33 r.value AS waterlevel_value
34 FROM waterway.bottlenecks AS b 34 FROM waterway.bottlenecks AS b
35 JOIN waterway.gauges AS g 35 JOIN waterway.gauges AS g
36 ON b.gauge_location = g.location AND b.gauge_validity = g.validity 36 ON b.gauge_location = g.location AND b.gauge_validity = g.validity
37 JOIN waterway.sounding_results AS s ON b.id = s.bottleneck_id 37 JOIN waterway.sounding_results AS s ON b.bottleneck_id = s.bottleneck_id
38 LEFT JOIN waterway.gauges_reference_water_levels AS r 38 LEFT JOIN waterway.gauges_reference_water_levels AS r
39 ON s.depth_reference = r.depth_reference 39 ON s.depth_reference = r.depth_reference
40 AND g.location = r.location AND g.validity = r.validity 40 AND g.location = r.location AND g.validity = r.validity
41 WHERE b.objnam = $1` 41 WHERE b.objnam = $1`
42 ) 42 )