Single Post - Most Comments

0

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 count(posts.id), posts.answercount as A from posts
--where posts.answercount A in (
--    select posts.answercount as B from posts
--    where posts.answercount A = posts.answercount B
group by posts.answercount
--order by posts.answercount A desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results