Usage of per-site off-topic close reasons

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  H.PostId AS [Post Link],
  H.UserId AS [User Link],
  H.Text AS [Text]
  --F.CloseAsOffTopicReasonTypeId AS [Id],
  --Count(*) AS [Count],
  --Min(R.MarkDownMini) AS [Reason]
FROM PostHistory H
--LEFT JOIN CloseAsOffTopicReasonTypes R
--ON F.CloseAsOffTopicReasonTypeId = R.Id
WHERE H.PostHistoryTypeId = 10 -- vote to close
  AND H.Comment = 102 -- off-topic (with subreasons)
-- GROUP BY F.CloseAsOffTopicReasonTypeId
ORDER BY CreationDate ASC

Enter Parameters

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