CREATE TABLE getCount (
   id int(32) NOT NULL auto_increment,
   maillistID int(32) NOT NULL,
   Count int(32) NOT NULL,
   PRIMARY KEY (id)
);




CREATE TABLE ipaddress (
   id int(16) NOT NULL auto_increment,
   num1 varchar(32) NOT NULL,
   num2 varchar(32) NOT NULL,
   Sc varchar(10) NOT NULL,
   PRIMARY KEY (id)
);

INSERT INTO ipaddress VALUES('1', '973996032', '974782463', 'CN');
INSERT INTO ipaddress VALUES('2', '975044608', '977272831', 'CN');
INSERT INTO ipaddress VALUES('3', '977403904', '977534975', 'CN');
INSERT INTO ipaddress VALUES('4', '977567744', '977600511', 'CN');
INSERT INTO ipaddress VALUES('5', '978452480', '978583551', 'CN');
INSERT INTO ipaddress VALUES('6', '978796544', '978812927', 'CN');
INSERT INTO ipaddress VALUES('7', '979599360', '979763199', 'CN');
INSERT INTO ipaddress VALUES('8', '980680704', '980942847', 'CN');
INSERT INTO ipaddress VALUES('9', '981467136', '981991423', 'CN');
INSERT INTO ipaddress VALUES('10', '982515712', '982581247', 'CN');
INSERT INTO ipaddress VALUES('11', '983171072', '983302143', 'CN');
INSERT INTO ipaddress VALUES('12', '985661440', '987758591', 'CN');
INSERT INTO ipaddress VALUES('13', '988807168', '989855743', 'CN');
INSERT INTO ipaddress VALUES('14', '991952896', '995360767', 'CN');
INSERT INTO ipaddress VALUES('15', '996868096', '997195775', 'CN');
INSERT INTO ipaddress VALUES('16', '999751680', '999784447', 'CN');
INSERT INTO ipaddress VALUES('17', '1000013824', '1000079359', 'CN');
INSERT INTO ipaddress VALUES('18', '1001127936', '1001390079', 'CN');
INSERT INTO ipaddress VALUES('19', '1002373120', '1002405887', 'CN');
INSERT INTO ipaddress VALUES('20', '1002434560', '1008730111', 'CN');
INSERT INTO ipaddress VALUES('21', '1010237440', '1010302975', 'CN');
INSERT INTO ipaddress VALUES('22', '1010761728', '1010827263', 'CN');
INSERT INTO ipaddress VALUES('23', '1017118720', '1019215871', 'CN');
INSERT INTO ipaddress VALUES('24', '1019346944', '1019478015', 'CN');
INSERT INTO ipaddress VALUES('25', '1019740160', '1021313023', 'CN');
INSERT INTO ipaddress VALUES('26', '1021837312', '1021968383', 'CN');
INSERT INTO ipaddress VALUES('27', '1022033920', '1022099455', 'CN');
INSERT INTO ipaddress VALUES('28', '1022722048', '1022754815', 'CN');
INSERT INTO ipaddress VALUES('29', '1022820352', '1022885887', 'CN');
INSERT INTO ipaddress VALUES('30', '1023148032', '1023213567', 'CN');
INSERT INTO ipaddress VALUES('31', '1023246336', '1023279103', 'CN');
INSERT INTO ipaddress VALUES('32', '1023344640', '1023410175', 'CN');
INSERT INTO ipaddress VALUES('33', '1023692800', '1023696895', 'CN');
INSERT INTO ipaddress VALUES('34', '1023717376', '1023721471', 'CN');
INSERT INTO ipaddress VALUES('35', '1023975424', '1023979519', 'CN');
INSERT INTO ipaddress VALUES('36', '1024335112', '1024335119', 'CN');
INSERT INTO ipaddress VALUES('37', '1024335184', '1024335199', 'CN');
INSERT INTO ipaddress VALUES('38', '1025245184', '1025277951', 'CN');
INSERT INTO ipaddress VALUES('39', '1025343488', '1025376255', 'CN');
INSERT INTO ipaddress VALUES('40', '1026392064', '1026408447', 'CN');
INSERT INTO ipaddress VALUES('41', '1026523136', '1026539519', 'CN');
INSERT INTO ipaddress VALUES('42', '1026555904', '1027080191', 'CN');
INSERT INTO ipaddress VALUES('43', '1029160960', '1029177343', 'CN');
INSERT INTO ipaddress VALUES('44', '1031798784', '1033982787', 'CN');
INSERT INTO ipaddress VALUES('45', '1033982789', '1034001207', 'CN');
INSERT INTO ipaddress VALUES('46', '1034001216', '1035993087', 'CN');
INSERT INTO ipaddress VALUES('47', '1037591500', '1037591503', 'CN');
INSERT INTO ipaddress VALUES('48', '1038614528', '1039007743', 'CN');
INSERT INTO ipaddress VALUES('49', '1039138816', '1039400959', 'CN');
INSERT INTO ipaddress VALUES('50', '1050616656', '1050616671', 'CN');
INSERT INTO ipaddress VALUES('51', '1050634432', '1050634439', 'CN');
INSERT INTO ipaddress VALUES('52', '1066828152', '1066828159', 'CN');
INSERT INTO ipaddress VALUES('53', '1067617792', '1067618047', 'CN');
INSERT INTO ipaddress VALUES('54', '1067934912', '1067934927', 'CN');
INSERT INTO ipaddress VALUES('55', '1073120286', '1073120295', 'CN');
INSERT INTO ipaddress VALUES('56', '1073120632', '1073120639', 'CN');
INSERT INTO ipaddress VALUES('57', '1073126328', '1073126337', 'CN');
INSERT INTO ipaddress VALUES('58', '1074194304', '1074194367', 'CN');
INSERT INTO ipaddress VALUES('59', '1075995568', '1075995583', 'CN');
INSERT INTO ipaddress VALUES('60', '1076029952', '1076030207', 'CN');
INSERT INTO ipaddress VALUES('61', '1076034048', '1076034063', 'CN');
INSERT INTO ipaddress VALUES('62', '1077005296', '1077005303', 'CN');
INSERT INTO ipaddress VALUES('63', '1077858016', '1077858047', 'CN');
INSERT INTO ipaddress VALUES('64', '1077865984', '1077866239', 'CN');
INSERT INTO ipaddress VALUES('65', '1077870336', '1077870591', 'CN');
INSERT INTO ipaddress VALUES('66', '1078433632', '1078433663', 'CN');
INSERT INTO ipaddress VALUES('67', '1078438912', '1078439167', 'CN');
INSERT INTO ipaddress VALUES('68', '1082091264', '1082091271', 'CN');
INSERT INTO ipaddress VALUES('69', '1088453857', '1088453870', 'CN');
INSERT INTO ipaddress VALUES('70', '1091798640', '1091798647', 'CN');
INSERT INTO ipaddress VALUES('71', '1091798784', '1091799039', 'CN');
INSERT INTO ipaddress VALUES('72', '1091803136', '1091803391', 'CN');
INSERT INTO ipaddress VALUES('73', '1091812352', '1091812607', 'CN');
INSERT INTO ipaddress VALUES('74', '1097742682', '1097742691', 'CN');
INSERT INTO ipaddress VALUES('75', '1113640397', '1113640416', 'CN');
INSERT INTO ipaddress VALUES('76', '1114584520', '1114584529', 'CN');
INSERT INTO ipaddress VALUES('77', '1115074680', '1115074687', 'CN');
INSERT INTO ipaddress VALUES('78', '1117815296', '1117815551', 'CN');
INSERT INTO ipaddress VALUES('79', '1117823488', '1117823743', 'CN');
INSERT INTO ipaddress VALUES('80', '1136658088', '1136658095', 'CN');
INSERT INTO ipaddress VALUES('81', '1136661344', '1136661351', 'CN');
INSERT INTO ipaddress VALUES('82', '1136663576', '1136663583', 'CN');
INSERT INTO ipaddress VALUES('83', '1136685232', '1136685239', 'CN');
INSERT INTO ipaddress VALUES('84', '1137378320', '1137378335', 'CN');
INSERT INTO ipaddress VALUES('85', '1163870576', '1163870583', 'CN');
INSERT INTO ipaddress VALUES('86', '1163878400', '1163878407', 'CN');
INSERT INTO ipaddress VALUES('87', '1208198792', '1208198799', 'CN');
INSERT INTO ipaddress VALUES('88', '1210098776', '1210098783', 'CN');
INSERT INTO ipaddress VALUES('89', '1211602240', '1211602247', 'CN');
INSERT INTO ipaddress VALUES('90', '1211609000', '1211609007', 'CN');
INSERT INTO ipaddress VALUES('91', '1211610464', '1211610479', 'CN');
INSERT INTO ipaddress VALUES('92', '1247202872', '1247202879', 'CN');
INSERT INTO ipaddress VALUES('93', '1266609408', '1266609415', 'CN');
INSERT INTO ipaddress VALUES('94', '1279962912', '1279962927', 'CN');
INSERT INTO ipaddress VALUES('95', '1279962944', '1279962975', 'CN');
INSERT INTO ipaddress VALUES('96', '1351800352', '1351800359', 'CN');
INSERT INTO ipaddress VALUES('97', '1441384608', '1441384639', 'CN');
INSERT INTO ipaddress VALUES('98', '1539631104', '1539632127', 'CN');
INSERT INTO ipaddress VALUES('99', '1946222592', '1946943487', 'CN');
INSERT INTO ipaddress VALUES('100', '1947009024', '1947074559', 'CN');
INSERT INTO ipaddress VALUES('101', '1947205632', '1948254207', 'CN');
INSERT INTO ipaddress VALUES('102', '1949564928', '1949958143', 'CN');
INSERT INTO ipaddress VALUES('103', '1949990912', '1949995007', 'CN');
INSERT INTO ipaddress VALUES('104', '1950011392', '1950015487', 'CN');
INSERT INTO ipaddress VALUES('105', '1950089216', '1950351359', 'CN');
INSERT INTO ipaddress VALUES('106', '1950482432', '1950515199', 'CN');
INSERT INTO ipaddress VALUES('107', '1950679040', '1950777343', 'CN');
INSERT INTO ipaddress VALUES('108', '1951137792', '1951399935', 'CN');
INSERT INTO ipaddress VALUES('109', '1952026624', '1952030719', 'CN');
INSERT INTO ipaddress VALUES('110', '1952102400', '1952104447', 'CN');
INSERT INTO ipaddress VALUES('111', '1952382976', '1952448511', 'CN');
INSERT INTO ipaddress VALUES('112', '1953497088', '1953890303', 'CN');
INSERT INTO ipaddress VALUES('113', '1954545664', '1958805503', 'CN');
INSERT INTO ipaddress VALUES('114', '1958809600', '1958821887', 'CN');
INSERT INTO ipaddress VALUES('115', '1958871040', '1959067647', 'CN');
INSERT INTO ipaddress VALUES('116', '1959133184', '1959239679', 'CN');
INSERT INTO ipaddres