spGetClientRolesQueryBased

      CREATE PROCEDURE [dbo].[spGetClientRolesQueryBased] (
            @ClientsID  int,
            @SystemID  int
        )
        AS
    SELECT 
            [ID], 
            [Name], 
            [SystemRole], 
            [SiteAdminRole], 
            [EveryoneRole], 
            [OwnerID], 
            [Guid], 
            [Deleted], 
            [Cascading], 
            [ClientsID], 
            [REQueryID] BackOfficeQueryID, 
            [REQueryName] BackOfficeQueryName,
            [BBSystem] BackOfficeSystemID,
            [REConstituentsOnly], 
            [ImageID], 
            [RefreshedDate],
            dbo.fnGetClientRoleUserCount(ID) as 'MembershipCount'
        FROM ClientRoles
        where ClientsID = @ClientsID 
            and Deleted = 0 
            and REQueryID > 0
            and BBSystem=@SystemID
        ORDER BY Name