Top 100 popular users near my reputation range. (The title is meant in a humorous way.)
Q&A for spacecraft operators, scientists, engineers, and enthusiasts
-- The Exhibitionists -- Top 100 user profile view count. (The title is meant in a humorous way.) DECLARE @myRep int SELECT TOP 1 @myRep = Reputation FROM Users WHERE Id = 9449426 SELECT TOP 100 Id as [User Link], Views, CreationDate, Reputation FROM Users WHERE Views > 1000 AND Reputation > @myRep AND Reputation < @myRep + 5000 ORDER BY Views DESC