--- /dev/null
+<?xml version="1.0"?>
+<custom-sql>
+ <sql id="getFicheInUserListsFromUserGroup">
+ <![CDATA[
+ select f.* from carnetadresses_liste l, carnetadresses_fiche_liste fl, carnetadresses_fiche f
+ where l.groupId = ?
+ and l.listeId = fl.listeId
+ and fl.ficheId = f.ficheId
+ ]]>
+ </sql>
+ <sql id="getUserIdForUserWithSeveralFiche">
+ <![CDATA[
+ select f.relUserId from carnetadresses_fiche f
+ where f.relUserId != 0
+ group by f.relUserId
+ having count(f.relUserId) > 1
+ ]]>
+ </sql>
+ <sql id="deleteFicheListDuplicateEntry">
+ <![CDATA[
+ delete from carnetadresses_fiche_liste
+ where ficheId = ?
+ and listeId in
+ (select * from (select fl.listeId
+ from carnetadresses_fiche_liste fl
+ where %FICHES_TO_DELETE% ) as tmp)
+ ]]>
+ </sql>
+ <sql id="selectDistinctListeIdFromFiche">
+ <![CDATA[
+ select distinct listeId
+ from carnetadresses_fiche_liste
+ where %FICHES_TO_SELECT%
+ ]]>
+ </sql>
+ <sql id="removeFicheListFromFicheIds">
+ <![CDATA[
+ delete from carnetadresses_fiche_liste
+ where %FICHES_TO_DELETE%
+ ]]>
+ </sql>
+ <sql id="removeFicheFromFicheIds">
+ <![CDATA[
+ delete from carnetadresses_fiche
+ where %FICHES_TO_DELETE%
+ ]]>
+ </sql>
+ <sql id="insertFicheList">
+ <![CDATA[
+ Insert into carnetadresses_fiche_liste (ficheId,listeId)
+ values %FICHES_LIST_TO_INSERT%
+ ]]>
+ </sql>
+</custom-sql>
\ No newline at end of file