Brings up those open question with no accepted answer of a certain time old with a tag.
Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
Please enter how many months in the month field.
Please enter a tag / keyword to check.
q.Id as [Post Link],
q.Score as 'Votes',
q.CreationDate as 'Posted',
q.LastActivityDate as 'Last Active',
q.ViewCount as 'Views',
q.CommentCount as 'Comments'
join Posts a on a.ParentId = q.Id
q.PostTypeId = 1 and
q.AcceptedAnswerId is null and
q.ClosedDate is null and
q.CreationDate < DATEADD(Month, -##Month:int?24##, getdate()) and
q.Tags like '%##Tag?freya##%'
max(a.Score) = 0
order by q.CreationDate asc