0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

-- Enter Query Title
-- Enter Query Description

-- Enter Query Title
-- Enter Query Description

SELECT top 100 u.displayname, p.id [Post Link], p.score FROM
users u
CROSS APPLY
(SELECT top 1 * from Posts p
WHERE u.id = p.ownerUserID
and p.posttypeid = 2
ORDER BY SCORE desc) p
order by reputation desc

fork query

edited jan 26 12

created jul 13 11 conradfrix