1 <?xml version="1.0"?>
\r
4 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.countByOrganizationIds">
\r
7 COUNT(*) AS COUNT_VALUE
\r
12 (User_.userId = BlogsEntry.userId)
\r
15 (Users_Orgs.userId = User_.userId)
\r
17 [$ORGANIZATION_ID$] AND
\r
18 (BlogsEntry.displayDate < ?)
\r
21 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findByGroupIds">
\r
29 (Group_.groupId = BlogsEntry.groupId)
\r
31 (Group_.companyId = ?) AND
\r
33 (Group_.groupId = ?) OR
\r
35 (Group_.liveGroupId = 0) AND
\r
37 Group_.groupId NOT IN (
\r
47 (Group_.classNameId != [$CLASS_NAME_ID_COM.LIFERAY.PORTAL.MODEL.LAYOUT$]) OR
\r
49 Group_.parentGroupId NOT IN (
\r
62 (BlogsEntry.displayDate < ?)
\r
64 BlogsEntry.displayDate DESC
\r
67 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findHeadersByGroupIds">
\r
69 SELECT be.entryId, be.groupId, be.userId, be.displayDate
\r
71 WHERE be.groupId IN ([$GROUP_IDS$])
\r
74 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findByOrganizationIds">
\r
82 (User_.userId = BlogsEntry.userId)
\r
85 (Users_Orgs.userId = User_.userId)
\r
87 [$ORGANIZATION_ID$] AND
\r
88 (BlogsEntry.displayDate < ?)
\r
90 BlogsEntry.displayDate DESC
\r
93 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findByNoAssets">
\r
106 classNameId = [$CLASS_NAME_ID_COM.LIFERAY.PORTLET.BLOGS.MODEL.BLOGSENTRY$]
\r
110 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsStatsUserFinder.countByOrganizationIds">
\r
113 COUNT(*) AS COUNT_VALUE
\r
118 (User_.userId = BlogsStatsUser.userId)
\r
121 (Users_Orgs.userId = User_.userId)
\r
123 (BlogsStatsUser.entryCount != 0) AND
\r
124 [$ORGANIZATION_ID$]
\r
127 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsStatsUserFinder.findByGroupIds">
\r
130 TEMP_TABLE.userId, TEMP_TABLE.lastPostDate
\r
134 BlogsStatsUser.userId AS userId, MAX(BlogsStatsUser.lastPostDate) AS lastPostDate
\r
139 (Group_.groupId = BlogsStatsUser.groupId)
\r
142 (Group_.companyId = ?) AND
\r
144 (Group_.groupId = ?) OR
\r
146 (Group_.liveGroupId = 0) AND
\r
148 Group_.groupId NOT IN (
\r
158 (Group_.classNameId != [$CLASS_NAME_ID_COM.LIFERAY.PORTAL.MODEL.LAYOUT$]) OR
\r
160 Group_.parentGroupId NOT IN (
\r
181 <sql id="com.liferay.portlet.blogs.service.persistence.BlogsStatsUserFinder.findByOrganizationIds">
\r
189 (User_.userId = BlogsStatsUser.userId)
\r
192 (Users_Orgs.userId = User_.userId)
\r
194 (BlogsStatsUser.entryCount != 0) AND
\r
195 [$ORGANIZATION_ID$]
\r