Questions with pending close votes - off topic reasons

3

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

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

Enter Parameters

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