Questions with pending close votes - off topic reasons

3

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT
    pf.PostId as [Post Link],
    COUNT(*) as CVs,
    p.ViewCount as Views,
    p.Score,
    p.AnswerCount as Answers,
    p.CreationDate as Date
FROM
    PendingFlags pf
INNER JOIN
    Posts p
ON
    p.Id = pf.PostId
WHERE
    FlagTypeId = 14
AND
    CloseAsOffTopicReasonTypeId = ##CloseAsOffTopicReasonTypeId?4##
GROUP BY
    pf.PostId, p.Score, p.ViewCount, p.AnswerCount, p.CreationDate
ORDER BY
    CVs DESC, p.ViewCount DESC

Enter Parameters

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