CREATE PROCEDURE dbo.[Forum_Post_Get]
    @PostID INT,
    @PortalID INT
AS
    SELECT  PostID,
            ParentPostID,
            UserID,
            RemoteAddr,
            [Subject],
            Body,
            P.CreatedDate,
            P.ThreadID,
            P.UpdatedDate,
            P.UpdatedByUser,
            IsApproved,
            IsLocked,
            IsClosed,
            DateApproved,
            PostReported,
            Addressed,
            ParseInfo,
            ( SELECT    COUNT(PostID)
              FROM      dbo.Forum_Posts
              WHERE     ThreadID = P.ThreadID
                        AND PostID < @PostID
                    AND IsApproved = 1
            ) AS PostsBefore,
            ( SELECT    COUNT(PostID)
              FROM      dbo.Forum_Posts
              WHERE     ThreadID = P.ThreadID
                        AND PostID > @PostID
                    AND IsApproved = 1
            ) AS PostsAfter,
            1 AS TotalRecords
    FROM    dbo.Forum_Posts P
            INNER JOIN dbo.Forum_Threads T ON P.ThreadID = T.ThreadID
            INNER JOIN dbo.Forum_Forums F ON T.ForumID = F.ForumID
            INNER JOIN dbo.Forum_Groups G ON F.GroupID = G.GroupID
    WHERE   PostID = @PostID
            AND PortalID = @PortalID

GO