CREATE VIEW dbo.[Forum_vw_PostSearch]
AS
    SELECT TOP ( 100 ) PERCENT
           P.PostID,
           P.ParentPostID,
           P.UserID,
           P.RemoteAddr,
           P.[Subject],
           P.Body,
           P.CreatedDate,
           P.ThreadID,
           P.UpdatedDate,
           P.UpdatedByUser,
           P.IsApproved,
           P.IsLocked,
           P.IsClosed,
           P.DateApproved,
           P.PostReported,
           T.ForumID,
           T.[Views],
           T.LastPostedPostID,
           T.Replies,
           T.IsPinned,
           T.PinnedDate,
           T.ThreadStatus,
           T.AnswerPostID,
           T.AnswerUserID,
           T.PollID,
           F.IsActive,
           F.ParentID,
           F.Name,
           F.[Description],
           F.IsModerated,
           F.MostRecentPostID,
           F.ForumType,
           F.PublicView,
           F.PublicPosting,
           F.ForumLink,
           G.PortalID,
           G.ModuleID,
           PP.UserID AS StartedByUserID,
           F.EnableForumsThreadStatus,
           T.ContentItemID,
           CI.ContentTypeID,
           CI.TabID,
           CI.ContentKey,
           CI.Indexed
    FROM    dbo.Forum_Posts AS P
           INNER JOIN dbo.Forum_Threads AS T ON P.ThreadID = T.ThreadID
           INNER JOIN dbo.Forum_Forums AS F ON T.ForumID = F.ForumID
           INNER JOIN dbo.Forum_Groups AS G ON F.GroupID = G.GroupID
           INNER JOIN dbo.Forum_Posts AS PP ON T.ThreadID = PP.PostID
           LEFT OUTER JOIN dbo.ContentItems AS CI ON T.ContentItemID = CI.ContentItemID
    ORDER BY P.CreatedDate DESC

GO