spGetEmailConditionBlockConditionMergeHTML

            CREATE PROCEDURE [dbo].[spGetEmailConditionBlockConditionMergeHTML]
            (
                @EmailID int
            )
            AS
            BEGIN
                    SELECT cbc.ID, cbc.ConditionBlockID, cbc.Priority, cbcmh.MergeFieldHTML as HTML
                    FROM ConditionBlockConditionMergeHTML cbcmh
                    JOIN ConditionBlockCondition cbc
                    ON cbc.ID = cbcmh.ConditionBlockConditionID
                    JOIN EmailConditionBlock ecb
                    on ecb.ConditionBlockID = cbc.ConditionBlockID
                    WHERE ecb.EmailID = @EmailID
            END