Q&A about the site for Drupal developers and administrators
SELECT TOP(##num?500##) Id AS [User Link], Location, Reputation FROM Users WHERE (Location LIKE '%##loc1?Oxford##' COLLATE Latin1_General_CI_AI) AND (Location LIKE '%##loc2?Canada##' COLLATE Latin1_General_CI_AI) ORDER BY [Reputation] DESC