Test: Location Austria

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

-- List of users in Austria
-- Not Case Sensitive

SELECT
    Top ##Top##
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation,
    Location,
    --CreationDate,
    LastAccessDate,
    UpVotes,
    DownVotes
    
FROM
    Users
WHERE

    (
        lower(location) like lower('%Austria%')
     or lower(location) like lower('% AT')
     
     or lower(location) like lower('%Graz%')
     or lower(Location) LIKE lower('%Innsbruck%')
     or lower(Location) LIKE lower('%Salzburg%')
     or lower(location) like lower('%Vienna%')
     
     or lower(Location) LIKE lower('%Linz (AT)%') -- Special Case
    
     )
  
  -- exclusions
     and not
     (
       lower(location) like lower('%dummy%')
       or lower(Location) LIKE lower('%dummy%')
       
      ---testing
      
     --or lower(Location) = lower('Austria')
     --or lower(location) like lower('%Graz%')
     --or lower(Location) LIKE lower('%Innsbruck%')
     
     --or lower(Location) LIKE lower('%Linz%')
     
     --or lower(Location) LIKE lower('%Salzburg%')
     --or lower(Location) LIKE lower('%Vienna%')
     
     )
 order by location asc -- to pick out incorrect results

Enter Parameters

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