How sporting am I (sportsmanship badge)?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Number of upvotes to competing answers where user has an answer with at least one upvote

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- How sporting am I (sportsmanship badge)?
-- Number of upvotes to competing answers where user has an answer with at least one upvote

DECLARE @UserId int = ##UserId##


SELECT
   count(id)
FROM
   Posts P
WHERE
   P.PostTypeId = 2 --question
   AND
   P.ParentId IN (
            SELECT 
               ParentId 
            FROM 
               Posts 
            WHERE 
               PostTypeId = 2 
            AND 
               OwnerUserId = @UserId
           )

Enter Parameters

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