7

Please login or register to vote for this query.

(click on this box to dismiss)

WITH FIRE!

Q&A for programming puzzle enthusiasts and code golfers

-- Kill ALL abandoned questions
-- WITH FIRE!

SELECT C.PostId AS [Post Link], P.Score, P.CreationDate, P.LastEditDate FROM Comments AS C, Posts AS P
WHERE (C.Text LIKE '%more information%' OR C.Text LIKE '%an you%')
AND C.PostId = P.Id
AND P.PostTypeId = 1
AND P.AcceptedAnswerId IS NULL
AND P.ClosedDate IS NULL
AND P.Id NOT IN
(
    SELECT A.ParentID FROM Posts AS A
    WHERE A.Score >= 1
    AND A.ClosedDate IS NULL
    AND A.PostTypeId = 2
)
ORDER BY Score, LastEditDate

fork query

edited dec 19 12

created sep 29 11 Marco Ceppi