I am trying to get a handle on selecting the top 10 entry and exit pages of my apache access_log database. I log the url, host name etc. This is what I have for top 10 popular URL's if its any help:
SELECT `url`, COUNT(`url`) AS `num` FROM `access_log` WHERE `date` = '0000-00-00' GROUP BY...