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 
  left(creationdate,10) dt,
  id [Post Link],
  viewcount Views,
  answercount Answers,
  commentcount Comments,
  favoritecount CommentFavs,
  Score,
  (select round(sum(score)/sum(1),1) AvgScore from posts pp where pp.parentid=p.id and pp.closeddate is null) AvgAnswerScore,
  tags
from posts p
where viewcount>1000000
order by viewcount desc

Enter Parameters

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