accepted answers for cs95 (user 4909087)


Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

declare @userId as int = 4909087;

select count(*)
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;

Enter Parameters

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