USP_DATALIST_FAFEVENTMARKETINGDEFAULTTEMPLATE

CREATE procedure dbo.USP_DATALIST_FAFEVENTMARKETINGDEFAULTTEMPLATE(@EVENTID uniqueidentifier)
as
    set nocount on;

    SELECT 
    ET.ID
  FROM 
    dbo.EmailTemplate ET (NOLOCK)
  INNER JOIN dbo.EVENTEMAILTEMPLATE EET (NOLOCK)
    ON ET.ID = EET.EMAILTEMPLATEID
    AND EET.CONFIRMATIONTYPECODE = 33
  WHERE EET.EVENTID = @EVENTID