DECLARE @Topper INT = @Top
   
   SELECT TOP (@Topper) yaf_User.UserID, yaf_User.Name, COUNT(ThanksToUserID) as Total
   FROM yaf_Thanks 
   INNER JOIN yaf_User 
   ON yaf_Thanks.ThanksToUserID = yaf_User.UserID 
   INNER JOIN yaf_Message
   ON yaf_Message.MessageID = yaf_Thanks.MessageID
   INNER JOIN yaf_Topic
   ON yaf_Topic.TopicID = yaf_Message.TopicID
   WHERE yaf_Thanks.ThanksDate > DATEADD(DAY, -7, GETDATE()) 
   GROUP BY yaf_Thanks.ThanksToUserID, yaf_User.Name, yaf_user.UserID
   ORDER BY COUNT(ThanksToUserID) DESC