--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/BedMobility.java	Fri Apr 20 16:04:34 2018 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/BedMobility.java	Mon Apr 23 15:18:48 2018 +0200
@@ -25,7 +25,10 @@
 import javax.persistence.SequenceGenerator;
 import javax.persistence.Table;
 
+import org.dive4elements.river.backend.SessionHolder;
 import org.dive4elements.river.model.River;
+import org.hibernate.Query;
+import org.hibernate.Session;
 
 /**
  * Hibernate binding for the DB table bed_mobility
@@ -134,4 +137,18 @@
     public void addValue(final BedMobilityValue value) {
         this.values.add(value);
     }
+
+    /**
+     * Selects a bed mobility series of a river from the database
+     */
+    public static BedMobility queryForRiver(final River river) {
+        final Session session = SessionHolder.HOLDER.get();
+        final Query query = session.createQuery("FROM BedMobilty WHERE river=:river");
+        query.setParameter("river", river);
+        final List<BedMobility> rows = query.list();
+        if (rows != null)
+            return rows.get(0);
+        else
+            return null;
+    }
 }
\ No newline at end of file