DECLARE @UserID int SET @UserID = 187606 SELECT SUM(Cas...


Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- Enter Query Title
-- Enter Query Description

SET @UserID = 187606

SELECT SUM(Case When VoteTypeID = 1 Then 15 WHEN VoteTypeID=2 THEN 10 WHEN VoteTypeID=3 THEN -2 ELSE 0 END)
FROM Votes v
INNER JOIN Posts p ON p.ID = v.PostID
WHERE p.OwnerUserID = @UserID AND p.CommunityOwnedDate IS NULL

Enter Parameters

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