--- /dev/null
+<?xml version="1.0"?>
+<custom-sql>
+<sql id="com.pentila.entSavoie.cdt.service.persistence.CDTSessionFinderImpl.findByTeacherId_RangeDate">
+<![CDATA[
+ SELECT cdtSession.*
+ FROM cdt_cdtsession cdtSession
+ JOIN cdt_sessionteacher sessionTeacher
+ ON cdtSession.sessionId = sessionTeacher.sessionId
+ WHERE cdtSession.sessionStart BETWEEN DATE(?) AND DATE(?)
+ AND sessionTeacher.teacherId = ?
+ AND cdtSession.deleted = 0
+]]>
+</sql>
+
+<sql id="com.pentila.entSavoie.cdt.service.persistence.CDTSessionFinderImpl.findByStudentId_RangeDate">
+<![CDATA[
+ SELECT cdtSession.*
+ FROM cdt_cdtsession cdtSession
+ JOIN cdt_sessionstudent sessionStudent
+ ON cdtSession.sessionId = sessionStudent.sessionId
+ WHERE cdtSession.sessionStart BETWEEN DATE(?) AND DATE(?)
+ AND sessionStudent.studentId = ?
+ AND cdtSession.deleted = 0
+]]>
+</sql>
+
+<sql id="com.pentila.entSavoie.cdt.service.persistence.CDTSessionFinderImpl.findByTeacherId_RangeDate_manual">
+<![CDATA[
+ SELECT cdtSession.*
+ FROM cdt_cdtsession cdtSession
+ JOIN cdt_sessionteacher sessionTeacher
+ ON cdtSession.sessionId = sessionTeacher.sessionId
+ WHERE cdtSession.sessionStart BETWEEN DATE(?) AND DATE(?)
+ AND sessionTeacher.teacherId = ?
+ AND cdtSession.deleted = 0
+ AND cdtSession.isManual = ?
+]]>
+</sql>
+
+<sql id="com.pentila.entSavoie.cdt.service.persistence.CDTSessionFinderImpl.updateSessionVisaValueForSessionId">
+<![CDATA[
+ UPDATE cdt_cdtsession
+ SET visa = ?
+ WHERE %SESSION_DISJONCTION%
+]]>
+</sql>
+
+<sql id="com.pentila.entSavoie.cdt.service.persistence.CDTSessionFinderImpl.findByTeacherId_RangeDate_GroupId">
+<![CDATA[
+ SELECT s.*
+ FROM cdt_cdtsession s
+ JOIN cdt_sessionteacher st
+ ON s.sessionId = st.sessionId
+ WHERE %GROUP_DISJONCTION%
+ AND st.teacherId = ?
+ AND s.sessionStart BETWEEN ? AND ?
+]]>
+</sql>
+</custom-sql>
\ No newline at end of file