Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games
SELECT TOP 20 Posts.OwnerUserId, Users.AboutMe, TagName, COUNT(*) AS UpVotes 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 = 'iOS' AND Users.Location like '%Nertherlands%' AND (Users.AboutMe like '%http%' OR Users.AboutMe like '%email%' OR Users.AboutMe like '%@%') GROUP BY TagName, Posts.OwnerUserId, Users.AboutMe ORDER BY UpVotes DESC