spGetNetAccountRelations

            CREATE PROCEDURE [dbo].[spGetNetAccountRelations]
            (
            @NetAccountID int
            )
            AS
            BEGIN

            SELECT 

            NetAccountRelation.ID,
            NetAccountID 'MyAccountID',
            RelationAccountID 'FriendAccountID',
            Confirmation,
            ConfirmationDate,
            NetAccountRelation.CreateDate,
            NetAccountRelation.UpdateDate

            FROM [NetAccountRelation] 
            INNER JOIN NetAccount on NetAccount.ID = RelationAccountID
            WHERE

            NetAccountID = @NetAccountID 
            AND 
            (BlockedID = 0 OR BlockedID IS NULL)
            AND
            Confirmation > 0
            AND
            NetAccount.Deleted = 0

            UNION

            SELECT 

            NetAccountRelation.ID,
            RelationAccountID 'MyAccountID',
            NetAccountID 'FriendAccountID',
            Confirmation,
            ConfirmationDate,
            NetAccountRelation.CreateDate,
            NetAccountRelation.UpdateDate

            FROM [NetAccountRelation] 
            INNER JOIN NetAccount on NetAccount.ID = NetAccountID
            WHERE

            RelationAccountID = @NetAccountID 
            AND 
            (BlockedID = 0 OR BlockedID IS NULL)
            AND
            Confirmation > 0
            AND
            NetAccount.Deleted = 0

            END