mysql> select url,count(*) as count from access_log 
      group by url order 
      by count desc limit 10;

+-------------------------------+----------+
| url                           | count    |
+-------------------------------+----------+
| /stylesheets/default.css      | 555      |
| /                             | 89       |
| /icons/phoenix_smallest.gif   | 64       |
| /~lstein/text.html            | 62       |
| /jade/                        | 60       |
| /AcePerl/                     | 52       |
| /~lstein/directory.html       | 51       |
| /~lstein/                     | 45       |
| /icons/new.gif                | 44       |
| /software/boulder/            | 43       |
+-------------------------------+----------+
10 rows in set (0.27 sec)