Zero scored question with no actual answer

1

Please login or register to vote for this query.

(click on this box to dismiss)

Questions having zero score or less, zero answers

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

/*
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..
*/
select
  Id as [Post Link],
  Score as 'Votes',
  CreationDate as 'Posted',
  LastActivityDate as 'Last Active',
  ViewCount as 'Views',
  CommentCount as 'Comments'
from
  Posts
where
  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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results