I’m running a website and we use the Sabai Discuss plugin. We have multiple cities and in each city multiple venues and in each venue the same 4 questions which have user generated answers.

By looking at the website front end I can see how many views each question has, ie

city 1  – venue 1 – question 1 – 1234 views
city 1  – venue 1 – question 2 – 400 views
city 1  – venue 1 – question 3 – 6000 views
city 1  – venue 1 – question 4 – 1645 views

city 2  – venue 3 – question 1 – 8443 views
city 2  – venue 3 – question 2 – 3421 views
city 2 – venue 3 – question 3 – 1231 views
city 2  – venue 3 – question 4 – 7125 views

etc, etc.  We have hundreds of cities with hundreds of venues so thousands of questions / answers.

I want to run a process that collects the statistics on which questions have the most amount of views. Some sort of output that looks like:

city 2  – venue 3 – question 1 – 8443 views
city 2  – venue 3 – question 4 – 7125 views
city 1  – venue 1 – question 3 – 6000 views
city 2  – venue 3 – question 2 – 3421 views
city 1  – venue 1 – question 4 – 1645 views
city 1  – venue 1 – question 1 – 1234 views
city 2 – venue 3 – question 3 – 1231 views
city 1  – venue 1 – question 2 – 400 views

Can someone suggest how I can do this? I have thousands of questions/answers and I don’t want to manually go through every venue and collate that way. Surely theres a process I can run that would output this somewhere/somehow?

All help appreciated!

Cheers 🙂