Bizarre question stats by Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

-- find posts with tag

WITH TaggedPosts(PostId)
AS (
  SELECT pt.PostId as PostId
  FROM PostTags pt INNER JOIN Tags t ON t.Id=pt.TagId
  WHERE t.TagName LIKE '%' + ##tag:string## + '%'
  GROUP BY pt.PostId
)

-- find bizarre questions

SELECT Id as [Post Link], * FROM Posts
WHERE Id IN (SELECT PostId FROM TaggedPosts)
AND PostTypeId = 1
AND AnswerCount = 0
AND AcceptedAnswerId IS NOT NULL

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results