Obscure posts especially valued, particularly within the community

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

-- Finds posts that are highly-valued (score >= 10) and orders them how many views per
-- post, descending. Low views per post means that a higher proportion of the value
-- is within the community.

select
  round((viewcount * 1.0 / score), 0) as viewsPerPoint, viewcount, score,
  creationdate, (case when posttypeid = 1 then 'Q' else 'A' end) as posttype,
  id as [Post Link]
from
(
  select p1.id, p1.posttypeid, p1.score, p1.creationdate,
    (case when p1.posttypeid = 1 then p1.viewcount else p2.viewcount end) as viewcount
  from posts p1
  left outer join posts p2
    on p1.parentid = p2.id
  where p1.score >= 10
  and (p1.posttypeid = 1 or p1.posttypeid = 2)
) QApostsWithViewcounts
order by (viewcount * 1.0 / score) asc

Enter Parameters

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