mostly easy tool/rec close votes needed

0

Please login or register to vote for this query.

(click on this box to dismiss)

read the question before voting to close of course to make sure, but should be easy close votes!!

Stack Overflow

Q&A for professional and enthusiast programmers

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?16##
AND
    LEN(p.Body) < 550
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