ViewCount scaling

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A about the Stack Exchange Network

select q.ViewCount, power(log10(q.ViewCount), 5) "log10(VeiwCount)^5"
from Posts q
     join Posts a on (q.Id = a.ParentId)
     join Posts o on (q.Id = o.ParentId)
where a.Score > 0
      and o.Score > 0
group by q.ViewCount
order by q.ViewCount

Enter Parameters

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