# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1382957534 -3600
# Node ID d4024d245f4ed2620d7542216c1212325f00f233
# Parent  5363047c827436405467d9109f28e34d79b4e2ad
meta-data.xml: Simplify query for densities a bit, sort by depth.

diff -r 5363047c8274 -r d4024d245f4e artifacts/doc/conf/meta-data.xml
--- a/artifacts/doc/conf/meta-data.xml	Sun Oct 27 17:30:38 2013 +0100
+++ b/artifacts/doc/conf/meta-data.xml	Mon Oct 28 11:52:14 2013 +0100
@@ -1254,9 +1254,9 @@
                 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}
+            WHERE   sd.river_id = ${river_id}
+            ORDER BY depth_upper
         </dc:statement>
         <dc:if test="dc:has-result()">
           <dc:for-each>