gistfile1.txt

	<sql id="com.liferay.portal.service.persistence.RoleFinder.findByC_R_C_A">
		<![CDATA[
			SELECT
				{Role_.*}
			FROM
				ResourceBlockPermission
			INNER JOIN
				ResourceBlock ON
					(ResourceBlock.resourceBlockId = ResourceBlockPermission.ResourceBlockId)
			INNER JOIN
				Role_ ON
					(Role_.roleId = ResourceBlockPermission.roleId)
			INNER JOIN
				ResourceAction ON
					(ResourceAction.name = ResourceBlock.name)
			WHERE
				(ResourceBlock.companyId = ?) AND
				(ResourceBlock.name = ?) AND
				(ResourceBlock.resourceBlockId = ?) AND
				(ResourceAction.actionId = ?) AND
				(MOD(INTEGER_DIV(ResourceBlockPermission.actionIds, ResourceAction.bitwisevalue), 2) = 1)
			ORDER BY Role_.name ASC
		]]>
	</sql>