Which of my answers received more votes than the accepted answer?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

WITH Utable AS ( SELECT
	Id AS AnswerId,
	ParentId AS QuestionId,
	Score 
FROM
	Posts   
WHERE
	OwnerUserId = 7128934     
	AND Posts.PostTypeId = 2   
	AND Posts.ParentId IN     (SELECT
		Posts.Id 
	FROM
		Posts 
	WHERE
		Posts.AcceptedAnswerId IS NOT NULL) ) SELECT
		Posts.Id as [Post Link] 
	FROM
		Posts   
	RIGHT JOIN
		Utable 
			ON Utable.QuestionId = Posts.Id 
	WHERE
		Utable.AnswerId <> Posts.AcceptedAnswerId 
		AND Utable.score > 1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results