0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

SELECT DISTINCT(u.Id), u.DisplayName, u.Reputation, u.WebsiteUrl
FROM Users AS u
JOIN (
 SELECT OwnerUserId, Tags
 FROM Posts AS p
) AS p ON p.OwnerUserId = u.Id
WHERE LOWER(location) LIKE '%berlin%'
   AND LOWER(p.Tags) LIKE '%go%'
ORDER BY Reputation DESC;

fork query

edited aug 3

created aug 3 anonymous