P3ah1afD

1SELECT MAX(no_hits) from (SELECT count(hits) AS 'no_hits' ) FROM stats WHERE 'date' >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH AND zones_code IN('011242077793513596890', '011242077783866125432'))
2	
3SELECT MAX(no_hits) 
4FROM (SELECT count(hits) AS 'no_hits' ) FROM stats 
5  WHERE 'date' >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH 
6    AND zones_code IN('011242077793513596890', '011242077783866125432')
7);
8	
9SELECT `zones_code`, SUM(`hits`) AS `no_hits`
10FROM `stats`
11WHERE `date` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)
12GROUP BY `zones_code`
13ORDER BY `no_hits` DESC
14LIMIT 1;
15	
16CREATE TABLE IF NOT EXISTS `stats` (
17  `id` int(11) NOT NULL,
18  `zones_code` char(21) default NULL,
19  `date` date default NULL,
20  `hits` int(11) default NULL,
21  PRIMARY KEY  (`id`)
22);
23
24INSERT INTO stats VALUES
25(10, '011242077793513596890', '2009-05-11', 13),
26(12, '011242077793513596890', '2009-05-12',235),
27(24, '011242077793513596890', '2009-05-13',  2),
28(32, '011242077793513596890', '2009-05-14',  5),
29(17, '011242077783866125432', '2009-05-12',165),
30(22, '011242077783866125432', '2009-05-13',  2),
31(30, '011242077783866125432', '2009-05-14',  5),
32(19, '011242077743853330663', '2009-05-12', 61),
33(20, '011242077737314753388', '2009-05-12', 54),
34(28, '011242077737314753388', '2009-05-13',  7),
35(36, '011242077737314753388', '2009-05-14', 31),
36(14, '011242077730456603312', '2009-05-12',240),
37(26, '011242077730456603312', '2009-05-13',  2),
38(34, '011242077730456603312', '2009-05-14',  5);
39	
40SELECT `zones_code`, SUM(`hits`) AS `no_hits`
41FROM `stats`
42WHERE `date` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)
43GROUP BY `zones_code`
44ORDER BY `no_hits` DESC
45LIMIT 1