100k users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS Position
  ,DisplayName
  ,Reputation
  ,WebsiteUrl
  ,AboutMe
  ,'http://stackoverflow.com/users/' + CONVERT(VARCHAR(10), Id) AS ProfileUrl
FROM Users(NOLOCK)
WHERE UPPER(Location) like N'%TURKEY%'
  OR Location like N'%, TR'
  OR Location like N'%,TR'
  OR Location like N'%/ TR'
  OR Location like N'%/TR'
  OR UPPER(Location) like N'%TÜRKIYE%'
  OR Location like N'%TÜRKİYE%'
  OR UPPER(Location) like N'%ANKARA%'
  OR UPPER(Location) like N'%IZMIR%'
  OR Location like N'%İZMİR%'
  OR UPPER(Location) like N'%ISTANBUL%'
  OR Location like N'%İSTANBUL%'
ORDER BY Reputation DESC

Enter Parameters

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