USP_DATALIST_NEWSLETTER

            CREATE procedure dbo.USP_DATALIST_NEWSLETTER(@ClientsID int) with execute as caller
            as
            set nocount on;

            SELECT 
                ET.ID,
                EE.EmailListID, 
                ET.Name, 
                ET.Description
            --    ET.Guid, 

            --    ET.FromAddress, 

            --    ET.FromDisplayName, 

            --    ET.Subject, 

            --    ET.Priority, 

            --    ET.ReplyAddress, 

            --    ET.ReturnReceipt, 

            --    ET.ReturnReceiptAddress, 

            --    ET.ForwardDSN, 

            --    ET.ForwardDSNAddress

            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 = @ClientsID
            AND ET.type=2
            AND ET.deleted=0
            ORDER BY EL.Name