Q&A for professional and enthusiast programmers
select TagName, count(distinct v.Id) downvotes, count(distinct p.Id) posts from Posts p join Posts q on isnull(p.ParentId, p.Id) = q.Id join Votes v on v.PostId = p.Id join PostTags pt on pt.PostId = q.Id join Tags t on TagId = t.Id where VoteTypeId = 3 and p.OwnerUserId in (##user?1438##) group by TagName order by count(*) desc