Most popular questions (with Q&A stats)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Includes questions that have at least 5 million views.

Linguistics Meta

Q&A about the site for professional linguists and others with an interest in linguistic research and theory

select top 5
  left(q.creationdate,10) dt,
  q.id [Post Link],
  q.viewcount Views,
  q.answercount Answers,
  q.commentcount Comments,
  q.favoritecount CommentFavs,
  q.Score,
  -- -(select round(avg(score),1) AvgScore from posts pp where pp.parentid=p.id and pp.closeddate is null) AvgAnswerScore,
  avg(a.score) cnt2,
  q.tags
from posts q left join posts a on q.id=a.parentid
where q.viewcount>1000000 
  and q.posttypeid=1 and a.posttypeid=2
group by left(q.creationdate,10), q.id,q.viewcount,q.answercount,q.commentcount,q.favoritecount,q.Score,q.tags
order by q.viewcount desc

Enter Parameters

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