--- /dev/null
+<?xml version="1.0"?>
+<custom-sql>
+ <sql id="GetAllDuplicateRessources">
+ <![CDATA[
+ select agenda_ressource.*
+ from agenda_ressource INNER JOIN
+ (SELECT idCreator
+ FROM agenda_ressource
+ where kind = 0
+ GROUP BY idCreator
+ HAVING ( COUNT(idCreator) > 1 ) ) AS duplicates
+ ON agenda_ressource.idCreator = duplicates.idCreator
+ where kind = 0;
+ ]]>
+ </sql>
+<sql file="custom-sql/event_agenda.xml"/>
+</custom-sql>
\ No newline at end of file