Q&A about the site for science fiction and fantasy enthusiasts
-- List of Users in the United Kingdom 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('%united kingdom%') or lower(location) like '% uk' or lower(location) like '%u.k&' or lower(location) LIKE '%england%' or lower(location) LIKE '%northern ireland%' or lower(location) LIKE '%n. ireland%' or lower(location) like '% ni' or lower(location) LIKE '%scotland%' or lower(location) LIKE '%wales%' or lower(location) LIKE '%aberdeen%' or lower(location) LIKE '%aberdeenshire%' or lower(location) LIKE '%aberystwyth%' or lower(location) LIKE '%accrington%' or lower(location) LIKE '%achnasheen%' or lower(location) LIKE '%aldershot%' or lower(location) LIKE '%alton%hampshire%' or lower(location) LIKE '%ashford%kent%' or lower(location) LIKE '%andover%hampshire%' or lower(location) LIKE '%aylesbury%' or lower(location) LIKE '%bangor%gwynedd%' or lower(location) LIKE '%basingstoke%' or lower(location) LIKE '%bedfordshire%' or lower(location) LIKE '%belfast%' or lower(location) LIKE '%berkshire%' or lower(location) LIKE '%blackburn%' or lower(location) LIKE '%blackpool%' or lower(location) LIKE '%bournemouth%' or lower(location) LIKE '%bracknell%' or lower(location) LIKE '%bristol%cornwall%' or lower(location) LIKE '%buckingham%' -- includes buckinghamshire or lower(location) LIKE '%burnham%' or lower(location) LIKE '%burnley%' or lower(location) LIKE '%canterbury%kent%' or lower(location) LIKE '%cardiff%' or lower(location) LIKE '%county durham%' or lower(location) LIKE '%cumbria%' or lower(location) LIKE '%derbyshire%' or lower(location) LIKE '%devon%' or lower(location) LIKE '%edinburgh%' or lower(location) LIKE '%glasgow%' or lower(location) LIKE '%london%' or lower(location) LIKE '%manchester%' or lower(location) LIKE '%southampton%' or lower(location) LIKE '%swansea%' or lower(location) LIKE '%woking%' or lower(location) LIKE '%wolverhampton%' or lower(location) LIKE '%worcestershire%' ) -- exclusions and not ( -- Enter dummy if not required lower(location) LIKE '%aberdeen, id%' or lower(location) LIKE '%aberdeen, sd%' or lower(location) LIKE '%new england%' or lower(location) LIKE '%berkshire, ma%' or lower(location) LIKE '%cardiff-by-the-sea%' --Cardiff-by-the-Sea, CA or lower(location) LIKE '%devon, pa%' or lower(location) LIKE '%england, ar%' or lower(location) LIKE '%east london%' or lower(location) LIKE '%london, ky%' or lower(location) LIKE '%london, on%' or lower(location) LIKE '%new london%' or lower(location) LIKE '%londonderry, nh%' or lower(location) LIKE '%londonderry, vt%' or lower(location) LIKE '%manchester-by-the-sea%' --Manchester-by-the-Sea, MA or lower(location) LIKE '%new glasgow%' -- canada or lower(location) LIKE '%southampton, ma%' or lower(location) LIKE '%southampton, pa%' or lower(location) LIKE '%swansea%ma%' or lower(location) LIKE '%swansea%il%' --testing or lower(location) LIKE '%aberdeen%' --includes Aberdeenshire or lower(location) LIKE '%aberystwyth%' or lower(location) LIKE '%accrington%' or lower(location) LIKE '%achnasheen%' or lower(location) LIKE '%aldershot%' or lower(location) LIKE '%alton%' or lower(location) LIKE '%andover%' or lower(location) LIKE '%ashford%' or lower(location) LIKE '%aylesbury%' or lower(location) LIKE '%bangor%' or lower(location) LIKE '%basingstoke%' or lower(location) LIKE '%bath%' or lower(location) LIKE '%bedford%' or lower(location) LIKE '%bedfordshire%' or lower(location) LIKE '%belfast%' or lower(location) LIKE '%berkshire%' or lower(location) LIKE '%birmingham%' or lower(location) LIKE '%blackburn%' or lower(location) LIKE '%blackpool%' or lower(location) LIKE '%bolton%' or lower(location) LIKE '%bournemouth%' or lower(location) LIKE '%bracknell%' or lower(location) LIKE '%bradford%' or lower(location) LIKE '%brentwood%' or lower(location) LIKE '%brighton%' or lower(location) LIKE '%bristol%' or lower(location) LIKE '%buckingham%' or lower(location) LIKE '%burnley%' or lower(location) LIKE '%cambridge%' or lower(location) LIKE '%canterbury%' or lower(location) LIKE '%cardiff%' or lower(location) LIKE '%cheltenham%' or lower(location) LIKE '%cheshire%' or lower(location) LIKE '%chelmsford%' or lower(location) LIKE '%chesterfield%' or lower(location) LIKE '%chichester%' or lower(location) LIKE '%colchester%' or lower(location) LIKE '%cornwall%' or lower(location) LIKE '%coventry%' or lower(location) LIKE '%cumbria%' or lower(location) LIKE '%derbyshire%' or lower(location) LIKE '%devon%' or lower(location) LIKE '%dorset%' or lower(location) LIKE '%dundee%' or lower(location) LIKE '%durham%' or lower(location) LIKE '%edinburgh%' or lower(location) = 'england' or lower(location) = 'england, uk' or lower(location) = 'england, united kingdom' or lower(location) LIKE '%essex%' or lower(location) LIKE '%london%' or lower(location) LIKE '%manchester%' or lower(location) LIKE '%reading%' or lower(location) = 'scotland' or lower(location) = 'scotland, uk' or lower(location) = 'scotland, united kingdom' or lower(location) LIKE '%southampton%' or lower(location) = 'united kingdom' or lower(location) = 'wales' or lower(location) = 'wales, uk' or lower(location) = 'wales, united kingdom' or lower(location) LIKE '%woking%' or lower(location) LIKE '%wolverhampton%' or lower(location) LIKE '%worcester%' or lower(location) LIKE '%york%' ) order by location asc -- to pick out incorrect results