Q&A about the site for Drupal developers and administrators
select 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.Score < 0 order by 'score difference' DESC;