DECLARE @UserId int = ##userId## SELECt COUNT(v.Id), vt...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam

Q&A for Muslims, experts in Islam, and those interested in learning more about Islam

-- Enter Query Title
-- Enter Query Description

DECLARE @UserId int = ##userId##

SELECt COUNT(v.Id), vt.Name
FROM Votes v
JOIN VoteTypes vt ON vt.Id = v.VoteTypeId
JOIN Posts p ON p.Id = v.PostId
WHERE p.OwnerUserId = @UserId
AND vt.Name = 'UpMod'
GROUP BY vt.Id, vt.Name

Enter Parameters

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