0

Please login or register to vote for this query.

(click on this box to dismiss)

Users with Israel in their location who are active in C++/C#, sorted by rep (having more than 100 rep)

Q&A for anime and manga fans

-- Developer in Israel That Do C++/C#
-- Users with Israel in their location who are active in C++/C#, sorted by rep

SELECT Users.DisplayName, Users.Reputation, Users.Id as ID, Users.WebsiteUrl
FROM Users
  JOIN 
   (
    SELECT Users.Id as UserId
      FROM Posts
      JOIN PostTags ON Posts.Id = PostTags.PostId
      JOIN Users on Users.Id = Posts.OwnerUserId
      WHERE
        (PostTags.TagId = 10 OR PostTags.TagId = 9)
      GROUP BY Users.Id
  ) As TopicUsers
  ON UserId = Users.Id
WHERE Users.Location = 'Israel'
  AND Users.Reputation > 100
ORDER BY Users.Reputation DESC

fork query

created nov 1 11 assaflavie