CREATE PROCEDURE dbo.[Forum_User_Get]
    (
      @UserID INT,
      @PortalID INT
    )
AS
    SELECT  U.UserID,
            [Signature],
            UserAvatar,
            Avatar,
            AdditionalAvatars,
            PostCount,
            LastActivity,
            IsTrusted,
            EnableOnlineStatus,
            ThreadsPerPage,
            PostsPerPage,
            ViewDescending,
            EnableModNotification,
            EmailFormat,
            PortalID,
            EnablePublicEmail,
            TrackingDuration,
            LockTrust,
            IsBanned,
            LiftBanDate,
            EnableSelfNotifications,
            EnableProfileWeb,
            EnableDefaultPostNotify,
            StartBanDate,
            DisplayName,
            Username,
            Email,
            IsSuperUser
    FROM    dbo.Forum_Users FU
            INNER JOIN dbo.Users U ON FU.UserID = U.UserID
    WHERE   U.[UserId] = @UserID
            AND [PortalID] = @PortalID

GO