CREATE PROCEDURE dbo.[Forum_UserTracking_GetForum] ( @ForumID INT )
AS
    SELECT  TF.ForumID,
            F.NAME,
            U.UserID,
            U.Email,
            TF.CreatedDate,
            U.Username
    FROM    dbo.Forum_TrackedForums TF
            INNER JOIN dbo.Users U ON TF.UserID = U.UserID
            INNER JOIN dbo.Forum_Forums F ON TF.ForumID = F.ForumID
    WHERE   TF.ForumID = @ForumID
    ORDER BY U.Email

GO