Questions having zero score or less, zero answers
Q&A for community managers, administrators, and moderators
Please enter the Year to get the list of the questions posted
before that amount of year, zero score and zero actual answers.
It is okay for most of the site not to produce any result.
Usefor the sites with low answered question percenatge.
For example: for 1 year old question input 1, for 2 input 2..
Id as [Post Link],
Score as 'Votes',
CreationDate as 'Posted',
LastActivityDate as 'Last Active',
ViewCount as 'Views',
CommentCount as 'Comments'
PostTypeId = 1 and
AcceptedAnswerId is null and
ClosedDate is null and
AnswerCount = 0 and
CreationDate < DATEADD(Year, -##Year##, getdate()) and
Score <= 0
order by CreationDate asc