1

Please login or register to vote for this query.

(click on this box to dismiss)

Brings up those open question with no accepted answer of a certain time old with a tag.

Q&A for people interested in the history and origins of science and mathematics

/*
Please enter how many months in the month field.
Please enter a tag / keyword to check.
*/

select
  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'
from
  Posts q 
join Posts a on a.ParentId = q.Id
where
  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##%'
group by 
  q.Id,q.Score,q.CreationDate,q.LastActivityDate,q.ViewCount,q.CommentCount
having 
  max(a.Score) = 0
order by q.CreationDate asc

fork query

edited apr 27 19

created apr 25 19 S M Mahmudul Hasan