0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scholars and enthusiasts of literature

select *
from 
(
select top 25 userid
from badges
where name = 'Unsung Hero'
order by date desc, id desc
) B
cross apply
(
select top 20 q.tags
from posts a
inner join posts q on q.id = a.parentid and q.acceptedanswerid=a.id
where a.posttypeid = 2
  and a.score = 0 -- inexact, Unsung Hero uses Vote=0(?)
  and a.owneruserid = B.userid
) A

fork query

created feb 8 11 cyberkiwi2010