# HG changeset patch
# User Bjoern Ricks <bjoern.ricks@intevation.de>
# Date 1347448339 0
# Node ID f210432f438329ba56c6c552dbebfd7e5d693344
# Parent  42db09d101f3265f71fcd9641c1f92ff68a64eca
Fix hibernate query


flys-backend/trunk@5438 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 42db09d101f3 -r f210432f4383 flys-backend/src/main/java/de/intevation/flys/model/River.java
--- a/flys-backend/src/main/java/de/intevation/flys/model/River.java	Wed Sep 12 10:28:26 2012 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/model/River.java	Wed Sep 12 11:12:19 2012 +0000
@@ -224,11 +224,12 @@
         Session session = SessionHolder.HOLDER.get();
 
         Query query = session.createQuery(
-        "select min(wqr.q) as min, max(wqr.q) as max from Wst w " +
-            "join WstColumns as wc " +
-            "join WstColumnQRange as wcqr " +
-            "join WstQRange as wqr " +
-            "where w.kind = 0 and river_id = :river_id");
+            "select min(wqr.q) as min, max(wqr.q) as max " +
+            "from Wst as w " +
+            "join w.columns as wc " +
+            "join wc.columnQRanges as wcqr " +
+            "join wcqr.wstQRange as wqr " +
+            "where w.kind = 0 and river_id = :river");
 
         query.setParameter("river", getId());