1

Please login or register to vote for this query.

(click on this box to dismiss)

Find useful questions by users who are respected in the community.

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

-- High Score Questions Without Accepted Answer by Reputable Users
-- Find useful questions by users who are respected in the community.

SELECT
  Posts.Id AS [Post Link],
  Posts.Score AS [Score],
  Posts.ViewCount AS [View Count],
  Users.Reputation AS [Asker Rep]
FROM
  Posts
  INNER JOIN PostTags ON Posts.Id = PostTags.PostId
  INNER JOIN Tags ON PostTags.TagId = Tags.id
  INNER JOIN Users ON Users.Id = Posts.OwnerUserId
WHERE
  Tags.TagName = '##TagName##' AND
  Posts.ClosedDate is NULL AND
  Posts.CommunityOwnedDate is NULL AND
  Posts.AcceptedAnswerId is NULL AND
  Posts.Score >= ##MinPostScore## AND
  Users.Reputation >= ##MinAskerRep##
ORDER BY
  Posts.Score DESC, Posts.ViewCount DESC

fork query

edited jun 10 2024

created jun 27 10 Tim Kryger