Single Post - Most Comments


Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

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

--How many posts have the exact same number of answers?

select id, count(*) from posts
where answercount in (
    select answercount from posts 
    where answercount = answercount
group by answercount
)--order by posts.answercount A desc
group by id

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results