Q&A for science fiction and fantasy enthusiasts
SELECT 'site://q/' + CAST(q.Id AS NVARCHAR) + '/' + CAST(MIN(m.Id) AS NVARCHAR) + '|' + MIN(q.Title) AS qti, COUNT(e.Id) AS ere FROM Posts AS q JOIN PostHistory AS e ON q.Id = e.PostId LEFT JOIN Users AS m ON m.AccountId = 1192385 WHERE q.PostTypeId = 1 AND e.PostHistoryTypeId IN(10, 11) GROUP BY q.Id HAVING 3 <= COUNT(e.Id) ORDER BY ere DESC;