--- /dev/null
+<?xml version="1.0"?>\r
+\r
+<custom-sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.countByOrganizationIds">\r
+ <![CDATA[\r
+ SELECT\r
+ COUNT(*) AS COUNT_VALUE\r
+ FROM\r
+ BlogsEntry\r
+ INNER JOIN\r
+ User_ ON\r
+ (User_.userId = BlogsEntry.userId)\r
+ INNER JOIN\r
+ Users_Orgs ON\r
+ (Users_Orgs.userId = User_.userId)\r
+ WHERE\r
+ [$ORGANIZATION_ID$] AND\r
+ (BlogsEntry.displayDate < ?)\r
+ ]]>\r
+ </sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findByGroupIds">\r
+ <![CDATA[\r
+ SELECT\r
+ {BlogsEntry.*}\r
+ FROM\r
+ BlogsEntry\r
+ INNER JOIN\r
+ Group_ ON\r
+ (Group_.groupId = BlogsEntry.groupId)\r
+ WHERE\r
+ (Group_.companyId = ?) AND\r
+ (\r
+ (Group_.groupId = ?) OR\r
+ (\r
+ (Group_.liveGroupId = 0) AND\r
+ (\r
+ Group_.groupId NOT IN (\r
+ SELECT\r
+ liveGroupId\r
+ FROM\r
+ Group_\r
+ WHERE\r
+ groupId = ?\r
+ )\r
+ ) AND\r
+ (\r
+ (Group_.classNameId != [$CLASS_NAME_ID_COM.LIFERAY.PORTAL.MODEL.LAYOUT$]) OR\r
+ (\r
+ Group_.parentGroupId NOT IN (\r
+ SELECT\r
+ groupId\r
+ FROM\r
+ Group_\r
+ WHERE\r
+ (groupId != ?) AND\r
+ (liveGroupId != 0)\r
+ )\r
+ )\r
+ )\r
+ )\r
+ ) AND\r
+ (BlogsEntry.displayDate < ?)\r
+ ORDER BY\r
+ BlogsEntry.displayDate DESC\r
+ ]]>\r
+ </sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findHeadersByGroupIds">\r
+ <![CDATA[\r
+ SELECT be.entryId, be.groupId, be.userId, be.displayDate\r
+ FROM BlogsEntry be\r
+ WHERE be.groupId IN ([$GROUP_IDS$])\r
+ ]]>\r
+ </sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findByOrganizationIds">\r
+ <![CDATA[\r
+ SELECT\r
+ {BlogsEntry.*}\r
+ FROM\r
+ BlogsEntry\r
+ INNER JOIN\r
+ User_ ON\r
+ (User_.userId = BlogsEntry.userId)\r
+ INNER JOIN\r
+ Users_Orgs ON\r
+ (Users_Orgs.userId = User_.userId)\r
+ WHERE\r
+ [$ORGANIZATION_ID$] AND\r
+ (BlogsEntry.displayDate < ?)\r
+ ORDER BY\r
+ BlogsEntry.displayDate DESC\r
+ ]]>\r
+ </sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsEntryFinder.findByNoAssets">\r
+ <![CDATA[\r
+ SELECT\r
+ {BlogsEntry.*}\r
+ FROM\r
+ BlogsEntry\r
+ WHERE\r
+ (entryId NOT IN (\r
+ SELECT\r
+ classPK\r
+ FROM\r
+ AssetEntry\r
+ WHERE\r
+ classNameId = [$CLASS_NAME_ID_COM.LIFERAY.PORTLET.BLOGS.MODEL.BLOGSENTRY$]\r
+ ))\r
+ ]]>\r
+ </sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsStatsUserFinder.countByOrganizationIds">\r
+ <![CDATA[\r
+ SELECT\r
+ COUNT(*) AS COUNT_VALUE\r
+ FROM\r
+ BlogsStatsUser\r
+ INNER JOIN\r
+ User_ ON\r
+ (User_.userId = BlogsStatsUser.userId)\r
+ INNER JOIN\r
+ Users_Orgs ON\r
+ (Users_Orgs.userId = User_.userId)\r
+ WHERE\r
+ (BlogsStatsUser.entryCount != 0) AND\r
+ [$ORGANIZATION_ID$]\r
+ ]]>\r
+ </sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsStatsUserFinder.findByGroupIds">\r
+ <![CDATA[\r
+ SELECT\r
+ TEMP_TABLE.userId, TEMP_TABLE.lastPostDate\r
+ FROM\r
+ (\r
+ SELECT\r
+ BlogsStatsUser.userId AS userId, MAX(BlogsStatsUser.lastPostDate) AS lastPostDate\r
+ FROM\r
+ BlogsStatsUser\r
+ INNER JOIN\r
+ Group_ ON\r
+ (Group_.groupId = BlogsStatsUser.groupId)\r
+ WHERE\r
+ (\r
+ (Group_.companyId = ?) AND\r
+ (\r
+ (Group_.groupId = ?) OR\r
+ (\r
+ (Group_.liveGroupId = 0) AND\r
+ (\r
+ Group_.groupId NOT IN (\r
+ SELECT\r
+ liveGroupId\r
+ FROM\r
+ Group_\r
+ WHERE\r
+ groupId = ?\r
+ )\r
+ ) AND\r
+ (\r
+ (Group_.classNameId != [$CLASS_NAME_ID_COM.LIFERAY.PORTAL.MODEL.LAYOUT$]) OR\r
+ (\r
+ Group_.parentGroupId NOT IN (\r
+ SELECT\r
+ groupId\r
+ FROM\r
+ Group_\r
+ WHERE\r
+ (groupId != ?) AND\r
+ (liveGroupId != 0)\r
+ )\r
+ )\r
+ )\r
+ )\r
+ )\r
+ )\r
+ GROUP BY\r
+ userId\r
+ ) TEMP_TABLE\r
+ ORDER BY\r
+ lastPostDate DESC\r
+ ]]>\r
+ </sql>\r
+ <sql id="com.liferay.portlet.blogs.service.persistence.BlogsStatsUserFinder.findByOrganizationIds">\r
+ <![CDATA[\r
+ SELECT\r
+ {BlogsStatsUser.*}\r
+ FROM\r
+ BlogsStatsUser\r
+ INNER JOIN\r
+ User_ ON\r
+ (User_.userId = BlogsStatsUser.userId)\r
+ INNER JOIN\r
+ Users_Orgs ON\r
+ (Users_Orgs.userId = User_.userId)\r
+ WHERE\r
+ (BlogsStatsUser.entryCount != 0) AND\r
+ [$ORGANIZATION_ID$]\r
+ ]]>\r
+ </sql>\r
+</custom-sql>
\ No newline at end of file