0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

select top(50) q.Id as [Post Link], q.OwnerUserId as [User Link],
(1.0 * q.Score * q.Score/q.ViewCount) as Rank,
q.Score, q.ViewCount, 
q.Tags, q.CreationDate,
q.AnswerCount, SUM(p.Score) as AScore
from Posts q
inner join Posts p
on p.ParentId = q.Id
where q.PostTypeId = 1
and q.AcceptedAnswerId is not null
and q.Score > 0
and q.CreationDate > DATEFROMPARTS(##year?2013##,##month?01##,01) 
and q.CreationDate < DATEADD(dd, -1, DATEADD(mm, 120, DATEFROMPARTS(##year?2013##,##month?01##,01)))
group by q.Id, q.OwnerUserId, q.CreationDate, q.Tags, q.Score, q.ViewCount, q.AnswerCount, p.ParentId
order by Rank desc

fork query

edited oct 23

created may 20 16 anonymous