Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
SELECT p.Id AS [Post Link], p.CreationDate FROM Posts AS p INNER JOIN PostTags AS pt ON pt.PostId = p.Id INNER JOIN Tags AS tn ON pt.TagId = tn.Id AND tn.TagName = '##tagname##' INNER JOIN PostLinks AS pl ON pl.PostId = p.Id AND pl.LinkTypeId = 3 --duplicate WHERE p.PostTypeId = 1 AND p.CreationDate < DATEADD(dd, -37, GETDATE()) AND p.AcceptedAnswerId is null AND p.Score < 1 AND p.AnswerCount = 0 ORDER BY p.CreationDate DESC