0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

select
  PostId
from
  (select
    vt.PostId
    ,rank () over (order by count(1) desc) rnk
  from VoteTypes vtt
  join Votes vt on vtt.Id = vt.VoteTypeId
  where vtt.Name = 'UpMod'
  group by vt.PostId) r
where rnk <= 10
union all
select
  PostId
from
  (select
    vt.PostId
    ,rank () over (order by count(1) desc) rnk
  from VoteTypes vtt
  join Votes vt on vtt.Id = vt.VoteTypeId
  where vtt.Name = 'DownMod'
  group by vt.PostId) r
where rnk <= 10

view current version

edited oct 3 23

created oct 3 23 anonymous