Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
SELECT p.Id AS [Post Link], p.ClosedDate FROM Posts AS p LEFT OUTER JOIN PostLinks AS pl ON pl.PostId = p.Id AND pl.LinkTypeId = 3 --duplicate WHERE p.PostTypeId = 1 AND p.ClosedDate < DATEADD(dd, -10, GETDATE()) AND p.AcceptedAnswerId is null AND p.Score < 2 AND (p.AnswerCount = 0 OR (SELECT max(a.Score) FROM Posts AS a WHERE a.ParentId = p.Id) < 2) AND pl.Id is null ORDER BY p.ClosedDate DESC