find candidates for Necromancer badge

3

Please login or register to vote for this query.

(click on this box to dismiss)

finds questions more than 60 days old having in the specified tag

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

DECLARE @tag VARCHAR(30) = ##tag:string##

SELECT TOP 1000
    Id AS [Post Link],
    Score,
    ViewCount as Views,
    AnswerCount as Answers,
    Body,
    CreationDate
FROM Posts
WHERE
    AcceptedAnswerId IS NULL
    AND PostTypeId = 1
    AND CreationDate < GETDATE() - 60
    AND ClosedDate IS NULL
    AND Tags LIKE '%<' + LOWER(@tag) + '>%'

Enter Parameters

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