--- /dev/null
+<?xml version="1.0"?>
+
+<custom-sql>
+ <sql id="com.liferay.portal.service.persistence.UserFinder.joinByUserEnseignement">
+ <![CDATA[
+ INNER JOIN
+ Matiere_User ON
+ (Matiere_User.userId = User_.userId)
+ WHERE
+ (Matiere_User.matiereId = ?)
+ ]]>
+ </sql>
+ <sql id="com.liferay.contacts.service.persistence.CardFinder.findByG_EA_FN">
+ <![CDATA[
+ SELECT
+ {Contacts_Card.*}
+ FROM
+ Contacts_Card
+ LEFT JOIN
+ User_ ON
+ (User_.userId = Contacts_Card.associatedUserId)
+ [$JOIN$]
+ WHERE
+ [$WHERE$]
+ (Contacts_Card.groupId = ?) AND
+ (
+ (lower(Contacts_Card.emailAddress) LIKE ? OR ? IS NULL) OR
+ (lower(Contacts_Card.fullName) LIKE ? OR ? IS NULL)
+ )
+ ]]>
+ </sql>
+ <sql id="com.liferay.contacts.service.persistence.CardFinder.findByG_FN">
+ <![CDATA[
+ SELECT
+ DISTINCT {Contacts_Card.*}
+ FROM
+ Contacts_Card
+ LEFT JOIN
+ User_ ON
+ (User_.userId = Contacts_Card.associatedUserId)
+ [$JOIN$]
+ WHERE
+ [$WHERE$]
+ (Contacts_Card.groupId = ?) AND
+ (lower(Contacts_Card.fullName) LIKE ? OR ? IS NULL)
+ ]]>
+ </sql>
+ <sql id="com.liferay.contacts.service.persistence.CardFinder.findByG_FN_FR">
+ <![CDATA[
+ SELECT
+ DISTINCT {Contacts_Card.*}
+ FROM
+ Contacts_Card
+ WHERE
+ (Contacts_Card.groupId = ?) AND
+ (Contacts_Card.associatedUserId = 0) AND
+ (lower(Contacts_Card.fullName) LIKE ? OR ? IS NULL)
+ ]]>
+ </sql>
+ <sql id="com.liferay.contacts.service.persistence.CardFinder.joinByGroupId">
+ <![CDATA[
+ LEFT JOIN
+ Users_Groups ON
+ (Users_Groups.userId = Contacts_Card.associatedUserId)
+ LEFT JOIN
+ Group_ ON
+ (Group_.groupId = Users_Groups.groupId)
+ WHERE
+ (Group_.groupId = ?)
+ ]]>
+ </sql>
+ <sql id="com.liferay.contacts.service.persistence.CardFinder.joinByUserActive">
+ WHERE
+ (User_.active_ = ?)
+ </sql>
+
+</custom-sql>
\ No newline at end of file