USP_SIMPLEDATALIST_ENEWSLETTER

CREATE procedure dbo.USP_SIMPLEDATALIST_ENEWSLETTER(
    @EVENTID uniqueidentifier
)
as
            SELECT 
                --EE.EmailListID as VALUE, 

        EL.Guid as VALUE,
                EL.Name as LABEL
            FROM dbo.EmailTemplate ET
            INNER JOIN dbo.EmailTemplate_EmailList EE
            ON ET.ID = EE.EmailTemplateID
            INNER JOIN dbo.EmailList EL
            ON EL.ID = EE.EmailListID
            WHERE ET.ClientsID = (SELECT ClientsID FROM ClientSites s 
        INNER JOIN dbo.eventextension ex on ex.clientsitesID = s.id WHERE ex.EVENTID = @EVENTID)
            AND ET.type=2
            AND ET.deleted=0
            ORDER BY EL.Name