Favourites per view for answered questions (draft)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Theoretical Computer Science

Q&A for theoretical computer scientists and researchers in related fields

select P.ViewCount, V.NumFavs
from Posts P
inner join (
  select PostId, count(Id) as NumFavs
  from Votes
  where VoteTypeId = 5
  group by PostId
  ) V on V.PostId = P.Id
inner join PostTags PT on PT.PostId = P.Id
inner join Tags T on T.Id = PT.TagId
where V.NumFavs > 0
  and T.TagName = 'haskell'
order by P.ViewCount desc

Enter Parameters

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