> Users | Pages
> -----------------------------
> pepe | index.html
> johnsen | about.html
> paco | about.html
> paco | index.html
> pepe | download.html
>
>
> It's easy to see the last 5, or 10, or 15 pages that an user has seen,
> or the last users that have viewed a page. But how can I find out the 5
> most seen pages
It's an easier problem than you think. =)
select pages, count(*) from table group by pages order by count(*) desc
limit 5;