Top 2500 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)

Stack Overflow

Q&A for programmers

SELECT TOP 2500
  q.Id AS [Post Link],
  q.ViewCount,
  q.Score,
  a.Score,
  q.CreationDate AS qDate,
  a.CreationDate AS aDate,
  LEN(q.Body) AS qLen,
  LEN(a.Body) AS aLen
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
ORDER BY
  q.Score ASC

Enter Parameters

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