USP_FAFEventEmailTemplate_DATALIST

CREATE procedure dbo.USP_FAFEventEmailTemplate_DATALIST
    @EVENTID uniqueidentifier = null,
  @CONFIRMATIONTYPECODE int = 0
as
    set nocount on;
select EET.ID, EET.EMAILTEMPLATEID,EET.EVENTID, EET.CONFIRMATIONTYPECODE, EET.NCNOTIFICATIONID, EET.ISACTIVE, C.NAME, EA.EMAILADDRESS, EE.CLIENTSITESID
from EVENTEMAILTEMPLATE EET (NOLOCK)
join dbo.EVENT (nolock) E on EET.EVENTID = E.ID 
left join dbo.CONSTITUENT C (nolock) on C.ID = E.EVENTLOCATIONCONTACTID
left join dbo.EMAILADDRESS EA (nolock) on EA.CONSTITUENTID = C.ID and EA.ISPRIMARY = 1
left join dbo.EVENTEXTENSION EE (nolock) on EE.EVENTID=E.ID
where EET.EVENTID = @EVENTID and EET.CONFIRMATIONTYPECODE = @CONFIRMATIONTYPECODE