SAVL for answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select top 10000 rank() over (order by Exponent desc) as Rank
  , R.Id as [Post Link]
  , R.ScoreRank, R.SAVL
  , R.Exponent
from (
  select rank() over (order by A.Score desc) as ScoreRank
    , A.Id, A.Score
    , cast(2 as float(53))/(1 + exp(-(cast(1 as float(53))/##a?80##)*(A.Score)*(1 + ##b?49##*cast(A.Score as float(53))/Q.ViewCount))) - 1 as SAVL
    , (cast(1 as float(53))/##a?80##)*(A.Score)*(1 + ##b?49##*cast(A.Score as float(53))/Q.ViewCount) as Exponent
  from Posts A
  inner join (
    select P.Id, max(P.ViewCount) as ViewCount
    from Posts P
    inner join PostTags PT on PT.PostId = P.Id
    inner join Tags T on T.Id = PT.TagId
    where ('##TagName?^_^##' = '^_^' or T.TagName = '##TagName?^_^##')
      and P.CreationDate >= dateadd(year, -(1+##MaxYearsElapsed?100##), getdate())
    group by P.Id
    ) Q on Q.Id = A.ParentId
  where (##UserId?-1## = -1 or A.OwnerUserId = ##UserId?-1##)
    --and A.CommunityOwnedDate is null
  ) R
--where R.SAVL >= 0.99

Enter Parameters

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