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(100) q.Id as [Post Link], q.OwnerUserId as [User Link],
(0.000000001 * q.Score * q.Score * POWER(q.ViewCount,0.3) * (q.CommentCount+2) * SUM(p.Score)) as Rank,
q.Score, q.ViewCount, 
q.Tags, q.CreationDate, q.CommentCount,
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.CommentCount, 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