CREATE PROCEDURE dbo.[Forum_UserTracking_GetThread] ( @ThreadID INT )
AS
    SELECT  TT.ThreadID,
            P.[Subject],
            U.UserID,
            U.Email,
            TT.CreatedDate,
            U.Username
    FROM    dbo.Forum_TrackedThreads TT
            INNER JOIN dbo.Users U ON TT.UserID = U.UserID
            INNER JOIN dbo.Forum_Posts P ON TT.ThreadID = P.PostID
    WHERE   TT.ThreadID = @ThreadID
    ORDER BY U.Email

GO