0

Please login or register to vote for this query.

(click on this box to dismiss)

the top 50, based on the view count of their respective parent questions

Q&A for anime and manga fans

-- Enter Query Title
-- Enter Query Description

select top 50
    a.id as [Post Link],
    (cast(a.score as decimal)/cast(q.viewcount as decimal)) as 'Score:Viewcount',
    a.Score,
    q.ViewCount,
    q.CreationDate
from posts as q
inner join posts as a
    on a.parentid = q.id
where q.viewcount > 0
and q.posttypeid = 1
order by 'Score:Viewcount' desc

fork query

created nov 8 11 burpenator