0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited oct 22 18

created oct 22 18 b_jonas