4 <sql id="com.liferay.portal.service.persistence.UserFinder.joinByUserEnseignement">
8 (Matiere_User.userId = User_.userId)
10 (Matiere_User.matiereId = ?)
13 <sql id="com.liferay.contacts.service.persistence.CardFinder.findByG_EA_FN">
21 (User_.userId = Contacts_Card.associatedUserId)
25 (Contacts_Card.groupId = ?) AND
27 (lower(Contacts_Card.emailAddress) LIKE ? OR ? IS NULL) OR
28 (lower(Contacts_Card.fullName) LIKE ? OR ? IS NULL)
32 <sql id="com.liferay.contacts.service.persistence.CardFinder.findByG_FN">
35 DISTINCT {Contacts_Card.*}
40 (User_.userId = Contacts_Card.associatedUserId)
44 (Contacts_Card.groupId = ?) AND
45 (lower(Contacts_Card.fullName) LIKE ? OR ? IS NULL)
48 <sql id="com.liferay.contacts.service.persistence.CardFinder.findByG_FN_FR">
51 DISTINCT {Contacts_Card.*}
55 (Contacts_Card.groupId = ?) AND
56 (Contacts_Card.associatedUserId = 0) AND
57 (lower(Contacts_Card.fullName) LIKE ? OR ? IS NULL)
60 <sql id="com.liferay.contacts.service.persistence.CardFinder.joinByGroupId">
64 (Users_Groups.userId = Contacts_Card.associatedUserId)
67 (Group_.groupId = Users_Groups.groupId)
72 <sql id="com.liferay.contacts.service.persistence.CardFinder.joinByUserActive">