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 * q.ViewCount * q.CommentCount+1 * q.FavoriteCount+1) as Rank, q.Score, q.ViewCount, q.Tags, q.CreationDate, q.CommentCount, q.AnswerCount, q.FavoriteCount, 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.FavoriteCount, q.CreationDate, q.Tags, q.Score, q.ViewCount, q.AnswerCount, p.ParentId order by Rank desc