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 DISTINCT PostId 
FROM Comments
Where PostId in
(SELECT TOP 3 PostId
FROm Comments
WHere PostId is Not null
Group By PostId
Order by Count(PostId) DESC);

Enter Parameters

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