Bizarre question stats by Tag


Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

-- 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 [Post Link] FROM Posts
WHERE Id IN (SELECT PostId FROM TaggedPosts)
AND PostTypeId = 1
AND AnswerCount = 0
AND AcceptedAnswerId IS NOT NULL

Enter Parameters

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