CREATE PROCEDURE dbo.[Forum_Moderate_PostGet] ( @ForumID INT )
AS
    SELECT  PostID,
            ParentPostID,
            UserID,
            RemoteAddr,
            [Subject],
            Body,
            P.CreatedDate,
            P.ThreadID,
            P.UpdatedDate,
            P.UpdatedByUser,
            IsApproved,
            IsLocked,
            IsClosed,
            DateApproved,
            PostReported,
            Addressed,
            ParseInfo
    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   P.IsApproved = 0
            AND T.ForumID = @ForumID
    ORDER BY P.CreatedDate ASC

GO