User List: Top N - Cambodia

1

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

-- List of Users in Belgium
SELECT
    Top ##Top##
    
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [# by Rep], 
    Id AS [User Link], 
    Reputation,
    Location,
    --CreationDate,
    LastAccessDate,
    UpVotes,
    DownVotes
    
FROM
    Users

WHERE
     (
      lower(Location) LIKE lower('%Belgium%')
      -- http://sustainablesources.com/resources/country-abbreviations/
      
      --or UPPER(RIGHT(RTRIM(Location), 3)) = ' BE' -- many false positives, try "to be"
      or UPPER(RIGHT(RTRIM(Location), 3)) = ', BE'
      
      or UPPER(RIGHT(RTRIM(Location), 3)) = ',BE'
      or UPPER(Location) = 'BE'
      
      or lower(Location) = lower('%Antwerp%') -- Assumed Belgium
      or lower(Location) like lower('%Antwerpen%')
      
      or lower(Location) LIKE lower('%Bruges%')
      
      or lower(Location) LIKE lower('%Bruxelles%')
      or lower(Location) LIKE lower('%Brussels%')
      
      or lower(Location) LIKE lower('%Dilsen%')
      
      or lower(Location) LIKE lower('%st%Flanders%') -- East and West Flanders
      
      
      or lower(Location) = lower('Ghent') -- Assumed Belgium
      
      or lower(Location) LIKE lower('%Lokeren%Ghent%')
      or lower(Location) LIKE lower('%Ghent%EU%')
      or lower(Location) LIKE lower('%Ghent%Flanders%')
      
      or lower(Location) LIKE lower('%Flemish Region%')  -- Assumed Belgium
      
      or lower(Location) = lower('Hasselt')  -- Assumed Belgium
      or lower(Location) = lower('Hoogstraten')  -- Assumed Belgium
      
      or lower(Location) LIKE lower('%Ieper%') -- Ypres  -- Assumed Belgium
      
      or lower(Location) = lower('Kortrijk') -- Assumed Belgium
      
      or lower(Location) LIKE lower('%Leuven%')
      
      or lower(Location) LIKE lower('%Lokeren%')
      
      or lower(Location) LIKE lower('%Mechelen%')
      or lower(Location) = lower('Mons') -- Assumed Belgium
      
           
      or lower(Location) LIKE lower('%Namur%')
      or lower(Location) LIKE lower('%Waregem%')
      
      
      or lower(Location) LIKE lower('%dummy%')
      or lower(Location) LIKE lower('%dummy%')
      )
      
       -- exclusions
       and not
       (   
       
       lower(Location) LIKE lower('%dummy%')
       or lower(Location) LIKE lower('%dummy%')
       or lower(Location) LIKE lower('%dummy%')
       or lower(Location) LIKE lower('%dummy%')
       
       --for testing
       or lower(Location) = lower('Belgium')
       or lower(Location) LIKE lower('%Belgium%EU%')
       
       
       or lower(Location) LIKE lower('%Aalst%')
       or lower(Location) LIKE lower('%Aalter%')
       
       or lower(Location) LIKE lower('%Aarsele%')
       or lower(Location) LIKE lower('%Aartselaar%')
       or lower(Location) LIKE lower('%Aertrycke%')
       or lower(Location) LIKE lower('%Affligem%')
       or lower(Location) LIKE lower('%Antwerp%')
       or lower(Location) = lower('Antwerp, Belgium') 
       or lower(Location) LIKE lower('%Ardooie%')
       
       
       
       or lower(Location) LIKE lower('%Arlon%')
       
       or lower(Location) LIKE lower('%Bassange%')
       
       or lower(Location) LIKE lower('%Bastogne%')
       or lower(Location) LIKE lower('%Beernem%')
       or lower(Location) LIKE lower('%Beerse%')
       or lower(Location) LIKE lower('%Beggynendyck%')
       or lower(Location) LIKE lower('%Berlaere%')
       or lower(Location) LIKE lower('%Betekom%')
       or lower(Location) LIKE lower('%Beveren%')
       or lower(Location) LIKE lower('%Bilzen%')
       or lower(Location) LIKE lower('%Binche%')
       
       or lower(Location) LIKE lower('%Blankenberge%')
       or lower(Location) LIKE lower('%Boortmeerbeek%')
       or lower(Location) LIKE lower('%Bottelaere%')
       or lower(Location) LIKE lower('%Bouwel%')
       or lower(Location) LIKE lower('%Braine-l%')
       or lower(Location) LIKE lower('%Brasschaat%')
       or lower(Location) LIKE lower('%Boechout%')
       or lower(Location) LIKE lower('%Brecht%')
       or lower(Location) LIKE lower('%Bredene%')
       or lower(Location) LIKE lower('%Bree%')
       or lower(Location) LIKE lower('%Bruges%')
       or lower(Location) LIKE lower('%Brugelette%')
       or lower(Location) LIKE lower('%Brussel%')
       
       or lower(Location) LIKE lower('%Bruxelles%')
       
       or lower(Location) LIKE lower('%Charleroi%')
       or lower(Location) LIKE lower('%Corbeek-Loo%')
       or lower(Location) LIKE lower('%Cuerne%')
       
       or lower(Location) LIKE lower('%Damme%')
       
       or lower(Location) LIKE lower('%Ferri%res%')
       
       or lower(Location) LIKE lower('%Flander%')
       or lower(Location) LIKE lower('%Flemish Region%')
       
       or lower(Location) LIKE lower('%ghent%')
       --or lower(Location) = lower('Ghent, Belgium')
       
       or lower(Location) LIKE lower('%Leuven%')
       or lower(Location) LIKE lower('%Lichterveld%')
       or lower(Location) LIKE lower('%Li%ge%')
       
       or lower(Location) LIKE lower('%Londerzeel%')
      
       
       or lower(Location) LIKE lower('%Liege%')
       or lower(Location) LIKE lower('%Mechelen%')
       or lower(Location) LIKE lower('%Mons%')
       or lower(Location) LIKE lower('%Namur%')
       or lower(Location) LIKE lower('%Waregem%')
       or lower(Location) LIKE lower('%Ypres%')
       
       
      
      
      or lower(Location) LIKE lower('%De%Panne%')
      or lower(Location) LIKE lower('%De%Pinte%')
      or lower(Location) LIKE lower('%Deinze%')
      or lower(Location) LIKE lower('%Dendermonde%')
      or lower(Location) LIKE lower('%Deurne%')
      or lower(Location) LIKE lower('%Deynze,%')
      or lower(Location) LIKE lower('%Diepenbeek%')
      or lower(Location) LIKE lower('%Diest%')
      or lower(Location) LIKE lower('%Dilbeek%')
      or lower(Location) LIKE lower('%Dilsen%')
      or lower(Location) LIKE lower('%Dworp%')
      or lower(Location) LIKE lower('%Eigenbrake%')
      or lower(Location) LIKE lower('%Ekeren%')
      or lower(Location) LIKE lower('%Elsegem%')
      or lower(Location) LIKE lower('%Erpe%')
      or lower(Location) LIKE lower('%Ertvelde%')
      or lower(Location) LIKE lower('%Essen%')
      or lower(Location) LIKE lower('%Ettelgem%')
      or lower(Location) LIKE lower('%Etterbeek%')
      or lower(Location) LIKE lower('%Fosses-la-Ville%')
      or lower(Location) LIKE lower('%Frameries%')
      or lower(Location) LIKE lower('%Geel%')
      or lower(Location) LIKE lower('%Gembloux%')
      or lower(Location) LIKE lower('%Genk%')
      or lower(Location) LIKE lower('%gent%')
      or lower(Location) LIKE lower('%Gheel%')
      or lower(Location) LIKE lower('%Gistel%')
      or lower(Location) LIKE lower('%Glaaien,%')
      or lower(Location) LIKE lower('%Grasheide%')
      or lower(Location) LIKE lower('%Grimberghen%')
      or lower(Location) LIKE lower('%Haasdonk%')
      or lower(Location) LIKE lower('%Hailebeke%')
      or lower(Location) LIKE lower('%Halen%')
      or lower(Location) LIKE lower('%Halle%')
      or lower(Location) LIKE lower('%Hamme%')
      or lower(Location) LIKE lower('%Hamont%')
      or lower(Location) LIKE lower('%Harelbeke%')
      or lower(Location) LIKE lower('%Hasselt%')
      or lower(Location) LIKE lower('%Heffen%')
      or lower(Location) LIKE lower('%Heist-op-den-Berg%')
      or lower(Location) LIKE lower('%Heppen%')
      or lower(Location) LIKE lower('%Herent%')
      or lower(Location) LIKE lower('%Heverlee%')
      or lower(Location) LIKE lower('%Hoeselt%')
      or lower(Location) LIKE lower('%Hollow Creek%')
      or lower(Location) LIKE lower('%Hoogstraten%')
      or lower(Location) LIKE lower('%Ieper%')
      or lower(Location) LIKE lower('%Ixelles%')
      or lower(Location) LIKE lower('%Jurbise%')
      or lower(Location) LIKE lower('%Kalmthout%')
      or lower(Location) LIKE lower('%Kersbeek%')
      or lower(Location) LIKE lower('%Kessel%')
      or lower(Location) LIKE lower('%Kinroy%')
      or lower(Location) LIKE lower('%Komen%')
      or lower(Location) LIKE lower('%Kortenberg%')
      or lower(Location) LIKE lower('%Kortrijk%')
      or lower(Location) LIKE lower('%Kuringen%')
      or lower(Location) LIKE lower('%Landegem%')
      or lower(Location) LIKE lower('%Lebbeke%')
      or lower(Location) LIKE lower('%Lede%')
      or lower(Location) LIKE lower('%Leupegem%')
      --or lower(Location) LIKE lower('%Lichterveld%')
      or lower(Location) LIKE lower('%Lier%')
      or lower(Location) LIKE lower('%Linden%')
      
      or lower(Location) LIKE lower('%Lokeren%')
      or lower(Location) LIKE lower('%Louvain-la-Neuve%')
      or lower(Location) LIKE lower('%Lubbeek%')
      or lower(Location) LIKE lower('%Lummen%')
      or lower(Location) LIKE lower('%Maissin%')
      or lower(Location) LIKE lower('%Maldegem%')
      or lower(Location) LIKE lower('%Marcinelle%')
      or lower(Location) LIKE lower('%Maxenzeel%')
      or lower(Location) LIKE lower('%Menen%')
      or lower(Location) LIKE lower('%Mol%')
      or lower(Location) LIKE lower('%Mortsel%')
      or lower(Location) LIKE lower('%Neufvilles%')
      or lower(Location) LIKE lower('%Nieuwpoort%')
      or lower(Location) LIKE lower('%Oostcamp%')
      or lower(Location) LIKE lower('%Oostende%')
      or lower(Location) LIKE lower('%dummy%')
      or lower(Location) LIKE lower('%dummy%')
      or lower(Location) LIKE lower('%dummy%')
       
       )   
                  
   and LEN(Location) > 1
   --and Reputation > 1

    --Temporarily sort by location to more easily pick out false positive entries
    ORDER BY Location ASC;

Enter Parameters

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