Tag-based Zombie sniffer rolfl


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.

Stack Overflow

Q&A for professional and enthusiast programmers

WITH BestAnswer as (
  select ParentId, Max(Score) as Score
  from Posts a
  group by parentId

  q.Id AS [Post Link],
  Posts q
    INNER JOIN BestAnswer a
       ON    q.Id = a.ParentId
         and a.Score >= ##MinScore:int?0##
         and a.Score <= ##MaxScore:int?0##
    INNER JOIN PostTags     ON q.Id           = PostTags.PostId
    INNER JOIN Tags         ON PostTags.TagId = Tags.id
      q.AnswerCount > 0
  AND q.AcceptedAnswerId IS NULL
  AND Tags.TagName   = '##TagName##'
-- TagName: Tag name as you would use in your post
-- MinScore: Highest answer has at least votes:
-- MaxScore: Highest answer has at most votes:

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results