spLoadRecord_ConditionBlockCondition

            CREATE PROCEDURE [dbo].[spLoadRecord_ConditionBlockCondition]
            (
                @ConditionBlockID int,
                @ConditionID int
            )
            AS
            BEGIN
                SELECT cbc.ID as ConditionBlockConditionID, cbc.Priority, c.HTML, c.ID as ConditionID
                FROM ConditionBlockCondition cbc
                JOIN Condition c
                ON c.ID = cbc.ConditionID
                WHERE cbc.ConditionBlockID = @ConditionBlockID
                AND cbc.ConditionID = @ConditionID

                SELECT cl.EmailListID, el.Name
                FROM ConditionBlockCondition cbc
                JOIN Condition c
                ON c.ID = cbc.ConditionID
                JOIN ConditionList cl
                ON cl.ConditionBlockConditionID = cbc.ID
                JOIN EmailList el
                on el.ID = cl.EmailListID
                WHERE cbc.ConditionBlockID = @ConditionBlockID
                AND cbc.ConditionID = @ConditionID

            END