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.

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 not (pp.closeddate is null)) AvgAnswerScore,
  tags
from posts p
where viewcount>1000000
order by viewcount desc

view current version

edited dec 4 19

created dec 4 19 ashleedawg