spGetEmailTemplatesForDataSourceRightsAdorned

CREATE procedure [dbo].[spGetEmailTemplatesForDataSourceRightsAdorned]
(
    @ClientUsersID int,
    @clientsID int,
    @ObjectTypeFilter int,
    @dataSourceID int,
    @IncludedDeleted bit
)

as 
select 
    [et].[id], 
    [et].[name],
    [et].[type],
    [et].DataSourceID,
    SEC.canview, 
    SEC.canedit, 
    CAST(0 AS BIT) canadd, 
    SEC.candelete, 
    SEC.cansecure,
    ISNULL(PM.LOCKARTIFACTS, 0) as LOCKED
from emailtemplate et
INNER JOIN [dbo].fnUserPrivs(@ClientUsersID,@ClientsID,@ObjectTypeFilter) SEC ON et.Guid=SEC.ObjectGuid
LEFT OUTER JOIN [dbo].PAGEMODELITEM PMI on PMI.OBJECTGUID = et.Guid
LEFT OUTER JOIN [dbo].PAGEMODEL PM on PMI.PAGEMODELID = PM.ID
WHERE ClientsID=@ClientsID
AND et.deleted in (0, @IncludedDeleted)
AND SEC.canView=1
and (et.datasourceid=@dataSourceID or et.dataSourceID=302)

order by [et].[name]