My zero scored, unaccepted answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

This query return a list of answers which are not yet accepted and scored Zero votes

Drupal Answers

Q&A for Drupal developers and administrators

SELECT 
  ROW_NUMBER() over(ORDER BY Answers.Id ASC) as [#],
  Answers.Id as [Post Link]
FROM

  Posts Qestions
INNER JOIN
  Posts Answers
ON
  Answers.ParentId = Qestions.Id
WHERE
  Answers.OwnerUserId = 8283848
  and Answers.Score=0
  and Qestions.AcceptedAnswerId is null
  and Qestions.Id not in (
    63156884, 63510041, 63413561, 60095510, 63913377, 63943120, 64131842,
    64034016, 63629935, 64109840, 58325857, 64602770, 64611388, 51599957
    )
ORDER BY Answers.CreationDate ASC
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results