0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

select p.parentId as Question, p.OwnerUserId as Answerer, COUNT(*) as Upvotes
from Posts as p
        INNER JOIN Votes as v ON  v.PostId = p.Id and 
                                  v.VoteTypeId = 2
where
      p.ParentId is not null and
      p.PostTypeId = 2 and
      p.ParentId in
      (
      select pt.PostId as Post from PostTags as pt, Posts as p
        where p.Id = pt.PostId and p.viewCount > 42000) 
group by p.parentId, p.OwnerUserId

fork query

edited apr 19 14 jon.doe13575

created apr 18 14 Ganesh