Valid I/O Methods

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results