Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
in Q2A Core by
How to get the sum of views of all questions ?
This will indicate the total number of views progress  / Give an indication of usage of site ?
Q2A version: 1.5.3
interesting idea to show this information frontend!

In my forum http://www.gute-mathe-fragen.de/ I get a sum of 3.530.569 views =)

1 Answer

+1 vote
selected by
Best answer

To get the total number of views of all questions, use this query:

SELECT SUM(views) FROM `qa_posts` WHERE type='Q'

Just to make sure to exclude flagged items in query.
How to get total question views of each user?