High Score Questions Without Accepted Answer by Reputable Users

3

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.

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

-- 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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results