Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Remember

How to get the total number of views of all the questions (sum of views of all question) ?

0 votes

2.9k views

asked Feb 19, 2014 in Q2A Core by Deepak Yadav

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

commented Feb 20, 2014 by offline

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 =)

Please log in or register to add a comment.

+1 vote

answered Feb 19, 2014 by Victor
selected Feb 19, 2014 by Deepak Yadav

Best answer

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

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

commented Feb 20, 2014 by q2amarket

Just to make sure to exclude flagged items in query.

commented Nov 18, 2018 by vivian

How to get total question views of each user?

Welcome to the Q&A site for Question2Answer.

If you have a question about Q2A, please ask here, in English.

To report a bug, please create a new issue on Github or ask a question here with the bug tag.

If you just want to try Q2A, please use the demo site.