User List: Top N - Turkey - with false positive exclusion

1

Please login or register to vote for this query.

(click on this box to dismiss)

List of Users in Turkey.

Amateur Radio

Q&A for amateur radio enthusiasts

-- List of Users in Turkey


SELECT   RankNo, 
         [User Link], 
         Reputation, 
         --DisplayName, 
         Location

FROM
         (
            SELECT Id [User Link], Reputation, Location,
                   DENSE_RANK() OVER (ORDER BY Reputation DESC) RankNo
            FROM   Users
            WHERE 
              (
               lower(Location) LIKE '%turkey%' 
              
               OR lower(Location) LIKE 'adana'
               OR lower(Location) LIKE 'adapazarı'
               --
               
               OR lower(Location) LIKE 'ankara'
               OR lower(Location) LIKE 'antalya'
               --

               OR lower(Location) LIKE 'bafra'
               OR lower(Location) LIKE 'bakırköy'
               --
               OR lower(Location) LIKE 'balıkesir'
               --
               OR lower(Location) LIKE 'beyşehir'
               OR lower(Location) LIKE 'bursa'
               
               OR Location LIKE 'Çanakkale'
               
               OR lower(Location) LIKE 'cordaleo'
               
               OR Location LIKE 'Çubuk'
               
               OR lower(Location) LIKE 'denizli'
               
               OR lower(Location) LIKE 'diyarbakir'

               OR lower(Location) LIKE 'edirne'
               OR lower(Location) LIKE 'edremit'
               OR lower(Location) LIKE 'eskişehir'
               
               OR lower(Location) LIKE 'eskisehir'
               -- 
               OR lower(Location) LIKE 'fethiye'
               
               
               
               OR lower(Location) LIKE 'gaziantep'
               --
               OR lower(Location) LIKE 'gaziemir'
               --
               OR lower(Location) LIKE 'hadimkoy'
               OR lower(Location) LIKE 'hatay'
               OR lower(Location) LIKE 'isparta'
               
               OR lower(Location) LIKE 'istanbul'
               OR lower(Location) LIKE 'izmir'
               
               OR lower(Location) LIKE 'kayseri'
               --
               OR lower(Location) LIKE 'kocaeli'
               -- 
               OR lower(Location) LIKE 'konya'
               
               
               OR lower(Location) LIKE 'kuşadası'
               --
               OR lower(Location) LIKE 'manisa'
               --
               OR lower(Location) LIKE 'manyas'
               --
               OR lower(Location) LIKE 'marmaris'
               --
               OR lower(Location) LIKE 'mersin'
               
               OR lower(Location) LIKE 'mugla'
               OR lower(Location) LIKE 'muğla'
               
               --
               OR lower(Location) LIKE 'nevşehir'
               --
               OR lower(Location) LIKE 'sakarya'
               --
               OR lower(Location) LIKE 'samsun'
               --
               OR lower(Location) LIKE 'serik'
               --
               OR lower(Location) LIKE 'smyrna'
               --
               OR lower(Location) LIKE 'suluova'
               OR lower(Location) LIKE 'trabzon'  
               )
    
          -- exclusions
             and not(lower(Location) LIKE '%australia%' -- TR
                  OR lower(Location) LIKE '%austria%'   -- TR
               
                  OR lower(Location) LIKE '%gorduno%' --Switzerland (Ordu in Turkey)      
                  )   
                  
            ) derivedtable

WHERE    RankNo <= ##MaximumRankNo## 
--and Reputation >= ##minimumReputation##

ORDER    BY RankNo
--ORDER    BY location

Enter Parameters

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