WITH FIRE!
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