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 '%england%' or lower(location) LIKE '%northern ireland%' or lower(location) LIKE '%n. ireland%' or lower(location) like '% ni' or lower(location) LIKE '%aberdeen%uk%' or lower(location) LIKE '%aberdeenshire%' or lower(location) LIKE '%aberystwyth%' or lower(location) LIKE '%alton%uk%' or lower(location) LIKE '%alton%hampshire%' or lower(location) LIKE '%andover%uk%' or lower(location) LIKE '%andover%hampshire%' or lower(location) LIKE '%bath%uk%' or lower(location) LIKE '%bath%eng%' or lower(location) LIKE '%bedford%bedfordshire%' or lower(location) LIKE '%bedford%uk%' or lower(location) LIKE '%bedfordshire%' or lower(location) LIKE '%belfast%' ) -- 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%' --testing or lower(location) LIKE '%aberdeen%' --includes Aberdeenshire or lower(location) LIKE '%aberystwyth%' or lower(location) LIKE '%alton%uk%' or lower(location) LIKE '%alton%hampshire%' or lower(location) LIKE '%andover%uk%' or lower(location) LIKE '%andover%hampshire%' or lower(location) LIKE '%bath%uk%' or lower(location) LIKE '%bath%eng%' or lower(location) LIKE '%bedford%bedfordshire%' or lower(location) LIKE '%bedford%uk%' or lower(location) LIKE '%bedfordshire%' or lower(location) LIKE '%belfast%' ) order by location asc -- to pick out incorrect results