Mexico Users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS 'Rep Rank', 
Id AS [User Link], Reputation, Location, 
Views, UpVotes, DownVotes, Age
FROM Users
WHERE (UPPER(Location) LIKE '%MEXICO%' 
OR UPPER(Location) LIKE '%MX%')
AND UPPER(Location) NOT LIKE '%NEW MEXICO%'
ORDER BY Reputation DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results