0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for computer enthusiasts and power users

SELECT
  COUNT(q.Id)
FROM
  Posts AS q
INNER JOIN
  Posts AS a
ON
  q.AcceptedAnswerId = a.Id
WHERE
  q.Score <= 0
 and
  q.AnswerCount = 1
 and
  q.ViewCount < DATEDIFF(DAY, q.CreationDate, GETDATE()) / 2
 and
  DATEDIFF(DAY, q.CreationDate, GETDATE()) > 60
 and
  a.Score <= 0
 and
  q.OwnerUserId = a.OwnerUserId

fork query

edited nov 18 14

created nov 18 14 anonymous