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 *
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
WHERE 
  u.CreationDate BETWEEN '2022-01-01 00:00:00' AND '2023-12-31 23:59:59'
  AND u.Reputation >= 100
ORDER BY u.Reputation DESC;

fork query

edited dec 4

created dec 4 anonymous