# HG changeset patch # User Felix Wolfsteller # Date 1380555167 -7200 # Node ID b893e1d0ddc7624141a6e6eddbb594f49e8c34b1 # Parent fc965ef589728d016c767a45ec5ac2702f2b6828 issue1435: Add densities-macro to meta-data.xml . diff -r fc965ef58972 -r b893e1d0ddc7 artifacts/doc/conf/meta-data.xml --- a/artifacts/doc/conf/meta-data.xml Mon Sep 30 17:32:04 2013 +0200 +++ b/artifacts/doc/conf/meta-data.xml Mon Sep 30 17:32:47 2013 +0200 @@ -1229,6 +1229,34 @@ + + + + + SELECT DISTINCT + sd.id AS sdid, + sd.description AS description, + d.lower AS depth_lower, + d.upper AS depth_upper + FROM sediment_density sd + JOIN rivers r ON sd.river_id = r.id + JOIN depths d ON sd.depth_id = d.id + WHERE r.id = ${river_id} + + + + + + + + + + +