Old unloved questions possibly eligible for auto-deletion v.3

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with score <= 0, low views, no answers, no OP activity

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

-- Old unloved questions possibly eligible for auto-deletion v.3
-- Questions with score <= 0, low views, no answers, no OP activity

SELECT p.Tags, COUNT(*)
FROM Posts p
LEFT OUTER JOIN Users u
ON p.OwnerUserId = u.id
WHERE 
    p.PostTypeId = 1
AND p.Score < 1
AND p.ViewCount < 500
AND ( p.AnswerCount < 1 OR p.AnswerCount IS NULL )
GROUP BY p.Tags ORDER BY 2 DESC

Enter Parameters

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