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, p.Name
FROM Users AS u
JOIN (
 SELECT OwnerUserId, Tags, pt.Name
 FROM Posts AS p
 JOIN PostTypes AS pt
 ON p.PostTypeId = pt.Id
) AS p ON p.OwnerUserId = u.Id
WHERE LOWER(location) LIKE '%berlin%'
ORDER BY Reputation DESC;

fork query

edited aug 3

created aug 3 anonymous