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 posts.answercount,count(,b.answercount,b.count(id)
FROM posts-- a Inner JOIN posts b where a.answercount = b.answercount
GROUP BY answercount--,b.answercount

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results