spLoadRecord_Condition

            CREATE PROCEDURE [dbo].[spLoadRecord_Condition]
            (
                @PKID int
            )
            AS
            BEGIN

                SELECT c.[ID], cbc.[ConditionBlockID], cbc.[Priority], c.[HTML]
                    FROM [dbo].[Condition] c
                INNER JOIN [dbo].[ConditionBlockCondition] cbc
                    ON c.[ID] = cbc.[ConditionID]
                WHERE c.[ID] = @PKID

                SELECT el.[ID], el.[Name]
                    FROM [dbo].[Condition] c
                INNER JOIN [dbo].[ConditionList] cl
                    ON c.[ID] = cl.[ConditionBlockConditionID]
                INNER JOIN [dbo].[EmailList] el
                    ON cl.[EmailListID] = el.[ID]
                WHERE c.[ID] = @PKID

            END