0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

DECLARE @UserId int = 447970


select count (q.Title)
from posts a
join posts q on a.ParentId = q.Id
join votes v on a.Id = v.PostId
where a.PostTypeId = 2
and q.PostTypeId = 1
and v.VoteTypeId = 1
and a.owneruserid = @userId
and q.CreationDate > '2018-03-31'

fork query

edited mar 25 19

created mar 25 19 anonymous