0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

-- 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

fork query

edited jul 24 12 anonymous

created jul 13 12 Merlin