<commit_before><custom-sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameAsc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.screenName ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameAscFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_rolescategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.screenName ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameDesc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.screenName DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameDescFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_rolescategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.screenName DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByRoleNameAsc">
        <![CDATA[
			SELECT  u.*, r.*
FROM User_ u
    INNER JOIN
    (
        SELECT ur.userId, MAX(roleOrdinal) roleOrdinal
        FROM Users_Roles ur
	INNER JOIN xcolab_rolescategory r
ON ur.roleId = r.roleId
        GROUP BY ur.userId
    ) b ON u.userId = b.userId
INNER JOIN xcolab_rolescategory r
ON r.roleOrdinal = b.roleOrdinal
WHERE u.screenName like ? or u.firstName like ? or u.lastName like ?
ORDER BY r.categoryName ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByRoleNameDesc">
        <![CDATA[
			SELECT  u.*, r.*
FROM User_ u
    INNER JOIN
    (
        SELECT ur.userId, MAX(roleOrdinal) roleOrdinal
        FROM Users_Roles ur
	INNER JOIN xcolab_rolescategory r
ON ur.roleId = r.roleId
        GROUP BY ur.userId
    ) b ON u.userId = b.userId
INNER JOIN xcolab_rolescategory r
ON r.roleOrdinal = b.roleOrdinal
WHERE u.screenName like ? or u.firstName like ? or u.lastName like ?
ORDER BY r.categoryName DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceAsc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.createDate ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceAscFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_rolescategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.createDate ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceDesc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.createDate DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceDescFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_rolescategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.createDate DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountAsc">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY activityCount ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountAscFilteredByCategory">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_rolescategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY activityCount ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountDesc">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY activityCount DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountDescFilteredByCategory">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_rolescategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY activityCount DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUserActivityCount">
        <![CDATA[
			SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = ?
		]]>
    </sql>

</custom-sql><commit_msg>Changes in case for custom queries (cherry picked from commit 20618ac)<commit_after><custom-sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameAsc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.screenName ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameAscFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_RolesCategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.screenName ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameDesc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.screenName DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByScreenNameDescFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_RolesCategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.screenName DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByRoleNameAsc">
        <![CDATA[
			SELECT  u.*, r.*
FROM User_ u
    INNER JOIN
    (
        SELECT ur.userId, MAX(roleOrdinal) roleOrdinal
        FROM Users_Roles ur
	INNER JOIN xcolab_RolesCategory r
ON ur.roleId = r.roleId
        GROUP BY ur.userId
    ) b ON u.userId = b.userId
INNER JOIN xcolab_RolesCategory r
ON r.roleOrdinal = b.roleOrdinal
WHERE u.screenName like ? or u.firstName like ? or u.lastName like ?
ORDER BY r.categoryName ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByRoleNameDesc">
        <![CDATA[
			SELECT  u.*, r.*
FROM User_ u
    INNER JOIN
    (
        SELECT ur.userId, MAX(roleOrdinal) roleOrdinal
        FROM Users_Roles ur
	INNER JOIN xcolab_RolesCategory r
ON ur.roleId = r.roleId
        GROUP BY ur.userId
    ) b ON u.userId = b.userId
INNER JOIN xcolab_RolesCategory r
ON r.roleOrdinal = b.roleOrdinal
WHERE u.screenName like ? or u.firstName like ? or u.lastName like ?
ORDER BY r.categoryName DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceAsc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.createDate ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceAscFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_RolesCategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.createDate ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceDesc">
        <![CDATA[
			SELECT * FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY us.createDate DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByMemberSinceDescFilteredByCategory">
        <![CDATA[
			SELECT * FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_RolesCategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY us.createDate DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountAsc">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY activityCount ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountAscFilteredByCategory">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_RolesCategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY activityCount ASC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountDesc">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us WHERE us.screenName like ? or us.firstName like ? or us.lastName like ? ORDER BY activityCount DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUsersSortedByActivityCountDescFilteredByCategory">
        <![CDATA[
			SELECT *, us.userId as uId, (SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = uId) as activityCount FROM User_ as us INNER JOIN Users_Roles as ur ON us.userId = ur.userId INNER JOIN xcolab_RolesCategory as ro ON ur.roleId = ro.roleId WHERE (us.screenName like ? or us.firstName like ? or us.lastName like ?) AND ro.categoryName = ? ORDER BY activityCount DESC
		]]>
    </sql>

    <sql id="com.ext.portlet.service.persistence.User_Finder.getUserActivityCount">
        <![CDATA[
			SELECT COUNT(*) FROM SocialActivity WHERE SocialActivity.userId = ?
		]]>
    </sql>

</custom-sql>
{'fraction_non_alphanumeric': 0.09973619266445409, 'fraction_numerical': 0.00042549570249340483, 'mean_word_length': 3.5996086105675147, 'pattern_counts': {'":': 0, '<': 97, '<?xml version=': 0, '>': 97, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6748988', 'n_tokens_mistral': 3997, 'n_tokens_neox': 3811, 'n_words': 1085}