spGetNetAccount_NetGroupRelations

        CREATE PROCEDURE dbo.spGetNetAccount_NetGroupRelations
        (
        @NetAccountID int
        )
        AS
        BEGIN

        SELECT 

        ngr.ID, 
        ngr.NetGroupID,
        ngr.Confirmation,
        ngr.ConfirmationDate,
        ngr.CreateDate,
        ngr.UpdateDate

        FROM [NetGroupRelation] ngr 
        INNER JOIN [NetGroup] ng on ng.ID = ngr.NetGroupID
        WHERE 
        ngr.NetAccountID = @NetAccountID AND 
        (ngr.BlockedID  IS NULL OR ngr.BlockedID < 1) AND
        ng.Deleted = 0

        END