So a little while back I created this query to retrieve the most commonly visited pages in my apex 5.0 application. I then altered it a little bit to fit into a dynamic list. This query will return the top ten most visited pages excluding the pages in the page group utility (which for me is things like the login page and homepage). It is set up so that it it will only count 1 visit to the page per minute as a hit on the page because I have a few pages that are refreshing at a high frequency.
Any questions/concerns/compliments/improvements are welcome: