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.

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

select
  format(q.creationdate,'yyyy-MMM-dd') Asked,
  q.id [Post Link],
  len(q.body) Bytes,
  format(q.viewcount,'#,##0') [Views],
  q.commentcount [Cmnts],
  q.commentcount+sum(a.commentcount) [All Cmnts],
  format(q.favoritecount,'#,##0') [Fav],
  format(q.score,'#,##0') [Score],
  q.answercount [Answers],
  format(avg(a.score),'#,##0') [Avg A],
  format(max(a.score),'#,##0') [Max A],
  q.Tags
from posts q left join posts a on q.id=a.parentid
where q.viewcount>2000000 and q.posttypeid=1 and a.posttypeid=2
group by format(q.creationdate,'yyyy-MMM-dd'),len(q.body),q.id,q.viewcount,q.answercount,
  q.commentcount,q.favoritecount,q.Score,q.tags
order by q.viewcount desc

Enter Parameters

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