Most popular questions (with Q&A stats)


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 20
  format(q.creationdate,'yyyy-MMM-dd') dt, [Post Link],
  q.viewcount [# Views],
  q.commentcount [#Comments],
  q.favoritecount [#Favs],
  q.score [Q Score],
  q.answercount [# Answers],
  avg(a.score)[Avg A Score],
  max(a.score)[Max A Score],
from posts q left join posts a on
where q.viewcount>1000000 
  and q.posttypeid=1 and a.posttypeid=2
group by format(q.creationdate,'yyyy-MMM-dd'),,q.viewcount,q.answercount,
order by q.viewcount desc

Enter Parameters

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