CREATE PROCEDURE dbo.[Forum_ISearchable]
    (
      @ModuleID INT,
      @StartDate DATETIME
    )
AS
    SELECT  P.[ThreadID],
            P.[PostID],
            P.[Subject],
            P.[Body],
            P.[CreatedDate],
            P.[UserID] AS CreatedByUser,
            P.[UpdatedDate],
            P.[UpdatedByUser],
            T.[ForumID],
            P.[DateApproved],
            F.PublicView
    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   G.ModuleID = @ModuleID
            AND P.IsApproved = 1
            AND P.IsLocked = 0
            AND F.PublicView = 1
            AND ( P.[CreatedDate] >= @StartDate
                  OR @StartDate IS NULL
                )

GO