0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

-- Accepted answer has less votes than the top voted answer for YOU

select top 20000 *
from
(
select  
   q.Id as [Post Link], 
   max(a.Score) [Top Score],
   accepted.Score as [Selected]
from Posts q
join Posts a on a.ParentId = q.Id
join Posts accepted on accepted.Id = q.AcceptedAnswerId and accepted.OwnerUserId = ##UserID##
group by q.Id, accepted.Score
having max(a.Score) > accepted.Score
) as X
order by [Top Score] - [Selected] desc

fork query

created apr 19 11 YOU