SELECT CONCAT('site://q/', Posts.Id, '|', SUBSTRING(Body, CHARINDEX('>', Body) + 1, CHARINDEX('</h', Body) - CHARINDEX('>', Body) - 1)) AS Method, 2 * Score - COUNT(*) AS Corrected FROM Posts
JOIN Votes ON Votes.PostId = Posts.Id
WHERE ParentId = 2447 AND VoteTypeId = 2
GROUP BY Posts.Id, Score, Body
HAVING COUNT(*) >= 2 * (COUNT(*) - Score) AND 2 * Score - COUNT(*) >= 5
ORDER BY Corrected DESC;