--- /dev/null
+<?xml version="1.0"?>
+<custom-sql>
+<sql id="com.pentila.entSavoie.userProperties.service.persistence.UserPropertiesFinderImpl.findRoleEtab">
+<![CDATA[
+ SELECT DISTINCT (roleId)
+ FROM userProperties_UserProperties
+ INNER JOIN Users_Roles ON ( Users_Roles.userId = UserProperties.userId )
+ WHERE etabId = ?
+]]>
+</sql>
+<sql id="com.pentila.entSavoie.userProperties.service.persistence.UserPropertiesFinderImpl.countUsersRoleEtab">
+<![CDATA[
+ SELECT COUNT(*)
+ FROM userProperties_UserProperties
+ INNER JOIN Users_Roles ON ( UserProperties.userId = Users_Roles.userId )
+ INNER JOIN User_ ON ( UserProperties.userId = User_.userId )
+ WHERE User_.active_ = 1
+ AND UserProperties.etabId = ?
+ AND Users_Roles.roleId = ?
+]]>
+</sql>
+<sql id="com.pentila.entSavoie.userProperties.service.persistence.UserPropertiesFinderImpl.searchUserByNameAndOrg">
+<![CDATA[
+ SELECT u.*
+ FROM user_ u
+ [$JOIN$]
+ WHERE
+ [$WHERE$]
+]]>
+</sql>
+<sql id="com.pentila.entSavoie.userProperties.service.persistence.UserPropertiesFinderImpl.countUserByNameAndOrg">
+<![CDATA[
+ SELECT COUNT(*)
+ FROM user_ u
+ [$JOIN$]
+ WHERE
+ [$WHERE$]
+]]>
+</sql>
+</custom-sql>
\ No newline at end of file