Top 25 comments in terms of upvotes.
Q&A about the site for administrators, end users, developers and designers for Craft CMS
select top(25) posts.id as [Post Link], comments.score, comments.text from comments join posts on comments.postid = posts.id order by comments.score desc