Questions where negatively scored accepted answers is outscored

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

select 
distinct q.Id as [Post Link], 
aa.Score as 'accepted answer score', 
hs.Score as 'highest answer score',
hs.Score - aa.Score as 'score difference'
from 
Posts as q 
left join Posts as aa on q.Id = aa.ParentId --- aa: accepted answer
left join Posts as hs on q.Id = hs.ParentId --- hs: highest scoring answer
where 
q.PostTypeId = 1 and
q.AcceptedAnswerId is not null and
q.AnswerCount > 1 and
aa.Score < hs.Score and
aa.Id = q.AcceptedAnswerId and
hs.Score = (Select max(score) from Posts csq where csq.ParentId = q.id) and
aa.CreationDate >= DateAdd(day, 3, hs.CreationDate) ---and
--- hs.Score - aa.Score > 3
order by 'score difference' DESC;

Enter Parameters

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