Q&A for linguists, etymologists, and serious English language enthusiasts
SELECT TOP 2000 CONCAT('http://stackoverflow.com/users/', Posts.OwnerUserId), Users.AboutMe, Users.Reputation, TagName, COUNT(*) AS UpVotes, Users.WebsiteUrl FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Votes ON Votes.PostId = Posts.Id and VoteTypeId = 2 INNER JOIN Users ON Users.Id = Posts.OwnerUserId WHERE --TagName = '##skill##' upper(Users.Location) like upper('%##location##%') and Users.AboutMe LIKE '%##Aboutme##%' and Users.WebsiteUrl LIKE '%linkedin%' GROUP BY TagName, Posts.OwnerUserId, Users.Reputation, Users.AboutMe, Users.WebsiteUrl ORDER BY UpVotes DESC