Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT p.Id as [Post Link], count(*) as [Occurrences] FROM Posts p INNER JOIN Votes v ON p.Id = v.PostId WHERE p.PostTypeId = 1 AND p.ClosedDate IS NULL AND v.VoteTypeId = 6 GROUP BY p.Id HAVING count(*) >= 2 ORDER BY occurrences DESC