Most and list toxic tags to question about (among 1000 most asked)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

with q as (
  select count(*) as cnt, t.id as tagid, t.tagname, v.votetypeid
  from (select top 1000 * from tags t order by t.count desc) as t
    join posttags pt on pt.tagid = t.id
    join posts p on p.id = pt.postid
    join votes v on v.postid = p.id
  where v.votetypeid in (2, 3) and p.posttypeid = 1
  group by t.id, t.tagname, v.votetypeid
)
select q.tagname AS [Tag], q.tagid AS [Tag ID], q.cnt AS [Upvotes], qq.cnt AS [Downvotes], ROUND(100.0 * qq.cnt / NULLIF(q.cnt, 0), 2) AS [D/U ratio]
from q
join q qq on q.tagname = qq.tagname and qq.votetypeid = 3
where q.votetypeid = 2
order by q.tagname

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results