0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

WITH voted_posts AS(
SELECT p.id,
       t.name,
       count(v.id) votes_cnt,
       RANK() OVER (
       PARTITION BY t.name
       ORDER BY count(v.id) DESC ) vote_rank
FROM posts p
JOIN votes v on p.id = v.postid
JOIN votetypes t on v.votetypeid = t.id and t.name in('UpMod', 'DownMod')
GROUP BY p.id, t.name
)
SELECT id
  FROM voted_posts
WHERE vote_rank <= 10;

view current version

edited oct 27

created oct 27 jon.doe37292