Q&A for gardeners and landscapers
SELECT distinct p.Id AS [Post Link], p.CreationDate FROM ReviewTasks AS rt INNER JOIN Posts AS p ON rt.PostId = p.Id WHERE rt.ReviewTaskTypeId = 2 -- Close Votes AND p.PostTypeId = 1 -- AND p.AcceptedAnswerId is null AND p.ClosedDate is null AND p.Score < 2 AND p.CreationDate < DATEADD(dd, -7, GETDATE()) AND (p.AnswerCount = 0 OR (SELECT max(a.Score) FROM Posts AS a WHERE a.ParentId = p.Id) < 2) ORDER BY p.CreationDate DESC