0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional and independent game developers

-- Enter Query Title
-- Enter Query Description
SELECT TOP 500
    [Id] [User Link],
    [Reputation],
    ROW_NUMBER() OVER (ORDER BY [Reputation] DESC, [CreationDate] ASC) [Rank]
FROM
    [Users]
WHERE
    [AboutMe] like '%twitter%'
  OR
    [WebsiteUrl] like '%twitter%'
ORDER BY
    [Reputation] DESC, [CreationDate] ASC

fork query

created feb 26 11 otac0n