It's not that simple unfortunately, this is what I have but I don't think its accurate:
CREATE TEMPORARY TABLE `tmp` SELECT `url`, COUNT(DISTINCT `host name`) AS `num` FROM `access_log` WHERE `date` = '0000-00-00' GROUP BY `host name` ORDER BY `num` DESC;
SELECT `url`, SUM(`num`) AS `num` FROM...