0

Please login or register to vote for this query.

(click on this box to dismiss)

A CR Zombie finder that takes a tag name to find zombies.

Q&A for professional and enthusiast programmers

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) <= ##MaxScore:int?0##
  AND MAX(a.Score) >= ##MinScore:int?0##
  
-- TagName: Tag name "as you would use in your post"
-- MinScore: Minimum score considered as answerable
-- MaxScore: Maximum score considered as unanswered

view current version

edited mar 19 18

created mar 19 18 Zeta