ITA Rank by Badge

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

DECLARE @queryLimit int = ##limit?500##
DECLARE @badgeName nvarchar  = '##badgeName?node.js##'

SELECT TOP(@queryLimit)
       ROW_NUMBER() OVER (ORDER BY u.Reputation desc, u.LastAccessDate desc) AS Rank,
       u.Id AS [User Link],
       u.Reputation, u.Location, u.LastAccessDate
FROM Badges b INNER JOIN Users u ON b.UserId = u.Id
WHERE 
    (UPPER(u.Location) LIKE 'ITA%' 
     OR UPPER(u.Location) LIKE '% ITA%'
    )

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results