0

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 about the site for professional and independent game developers

-- The Exhibitionists
-- Top 100 user profile view count. (The title is meant in a humorous way.)


DECLARE @myRep int = 0

SELECT TOP 1
    Id as [User Link],
    Views,
    Reputation,
    CreationDate
FROM Users
WHERE Id = 9449426

SELECT TOP 20
    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 21 NearHuscarl

created jul 24 10 Peter Mortensen