Kill ALL abandoned questions

7

Please login or register to vote for this query.

(click on this box to dismiss)

WITH FIRE!

Drupal Answers

Q&A for Drupal developers and administrators

-- 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

Enter Parameters

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