wybrać użytkowników, którzy komentowali posty polskich użytkowników

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT COUNT(*), Location FROM users WHERE Id IN

(SELECT A.OwnerUserId FROM Posts A
INNER JOIN Posts B
ON A.ParentId = B.Id
WHERE B.OwnerUserId IN
(SELECT Id FROM USERS
WHERE Location LIKE '%Warszawa%' OR Location LIKE '%Warsaw%'
 OR Location LIKE '%Prague%' OR Location LIKE '%Budapest%' OR Location LIKE '%Bucharest%'
  OR Location LIKE '%Praha%'  OR Location LIKE '%Bucuresti%'  OR Location LIKE '%Bratislava%')
)

GROUP BY Location

Enter Parameters

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