0

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы о сайте для программистов

-- Revival/Necromancer badge candidates
-- 

SELECT TOP 1000
    p.Id AS [Post Link],
    p.Score,
    p.ViewCount,
    p.Tags
FROM
    Posts p
WHERE
    AcceptedAnswerId IS NULL
    AND
    p.PostTypeId = 1
    AND
    p.CreationDate < GETDATE() - 60
    AND
    p.ClosedDate IS NULL
    AND
    p.AnswerCount = 0
AND NOT EXISTS
    (
        SELECT *
        FROM Posts p2
        WHERE p2.ParentId = p.Id
        AND p2.Score >= 2
        AND p2.PostTypeId = 2
    )
ORDER BY
    p.AnswerCount ASC

fork query

edited mar 16 16 anonymous

created sep 2 11 danielsixfive