Q&A for enthusiasts and power users of the Android operating system
--Users.Id --Users.Location --SELECT DisplayName, Location FROM Users WHERE Id='210290' /* SELECT id as [User Link] FROM Users WHERE ( Location='##Location##' AND ) Users from a given location with tags in xx,yy,zz order desc */ SELECT Users.id as [User Link], Reputation FROM Users INNER JOIN Tags ON Tags.TagName IN ('java', 'ios', 'security', 'javascript') INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.OwnerUserId = Users.id AND Posts.ParentId = PostTags.PostId --INNER JOIN Posts ON Posts.OwnerUserId = Users.id --AND Posts.Tags IN ('Java') --INNER JOIN Posts ON Posts.Tags = 'Java' WHERE ( Location='##Location##' ) GROUP BY Users.id, Reputation ORDER BY Reputation DESC /* DECLARE @UserId int = ##UserId## SELECT --TOP 20 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 WHERE Posts.OwnerUserId = @UserId GROUP BY TagName ORDER BY UpVotes DESC */