Guest User

Untitled

a guest
Mar 19th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. SELECT
  2. q.Id AS [Post Link],
  3. q.Tags
  4. FROM
  5. Posts q
  6. INNER JOIN Posts a ON q.Id = a.ParentId
  7. INNER JOIN PostTags ON q.Id = PostTags.PostId
  8. INNER JOIN Tags ON PostTags.TagId = Tags.id
  9. WHERE
  10. q.AnswerCount > 0
  11. AND q.AcceptedAnswerId IS NULL
  12. AND Tags.TagName = '##TagName##'
  13. GROUP BY
  14. q.Id, q.Tags
  15. HAVING
  16. MAX(a.Score) >= ##MinScore:int?0##
  17. AND MAX(a.Score) <= ##MaxScore:int?0##
  18.  
  19. -- TagName: Tag name "as you would use in your post"
  20. -- MinScore: Highest answer has at least votes:
  21. -- MaxScore: Highest answer has at most votes:
Add Comment
Please, Sign In to add comment