Posts with same number of Answers

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

--SELECT COUNT(*) 'No of Rows'
--FROM (SELECT Count(P.AnswerCount) 'No Of Posts', P.AnswerCount
--FROM Posts AS P
--WHERE AnswerCount IS NOT NULL
--GROUP BY P.AnswerCount) AS TEMP;

SELECT TOP 3 Count(PostId), Id
FROM Comments
WHere PostId is Not null
Group By PostId, Id
Order by Count(PostId) DESC;

Enter Parameters

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