0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

SELECT DISTINCT u.Id, *
FROM Users u
JOIN (
    SELECT DISTINCT PostId
    FROM PostTags pt
    JOIN Tags t ON pt.TagId = t.Id
    WHERE t.TagName LIKE '%math%'
) math_posts ON math_posts.PostId = u.Id
JOIN Comments c ON math_posts.PostId = c.PostId
JOIN Votes v ON math_posts.PostId = v.PostId
ORDER BY u.Reputation DESC;

fork query

edited dec 4

created dec 4 anonymous