# HG changeset patch # User Tom Gottfried # Date 1386337908 -3600 # Node ID a6363e080e2c43bf34aa068ec68c4a5171cb3e13 # Parent c36aae57ad439e4e19dc6f017763343e91c2dd08 Order by years in SQ-relation datacage. diff -r c36aae57ad43 -r a6363e080e2c artifacts/doc/conf/meta-data.xml --- a/artifacts/doc/conf/meta-data.xml Fri Dec 06 14:27:03 2013 +0100 +++ b/artifacts/doc/conf/meta-data.xml Fri Dec 06 14:51:48 2013 +0100 @@ -1922,6 +1922,7 @@ JOIN sq_relation_value sqv ON sqv.sq_relation_id = sq.id JOIN measurement_station ms ON sqv.measurement_station_id = ms.id WHERE r.id = ${river_id} + ORDER BY start_time, stop_time