count of single answered, self answered, accepted questions with score of <= 0 and low views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

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

Enter Parameters

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