CREATE TABLE report_exit_points
(
	id_site MEDIUMINT NOT NULL DEFAULT  0 ,
	hour INTEGER NOT NULL DEFAULT  0 ,
	url TEXT NOT NULL DEFAULT '',
	number MEDIUMINT NOT NULL DEFAULT  0 ,
	INDEX idx (id_site,hour)
) Type=MyISAM
;

CREATE TABLE report_month_exit_points
(
	id_site MEDIUMINT NOT NULL DEFAULT  0 ,
	day INTEGER NOT NULL DEFAULT  0 ,
	url TEXT NOT NULL DEFAULT '',
	number MEDIUMINT NOT NULL DEFAULT  0 ,
	INDEX idx (id_site,day),
) Type=MyISAM
;

SELECT
		SUM(number) as number,url
	FROM (
		SELECT number,url
		FROM report_exit_points
		WHERE id_site= 444  AND hour BETWEEN  1133395200  AND  1135295999 
		UNION ALL
			SELECT number,url
			FROM report_month_exit_points
			WHERE id_site= 444  AND day BETWEEN  1133395200  AND  1135295999 
	) AS t
	GROUP BY url
	ORDER BY number DESC,url ASC
	LIMIT  10 , 10 	

WHERE id_site= 444  AND day BETWEEN  1133395200  AND  1135295999 

C:\work\web\counter\tmp>mysql < sql
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1       PRIMARY <derived2>      ALL     NULL    NULL    NULL    NULL    25390   Using temporary; Using filesort
2       DERIVED report_exit_points      range   idx     idx     7       NULL    24798   Using where
3       UNION   report_month_exit_points        range   idx     idx     7       NULL    1566    Using where
NULL    UNION RESULT    <union2,3>      ALL     NULL    NULL    NULL    NULL    NULL