spGetEmailTemplateRightsAdorned

CREATE PROCEDURE [dbo].[spGetEmailTemplateRightsAdorned]
(
    @ClientUsersID int,
    @ClientsID int,
    @ObjectTypeFilter int,
    @ExcludeBackOfficeSystem nvarchar(max)
)
AS

    BEGIN
        SELECT 
            e.[ID],
            e.[ClientsID],
            e.[Name],
            e.[Description],
            e.[OwnerID],
            e.[Deleted],
            e.[Guid],
            e.[ContentHTML],
            e.[ContentText],
            e.[FromAddress],
            e.[FromDisplayName],
            e.[Subject],
            e.[Priority],
            e.[ReplyAddress],
            e.[ReturnReceipt],
            e.[ReturnReceiptAddress],
            e.[ForwardDSN],
            e.[ForwardDSNAddress],
            e.[Type],
            e.[IsInternalUse],
            e.[DataSourceID],
            SEC.canview, 
            SEC.canedit, 
            CAST(0 AS BIT) canadd, 
            SEC.candelete, 
            SEC.cansecure,
            ISNULL(PM.LOCKARTIFACTS, 0) as LOCKED
        FROM [dbo].EmailTemplate e inner join Datasources ds on e.Datasourceid = ds.datasourceid
        INNER JOIN [dbo].fnUserPrivs(@ClientUsersID,@ClientsID,@ObjectTypeFilter) SEC ON Guid=SEC.ObjectGuid
        LEFT OUTER JOIN [dbo].PAGEMODELITEM PMI on PMI.OBJECTGUID = e.Guid
        LEFT OUTER JOIN [dbo].PAGEMODEL PM on PMI.PAGEMODELID = PM.ID
        WHERE ClientsID=@ClientsID 
        AND NOT EXISTS (SELECT NULL FROM dbo.fnCSVIDsToTable(@ExcludeBackOfficeSystem) WHERE ID = ds.BackOfficeSystemID)
        AND e.deleted=0 
        AND SEC.canView=1
        ORDER BY e.[Name]
    END