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

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 = 1 --question
   AND
   P.id IN (
            SELECT 
               ParentId 
            FROM 
               Posts 
            WHERE 
               PostTypeId = 2 
            AND 
               OwnerUserId = @UserId
           )

fork query

created apr 7 11 axristo