Users by location and tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

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
*/

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results