Questions without answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

DECLARE @start DATETIME = convert(DATETIME, '##start?2010/02/01 00:00:00##')
DECLARE @end DATETIME = convert(DATETIME, '##end?2025/05/01 00:00:00##')
DECLARE @minvote INT= '##minvote?0##'
DECLARE @minview INT= '##minview?0##'
SELECT Q.Id AS [Post Link], Q.ViewCount AS Views, 
  Q.Score
FROM
  Posts Q
WHERE
  Q.ViewCount >= @minview AND
  Q.score >=@minvote AND
  Q.PostTypeId = 1 AND
  Q.ClosedDate IS NULL AND
  Q.CreationDate > @start AND
   Q.CreationDate < @end AND
  Q.AnswerCount=0
ORDER BY Q.ViewCount DESC

Enter Parameters

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