0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

SELECT TOP 1000 Us.Location
FROM Posts 
INNER JOIN (SELECT PostId FROM PostTags WHERE TagId=17) AS PT ON PT.PostId=Posts.id
INNER JOIN (SELECT id, Location FROM Users WHERE Location<>'')
  AS Us ON Us.id=Posts.OwnerUserId
WHERE PostTypeId=1
GROUP BY Us.Location

SELECT DISTINCT id, Location 
FROM Users AS Us
INNER JOIN 
  (SELECT OwnerUserId 
   FROM Posts
     INNER JOIN (SELECT PostId FROM PostTags WHERE TagId=17) 
     AS PT 
     ON PT.PostId=Posts.id
   WHERE PostTypeId=1)
  AS Posts
  ON Us.id=Posts.OwnerUserId
WHERE Location<>''

fork query

edited feb 18 18

created feb 16 18 anonymous