1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited sep 24 NearHuscarl

created jul 24 10 Peter Mortensen