Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- q.Id AS [Post Link],
- q.Tags
- FROM
- Posts q
- INNER JOIN Posts a ON q.Id = a.ParentId
- INNER JOIN PostTags ON q.Id = PostTags.PostId
- INNER JOIN Tags ON PostTags.TagId = Tags.id
- WHERE
- q.AnswerCount > 0
- AND q.AcceptedAnswerId IS NULL
- AND Tags.TagName = '##TagName##'
- GROUP BY
- q.Id, q.Tags
- HAVING
- MAX(a.Score) >= ##MinScore:int?0##
- AND MAX(a.Score) <= ##MaxScore:int?0##
- -- TagName: Tag name "as you would use in your post"
- -- MinScore: Highest answer has at least votes:
- -- MaxScore: Highest answer has at most votes:
Add Comment
Please, Sign In to add comment