--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/Channel.java	Mon Aug 20 09:42:32 2018 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/Channel.java	Mon Aug 20 09:46:02 2018 +0200
@@ -170,4 +170,19 @@
         query.setParameter("id", id);
         return (Channel) query.list().get(0);
     }
+
+    /**
+     * Queries the channel series for a river and a year from the database
+     */
+    public static Channel getSeries(final River river, final int year) {
+        final Session session = SessionHolder.HOLDER.get();
+        final Query query = session.createQuery("FROM Channel WHERE (river=:river) AND (year_from <= :year) AND (year_to >= :year)");
+        query.setParameter("river", river);
+        query.setParameter("year", year);
+        @SuppressWarnings("unchecked")
+        final List<Object[]> rows = query.list();
+        if (!rows.isEmpty())
+            return (Channel) query.list().get(0);
+        return null;
+    }
 }
\ No newline at end of file