0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

-- accepted answer has less votes than the top voted answer and was posted after
select top 30000 *
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
where accepted.Id < a.Id
group by q.Id, accepted.Score
having max(a.Score) > accepted.Score
) as X
order by 0 - [Selected] desc

fork query

created may 3 11 anonymous