Compare records in table

Miguel61 · May 29, 2013, 7:04pm

Hello guys, I need your appreciated help.

This is mysql query:

mysql&gt; SELECT
	`YEAR`,
	g,
	COUNT(*) AS number
FROM
	`registered`
WHERE
	(
		`YEAR` &gt; 1970
		AND g NOT IN ('probe')
	)
GROUP BY
	`YEAR`,
	g
ORDER BY
	`YEAR` DESC,
	number DESC;
+------+---+--------+
| YEAR | g | number |
+------+---+--------+
| 2013 | + |     52 |
| 2013 | - |     31 |
| 2012 | + |    426 |
| 2012 | - |     90 |
| 2011 | + |    422 |
| 2011 | - |     89 |
| 2010 | + |    106 |
| 2010 | - |     42 |
+------+---+--------+
8 rows in set

How to do for produce this output?:

+------+---+--------+
| YEAR | g | number |
+------+---+--------+
| 2013 | + |     52 |-88%  ===&gt; (52-426)/426*100
| 2013 | - |     31 |-66%  ===&gt; (31-90)/90*100
| 2012 | + |    426 |+1%   ===&gt; (426-422)/422*100
| 2012 | - |     90 |+1,1% ===&gt; (90-89)/89*100
| 2011 | + |    422 |+298% ===&gt; (422-106)/106*100
| 2011 | - |     89 |+112% ===&gt; (89-42)/42*100
| 2010 | + |    106 |
| 2010 | - |     42 |
+------+---+--------+

Can you help me?
Thanks in advance.

r937 · May 29, 2013, 8:06pm

is it possible for you to create a VIEW?

Miguel61 · May 30, 2013, 7:08pm

[QUOTE=r937;5461354]is it possible for you to create a VIEW?[/QUOTE]
Of course.

DROP TABLE IF EXISTS `registered`;
CREATE TABLE `registered` (
  `Year` int(10) DEFAULT NULL,
  `G` varchar(255) DEFAULT NULL,
  `id` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1889 DEFAULT CHARSET=latin1;

INSERT INTO `registered` VALUES ('2013', '-', '1');
INSERT INTO `registered` VALUES ('2013', '-', '2');
INSERT INTO `registered` VALUES ('2013', 'probe', '3');
INSERT INTO `registered` VALUES ('2013', 'probe', '4');
INSERT INTO `registered` VALUES ('2013', 'probe', '5');
INSERT INTO `registered` VALUES ('2013', '+', '6');
INSERT INTO `registered` VALUES ('2013', '+', '7');
INSERT INTO `registered` VALUES ('2013', '-', '8');
INSERT INTO `registered` VALUES ('2013', '+', '9');
INSERT INTO `registered` VALUES ('2013', '+', '10');
INSERT INTO `registered` VALUES ('2013', 'probe', '11');
INSERT INTO `registered` VALUES ('2013', 'probe', '12');
INSERT INTO `registered` VALUES ('2013', 'probe', '13');
INSERT INTO `registered` VALUES ('2013', 'probe', '14');
INSERT INTO `registered` VALUES ('2013', 'probe', '15');
INSERT INTO `registered` VALUES ('2013', 'probe', '16');
INSERT INTO `registered` VALUES ('2013', 'probe', '17');
INSERT INTO `registered` VALUES ('2013', 'probe', '18');
INSERT INTO `registered` VALUES ('2013', 'probe', '19');
INSERT INTO `registered` VALUES ('2013', 'probe', '20');
INSERT INTO `registered` VALUES ('2013', 'probe', '21');
INSERT INTO `registered` VALUES ('2013', 'probe', '22');
INSERT INTO `registered` VALUES ('2013', 'probe', '23');
INSERT INTO `registered` VALUES ('2013', 'probe', '24');
INSERT INTO `registered` VALUES ('2013', 'probe', '25');
INSERT INTO `registered` VALUES ('2013', 'probe', '26');
INSERT INTO `registered` VALUES ('2013', 'probe', '27');
INSERT INTO `registered` VALUES ('2013', 'probe', '28');
INSERT INTO `registered` VALUES ('2013', 'probe', '29');
INSERT INTO `registered` VALUES ('2013', '-', '30');
INSERT INTO `registered` VALUES ('2013', '+', '31');
INSERT INTO `registered` VALUES ('2013', 'probe', '32');
INSERT INTO `registered` VALUES ('2013', '+', '33');
INSERT INTO `registered` VALUES ('2013', '+', '34');
INSERT INTO `registered` VALUES ('2013', 'probe', '35');
INSERT INTO `registered` VALUES ('2013', 'probe', '36');
INSERT INTO `registered` VALUES ('2013', 'probe', '37');
INSERT INTO `registered` VALUES ('2013', 'probe', '38');
INSERT INTO `registered` VALUES ('2013', 'probe', '39');
INSERT INTO `registered` VALUES ('2013', 'probe', '40');
INSERT INTO `registered` VALUES ('2013', 'probe', '41');
INSERT INTO `registered` VALUES ('2013', 'probe', '42');
INSERT INTO `registered` VALUES ('2013', 'probe', '43');
INSERT INTO `registered` VALUES ('2013', 'probe', '44');
INSERT INTO `registered` VALUES ('2013', 'probe', '45');
INSERT INTO `registered` VALUES ('2013', 'probe', '46');
INSERT INTO `registered` VALUES ('2013', 'probe', '47');
INSERT INTO `registered` VALUES ('2013', 'probe', '48');
INSERT INTO `registered` VALUES ('2013', 'probe', '49');
INSERT INTO `registered` VALUES ('2013', 'probe', '50');
INSERT INTO `registered` VALUES ('2013', 'probe', '51');
INSERT INTO `registered` VALUES ('2013', 'probe', '52');
INSERT INTO `registered` VALUES ('2013', 'probe', '53');
INSERT INTO `registered` VALUES ('2013', 'probe', '54');
INSERT INTO `registered` VALUES ('2013', 'probe', '55');
INSERT INTO `registered` VALUES ('2013', 'probe', '56');
INSERT INTO `registered` VALUES ('2013', 'probe', '57');
INSERT INTO `registered` VALUES ('2013', 'probe', '58');
INSERT INTO `registered` VALUES ('2013', 'probe', '59');
INSERT INTO `registered` VALUES ('2013', 'probe', '60');
INSERT INTO `registered` VALUES ('2013', 'probe', '61');
INSERT INTO `registered` VALUES ('2013', 'probe', '62');
INSERT INTO `registered` VALUES ('2013', 'probe', '63');
INSERT INTO `registered` VALUES ('2013', 'probe', '64');
INSERT INTO `registered` VALUES ('2013', 'probe', '65');
INSERT INTO `registered` VALUES ('2013', 'probe', '66');
INSERT INTO `registered` VALUES ('2013', '+', '67');
INSERT INTO `registered` VALUES ('2013', 'probe', '68');
INSERT INTO `registered` VALUES ('2013', 'probe', '69');
INSERT INTO `registered` VALUES ('2013', '+', '70');
INSERT INTO `registered` VALUES ('2013', '-', '71');
INSERT INTO `registered` VALUES ('2013', '+', '72');
INSERT INTO `registered` VALUES ('2013', '-', '73');
INSERT INTO `registered` VALUES ('2013', '-', '74');
INSERT INTO `registered` VALUES ('2013', '-', '75');
INSERT INTO `registered` VALUES ('2013', '+', '76');
INSERT INTO `registered` VALUES ('2013', '-', '77');
INSERT INTO `registered` VALUES ('2013', '-', '78');
INSERT INTO `registered` VALUES ('2013', '-', '79');
INSERT INTO `registered` VALUES ('2013', '-', '80');
INSERT INTO `registered` VALUES ('2013', 'probe', '81');
INSERT INTO `registered` VALUES ('2013', 'probe', '82');
INSERT INTO `registered` VALUES ('2013', 'probe', '83');
INSERT INTO `registered` VALUES ('2013', 'probe', '84');
INSERT INTO `registered` VALUES ('2013', '+', '85');
INSERT INTO `registered` VALUES ('2013', '+', '86');
INSERT INTO `registered` VALUES ('2013', '+', '87');
INSERT INTO `registered` VALUES ('2013', 'probe', '88');
INSERT INTO `registered` VALUES ('2013', '+', '89');
INSERT INTO `registered` VALUES ('2013', '+', '90');
INSERT INTO `registered` VALUES ('2013', '-', '91');
INSERT INTO `registered` VALUES ('2013', '-', '92');
INSERT INTO `registered` VALUES ('2013', '-', '93');
INSERT INTO `registered` VALUES ('2013', '+', '94');
INSERT INTO `registered` VALUES ('2013', '+', '95');
INSERT INTO `registered` VALUES ('2013', '+', '96');
INSERT INTO `registered` VALUES ('2013', 'probe', '97');
INSERT INTO `registered` VALUES ('2013', 'probe', '98');
INSERT INTO `registered` VALUES ('2013', '-', '99');
INSERT INTO `registered` VALUES ('2013', '-', '100');
INSERT INTO `registered` VALUES ('2013', '+', '101');
INSERT INTO `registered` VALUES ('2013', '-', '102');
INSERT INTO `registered` VALUES ('2013', '-', '103');
INSERT INTO `registered` VALUES ('2013', '+', '104');
INSERT INTO `registered` VALUES ('2013', '-', '105');
INSERT INTO `registered` VALUES ('2013', '-', '106');
INSERT INTO `registered` VALUES ('2013', '+', '107');
INSERT INTO `registered` VALUES ('2013', 'probe', '108');
INSERT INTO `registered` VALUES ('2013', '+', '109');
INSERT INTO `registered` VALUES ('2013', '+', '110');
INSERT INTO `registered` VALUES ('2013', '+', '111');
INSERT INTO `registered` VALUES ('2013', 'probe', '112');
INSERT INTO `registered` VALUES ('2013', '+', '113');
INSERT INTO `registered` VALUES ('2013', 'probe', '114');
INSERT INTO `registered` VALUES ('2013', 'probe', '115');
INSERT INTO `registered` VALUES ('2013', '+', '116');
INSERT INTO `registered` VALUES ('2013', 'probe', '117');
INSERT INTO `registered` VALUES ('2013', '+', '118');
INSERT INTO `registered` VALUES ('2013', '+', '119');
INSERT INTO `registered` VALUES ('2013', '-', '120');
INSERT INTO `registered` VALUES ('2013', '+', '121');
INSERT INTO `registered` VALUES ('2013', 'probe', '122');
INSERT INTO `registered` VALUES ('2013', 'probe', '123');
INSERT INTO `registered` VALUES ('2013', '+', '124');
INSERT INTO `registered` VALUES ('2013', '-', '125');
INSERT INTO `registered` VALUES ('2013', 'probe', '126');
INSERT INTO `registered` VALUES ('2013', '+', '127');
INSERT INTO `registered` VALUES ('2013', 'probe', '128');
INSERT INTO `registered` VALUES ('2013', '+', '129');
INSERT INTO `registered` VALUES ('2013', 'probe', '130');
INSERT INTO `registered` VALUES ('2013', 'probe', '131');
INSERT INTO `registered` VALUES ('2013', '+', '132');
INSERT INTO `registered` VALUES ('2013', '+', '133');
INSERT INTO `registered` VALUES ('2013', '+', '134');
INSERT INTO `registered` VALUES ('2013', '+', '135');
INSERT INTO `registered` VALUES ('2013', '+', '136');
INSERT INTO `registered` VALUES ('2013', '+', '137');
INSERT INTO `registered` VALUES ('2013', 'probe', '138');
INSERT INTO `registered` VALUES ('2013', '-', '139');
INSERT INTO `registered` VALUES ('2013', 'probe', '140');
INSERT INTO `registered` VALUES ('2013', '+', '141');
INSERT INTO `registered` VALUES ('2013', '+', '142');
INSERT INTO `registered` VALUES ('2013', '+', '143');
INSERT INTO `registered` VALUES ('2013', '+', '144');
INSERT INTO `registered` VALUES ('2013', '-', '145');
INSERT INTO `registered` VALUES ('2013', '-', '146');
INSERT INTO `registered` VALUES ('2013', '-', '147');
INSERT INTO `registered` VALUES ('2013', '-', '148');
INSERT INTO `registered` VALUES ('2013', '+', '149');
INSERT INTO `registered` VALUES ('2013', 'probe', '150');
INSERT INTO `registered` VALUES ('2013', 'probe', '151');
INSERT INTO `registered` VALUES ('2013', '-', '152');
INSERT INTO `registered` VALUES ('2013', '-', '153');
INSERT INTO `registered` VALUES ('2013', '+', '154');
INSERT INTO `registered` VALUES ('2013', 'probe', '155');
INSERT INTO `registered` VALUES ('2013', 'probe', '156');
INSERT INTO `registered` VALUES ('1970', 'probe', '157');
INSERT INTO `registered` VALUES ('2013', 'probe', '158');
INSERT INTO `registered` VALUES ('2013', 'probe', '159');
INSERT INTO `registered` VALUES ('2013', '+', '160');
INSERT INTO `registered` VALUES ('2013', '-', '161');
INSERT INTO `registered` VALUES ('2013', 'probe', '162');
INSERT INTO `registered` VALUES ('2013', 'probe', '163');
INSERT INTO `registered` VALUES ('2013', 'probe', '164');
INSERT INTO `registered` VALUES ('2013', '+', '165');
INSERT INTO `registered` VALUES ('2013', '+', '166');
INSERT INTO `registered` VALUES ('2013', 'probe', '167');
INSERT INTO `registered` VALUES ('2013', '+', '168');
INSERT INTO `registered` VALUES ('2013', 'probe', '169');
INSERT INTO `registered` VALUES ('2013', '+', '170');
INSERT INTO `registered` VALUES ('2013', '+', '171');
INSERT INTO `registered` VALUES ('2013', '+', '172');
INSERT INTO `registered` VALUES ('2012', '+', '173');
INSERT INTO `registered` VALUES ('2012', 'probe', '174');
INSERT INTO `registered` VALUES ('2012', 'probe', '175');
INSERT INTO `registered` VALUES ('2012', 'probe', '176');
INSERT INTO `registered` VALUES ('2012', 'probe', '177');
INSERT INTO `registered` VALUES ('2012', 'probe', '178');
INSERT INTO `registered` VALUES ('2012', 'probe', '179');
INSERT INTO `registered` VALUES ('2012', 'probe', '180');
INSERT INTO `registered` VALUES ('2012', 'probe', '181');
INSERT INTO `registered` VALUES ('2012', 'probe', '182');
INSERT INTO `registered` VALUES ('2012', 'probe', '183');
INSERT INTO `registered` VALUES ('2012', 'probe', '184');
INSERT INTO `registered` VALUES ('2012', 'probe', '185');
INSERT INTO `registered` VALUES ('2012', 'probe', '186');
INSERT INTO `registered` VALUES ('2012', 'probe', '187');
INSERT INTO `registered` VALUES ('2012', 'probe', '188');
INSERT INTO `registered` VALUES ('2012', 'probe', '189');
INSERT INTO `registered` VALUES ('2012', 'probe', '190');
INSERT INTO `registered` VALUES ('2012', 'probe', '191');
INSERT INTO `registered` VALUES ('2012', 'probe', '192');
INSERT INTO `registered` VALUES ('2012', 'probe', '193');
INSERT INTO `registered` VALUES ('2012', 'probe', '194');
INSERT INTO `registered` VALUES ('2012', 'probe', '195');
INSERT INTO `registered` VALUES ('2012', 'probe', '196');
INSERT INTO `registered` VALUES ('2012', 'probe', '197');
INSERT INTO `registered` VALUES ('2012', 'probe', '198');
INSERT INTO `registered` VALUES ('2012', 'probe', '199');
INSERT INTO `registered` VALUES ('2012', 'probe', '200');
INSERT INTO `registered` VALUES ('2012', 'probe', '201');
INSERT INTO `registered` VALUES ('2012', 'probe', '202');
INSERT INTO `registered` VALUES ('2012', 'probe', '203');
INSERT INTO `registered` VALUES ('2012', 'probe', '204');
INSERT INTO `registered` VALUES ('2012', 'probe', '205');
INSERT INTO `registered` VALUES ('2012', 'probe', '206');
INSERT INTO `registered` VALUES ('2012', 'probe', '207');
INSERT INTO `registered` VALUES ('2012', 'probe', '208');
INSERT INTO `registered` VALUES ('2012', '+', '209');
INSERT INTO `registered` VALUES ('2012', '+', '210');
INSERT INTO `registered` VALUES ('2012', '+', '211');
INSERT INTO `registered` VALUES ('2012', '+', '212');
INSERT INTO `registered` VALUES ('2012', '+', '213');
INSERT INTO `registered` VALUES ('2012', '+', '214');
INSERT INTO `registered` VALUES ('2012', '+', '215');
INSERT INTO `registered` VALUES ('2012', 'probe', '216');
INSERT INTO `registered` VALUES ('2012', 'probe', '217');
INSERT INTO `registered` VALUES ('2012', 'probe', '218');
INSERT INTO `registered` VALUES ('2012', '-', '219');
INSERT INTO `registered` VALUES ('2012', '+', '220');
INSERT INTO `registered` VALUES ('2012', '+', '221');
INSERT INTO `registered` VALUES ('2012', 'probe', '222');
INSERT INTO `registered` VALUES ('2012', '-', '223');
INSERT INTO `registered` VALUES ('2012', '+', '224');
INSERT INTO `registered` VALUES ('2012', '-', '225');
INSERT INTO `registered` VALUES ('2012', '+', '226');
INSERT INTO `registered` VALUES ('2012', '+', '227');
INSERT INTO `registered` VALUES ('2012', '-', '228');
INSERT INTO `registered` VALUES ('2012', '+', '229');
INSERT INTO `registered` VALUES ('2012', '+', '230');
INSERT INTO `registered` VALUES ('2012', '-', '231');
INSERT INTO `registered` VALUES ('2012', '-', '232');
INSERT INTO `registered` VALUES ('2012', '+', '233');
INSERT INTO `registered` VALUES ('2012', '-', '234');
INSERT INTO `registered` VALUES ('2012', '-', '235');
INSERT INTO `registered` VALUES ('2012', '+', '236');
INSERT INTO `registered` VALUES ('2012', '-', '237');
INSERT INTO `registered` VALUES ('2012', '+', '238');
INSERT INTO `registered` VALUES ('2012', '+', '239');
INSERT INTO `registered` VALUES ('2012', '+', '240');
INSERT INTO `registered` VALUES ('2012', '+', '241');
INSERT INTO `registered` VALUES ('2012', '+', '242');
INSERT INTO `registered` VALUES ('2012', '-', '243');
INSERT INTO `registered` VALUES ('2012', '+', '244');
INSERT INTO `registered` VALUES ('2012', '-', '245');
INSERT INTO `registered` VALUES ('2012', '-', '246');
INSERT INTO `registered` VALUES ('2012', '-', '247');
INSERT INTO `registered` VALUES ('2012', '+', '248');
INSERT INTO `registered` VALUES ('2012', '+', '249');
INSERT INTO `registered` VALUES ('2012', '+', '250');
INSERT INTO `registered` VALUES ('2012', '+', '251');
INSERT INTO `registered` VALUES ('2012', 'probe', '252');
INSERT INTO `registered` VALUES ('2012', 'probe', '253');
INSERT INTO `registered` VALUES ('2012', 'probe', '254');
INSERT INTO `registered` VALUES ('2012', 'probe', '255');
INSERT INTO `registered` VALUES ('2012', 'probe', '256');
INSERT INTO `registered` VALUES ('2012', 'probe', '257');
INSERT INTO `registered` VALUES ('2012', 'probe', '258');
INSERT INTO `registered` VALUES ('2012', 'probe', '259');
INSERT INTO `registered` VALUES ('2012', 'probe', '260');
INSERT INTO `registered` VALUES ('2012', 'probe', '261');
INSERT INTO `registered` VALUES ('2012', 'probe', '262');
INSERT INTO `registered` VALUES ('2012', 'probe', '263');
INSERT INTO `registered` VALUES ('2012', 'probe', '264');
INSERT INTO `registered` VALUES ('2012', 'probe', '265');
INSERT INTO `registered` VALUES ('2012', 'probe', '266');
INSERT INTO `registered` VALUES ('2012', '+', '267');
INSERT INTO `registered` VALUES ('2012', '+', '268');
INSERT INTO `registered` VALUES ('2012', '+', '269');
INSERT INTO `registered` VALUES ('2012', '+', '270');
INSERT INTO `registered` VALUES ('2012', '+', '271');
INSERT INTO `registered` VALUES ('2012', '+', '272');
INSERT INTO `registered` VALUES ('2012', 'probe', '273');
INSERT INTO `registered` VALUES ('2012', 'probe', '274');
INSERT INTO `registered` VALUES ('2012', '+', '275');
INSERT INTO `registered` VALUES ('2012', 'probe', '276');
INSERT INTO `registered` VALUES ('2012', 'probe', '277');
INSERT INTO `registered` VALUES ('2012', 'probe', '278');
INSERT INTO `registered` VALUES ('2012', '+', '279');
INSERT INTO `registered` VALUES ('2012', 'probe', '280');
INSERT INTO `registered` VALUES ('2012', '+', '281');
INSERT INTO `registered` VALUES ('2012', '+', '282');
INSERT INTO `registered` VALUES ('2012', 'probe', '283');
INSERT INTO `registered` VALUES ('2012', 'probe', '284');
INSERT INTO `registered` VALUES ('2012', 'probe', '285');
INSERT INTO `registered` VALUES ('2012', '-', '286');
INSERT INTO `registered` VALUES ('2012', '+', '287');
INSERT INTO `registered` VALUES ('2012', '-', '288');
INSERT INTO `registered` VALUES ('2012', '+', '289');
INSERT INTO `registered` VALUES ('2012', '-', '290');
INSERT INTO `registered` VALUES ('2012', '-', '291');
INSERT INTO `registered` VALUES ('2012', '+', '292');
INSERT INTO `registered` VALUES ('2012', '+', '293');
INSERT INTO `registered` VALUES ('2012', 'probe', '294');
INSERT INTO `registered` VALUES ('2012', '-', '295');
INSERT INTO `registered` VALUES ('2012', '-', '296');
INSERT INTO `registered` VALUES ('2012', '+', '297');
INSERT INTO `registered` VALUES ('2012', 'probe', '298');
INSERT INTO `registered` VALUES ('2012', '+', '299');
INSERT INTO `registered` VALUES ('2012', '+', '300');
INSERT INTO `registered` VALUES ('2012', '+', '301');
INSERT INTO `registered` VALUES ('2012', '+', '302');
INSERT INTO `registered` VALUES ('2012', '+', '303');
INSERT INTO `registered` VALUES ('2012', '+', '304');
INSERT INTO `registered` VALUES ('2012', '+', '305');
INSERT INTO `registered` VALUES ('2012', '+', '306');
INSERT INTO `registered` VALUES ('2012', '+', '307');
INSERT INTO `registered` VALUES ('2012', '+', '308');
INSERT INTO `registered` VALUES ('2012', '+', '309');
INSERT INTO `registered` VALUES ('2012', '+', '310');
INSERT INTO `registered` VALUES ('2012', '+', '311');
INSERT INTO `registered` VALUES ('2012', '+', '312');
INSERT INTO `registered` VALUES ('2012', '+', '313');
INSERT INTO `registered` VALUES ('2012', '+', '314');
INSERT INTO `registered` VALUES ('2012', '+', '315');
INSERT INTO `registered` VALUES ('2012', '+', '316');
INSERT INTO `registered` VALUES ('2012', '+', '317');
INSERT INTO `registered` VALUES ('2012', '+', '318');
INSERT INTO `registered` VALUES ('2012', '+', '319');
INSERT INTO `registered` VALUES ('2012', '+', '320');
INSERT INTO `registered` VALUES ('2012', '+', '321');
INSERT INTO `registered` VALUES ('2012', '+', '322');
INSERT INTO `registered` VALUES ('2012', '+', '323');
INSERT INTO `registered` VALUES ('2012', '+', '324');
INSERT INTO `registered` VALUES ('2012', '+', '325');
INSERT INTO `registered` VALUES ('2012', '+', '326');
INSERT INTO `registered` VALUES ('2012', '+', '327');
INSERT INTO `registered` VALUES ('2012', '+', '328');
INSERT INTO `registered` VALUES ('2012', '+', '329');
INSERT INTO `registered` VALUES ('2012', '+', '330');
INSERT INTO `registered` VALUES ('2012', '+', '331');
INSERT INTO `registered` VALUES ('2012', '+', '332');
INSERT INTO `registered` VALUES ('2012', '+', '333');
INSERT INTO `registered` VALUES ('2012', '+', '334');
INSERT INTO `registered` VALUES ('2012', 'probe', '335');
INSERT INTO `registered` VALUES ('2012', 'probe', '336');
INSERT INTO `registered` VALUES ('2012', 'probe', '337');
INSERT INTO `registered` VALUES ('2012', 'probe', '338');
INSERT INTO `registered` VALUES ('2012', 'probe', '339');
INSERT INTO `registered` VALUES ('2012', '+', '340');
INSERT INTO `registered` VALUES ('2012', '+', '341');
INSERT INTO `registered` VALUES ('2012', '+', '342');
INSERT INTO `registered` VALUES ('2012', '+', '343');
INSERT INTO `registered` VALUES ('2012', '+', '344');
INSERT INTO `registered` VALUES ('2012', '+', '345');
INSERT INTO `registered` VALUES ('2012', '+', '346');
INSERT INTO `registered` VALUES ('2012', '+', '347');
INSERT INTO `registered` VALUES ('2012', '+', '348');
INSERT INTO `registered` VALUES ('2012', '+', '349');
INSERT INTO `registered` VALUES ('2012', '+', '350');
INSERT INTO `registered` VALUES ('2012', '+', '351');
INSERT INTO `registered` VALUES ('2012', '+', '352');
INSERT INTO `registered` VALUES ('2012', '+', '353');
INSERT INTO `registered` VALUES ('2012', '+', '354');
INSERT INTO `registered` VALUES ('2012', 'probe', '355');
INSERT INTO `registered` VALUES ('2012', 'probe', '356');
INSERT INTO `registered` VALUES ('2012', 'probe', '357');
INSERT INTO `registered` VALUES ('2012', '-', '358');
INSERT INTO `registered` VALUES ('2012', 'probe', '359');
INSERT INTO `registered` VALUES ('2012', '+', '360');
INSERT INTO `registered` VALUES ('2012', 'probe', '361');
INSERT INTO `registered` VALUES ('2012', '+', '362');
INSERT INTO `registered` VALUES ('2012', '+', '363');
INSERT INTO `registered` VALUES ('2012', '+', '364');
INSERT INTO `registered` VALUES ('2012', '+', '365');
INSERT INTO `registered` VALUES ('2012', '+', '366');
INSERT INTO `registered` VALUES ('2012', '+', '367');
INSERT INTO `registered` VALUES ('2012', '+', '368');
INSERT INTO `registered` VALUES ('2012', '+', '369');
INSERT INTO `registered` VALUES ('2012', 'probe', '370');
INSERT INTO `registered` VALUES ('2012', '-', '371');
INSERT INTO `registered` VALUES ('2012', '+', '372');
INSERT INTO `registered` VALUES ('2012', '+', '373');
INSERT INTO `registered` VALUES ('2012', '+', '374');
INSERT INTO `registered` VALUES ('2012', '+', '375');
INSERT INTO `registered` VALUES ('2012', '-', '376');
INSERT INTO `registered` VALUES ('2012', '+', '377');
INSERT INTO `registered` VALUES ('2012', '+', '378');
INSERT INTO `registered` VALUES ('2012', 'probe', '379');
INSERT INTO `registered` VALUES ('2012', 'probe', '380');
INSERT INTO `registered` VALUES ('2012', 'probe', '381');
INSERT INTO `registered` VALUES ('2012', 'probe', '382');
INSERT INTO `registered` VALUES ('2012', 'probe', '383');
INSERT INTO `registered` VALUES ('2012', '+', '384');
INSERT INTO `registered` VALUES ('2012', '+', '385');
INSERT INTO `registered` VALUES ('2012', '+', '386');
INSERT INTO `registered` VALUES ('2012', 'probe', '387');
INSERT INTO `registered` VALUES ('2012', '-', '388');
INSERT INTO `registered` VALUES ('2012', 'probe', '389');
INSERT INTO `registered` VALUES ('2012', '-', '390');
INSERT INTO `registered` VALUES ('2012', '+', '391');
INSERT INTO `registered` VALUES ('2012', '+', '392');
INSERT INTO `registered` VALUES ('2012', '+', '393');
INSERT INTO `registered` VALUES ('2012', '+', '394');
INSERT INTO `registered` VALUES ('2012', '-', '395');
INSERT INTO `registered` VALUES ('2012', 'probe', '396');
INSERT INTO `registered` VALUES ('2012', 'probe', '397');
INSERT INTO `registered` VALUES ('2012', '+', '398');
INSERT INTO `registered` VALUES ('2012', '+', '399');
INSERT INTO `registered` VALUES ('2012', '-', '400');
INSERT INTO `registered` VALUES ('2012', '+', '401');
INSERT INTO `registered` VALUES ('2012', '+', '402');
INSERT INTO `registered` VALUES ('2012', '+', '403');
INSERT INTO `registered` VALUES ('2012', '+', '404');
INSERT INTO `registered` VALUES ('2012', 'probe', '405');
INSERT INTO `registered` VALUES ('2012', 'probe', '406');
INSERT INTO `registered` VALUES ('2012', '+', '407');
INSERT INTO `registered` VALUES ('2012', 'probe', '408');
INSERT INTO `registered` VALUES ('2012', 'probe', '409');
INSERT INTO `registered` VALUES ('2012', 'probe', '410');
INSERT INTO `registered` VALUES ('2012', 'probe', '411');
INSERT INTO `registered` VALUES ('2012', 'probe', '412');
INSERT INTO `registered` VALUES ('2012', 'probe', '413');
INSERT INTO `registered` VALUES ('2012', 'probe', '414');
INSERT INTO `registered` VALUES ('2012', 'probe', '415');
INSERT INTO `registered` VALUES ('2012', 'probe', '416');
INSERT INTO `registered` VALUES ('2012', 'probe', '417');
INSERT INTO `registered` VALUES ('2012', 'probe', '418');
INSERT INTO `registered` VALUES ('2012', 'probe', '419');
INSERT INTO `registered` VALUES ('2012', '+', '420');
INSERT INTO `registered` VALUES ('2012', '-', '421');
INSERT INTO `registered` VALUES ('2012', '+', '422');
INSERT INTO `registered` VALUES ('2012', '-', '423');
INSERT INTO `registered` VALUES ('2012', '+', '424');
INSERT INTO `registered` VALUES ('2012', 'probe', '425');
INSERT INTO `registered` VALUES ('2012', '+', '426');
INSERT INTO `registered` VALUES ('2012', '+', '427');
INSERT INTO `registered` VALUES ('2012', '+', '428');
INSERT INTO `registered` VALUES ('2012', '+', '429');
INSERT INTO `registered` VALUES ('2012', '+', '430');
INSERT INTO `registered` VALUES ('2012', 'probe', '431');
INSERT INTO `registered` VALUES ('2012', '+', '432');
INSERT INTO `registered` VALUES ('2012', 'probe', '433');
INSERT INTO `registered` VALUES ('2012', 'probe', '434');
INSERT INTO `registered` VALUES ('2012', '+', '435');
INSERT INTO `registered` VALUES ('2012', '+', '436');
INSERT INTO `registered` VALUES ('2012', 'probe', '437');
INSERT INTO `registered` VALUES ('2012', 'probe', '438');
INSERT INTO `registered` VALUES ('2012', 'probe', '439');
INSERT INTO `registered` VALUES ('2012', 'probe', '440');
INSERT INTO `registered` VALUES ('2012', '+', '441');
INSERT INTO `registered` VALUES ('2012', '+', '442');
INSERT INTO `registered` VALUES ('2012', '+', '443');
INSERT INTO `registered` VALUES ('2012', '+', '444');
INSERT INTO `registered` VALUES ('2012', '+', '445');
INSERT INTO `registered` VALUES ('2012', '+', '446');
INSERT INTO `registered` VALUES ('2012', '-', '447');
INSERT INTO `registered` VALUES ('2012', '+', '448');
INSERT INTO `registered` VALUES ('2012', '+', '449');
INSERT INTO `registered` VALUES ('2012', '+', '450');
INSERT INTO `registered` VALUES ('2012', 'probe', '451');
INSERT INTO `registered` VALUES ('2012', 'probe', '452');
INSERT INTO `registered` VALUES ('2012', 'probe', '453');
INSERT INTO `registered` VALUES ('2012', 'probe', '454');
INSERT INTO `registered` VALUES ('2012', 'probe', '455');
INSERT INTO `registered` VALUES ('2012', '+', '456');
INSERT INTO `registered` VALUES ('2012', 'probe', '457');
INSERT INTO `registered` VALUES ('2012', 'probe', '458');
INSERT INTO `registered` VALUES ('2012', 'probe', '459');
INSERT INTO `registered` VALUES ('2012', '+', '460');
INSERT INTO `registered` VALUES ('2012', '+', '461');
INSERT INTO `registered` VALUES ('2012', '+', '462');
INSERT INTO `registered` VALUES ('2012', 'probe', '463');
INSERT INTO `registered` VALUES ('2012', 'probe', '464');
INSERT INTO `registered` VALUES ('2012', 'probe', '465');
INSERT INTO `registered` VALUES ('2012', 'probe', '466');
INSERT INTO `registered` VALUES ('2012', '-', '467');
INSERT INTO `registered` VALUES ('2012', '+', '468');
INSERT INTO `registered` VALUES ('2012', '+', '469');
INSERT INTO `registered` VALUES ('2012', '+', '470');
INSERT INTO `registered` VALUES ('2012', '+', '471');
INSERT INTO `registered` VALUES ('2012', '+', '472');
INSERT INTO `registered` VALUES ('2012', '+', '473');
INSERT INTO `registered` VALUES ('2012', '+', '474');
INSERT INTO `registered` VALUES ('2012', '+', '475');
INSERT INTO `registered` VALUES ('2012', 'probe', '476');
INSERT INTO `registered` VALUES ('2012', 'probe', '477');
INSERT INTO `registered` VALUES ('2012', 'probe', '478');
INSERT INTO `registered` VALUES ('2012', 'probe', '479');
INSERT INTO `registered` VALUES ('2012', 'probe', '480');
INSERT INTO `registered` VALUES ('2012', 'probe', '481');
INSERT INTO `registered` VALUES ('2012', 'probe', '482');
INSERT INTO `registered` VALUES ('2012', 'probe', '483');
INSERT INTO `registered` VALUES ('2012', 'probe', '484');
INSERT INTO `registered` VALUES ('2012', 'probe', '485');
INSERT INTO `registered` VALUES ('2012', '-', '486');
INSERT INTO `registered` VALUES ('2012', '-', '487');
INSERT INTO `registered` VALUES ('2012', '+', '488');
INSERT INTO `registered` VALUES ('2012', 'probe', '489');
INSERT INTO `registered` VALUES ('2012', 'probe', '490');
INSERT INTO `registered` VALUES ('2012', 'probe', '491');
INSERT INTO `registered` VALUES ('2012', 'probe', '492');
INSERT INTO `registered` VALUES ('2012', 'probe', '493');
INSERT INTO `registered` VALUES ('2012', '+', '494');
INSERT INTO `registered` VALUES ('2012', '+', '495');
INSERT INTO `registered` VALUES ('2012', '-', '496');
INSERT INTO `registered` VALUES ('2012', '-', '497');
INSERT INTO `registered` VALUES ('2012', '-', '498');
INSERT INTO `registered` VALUES ('2012', 'probe', '499');
INSERT INTO `registered` VALUES ('2012', '-', '500');
INSERT INTO `registered` VALUES ('2012', '+', '501');
INSERT INTO `registered` VALUES ('2012', 'probe', '502');
INSERT INTO `registered` VALUES ('2012', '+', '503');
INSERT INTO `registered` VALUES ('2012', '+', '504');
INSERT INTO `registered` VALUES ('2012', '-', '505');
INSERT INTO `registered` VALUES ('2012', '-', '506');
INSERT INTO `registered` VALUES ('2012', '-', '507');
INSERT INTO `registered` VALUES ('2012', '+', '508');
INSERT INTO `registered` VALUES ('2012', 'probe', '509');
INSERT INTO `registered` VALUES ('2012', 'probe', '510');
INSERT INTO `registered` VALUES ('2012', '+', '511');
INSERT INTO `registered` VALUES ('2012', '+', '512');
INSERT INTO `registered` VALUES ('2012', '+', '513');
INSERT INTO `registered` VALUES ('2012', 'probe', '514');
INSERT INTO `registered` VALUES ('2012', 'probe', '515');
INSERT INTO `registered` VALUES ('2012', 'probe', '516');
INSERT INTO `registered` VALUES ('2012', '+', '517');
INSERT INTO `registered` VALUES ('2012', 'probe', '518');
INSERT INTO `registered` VALUES ('2012', 'probe', '519');
INSERT INTO `registered` VALUES ('2012', 'probe', '520');
INSERT INTO `registered` VALUES ('2012', 'probe', '521');
INSERT INTO `registered` VALUES ('2012', '+', '522');
INSERT INTO `registered` VALUES ('2012', 'probe', '523');
INSERT INTO `registered` VALUES ('2012', 'probe', '524');
INSERT INTO `registered` VALUES ('2012', '+', '525');
INSERT INTO `registered` VALUES ('2012', '+', '526');
INSERT INTO `registered` VALUES ('2012', '+', '527');
INSERT INTO `registered` VALUES ('2012', '+', '528');
INSERT INTO `registered` VALUES ('2012', '+', '529');
INSERT INTO `registered` VALUES ('2012', '+', '530');
INSERT INTO `registered` VALUES ('2012', '-', '531');
INSERT INTO `registered` VALUES ('2012', 'probe', '532');
INSERT INTO `registered` VALUES ('2012', '-', '533');
INSERT INTO `registered` VALUES ('2012', '-', '534');
INSERT INTO `registered` VALUES ('2012', '+', '535');
INSERT INTO `registered` VALUES ('2012', '+', '536');
INSERT INTO `registered` VALUES ('2012', '+', '537');
INSERT INTO `registered` VALUES ('2012', 'probe', '538');
INSERT INTO `registered` VALUES ('2012', 'probe', '539');
INSERT INTO `registered` VALUES ('2012', 'probe', '540');
INSERT INTO `registered` VALUES ('2012', 'probe', '541');
INSERT INTO `registered` VALUES ('2012', 'probe', '542');
INSERT INTO `registered` VALUES ('2012', 'probe', '543');
INSERT INTO `registered` VALUES ('2012', 'probe', '544');
INSERT INTO `registered` VALUES ('2012', 'probe', '545');
INSERT INTO `registered` VALUES ('2012', 'probe', '546');
INSERT INTO `registered` VALUES ('2012', 'probe', '547');
INSERT INTO `registered` VALUES ('2012', 'probe', '548');
INSERT INTO `registered` VALUES ('2012', '+', '549');
INSERT INTO `registered` VALUES ('2012', '+', '550');
INSERT INTO `registered` VALUES ('2012', '+', '551');
INSERT INTO `registered` VALUES ('2012', '+', '552');
INSERT INTO `registered` VALUES ('2012', '+', '553');
INSERT INTO `registered` VALUES ('2012', '+', '554');
INSERT INTO `registered` VALUES ('2012', 'probe', '555');
INSERT INTO `registered` VALUES ('2012', 'probe', '556');
INSERT INTO `registered` VALUES ('2012', 'probe', '557');
INSERT INTO `registered` VALUES ('2012', 'probe', '558');
INSERT INTO `registered` VALUES ('2012', 'probe', '559');
INSERT INTO `registered` VALUES ('2012', '+', '560');
INSERT INTO `registered` VALUES ('2012', 'probe', '561');
INSERT INTO `registered` VALUES ('2012', 'probe', '562');
INSERT INTO `registered` VALUES ('2012', 'probe', '563');
INSERT INTO `registered` VALUES ('2012', 'probe', '564');
INSERT INTO `registered` VALUES ('2012', '+', '565');
INSERT INTO `registered` VALUES ('2012', '+', '566');
INSERT INTO `registered` VALUES ('2012', '+', '567');
INSERT INTO `registered` VALUES ('2012', '+', '568');
INSERT INTO `registered` VALUES ('2012', 'probe', '569');
INSERT INTO `registered` VALUES ('2012', '-', '570');
INSERT INTO `registered` VALUES ('2012', '+', '571');
INSERT INTO `registered` VALUES ('2012', '+', '572');
INSERT INTO `registered` VALUES ('2012', 'probe', '573');
INSERT INTO `registered` VALUES ('2012', 'probe', '574');
INSERT INTO `registered` VALUES ('2012', 'probe', '575');
INSERT INTO `registered` VALUES ('2012', '+', '576');
INSERT INTO `registered` VALUES ('2012', '+', '577');
INSERT INTO `registered` VALUES ('2012', 'probe', '578');
INSERT INTO `registered` VALUES ('2012', 'probe', '579');
INSERT INTO `registered` VALUES ('2012', '+', '580');
INSERT INTO `registered` VALUES ('2012', '-', '581');
INSERT INTO `registered` VALUES ('2012', '+', '582');
INSERT INTO `registered` VALUES ('2012', '+', '583');
INSERT INTO `registered` VALUES ('2012', '+', '584');
INSERT INTO `registered` VALUES ('2012', 'probe', '585');
INSERT INTO `registered` VALUES ('2012', '+', '586');
INSERT INTO `registered` VALUES ('2012', '+', '587');
INSERT INTO `registered` VALUES ('2012', 'probe', '588');
INSERT INTO `registered` VALUES ('2012', 'probe', '589');
INSERT INTO `registered` VALUES ('2012', 'probe', '590');
INSERT INTO `registered` VALUES ('2012', 'probe', '591');
INSERT INTO `registered` VALUES ('2012', '+', '592');
INSERT INTO `registered` VALUES ('2012', 'probe', '593');
INSERT INTO `registered` VALUES ('2012', '+', '594');
INSERT INTO `registered` VALUES ('2012', '+', '595');
INSERT INTO `registered` VALUES ('2012', '+', '596');
INSERT INTO `registered` VALUES ('2012', '+', '597');
INSERT INTO `registered` VALUES ('2012', '+', '598');
INSERT INTO `registered` VALUES ('2012', '+', '599');
INSERT INTO `registered` VALUES ('2012', '+', '600');
INSERT INTO `registered` VALUES ('2012', '+', '601');
INSERT INTO `registered` VALUES ('2012', '+', '602');
INSERT INTO `registered` VALUES ('2012', '+', '603');
INSERT INTO `registered` VALUES ('2012', '+', '604');
INSERT INTO `registered` VALUES ('2012', 'probe', '605');
INSERT INTO `registered` VALUES ('2012', 'probe', '606');
INSERT INTO `registered` VALUES ('2012', 'probe', '607');
INSERT INTO `registered` VALUES ('2012', 'probe', '608');
INSERT INTO `registered` VALUES ('2012', 'probe', '609');
INSERT INTO `registered` VALUES ('2012', 'probe', '610');
INSERT INTO `registered` VALUES ('2012', 'probe', '611');
INSERT INTO `registered` VALUES ('2012', 'probe', '612');
INSERT INTO `registered` VALUES ('2012', 'probe', '613');
INSERT INTO `registered` VALUES ('2012', 'probe', '614');
INSERT INTO `registered` VALUES ('2012', '+', '615');
INSERT INTO `registered` VALUES ('2012', '-', '616');
INSERT INTO `registered` VALUES ('2012', '+', '617');
INSERT INTO `registered` VALUES ('2012', '-', '618');
INSERT INTO `registered` VALUES ('2012', '-', '619');
INSERT INTO `registered` VALUES ('2012', '+', '620');
INSERT INTO `registered` VALUES ('2012', '+', '621');
INSERT INTO `registered` VALUES ('2012', '+', '622');
INSERT INTO `registered` VALUES ('2012', '-', '623');
INSERT INTO `registered` VALUES ('2012', '-', '624');
INSERT INTO `registered` VALUES ('2012', '+', '625');
INSERT INTO `registered` VALUES ('2012', '+', '626');
INSERT INTO `registered` VALUES ('2012', '+', '627');
INSERT INTO `registered` VALUES ('2012', '+', '628');
INSERT INTO `registered` VALUES ('2012', '+', '629');
INSERT INTO `registered` VALUES ('2012', '+', '630');
INSERT INTO `registered` VALUES ('2012', '+', '631');
INSERT INTO `registered` VALUES ('2012', '+', '632');
INSERT INTO `registered` VALUES ('2012', '+', '633');
INSERT INTO `registered` VALUES ('2012', '+', '634');
INSERT INTO `registered` VALUES ('2012', 'probe', '635');
INSERT INTO `registered` VALUES ('2012', 'probe', '636');
INSERT INTO `registered` VALUES ('2012', 'probe', '637');
INSERT INTO `registered` VALUES ('2012', 'probe', '638');
INSERT INTO `registered` VALUES ('2012', 'probe', '639');
INSERT INTO `registered` VALUES ('2012', 'probe', '640');
INSERT INTO `registered` VALUES ('2012', 'probe', '641');
INSERT INTO `registered` VALUES ('2012', 'probe', '642');
INSERT INTO `registered` VALUES ('2012', 'probe', '643');
INSERT INTO `registered` VALUES ('2012', 'probe', '644');
INSERT INTO `registered` VALUES ('2012', 'probe', '645');
INSERT INTO `registered` VALUES ('2012', 'probe', '646');
INSERT INTO `registered` VALUES ('2012', '-', '647');
INSERT INTO `registered` VALUES ('2012', '-', '648');
INSERT INTO `registered` VALUES ('2012', '-', '649');
INSERT INTO `registered` VALUES ('2012', 'probe', '650');
INSERT INTO `registered` VALUES ('2012', 'probe', '651');
INSERT INTO `registered` VALUES ('2012', 'probe', '652');
INSERT INTO `registered` VALUES ('2012', 'probe', '653');
INSERT INTO `registered` VALUES ('2012', 'probe', '654');
INSERT INTO `registered` VALUES ('2012', 'probe', '655');
INSERT INTO `registered` VALUES ('2012', '+', '656');
INSERT INTO `registered` VALUES ('2012', '+', '657');
INSERT INTO `registered` VALUES ('2012', '+', '658');
INSERT INTO `registered` VALUES ('2012', 'probe', '659');
INSERT INTO `registered` VALUES ('2012', 'probe', '660');
INSERT INTO `registered` VALUES ('2012', '+', '661');
INSERT INTO `registered` VALUES ('2012', '+', '662');
INSERT INTO `registered` VALUES ('2012', '+', '663');
INSERT INTO `registered` VALUES ('2012', '+', '664');
INSERT INTO `registered` VALUES ('2012', '+', '665');
INSERT INTO `registered` VALUES ('2012', '+', '666');
INSERT INTO `registered` VALUES ('2012', '+', '667');
INSERT INTO `registered` VALUES ('2012', '-', '668');
INSERT INTO `registered` VALUES ('2012', 'probe', '669');
INSERT INTO `registered` VALUES ('2012', 'probe', '670');
INSERT INTO `registered` VALUES ('2012', 'probe', '671');
INSERT INTO `registered` VALUES ('2012', '-', '672');
INSERT INTO `registered` VALUES ('2012', '-', '673');
INSERT INTO `registered` VALUES ('2012', '+', '674');
INSERT INTO `registered` VALUES ('2012', '-', '675');
INSERT INTO `registered` VALUES ('2012', '+', '676');
INSERT INTO `registered` VALUES ('2012', '+', '677');
INSERT INTO `registered` VALUES ('2012', 'probe', '678');
INSERT INTO `registered` VALUES ('2012', 'probe', '679');
INSERT INTO `registered` VALUES ('2012', '+', '680');
INSERT INTO `registered` VALUES ('2012', '-', '681');
INSERT INTO `registered` VALUES ('2012', 'probe', '682');
INSERT INTO `registered` VALUES ('2012', '+', '683');
INSERT INTO `registered` VALUES ('2012', 'probe', '684');
INSERT INTO `registered` VALUES ('2012', '+', '685');
INSERT INTO `registered` VALUES ('2012', 'probe', '686');
INSERT INTO `registered` VALUES ('2012', 'probe', '687');
INSERT INTO `registered` VALUES ('2012', 'probe', '688');
INSERT INTO `registered` VALUES ('2012', 'probe', '689');
INSERT INTO `registered` VALUES ('2012', '+', '690');
INSERT INTO `registered` VALUES ('2012', '+', '691');
INSERT INTO `registered` VALUES ('2012', '+', '692');
INSERT INTO `registered` VALUES ('2012', '+', '693');
INSERT INTO `registered` VALUES ('2012', '+', '694');
INSERT INTO `registered` VALUES ('2012', '+', '695');
INSERT INTO `registered` VALUES ('2012', '+', '696');
INSERT INTO `registered` VALUES ('2012', '+', '697');
INSERT INTO `registered` VALUES ('2012', 'probe', '698');
INSERT INTO `registered` VALUES ('2012', 'probe', '699');
INSERT INTO `registered` VALUES ('2012', 'probe', '700');
INSERT INTO `registered` VALUES ('2012', '-', '701');
INSERT INTO `registered` VALUES ('2012', '-', '702');
INSERT INTO `registered` VALUES ('2012', '+', '703');
INSERT INTO `registered` VALUES ('2012', 'probe', '704');
INSERT INTO `registered` VALUES ('2012', 'probe', '705');
INSERT INTO `registered` VALUES ('2012', 'probe', '706');
INSERT INTO `registered` VALUES ('2012', 'probe', '707');
INSERT INTO `registered` VALUES ('2012', '+', '708');
INSERT INTO `registered` VALUES ('2012', '-', '709');
INSERT INTO `registered` VALUES ('2012', '+', '710');
INSERT INTO `registered` VALUES ('2012', '+', '711');
INSERT INTO `registered` VALUES ('2012', '-', '712');
INSERT INTO `registered` VALUES ('2012', 'probe', '713');
INSERT INTO `registered` VALUES ('2012', 'probe', '714');
INSERT INTO `registered` VALUES ('1970', '', '715');
INSERT INTO `registered` VALUES ('2012', 'probe', '716');
INSERT INTO `registered` VALUES ('2012', 'probe', '717');
INSERT INTO `registered` VALUES ('2012', 'probe', '718');
INSERT INTO `registered` VALUES ('2012', 'probe', '719');
INSERT INTO `registered` VALUES ('2012', '+', '720');
INSERT INTO `registered` VALUES ('2012', 'probe', '721');
INSERT INTO `registered` VALUES ('2012', 'probe', '722');
INSERT INTO `registered` VALUES ('2012', '+', '723');
INSERT INTO `registered` VALUES ('2012', '+', '724');
INSERT INTO `registered` VALUES ('2012', 'probe', '725');
INSERT INTO `registered` VALUES ('2012', 'probe', '726');
INSERT INTO `registered` VALUES ('2012', '+', '727');
INSERT INTO `registered` VALUES ('2012', '+', '728');
INSERT INTO `registered` VALUES ('2012', '+', '729');
INSERT INTO `registered` VALUES ('2012', '+', '730');
INSERT INTO `registered` VALUES ('2012', 'probe', '731');
INSERT INTO `registered` VALUES ('2012', '-', '732');
INSERT INTO `registered` VALUES ('2012', '-', '733');
INSERT INTO `registered` VALUES ('2012', '+', '734');
INSERT INTO `registered` VALUES ('2012', '+', '735');
INSERT INTO `registered` VALUES ('2012', 'probe', '736');
INSERT INTO `registered` VALUES ('2012', '+', '737');
INSERT INTO `registered` VALUES ('2012', '+', '738');
INSERT INTO `registered` VALUES ('2012', 'probe', '739');
INSERT INTO `registered` VALUES ('2012', 'probe', '740');
INSERT INTO `registered` VALUES ('2012', 'probe', '741');
INSERT INTO `registered` VALUES ('2012', 'probe', '742');
INSERT INTO `registered` VALUES ('2012', 'probe', '743');
INSERT INTO `registered` VALUES ('2012', 'probe', '744');
INSERT INTO `registered` VALUES ('2012', '+', '745');
INSERT INTO `registered` VALUES ('2012', '+', '746');
INSERT INTO `registered` VALUES ('2012', '+', '747');
INSERT INTO `registered` VALUES ('2012', '+', '748');
INSERT INTO `registered` VALUES ('2012', '+', '749');
INSERT INTO `registered` VALUES ('2012', '+', '750');
INSERT INTO `registered` VALUES ('2012', '-', '751');
INSERT INTO `registered` VALUES ('2012', '+', '752');
INSERT INTO `registered` VALUES ('2012', '+', '753');
INSERT INTO `registered` VALUES ('2012', '-', '754');
INSERT INTO `registered` VALUES ('2012', '+', '755');
INSERT INTO `registered` VALUES ('2012', '-', '756');
INSERT INTO `registered` VALUES ('2012', 'probe', '757');
INSERT INTO `registered` VALUES ('2012', '+', '758');
INSERT INTO `registered` VALUES ('2012', '+', '759');
INSERT INTO `registered` VALUES ('2012', '+', '760');
INSERT INTO `registered` VALUES ('2012', '+', '761');
INSERT INTO `registered` VALUES ('2012', '+', '762');
INSERT INTO `registered` VALUES ('2012', '+', '763');
INSERT INTO `registered` VALUES ('2012', '-', '764');
INSERT INTO `registered` VALUES ('2012', '-', '765');
INSERT INTO `registered` VALUES ('2012', '+', '766');
INSERT INTO `registered` VALUES ('2012', '-', '767');
INSERT INTO `registered` VALUES ('2012', '-', '768');
INSERT INTO `registered` VALUES ('2012', '+', '769');
INSERT INTO `registered` VALUES ('2012', '+', '770');
INSERT INTO `registered` VALUES ('2012', '-', '771');
INSERT INTO `registered` VALUES ('2012', '+', '772');
INSERT INTO `registered` VALUES ('2012', '+', '773');
INSERT INTO `registered` VALUES ('2012', '+', '774');
INSERT INTO `registered` VALUES ('2012', 'probe', '775');
INSERT INTO `registered` VALUES ('2012', '-', '776');
INSERT INTO `registered` VALUES ('2012', 'probe', '777');
INSERT INTO `registered` VALUES ('2012', 'probe', '778');
INSERT INTO `registered` VALUES ('2012', 'probe', '779');
INSERT INTO `registered` VALUES ('2012', 'probe', '780');
INSERT INTO `registered` VALUES ('2012', 'probe', '781');
INSERT INTO `registered` VALUES ('2012', 'probe', '782');
INSERT INTO `registered` VALUES ('2012', 'probe', '783');
INSERT INTO `registered` VALUES ('2012', '-', '784');
INSERT INTO `registered` VALUES ('2012', '+', '785');
INSERT INTO `registered` VALUES ('2012', '+', '786');
INSERT INTO `registered` VALUES ('2012', '+', '787');
INSERT INTO `registered` VALUES ('2012', '+', '788');
INSERT INTO `registered` VALUES ('2012', '+', '789');
INSERT INTO `registered` VALUES ('2012', '+', '790');
INSERT INTO `registered` VALUES ('2012', '-', '791');
INSERT INTO `registered` VALUES ('2012', '+', '792');
INSERT INTO `registered` VALUES ('2012', '+', '793');
INSERT INTO `registered` VALUES ('2012', '-', '794');
INSERT INTO `registered` VALUES ('2012', '+', '795');
INSERT INTO `registered` VALUES ('2012', '+', '796');
INSERT INTO `registered` VALUES ('2012', '+', '797');
INSERT INTO `registered` VALUES ('2012', '-', '798');
INSERT INTO `registered` VALUES ('2012', '+', '799');
INSERT INTO `registered` VALUES ('2012', 'probe', '800');
INSERT INTO `registered` VALUES ('2012', '-', '801');
INSERT INTO `registered` VALUES ('2012', '-', '802');
INSERT INTO `registered` VALUES ('2012', '-', '803');
INSERT INTO `registered` VALUES ('2012', '-', '804');
INSERT INTO `registered` VALUES ('2012', '-', '805');
INSERT INTO `registered` VALUES ('2012', '-', '806');
INSERT INTO `registered` VALUES ('2012', '+', '807');
INSERT INTO `registered` VALUES ('2012', '+', '808');
INSERT INTO `registered` VALUES ('2012', '+', '809');
INSERT INTO `registered` VALUES ('2012', '+', '810');
INSERT INTO `registered` VALUES ('2012', '+', '811');
INSERT INTO `registered` VALUES ('2012', '+', '812');
INSERT INTO `registered` VALUES ('2012', '+', '813');
INSERT INTO `registered` VALUES ('2012', '+', '814');
INSERT INTO `registered` VALUES ('2012', '+', '815');
INSERT INTO `registered` VALUES ('2012', '+', '816');
INSERT INTO `registered` VALUES ('2012', '+', '817');
INSERT INTO `registered` VALUES ('2012', '+', '818');
INSERT INTO `registered` VALUES ('2012', '+', '819');
INSERT INTO `registered` VALUES ('2012', '+', '820');
INSERT INTO `registered` VALUES ('2012', '+', '821');
INSERT INTO `registered` VALUES ('2012', '+', '822');
INSERT INTO `registered` VALUES ('2012', '+', '823');
INSERT INTO `registered` VALUES ('2012', '+', '824');
INSERT INTO `registered` VALUES ('2012', '+', '825');
INSERT INTO `registered` VALUES ('2012', '+', '826');
INSERT INTO `registered` VALUES ('2012', '+', '827');
INSERT INTO `registered` VALUES ('2012', '+', '828');
INSERT INTO `registered` VALUES ('2012', '+', '829');
INSERT INTO `registered` VALUES ('2012', '+', '830');
INSERT INTO `registered` VALUES ('2012', '+', '831');
INSERT INTO `registered` VALUES ('2012', '+', '832');
INSERT INTO `registered` VALUES ('2012', '+', '833');
INSERT INTO `registered` VALUES ('2012', 'probe', '834');
INSERT INTO `registered` VALUES ('2012', '+', '835');
INSERT INTO `registered` VALUES ('2012', '-', '836');
INSERT INTO `registered` VALUES ('2012', '+', '837');
INSERT INTO `registered` VALUES ('2012', '+', '838');
INSERT INTO `registered` VALUES ('2012', '+', '839');
INSERT INTO `registered` VALUES ('2012', 'probe', '840');
INSERT INTO `registered` VALUES ('2012', 'probe', '841');
INSERT INTO `registered` VALUES ('2012', 'probe', '842');
INSERT INTO `registered` VALUES ('2012', '+', '843');
INSERT INTO `registered` VALUES ('2012', '-', '844');
INSERT INTO `registered` VALUES ('2012', '+', '845');
INSERT INTO `registered` VALUES ('2012', '-', '846');
INSERT INTO `registered` VALUES ('2012', '+', '847');
INSERT INTO `registered` VALUES ('2012', '-', '848');
INSERT INTO `registered` VALUES ('2012', '+', '849');
INSERT INTO `registered` VALUES ('2012', '+', '850');
INSERT INTO `registered` VALUES ('2012', '+', '851');
INSERT INTO `registered` VALUES ('2012', 'probe', '852');
INSERT INTO `registered` VALUES ('2012', '+', '853');
INSERT INTO `registered` VALUES ('2012', 'probe', '854');
INSERT INTO `registered` VALUES ('2012', 'probe', '855');
INSERT INTO `registered` VALUES ('2012', 'probe', '856');
INSERT INTO `registered` VALUES ('2012', '+', '857');
INSERT INTO `registered` VALUES ('2012', '+', '858');
INSERT INTO `registered` VALUES ('2012', '+', '859');
INSERT INTO `registered` VALUES ('2012', '+', '860');
INSERT INTO `registered` VALUES ('2012', '-', '861');
INSERT INTO `registered` VALUES ('2012', '-', '862');
INSERT INTO `registered` VALUES ('2012', 'probe', '863');
INSERT INTO `registered` VALUES ('2012', 'probe', '864');
INSERT INTO `registered` VALUES ('2012', 'probe', '865');
INSERT INTO `registered` VALUES ('2012', 'probe', '866');
INSERT INTO `registered` VALUES ('2012', 'probe', '867');
INSERT INTO `registered` VALUES ('2012', '-', '868');
INSERT INTO `registered` VALUES ('2012', '-', '869');
INSERT INTO `registered` VALUES ('2012', '+', '870');
INSERT INTO `registered` VALUES ('2012', '+', '871');
INSERT INTO `registered` VALUES ('2012', '+', '872');
INSERT INTO `registered` VALUES ('2012', '+', '873');
INSERT INTO `registered` VALUES ('2012', '+', '874');
INSERT INTO `registered` VALUES ('2012', '+', '875');
INSERT INTO `registered` VALUES ('2012', '+', '876');
INSERT INTO `registered` VALUES ('2012', '+', '877');
INSERT INTO `registered` VALUES ('2012', '+', '878');
INSERT INTO `registered` VALUES ('2012', '+', '879');
INSERT INTO `registered` VALUES ('2012', '+', '880');
INSERT INTO `registered` VALUES ('2012', '+', '881');
INSERT INTO `registered` VALUES ('2012', '+', '882');
INSERT INTO `registered` VALUES ('2012', '+', '883');
INSERT INTO `registered` VALUES ('2012', '+', '884');
INSERT INTO `registered` VALUES ('2012', '+', '885');
INSERT INTO `registered` VALUES ('2012', '+', '886');
INSERT INTO `registered` VALUES ('2012', '+', '887');
INSERT INTO `registered` VALUES ('2012', '+', '888');
INSERT INTO `registered` VALUES ('2012', '+', '889');
INSERT INTO `registered` VALUES ('2012', '+', '890');
INSERT INTO `registered` VALUES ('2012', '+', '891');
INSERT INTO `registered` VALUES ('2012', '+', '892');
INSERT INTO `registered` VALUES ('2012', '+', '893');
INSERT INTO `registered` VALUES ('2012', '+', '894');
INSERT INTO `registered` VALUES ('2012', '+', '895');
INSERT INTO `registered` VALUES ('2012', '+', '896');
INSERT INTO `registered` VALUES ('2012', '+', '897');
INSERT INTO `registered` VALUES ('2012', '+', '898');
INSERT INTO `registered` VALUES ('2012', '+', '899');
INSERT INTO `registered` VALUES ('2012', '+', '900');
INSERT INTO `registered` VALUES ('2012', '+', '901');
INSERT INTO `registered` VALUES ('2012', '+', '902');
INSERT INTO `registered` VALUES ('2012', '+', '903');
INSERT INTO `registered` VALUES ('2012', '+', '904');
INSERT INTO `registered` VALUES ('2012', '+', '905');
INSERT INTO `registered` VALUES ('2012', '+', '906');
INSERT INTO `registered` VALUES ('2012', '+', '907');
INSERT INTO `registered` VALUES ('2012', '+', '908');
INSERT INTO `registered` VALUES ('2012', '+', '909');
INSERT INTO `registered` VALUES ('2012', '+', '910');
INSERT INTO `registered` VALUES ('2012', '+', '911');
INSERT INTO `registered` VALUES ('2012', '+', '912');
INSERT INTO `registered` VALUES ('2012', '+', '913');
INSERT INTO `registered` VALUES ('2012', '+', '914');
INSERT INTO `registered` VALUES ('2012', '+', '915');
INSERT INTO `registered` VALUES ('2012', '+', '916');
INSERT INTO `registered` VALUES ('2012', '+', '917');
INSERT INTO `registered` VALUES ('2012', '+', '918');
INSERT INTO `registered` VALUES ('2012', '+', '919');
INSERT INTO `registered` VALUES ('2012', '+', '920');
INSERT INTO `registered` VALUES ('2012', '+', '921');
INSERT INTO `registered` VALUES ('2012', '+', '922');
INSERT INTO `registered` VALUES ('2012', '+', '923');
INSERT INTO `registered` VALUES ('2012', '+', '924');
INSERT INTO `registered` VALUES ('2012', '+', '925');
INSERT INTO `registered` VALUES ('2012', '+', '926');
INSERT INTO `registered` VALUES ('2012', '+', '927');
INSERT INTO `registered` VALUES ('2012', '+', '928');
INSERT INTO `registered` VALUES ('2012', '+', '929');
INSERT INTO `registered` VALUES ('2012', '+', '930');
INSERT INTO `registered` VALUES ('2012', '+', '931');
INSERT INTO `registered` VALUES ('2012', '+', '932');
INSERT INTO `registered` VALUES ('2012', '+', '933');
INSERT INTO `registered` VALUES ('2012', '+', '934');
INSERT INTO `registered` VALUES ('2012', '+', '935');
INSERT INTO `registered` VALUES ('2012', '+', '936');
INSERT INTO `registered` VALUES ('2012', '+', '937');
INSERT INTO `registered` VALUES ('2012', '+', '938');
INSERT INTO `registered` VALUES ('2012', '+', '939');
INSERT INTO `registered` VALUES ('2012', '+', '940');
INSERT INTO `registered` VALUES ('2012', '+', '941');
INSERT INTO `registered` VALUES ('2012', '+', '942');
INSERT INTO `registered` VALUES ('2012', '+', '943');
INSERT INTO `registered` VALUES ('2012', '+', '944');
INSERT INTO `registered` VALUES ('2012', '+', '945');
INSERT INTO `registered` VALUES ('2012', '+', '946');
INSERT INTO `registered` VALUES ('2012', '+', '947');
INSERT INTO `registered` VALUES ('2012', '+', '948');
INSERT INTO `registered` VALUES ('2012', '+', '949');
INSERT INTO `registered` VALUES ('2012', '+', '950');
INSERT INTO `registered` VALUES ('2012', '+', '951');
INSERT INTO `registered` VALUES ('2012', '+', '952');
INSERT INTO `registered` VALUES ('2012', '+', '953');
INSERT INTO `registered` VALUES ('2012', '+', '954');
INSERT INTO `registered` VALUES ('2012', '+', '955');
INSERT INTO `registered` VALUES ('2012', '+', '956');
INSERT INTO `registered` VALUES ('2012', '+', '957');
INSERT INTO `registered` VALUES ('2012', 'probe', '958');
INSERT INTO `registered` VALUES ('2012', 'probe', '959');
INSERT INTO `registered` VALUES ('2012', 'probe', '960');
INSERT INTO `registered` VALUES ('2012', 'probe', '961');
INSERT INTO `registered` VALUES ('2012', 'probe', '962');
INSERT INTO `registered` VALUES ('2012', 'probe', '963');
INSERT INTO `registered` VALUES ('2012', '+', '964');
INSERT INTO `registered` VALUES ('2011', '+', '965');
INSERT INTO `registered` VALUES ('2011', '+', '966');
INSERT INTO `registered` VALUES ('2011', '+', '967');
INSERT INTO `registered` VALUES ('2011', '+', '968');
INSERT INTO `registered` VALUES ('2011', 'probe', '969');
INSERT INTO `registered` VALUES ('2011', 'probe', '970');
INSERT INTO `registered` VALUES ('2011', '+', '971');
INSERT INTO `registered` VALUES ('2011', '-', '972');
INSERT INTO `registered` VALUES ('2011', '+', '973');
INSERT INTO `registered` VALUES ('2011', 'probe', '974');
INSERT INTO `registered` VALUES ('2011', '+', '975');
INSERT INTO `registered` VALUES ('2011', '+', '976');
INSERT INTO `registered` VALUES ('2011', '+', '977');
INSERT INTO `registered` VALUES ('2011', '-', '978');
INSERT INTO `registered` VALUES ('2011', '+', '979');
INSERT INTO `registered` VALUES ('2011', '+', '980');
INSERT INTO `registered` VALUES ('2011', '+', '981');
INSERT INTO `registered` VALUES ('2011', '+', '982');
INSERT INTO `registered` VALUES ('2011', '+', '983');
INSERT INTO `registered` VALUES ('2011', '+', '984');
INSERT INTO `registered` VALUES ('2011', '+', '985');
INSERT INTO `registered` VALUES ('2011', '+', '986');
INSERT INTO `registered` VALUES ('2011', '+', '987');
INSERT INTO `registered` VALUES ('2011', '+', '988');
INSERT INTO `registered` VALUES ('2011', '+', '989');
INSERT INTO `registered` VALUES ('2011', '+', '990');
INSERT INTO `registered` VALUES ('2011', '+', '991');
INSERT INTO `registered` VALUES ('2011', '+', '992');
INSERT INTO `registered` VALUES ('2011', '+', '993');
INSERT INTO `registered` VALUES ('2011', '-', '994');
INSERT INTO `registered` VALUES ('2011', 'probe', '995');
INSERT INTO `registered` VALUES ('2011', 'probe', '996');
INSERT INTO `registered` VALUES ('2011', '-', '997');
INSERT INTO `registered` VALUES ('2011', '-', '998');
INSERT INTO `registered` VALUES ('2011', '+', '999');
INSERT INTO `registered` VALUES ('2011', '+', '1000');

... continued

Miguel61 · May 30, 2013, 7:10pm

INSERT INTO `registered` VALUES ('2011', '+', '1001');
INSERT INTO `registered` VALUES ('2011', '+', '1002');
INSERT INTO `registered` VALUES ('2011', '+', '1003');
INSERT INTO `registered` VALUES ('2011', '+', '1004');
INSERT INTO `registered` VALUES ('2011', '+', '1005');
INSERT INTO `registered` VALUES ('2011', '+', '1006');
INSERT INTO `registered` VALUES ('2011', '+', '1007');
INSERT INTO `registered` VALUES ('2011', '+', '1008');
INSERT INTO `registered` VALUES ('2011', '-', '1009');
INSERT INTO `registered` VALUES ('2011', '+', '1010');
INSERT INTO `registered` VALUES ('2011', '+', '1011');
INSERT INTO `registered` VALUES ('2011', '+', '1012');
INSERT INTO `registered` VALUES ('2011', '+', '1013');
INSERT INTO `registered` VALUES ('2011', '-', '1014');
INSERT INTO `registered` VALUES ('2011', '+', '1015');
INSERT INTO `registered` VALUES ('2011', '+', '1016');
INSERT INTO `registered` VALUES ('2011', '+', '1017');
INSERT INTO `registered` VALUES ('2011', '+', '1018');
INSERT INTO `registered` VALUES ('2011', '+', '1019');
INSERT INTO `registered` VALUES ('2011', '+', '1020');
INSERT INTO `registered` VALUES ('2011', '+', '1021');
INSERT INTO `registered` VALUES ('2011', '+', '1022');
INSERT INTO `registered` VALUES ('2011', '+', '1023');
INSERT INTO `registered` VALUES ('2011', 'probe', '1024');
INSERT INTO `registered` VALUES ('2011', 'probe', '1025');
INSERT INTO `registered` VALUES ('2011', 'probe', '1026');
INSERT INTO `registered` VALUES ('2011', 'probe', '1027');
INSERT INTO `registered` VALUES ('2011', 'probe', '1028');
INSERT INTO `registered` VALUES ('2011', 'probe', '1029');
INSERT INTO `registered` VALUES ('2011', 'probe', '1030');
INSERT INTO `registered` VALUES ('2011', 'probe', '1031');
INSERT INTO `registered` VALUES ('2011', '+', '1032');
INSERT INTO `registered` VALUES ('2011', 'probe', '1033');
INSERT INTO `registered` VALUES ('2011', '+', '1034');
INSERT INTO `registered` VALUES ('2011', '+', '1035');
INSERT INTO `registered` VALUES ('2011', '+', '1036');
INSERT INTO `registered` VALUES ('2011', '+', '1037');
INSERT INTO `registered` VALUES ('2011', '+', '1038');
INSERT INTO `registered` VALUES ('2011', '+', '1039');
INSERT INTO `registered` VALUES ('2011', '+', '1040');
INSERT INTO `registered` VALUES ('2011', '+', '1041');
INSERT INTO `registered` VALUES ('2011', 'probe', '1042');
INSERT INTO `registered` VALUES ('2011', '+', '1043');
INSERT INTO `registered` VALUES ('2011', '+', '1044');
INSERT INTO `registered` VALUES ('2011', '+', '1045');
INSERT INTO `registered` VALUES ('2011', '+', '1046');
INSERT INTO `registered` VALUES ('2011', '+', '1047');
INSERT INTO `registered` VALUES ('2011', '-', '1048');
INSERT INTO `registered` VALUES ('2011', '+', '1049');
INSERT INTO `registered` VALUES ('2011', 'probe', '1050');
INSERT INTO `registered` VALUES ('2011', 'probe', '1051');
INSERT INTO `registered` VALUES ('2011', '+', '1052');
INSERT INTO `registered` VALUES ('2011', '+', '1053');
INSERT INTO `registered` VALUES ('2011', '+', '1054');
INSERT INTO `registered` VALUES ('2011', 'probe', '1055');
INSERT INTO `registered` VALUES ('2011', 'probe', '1056');
INSERT INTO `registered` VALUES ('2011', 'probe', '1057');
INSERT INTO `registered` VALUES ('2011', 'probe', '1058');
INSERT INTO `registered` VALUES ('2011', 'probe', '1059');
INSERT INTO `registered` VALUES ('2011', 'probe', '1060');
INSERT INTO `registered` VALUES ('2011', '+', '1061');
INSERT INTO `registered` VALUES ('2011', 'probe', '1062');
INSERT INTO `registered` VALUES ('2011', 'probe', '1063');
INSERT INTO `registered` VALUES ('2011', '+', '1064');
INSERT INTO `registered` VALUES ('2011', '-', '1065');
INSERT INTO `registered` VALUES ('2011', '+', '1066');
INSERT INTO `registered` VALUES ('2011', '+', '1067');
INSERT INTO `registered` VALUES ('2011', '+', '1068');
INSERT INTO `registered` VALUES ('2011', '+', '1069');
INSERT INTO `registered` VALUES ('2011', '+', '1070');
INSERT INTO `registered` VALUES ('2011', '+', '1071');
INSERT INTO `registered` VALUES ('2011', '+', '1072');
INSERT INTO `registered` VALUES ('2011', '+', '1073');
INSERT INTO `registered` VALUES ('2011', '-', '1074');
INSERT INTO `registered` VALUES ('2011', '-', '1075');
INSERT INTO `registered` VALUES ('2011', '+', '1076');
INSERT INTO `registered` VALUES ('2011', '+', '1077');
INSERT INTO `registered` VALUES ('2011', '+', '1078');
INSERT INTO `registered` VALUES ('2011', '+', '1079');
INSERT INTO `registered` VALUES ('2011', '+', '1080');
INSERT INTO `registered` VALUES ('2011', '+', '1081');
INSERT INTO `registered` VALUES ('2011', '+', '1082');
INSERT INTO `registered` VALUES ('2011', '+', '1083');
INSERT INTO `registered` VALUES ('2011', '+', '1084');
INSERT INTO `registered` VALUES ('2011', '+', '1085');
INSERT INTO `registered` VALUES ('2011', '+', '1086');
INSERT INTO `registered` VALUES ('2011', '+', '1087');
INSERT INTO `registered` VALUES ('2011', '+', '1088');
INSERT INTO `registered` VALUES ('2011', '+', '1089');
INSERT INTO `registered` VALUES ('2011', '-', '1090');
INSERT INTO `registered` VALUES ('2011', '-', '1091');
INSERT INTO `registered` VALUES ('2011', '+', '1092');
INSERT INTO `registered` VALUES ('2011', '+', '1093');
INSERT INTO `registered` VALUES ('2011', '+', '1094');
INSERT INTO `registered` VALUES ('2011', 'probe', '1095');
INSERT INTO `registered` VALUES ('2011', 'probe', '1096');
INSERT INTO `registered` VALUES ('2011', 'probe', '1097');
INSERT INTO `registered` VALUES ('2011', 'probe', '1098');
INSERT INTO `registered` VALUES ('2011', 'probe', '1099');
INSERT INTO `registered` VALUES ('2011', 'probe', '1100');
INSERT INTO `registered` VALUES ('2011', 'probe', '1101');
INSERT INTO `registered` VALUES ('2011', 'probe', '1102');
INSERT INTO `registered` VALUES ('2011', 'probe', '1103');
INSERT INTO `registered` VALUES ('2011', 'probe', '1104');
INSERT INTO `registered` VALUES ('2011', 'probe', '1105');
INSERT INTO `registered` VALUES ('2011', '+', '1106');
INSERT INTO `registered` VALUES ('2011', 'probe', '1107');
INSERT INTO `registered` VALUES ('2011', 'probe', '1108');
INSERT INTO `registered` VALUES ('2011', '+', '1109');
INSERT INTO `registered` VALUES ('2011', '-', '1110');
INSERT INTO `registered` VALUES ('2011', '+', '1111');
INSERT INTO `registered` VALUES ('2011', '+', '1112');
INSERT INTO `registered` VALUES ('2011', '+', '1113');
INSERT INTO `registered` VALUES ('2011', '+', '1114');
INSERT INTO `registered` VALUES ('2011', '-', '1115');
INSERT INTO `registered` VALUES ('2011', '+', '1116');
INSERT INTO `registered` VALUES ('2011', '+', '1117');
INSERT INTO `registered` VALUES ('2011', '+', '1118');
INSERT INTO `registered` VALUES ('2011', '+', '1119');
INSERT INTO `registered` VALUES ('2011', '+', '1120');
INSERT INTO `registered` VALUES ('2011', '+', '1121');
INSERT INTO `registered` VALUES ('2011', '+', '1122');
INSERT INTO `registered` VALUES ('2011', '+', '1123');
INSERT INTO `registered` VALUES ('2011', '+', '1124');
INSERT INTO `registered` VALUES ('2011', '+', '1125');
INSERT INTO `registered` VALUES ('2011', 'probe', '1126');
INSERT INTO `registered` VALUES ('2011', '+', '1127');
INSERT INTO `registered` VALUES ('2011', '+', '1128');
INSERT INTO `registered` VALUES ('2011', '+', '1129');
INSERT INTO `registered` VALUES ('2011', '+', '1130');
INSERT INTO `registered` VALUES ('2011', '+', '1131');
INSERT INTO `registered` VALUES ('2011', 'probe', '1132');
INSERT INTO `registered` VALUES ('2011', 'probe', '1133');
INSERT INTO `registered` VALUES ('2011', '+', '1134');
INSERT INTO `registered` VALUES ('2011', '-', '1135');
INSERT INTO `registered` VALUES ('2011', '+', '1136');
INSERT INTO `registered` VALUES ('2011', '+', '1137');
INSERT INTO `registered` VALUES ('2011', 'probe', '1138');
INSERT INTO `registered` VALUES ('2011', '+', '1139');
INSERT INTO `registered` VALUES ('2011', '+', '1140');
INSERT INTO `registered` VALUES ('2011', '+', '1141');
INSERT INTO `registered` VALUES ('2011', '+', '1142');
INSERT INTO `registered` VALUES ('2011', 'probe', '1143');
INSERT INTO `registered` VALUES ('2011', 'probe', '1144');
INSERT INTO `registered` VALUES ('2011', 'probe', '1145');
INSERT INTO `registered` VALUES ('2011', '+', '1146');
INSERT INTO `registered` VALUES ('2011', '+', '1147');
INSERT INTO `registered` VALUES ('2011', '+', '1148');
INSERT INTO `registered` VALUES ('2011', 'probe', '1149');
INSERT INTO `registered` VALUES ('2011', '+', '1150');
INSERT INTO `registered` VALUES ('2011', '+', '1151');
INSERT INTO `registered` VALUES ('2011', '+', '1152');
INSERT INTO `registered` VALUES ('2011', 'probe', '1153');
INSERT INTO `registered` VALUES ('2011', 'probe', '1154');
INSERT INTO `registered` VALUES ('2011', 'probe', '1155');
INSERT INTO `registered` VALUES ('2011', 'probe', '1156');
INSERT INTO `registered` VALUES ('2011', 'probe', '1157');
INSERT INTO `registered` VALUES ('2011', '-', '1158');
INSERT INTO `registered` VALUES ('2011', '+', '1159');
INSERT INTO `registered` VALUES ('2011', '-', '1160');
INSERT INTO `registered` VALUES ('2011', '-', '1161');
INSERT INTO `registered` VALUES ('2011', '+', '1162');
INSERT INTO `registered` VALUES ('2011', '+', '1163');
INSERT INTO `registered` VALUES ('2011', '+', '1164');
INSERT INTO `registered` VALUES ('2011', '+', '1165');
INSERT INTO `registered` VALUES ('2011', '+', '1166');
INSERT INTO `registered` VALUES ('2011', 'probe', '1167');
INSERT INTO `registered` VALUES ('2011', '-', '1168');
INSERT INTO `registered` VALUES ('2011', '-', '1169');
INSERT INTO `registered` VALUES ('2011', '+', '1170');
INSERT INTO `registered` VALUES ('2011', '-', '1171');
INSERT INTO `registered` VALUES ('2011', '-', '1172');
INSERT INTO `registered` VALUES ('2011', 'probe', '1173');
INSERT INTO `registered` VALUES ('2011', 'probe', '1174');
INSERT INTO `registered` VALUES ('2011', 'probe', '1175');
INSERT INTO `registered` VALUES ('2011', '+', '1176');
INSERT INTO `registered` VALUES ('2011', '-', '1177');
INSERT INTO `registered` VALUES ('2011', '+', '1178');
INSERT INTO `registered` VALUES ('2011', '+', '1179');
INSERT INTO `registered` VALUES ('2011', 'probe', '1180');
INSERT INTO `registered` VALUES ('2011', '+', '1181');
INSERT INTO `registered` VALUES ('2011', '+', '1182');
INSERT INTO `registered` VALUES ('2011', '+', '1183');
INSERT INTO `registered` VALUES ('2011', '-', '1184');
INSERT INTO `registered` VALUES ('2011', '+', '1185');
INSERT INTO `registered` VALUES ('2011', '+', '1186');
INSERT INTO `registered` VALUES ('2011', '+', '1187');
INSERT INTO `registered` VALUES ('2011', '+', '1188');
INSERT INTO `registered` VALUES ('2011', '+', '1189');
INSERT INTO `registered` VALUES ('2011', '+', '1190');
INSERT INTO `registered` VALUES ('2011', 'probe', '1191');
INSERT INTO `registered` VALUES ('2011', 'probe', '1192');
INSERT INTO `registered` VALUES ('2011', 'probe', '1193');
INSERT INTO `registered` VALUES ('2011', 'probe', '1194');
INSERT INTO `registered` VALUES ('2011', 'probe', '1195');
INSERT INTO `registered` VALUES ('2011', '+', '1196');
INSERT INTO `registered` VALUES ('2011', '+', '1197');
INSERT INTO `registered` VALUES ('2011', '+', '1198');
INSERT INTO `registered` VALUES ('2011', '+', '1199');
INSERT INTO `registered` VALUES ('2011', '+', '1200');
INSERT INTO `registered` VALUES ('2011', '+', '1201');
INSERT INTO `registered` VALUES ('2011', 'probe', '1202');
INSERT INTO `registered` VALUES ('2011', '+', '1203');
INSERT INTO `registered` VALUES ('2011', '+', '1204');
INSERT INTO `registered` VALUES ('2011', '+', '1205');
INSERT INTO `registered` VALUES ('2011', '+', '1206');
INSERT INTO `registered` VALUES ('2011', 'probe', '1207');
INSERT INTO `registered` VALUES ('2011', 'probe', '1208');
INSERT INTO `registered` VALUES ('2011', '+', '1209');
INSERT INTO `registered` VALUES ('2011', '+', '1210');
INSERT INTO `registered` VALUES ('2011', '+', '1211');
INSERT INTO `registered` VALUES ('2011', 'probe', '1212');
INSERT INTO `registered` VALUES ('2011', 'probe', '1213');
INSERT INTO `registered` VALUES ('2011', 'probe', '1214');
INSERT INTO `registered` VALUES ('2011', 'probe', '1215');
INSERT INTO `registered` VALUES ('2011', 'probe', '1216');
INSERT INTO `registered` VALUES ('2011', 'probe', '1217');
INSERT INTO `registered` VALUES ('2011', 'probe', '1218');
INSERT INTO `registered` VALUES ('2011', 'probe', '1219');
INSERT INTO `registered` VALUES ('2011', 'probe', '1220');
INSERT INTO `registered` VALUES ('2011', 'probe', '1221');
INSERT INTO `registered` VALUES ('2011', 'probe', '1222');
INSERT INTO `registered` VALUES ('2011', 'probe', '1223');
INSERT INTO `registered` VALUES ('2011', 'probe', '1224');
INSERT INTO `registered` VALUES ('2011', 'probe', '1225');
INSERT INTO `registered` VALUES ('2011', 'probe', '1226');
INSERT INTO `registered` VALUES ('2011', 'probe', '1227');
INSERT INTO `registered` VALUES ('2011', 'probe', '1228');
INSERT INTO `registered` VALUES ('2011', 'probe', '1229');
INSERT INTO `registered` VALUES ('2011', 'probe', '1230');
INSERT INTO `registered` VALUES ('2011', 'probe', '1231');
INSERT INTO `registered` VALUES ('2011', 'probe', '1232');
INSERT INTO `registered` VALUES ('2011', 'probe', '1233');
INSERT INTO `registered` VALUES ('2011', 'probe', '1234');
INSERT INTO `registered` VALUES ('2011', 'probe', '1235');
INSERT INTO `registered` VALUES ('2011', 'probe', '1236');
INSERT INTO `registered` VALUES ('2011', 'probe', '1237');
INSERT INTO `registered` VALUES ('2011', 'probe', '1238');
INSERT INTO `registered` VALUES ('2011', 'probe', '1239');
INSERT INTO `registered` VALUES ('2011', 'probe', '1240');
INSERT INTO `registered` VALUES ('2011', 'probe', '1241');
INSERT INTO `registered` VALUES ('2011', 'probe', '1242');
INSERT INTO `registered` VALUES ('2011', 'probe', '1243');
INSERT INTO `registered` VALUES ('2011', 'probe', '1244');
INSERT INTO `registered` VALUES ('2011', 'probe', '1245');
INSERT INTO `registered` VALUES ('2011', 'probe', '1246');
INSERT INTO `registered` VALUES ('2011', '+', '1247');
INSERT INTO `registered` VALUES ('2011', '+', '1248');
INSERT INTO `registered` VALUES ('2011', '+', '1249');
INSERT INTO `registered` VALUES ('2011', '-', '1250');
INSERT INTO `registered` VALUES ('2011', '-', '1251');
INSERT INTO `registered` VALUES ('2011', '-', '1252');
INSERT INTO `registered` VALUES ('2011', '+', '1253');
INSERT INTO `registered` VALUES ('2011', '+', '1254');
INSERT INTO `registered` VALUES ('2011', '-', '1255');
INSERT INTO `registered` VALUES ('2011', '+', '1256');
INSERT INTO `registered` VALUES ('2011', '+', '1257');
INSERT INTO `registered` VALUES ('2011', '+', '1258');
INSERT INTO `registered` VALUES ('2011', '+', '1259');
INSERT INTO `registered` VALUES ('2011', '+', '1260');
INSERT INTO `registered` VALUES ('2011', '+', '1261');
INSERT INTO `registered` VALUES ('2011', '+', '1262');
INSERT INTO `registered` VALUES ('2011', '+', '1263');
INSERT INTO `registered` VALUES ('2011', '+', '1264');
INSERT INTO `registered` VALUES ('2011', '+', '1265');
INSERT INTO `registered` VALUES ('2011', '+', '1266');
INSERT INTO `registered` VALUES ('2011', '+', '1267');
INSERT INTO `registered` VALUES ('2011', '+', '1268');
INSERT INTO `registered` VALUES ('2011', '-', '1269');
INSERT INTO `registered` VALUES ('2011', '+', '1270');
INSERT INTO `registered` VALUES ('2011', '+', '1271');
INSERT INTO `registered` VALUES ('2011', '+', '1272');
INSERT INTO `registered` VALUES ('2011', 'probe', '1273');
INSERT INTO `registered` VALUES ('2011', '+', '1274');
INSERT INTO `registered` VALUES ('2011', '+', '1275');
INSERT INTO `registered` VALUES ('2011', '+', '1276');
INSERT INTO `registered` VALUES ('2011', '-', '1277');
INSERT INTO `registered` VALUES ('2011', '+', '1278');
INSERT INTO `registered` VALUES ('2011', 'probe', '1279');
INSERT INTO `registered` VALUES ('2011', '+', '1280');
INSERT INTO `registered` VALUES ('2011', '+', '1281');
INSERT INTO `registered` VALUES ('2011', '+', '1282');
INSERT INTO `registered` VALUES ('2011', '+', '1283');
INSERT INTO `registered` VALUES ('2011', 'probe', '1284');
INSERT INTO `registered` VALUES ('2011', 'probe', '1285');
INSERT INTO `registered` VALUES ('2011', 'probe', '1286');
INSERT INTO `registered` VALUES ('2011', 'probe', '1287');
INSERT INTO `registered` VALUES ('2011', '+', '1288');
INSERT INTO `registered` VALUES ('2011', '-', '1289');
INSERT INTO `registered` VALUES ('2011', '+', '1290');
INSERT INTO `registered` VALUES ('2011', '+', '1291');
INSERT INTO `registered` VALUES ('2011', '+', '1292');
INSERT INTO `registered` VALUES ('2011', '-', '1293');
INSERT INTO `registered` VALUES ('2011', '+', '1294');
INSERT INTO `registered` VALUES ('2011', '+', '1295');
INSERT INTO `registered` VALUES ('2011', '-', '1296');
INSERT INTO `registered` VALUES ('2011', '+', '1297');
INSERT INTO `registered` VALUES ('2011', '+', '1298');
INSERT INTO `registered` VALUES ('2011', 'probe', '1299');
INSERT INTO `registered` VALUES ('2011', 'probe', '1300');
INSERT INTO `registered` VALUES ('2011', '+', '1301');
INSERT INTO `registered` VALUES ('2011', '+', '1302');
INSERT INTO `registered` VALUES ('2011', '+', '1303');
INSERT INTO `registered` VALUES ('2011', '+', '1304');
INSERT INTO `registered` VALUES ('2011', '+', '1305');
INSERT INTO `registered` VALUES ('2011', '+', '1306');
INSERT INTO `registered` VALUES ('2011', 'probe', '1307');
INSERT INTO `registered` VALUES ('2011', 'probe', '1308');
INSERT INTO `registered` VALUES ('2011', '+', '1309');
INSERT INTO `registered` VALUES ('2011', '+', '1310');
INSERT INTO `registered` VALUES ('2011', '+', '1311');
INSERT INTO `registered` VALUES ('2011', '+', '1312');
INSERT INTO `registered` VALUES ('2011', '+', '1313');
INSERT INTO `registered` VALUES ('2011', '+', '1314');
INSERT INTO `registered` VALUES ('2011', '-', '1315');
INSERT INTO `registered` VALUES ('2011', '+', '1316');
INSERT INTO `registered` VALUES ('2011', '+', '1317');
INSERT INTO `registered` VALUES ('2011', '+', '1318');
INSERT INTO `registered` VALUES ('2011', '-', '1319');
INSERT INTO `registered` VALUES ('2011', '+', '1320');
INSERT INTO `registered` VALUES ('2011', '+', '1321');
INSERT INTO `registered` VALUES ('2011', '+', '1322');
INSERT INTO `registered` VALUES ('2011', '+', '1323');
INSERT INTO `registered` VALUES ('2011', '-', '1324');
INSERT INTO `registered` VALUES ('2011', '-', '1325');
INSERT INTO `registered` VALUES ('2011', '-', '1326');
INSERT INTO `registered` VALUES ('2011', '-', '1327');
INSERT INTO `registered` VALUES ('2011', '+', '1328');
INSERT INTO `registered` VALUES ('2011', 'probe', '1329');
INSERT INTO `registered` VALUES ('2011', 'probe', '1330');
INSERT INTO `registered` VALUES ('2011', 'probe', '1331');
INSERT INTO `registered` VALUES ('2011', 'probe', '1332');
INSERT INTO `registered` VALUES ('2011', 'probe', '1333');
INSERT INTO `registered` VALUES ('2011', '+', '1334');
INSERT INTO `registered` VALUES ('2011', 'probe', '1335');
INSERT INTO `registered` VALUES ('2011', 'probe', '1336');
INSERT INTO `registered` VALUES ('2011', 'probe', '1337');
INSERT INTO `registered` VALUES ('2011', 'probe', '1338');
INSERT INTO `registered` VALUES ('2011', 'probe', '1339');
INSERT INTO `registered` VALUES ('2011', '+', '1340');
INSERT INTO `registered` VALUES ('2011', '+', '1341');
INSERT INTO `registered` VALUES ('2011', '-', '1342');
INSERT INTO `registered` VALUES ('2011', '-', '1343');
INSERT INTO `registered` VALUES ('2011', '+', '1344');
INSERT INTO `registered` VALUES ('2011', 'probe', '1345');
INSERT INTO `registered` VALUES ('2011', '+', '1346');
INSERT INTO `registered` VALUES ('2011', '+', '1347');
INSERT INTO `registered` VALUES ('2011', '+', '1348');
INSERT INTO `registered` VALUES ('2011', '+', '1349');
INSERT INTO `registered` VALUES ('2011', '+', '1350');
INSERT INTO `registered` VALUES ('2011', 'probe', '1351');
INSERT INTO `registered` VALUES ('2011', '+', '1352');
INSERT INTO `registered` VALUES ('2011', '+', '1353');
INSERT INTO `registered` VALUES ('2011', 'probe', '1354');
INSERT INTO `registered` VALUES ('2011', 'probe', '1355');
INSERT INTO `registered` VALUES ('2011', '+', '1356');
INSERT INTO `registered` VALUES ('2011', 'probe', '1357');
INSERT INTO `registered` VALUES ('2011', '-', '1358');
INSERT INTO `registered` VALUES ('2011', '+', '1359');
INSERT INTO `registered` VALUES ('2011', '-', '1360');
INSERT INTO `registered` VALUES ('2011', '+', '1361');
INSERT INTO `registered` VALUES ('2011', '+', '1362');
INSERT INTO `registered` VALUES ('2011', '+', '1363');
INSERT INTO `registered` VALUES ('2011', '+', '1364');
INSERT INTO `registered` VALUES ('2011', '-', '1365');
INSERT INTO `registered` VALUES ('2011', 'probe', '1366');
INSERT INTO `registered` VALUES ('2011', 'probe', '1367');
INSERT INTO `registered` VALUES ('2011', 'probe', '1368');
INSERT INTO `registered` VALUES ('2011', '+', '1369');
INSERT INTO `registered` VALUES ('2011', '-', '1370');
INSERT INTO `registered` VALUES ('2011', 'probe', '1371');
INSERT INTO `registered` VALUES ('2011', 'probe', '1372');
INSERT INTO `registered` VALUES ('2011', 'probe', '1373');
INSERT INTO `registered` VALUES ('2011', 'probe', '1374');
INSERT INTO `registered` VALUES ('2011', 'probe', '1375');
INSERT INTO `registered` VALUES ('2011', 'probe', '1376');
INSERT INTO `registered` VALUES ('2011', '-', '1377');
INSERT INTO `registered` VALUES ('2011', '-', '1378');
INSERT INTO `registered` VALUES ('2011', '-', '1379');
INSERT INTO `registered` VALUES ('2011', '+', '1380');
INSERT INTO `registered` VALUES ('2011', '+', '1381');
INSERT INTO `registered` VALUES ('2011', '+', '1382');
INSERT INTO `registered` VALUES ('2011', '+', '1383');
INSERT INTO `registered` VALUES ('2011', '-', '1384');
INSERT INTO `registered` VALUES ('2011', '+', '1385');
INSERT INTO `registered` VALUES ('2011', '+', '1386');
INSERT INTO `registered` VALUES ('2011', '-', '1387');
INSERT INTO `registered` VALUES ('2011', '+', '1388');
INSERT INTO `registered` VALUES ('2011', 'probe', '1389');
INSERT INTO `registered` VALUES ('2011', 'probe', '1390');
INSERT INTO `registered` VALUES ('2011', 'probe', '1391');
INSERT INTO `registered` VALUES ('2011', 'probe', '1392');
INSERT INTO `registered` VALUES ('2011', 'probe', '1393');
INSERT INTO `registered` VALUES ('2011', 'probe', '1394');
INSERT INTO `registered` VALUES ('2011', 'probe', '1395');
INSERT INTO `registered` VALUES ('2011', 'probe', '1396');
INSERT INTO `registered` VALUES ('2011', '+', '1397');
INSERT INTO `registered` VALUES ('2011', '+', '1398');
INSERT INTO `registered` VALUES ('2011', '+', '1399');
INSERT INTO `registered` VALUES ('2011', '+', '1400');
INSERT INTO `registered` VALUES ('2011', '+', '1401');
INSERT INTO `registered` VALUES ('2011', '+', '1402');
INSERT INTO `registered` VALUES ('2011', '+', '1403');
INSERT INTO `registered` VALUES ('2011', 'probe', '1404');
INSERT INTO `registered` VALUES ('2011', 'probe', '1405');
INSERT INTO `registered` VALUES ('2011', 'probe', '1406');
INSERT INTO `registered` VALUES ('2011', 'probe', '1407');
INSERT INTO `registered` VALUES ('2011', '-', '1408');
INSERT INTO `registered` VALUES ('2011', '+', '1409');
INSERT INTO `registered` VALUES ('2011', '+', '1410');
INSERT INTO `registered` VALUES ('2011', '-', '1411');
INSERT INTO `registered` VALUES ('2011', '+', '1412');
INSERT INTO `registered` VALUES ('2011', 'probe', '1413');
INSERT INTO `registered` VALUES ('2011', 'probe', '1414');
INSERT INTO `registered` VALUES ('2011', '+', '1415');
INSERT INTO `registered` VALUES ('2011', 'probe', '1416');
INSERT INTO `registered` VALUES ('2011', 'probe', '1417');
INSERT INTO `registered` VALUES ('2011', 'probe', '1418');
INSERT INTO `registered` VALUES ('2011', '+', '1419');
INSERT INTO `registered` VALUES ('2011', '+', '1420');
INSERT INTO `registered` VALUES ('2011', '-', '1421');
INSERT INTO `registered` VALUES ('2011', '+', '1422');
INSERT INTO `registered` VALUES ('2011', '+', '1423');
INSERT INTO `registered` VALUES ('2011', 'probe', '1424');
INSERT INTO `registered` VALUES ('2011', '+', '1425');
INSERT INTO `registered` VALUES ('2011', '+', '1426');
INSERT INTO `registered` VALUES ('2011', '+', '1427');
INSERT INTO `registered` VALUES ('2011', '+', '1428');
INSERT INTO `registered` VALUES ('2011', '+', '1429');
INSERT INTO `registered` VALUES ('2011', '-', '1430');
INSERT INTO `registered` VALUES ('2011', '+', '1431');
INSERT INTO `registered` VALUES ('2011', 'probe', '1432');
INSERT INTO `registered` VALUES ('2011', '+', '1433');
INSERT INTO `registered` VALUES ('2011', '+', '1434');
INSERT INTO `registered` VALUES ('2011', '-', '1435');
INSERT INTO `registered` VALUES ('2011', '-', '1436');
INSERT INTO `registered` VALUES ('2011', '+', '1437');
INSERT INTO `registered` VALUES ('2011', '+', '1438');
INSERT INTO `registered` VALUES ('2011', '+', '1439');
INSERT INTO `registered` VALUES ('2011', '-', '1440');
INSERT INTO `registered` VALUES ('2011', '-', '1441');
INSERT INTO `registered` VALUES ('2011', '+', '1442');
INSERT INTO `registered` VALUES ('2011', '+', '1443');
INSERT INTO `registered` VALUES ('2011', '+', '1444');
INSERT INTO `registered` VALUES ('2011', '+', '1445');
INSERT INTO `registered` VALUES ('2011', '+', '1446');
INSERT INTO `registered` VALUES ('2011', '+', '1447');
INSERT INTO `registered` VALUES ('2011', '+', '1448');
INSERT INTO `registered` VALUES ('2011', '+', '1449');
INSERT INTO `registered` VALUES ('2011', '+', '1450');
INSERT INTO `registered` VALUES ('2011', 'probe', '1451');
INSERT INTO `registered` VALUES ('2011', '+', '1452');
INSERT INTO `registered` VALUES ('2011', '+', '1453');
INSERT INTO `registered` VALUES ('2011', '+', '1454');
INSERT INTO `registered` VALUES ('2011', '+', '1455');
INSERT INTO `registered` VALUES ('2011', '+', '1456');
INSERT INTO `registered` VALUES ('2011', '+', '1457');
INSERT INTO `registered` VALUES ('2011', '+', '1458');
INSERT INTO `registered` VALUES ('2011', '+', '1459');
INSERT INTO `registered` VALUES ('2011', '-', '1460');
INSERT INTO `registered` VALUES ('2011', 'probe', '1461');
INSERT INTO `registered` VALUES ('2011', '+', '1462');
INSERT INTO `registered` VALUES ('2011', '+', '1463');
INSERT INTO `registered` VALUES ('2011', '+', '1464');
INSERT INTO `registered` VALUES ('2011', '+', '1465');
INSERT INTO `registered` VALUES ('2011', '+', '1466');
INSERT INTO `registered` VALUES ('2011', '-', '1467');
INSERT INTO `registered` VALUES ('2011', 'probe', '1468');
INSERT INTO `registered` VALUES ('2011', 'probe', '1469');
INSERT INTO `registered` VALUES ('2011', '+', '1470');
INSERT INTO `registered` VALUES ('2011', '+', '1471');
INSERT INTO `registered` VALUES ('2011', '+', '1472');
INSERT INTO `registered` VALUES ('2011', '+', '1473');
INSERT INTO `registered` VALUES ('2011', '+', '1474');
INSERT INTO `registered` VALUES ('2011', '+', '1475');
INSERT INTO `registered` VALUES ('2011', '-', '1476');
INSERT INTO `registered` VALUES ('2011', 'probe', '1477');
INSERT INTO `registered` VALUES ('2011', '-', '1478');
INSERT INTO `registered` VALUES ('2011', '+', '1479');
INSERT INTO `registered` VALUES ('2011', 'probe', '1480');
INSERT INTO `registered` VALUES ('2011', '+', '1481');
INSERT INTO `registered` VALUES ('2011', 'probe', '1482');
INSERT INTO `registered` VALUES ('2011', '+', '1483');
INSERT INTO `registered` VALUES ('2011', '-', '1484');
INSERT INTO `registered` VALUES ('2011', '+', '1485');
INSERT INTO `registered` VALUES ('2011', '+', '1486');
INSERT INTO `registered` VALUES ('2011', 'probe', '1487');
INSERT INTO `registered` VALUES ('2011', '+', '1488');
INSERT INTO `registered` VALUES ('2011', '-', '1489');
INSERT INTO `registered` VALUES ('2011', '+', '1490');
INSERT INTO `registered` VALUES ('2011', '+', '1491');
INSERT INTO `registered` VALUES ('2011', '+', '1492');
INSERT INTO `registered` VALUES ('2011', '+', '1493');
INSERT INTO `registered` VALUES ('2011', '+', '1494');
INSERT INTO `registered` VALUES ('2011', '+', '1495');
INSERT INTO `registered` VALUES ('2011', '+', '1496');
INSERT INTO `registered` VALUES ('2011', '+', '1497');
INSERT INTO `registered` VALUES ('2011', '+', '1498');
INSERT INTO `registered` VALUES ('2011', '+', '1499');
INSERT INTO `registered` VALUES ('2011', 'probe', '1500');
INSERT INTO `registered` VALUES ('2011', '+', '1501');
INSERT INTO `registered` VALUES ('2011', '-', '1502');
INSERT INTO `registered` VALUES ('2011', '-', '1503');
INSERT INTO `registered` VALUES ('2011', '+', '1504');
INSERT INTO `registered` VALUES ('2011', '-', '1505');
INSERT INTO `registered` VALUES ('2011', '+', '1506');
INSERT INTO `registered` VALUES ('2011', '-', '1507');
INSERT INTO `registered` VALUES ('2011', '-', '1508');
INSERT INTO `registered` VALUES ('2011', '+', '1509');
INSERT INTO `registered` VALUES ('2011', '+', '1510');
INSERT INTO `registered` VALUES ('2011', '+', '1511');
INSERT INTO `registered` VALUES ('2011', 'probe', '1512');
INSERT INTO `registered` VALUES ('2011', 'probe', '1513');
INSERT INTO `registered` VALUES ('2011', 'probe', '1514');
INSERT INTO `registered` VALUES ('2011', 'probe', '1515');
INSERT INTO `registered` VALUES ('2011', 'probe', '1516');
INSERT INTO `registered` VALUES ('2011', 'probe', '1517');
INSERT INTO `registered` VALUES ('2011', 'probe', '1518');
INSERT INTO `registered` VALUES ('2011', '+', '1519');
INSERT INTO `registered` VALUES ('2011', '-', '1520');
INSERT INTO `registered` VALUES ('2011', '-', '1521');
INSERT INTO `registered` VALUES ('2011', '-', '1522');
INSERT INTO `registered` VALUES ('2011', '+', '1523');
INSERT INTO `registered` VALUES ('2011', 'probe', '1524');
INSERT INTO `registered` VALUES ('2011', 'probe', '1525');
INSERT INTO `registered` VALUES ('2011', '+', '1526');
INSERT INTO `registered` VALUES ('2011', '-', '1527');
INSERT INTO `registered` VALUES ('2011', '-', '1528');
INSERT INTO `registered` VALUES ('2011', 'probe', '1529');
INSERT INTO `registered` VALUES ('2011', '+', '1530');
INSERT INTO `registered` VALUES ('2011', 'probe', '1531');
INSERT INTO `registered` VALUES ('2011', '+', '1532');
INSERT INTO `registered` VALUES ('2011', '+', '1533');
INSERT INTO `registered` VALUES ('2011', '+', '1534');
INSERT INTO `registered` VALUES ('2011', 'probe', '1535');
INSERT INTO `registered` VALUES ('2011', '-', '1536');
INSERT INTO `registered` VALUES ('2011', '+', '1537');
INSERT INTO `registered` VALUES ('2011', 'probe', '1538');
INSERT INTO `registered` VALUES ('2011', 'probe', '1539');
INSERT INTO `registered` VALUES ('2011', 'probe', '1540');
INSERT INTO `registered` VALUES ('2011', '+', '1541');
INSERT INTO `registered` VALUES ('2011', '+', '1542');
INSERT INTO `registered` VALUES ('2011', 'probe', '1543');
INSERT INTO `registered` VALUES ('2011', 'probe', '1544');
INSERT INTO `registered` VALUES ('2011', '-', '1545');
INSERT INTO `registered` VALUES ('2011', '-', '1546');
INSERT INTO `registered` VALUES ('2011', '+', '1547');
INSERT INTO `registered` VALUES ('2011', '+', '1548');
INSERT INTO `registered` VALUES ('2011', '-', '1549');
INSERT INTO `registered` VALUES ('2011', '-', '1550');
INSERT INTO `registered` VALUES ('2011', '+', '1551');
INSERT INTO `registered` VALUES ('2011', '+', '1552');
INSERT INTO `registered` VALUES ('2011', 'probe', '1553');
INSERT INTO `registered` VALUES ('2011', 'probe', '1554');
INSERT INTO `registered` VALUES ('2011', '+', '1555');
INSERT INTO `registered` VALUES ('2011', 'probe', '1556');
INSERT INTO `registered` VALUES ('2011', 'probe', '1557');
INSERT INTO `registered` VALUES ('2011', '-', '1558');
INSERT INTO `registered` VALUES ('2011', '-', '1559');
INSERT INTO `registered` VALUES ('2011', '+', '1560');
INSERT INTO `registered` VALUES ('2011', 'probe', '1561');
INSERT INTO `registered` VALUES ('2011', 'probe', '1562');
INSERT INTO `registered` VALUES ('2011', 'probe', '1563');
INSERT INTO `registered` VALUES ('2011', '+', '1564');
INSERT INTO `registered` VALUES ('2011', '+', '1565');
INSERT INTO `registered` VALUES ('2011', '+', '1566');
INSERT INTO `registered` VALUES ('2011', 'probe', '1567');
INSERT INTO `registered` VALUES ('2011', 'probe', '1568');
INSERT INTO `registered` VALUES ('2011', '+', '1569');
INSERT INTO `registered` VALUES ('2011', '-', '1570');
INSERT INTO `registered` VALUES ('2011', 'probe', '1571');
INSERT INTO `registered` VALUES ('2011', '-', '1572');
INSERT INTO `registered` VALUES ('2011', 'probe', '1573');
INSERT INTO `registered` VALUES ('2011', '+', '1574');
INSERT INTO `registered` VALUES ('2011', 'probe', '1575');
INSERT INTO `registered` VALUES ('2011', '+', '1576');
INSERT INTO `registered` VALUES ('2011', 'probe', '1577');
INSERT INTO `registered` VALUES ('2011', 'probe', '1578');
INSERT INTO `registered` VALUES ('2011', '+', '1579');
INSERT INTO `registered` VALUES ('2011', '+', '1580');
INSERT INTO `registered` VALUES ('2011', 'probe', '1581');
INSERT INTO `registered` VALUES ('2011', '+', '1582');
INSERT INTO `registered` VALUES ('2011', '+', '1583');
INSERT INTO `registered` VALUES ('2011', '-', '1584');
INSERT INTO `registered` VALUES ('2011', '+', '1585');
INSERT INTO `registered` VALUES ('2011', '+', '1586');
INSERT INTO `registered` VALUES ('2011', '+', '1587');
INSERT INTO `registered` VALUES ('2011', 'probe', '1588');
INSERT INTO `registered` VALUES ('2011', '+', '1589');
INSERT INTO `registered` VALUES ('2011', '+', '1590');
INSERT INTO `registered` VALUES ('2011', '+', '1591');
INSERT INTO `registered` VALUES ('2011', '+', '1592');
INSERT INTO `registered` VALUES ('2011', 'probe', '1593');
INSERT INTO `registered` VALUES ('2011', 'probe', '1594');
INSERT INTO `registered` VALUES ('2011', 'probe', '1595');
INSERT INTO `registered` VALUES ('2011', 'probe', '1596');
INSERT INTO `registered` VALUES ('2011', 'probe', '1597');
INSERT INTO `registered` VALUES ('2011', '+', '1598');
INSERT INTO `registered` VALUES ('2011', '+', '1599');
INSERT INTO `registered` VALUES ('2011', '+', '1600');
INSERT INTO `registered` VALUES ('2011', '+', '1601');
INSERT INTO `registered` VALUES ('2011', '+', '1602');
INSERT INTO `registered` VALUES ('2011', '-', '1603');
INSERT INTO `registered` VALUES ('2011', '+', '1604');
INSERT INTO `registered` VALUES ('2011', '+', '1605');
INSERT INTO `registered` VALUES ('2011', '+', '1606');
INSERT INTO `registered` VALUES ('2011', '+', '1607');
INSERT INTO `registered` VALUES ('2011', '+', '1608');
INSERT INTO `registered` VALUES ('2011', 'probe', '1609');
INSERT INTO `registered` VALUES ('2011', 'probe', '1610');
INSERT INTO `registered` VALUES ('2011', '+', '1611');
INSERT INTO `registered` VALUES ('2011', '-', '1612');
INSERT INTO `registered` VALUES ('2011', '-', '1613');
INSERT INTO `registered` VALUES ('2011', 'probe', '1614');
INSERT INTO `registered` VALUES ('2011', 'probe', '1615');
INSERT INTO `registered` VALUES ('2011', '+', '1616');
INSERT INTO `registered` VALUES ('2011', '+', '1617');
INSERT INTO `registered` VALUES ('2011', '+', '1618');
INSERT INTO `registered` VALUES ('2011', '+', '1619');
INSERT INTO `registered` VALUES ('2011', '+', '1620');
INSERT INTO `registered` VALUES ('2011', '+', '1621');
INSERT INTO `registered` VALUES ('2011', '+', '1622');
INSERT INTO `registered` VALUES ('2011', '+', '1623');
INSERT INTO `registered` VALUES ('2011', '+', '1624');
INSERT INTO `registered` VALUES ('2011', '+', '1625');
INSERT INTO `registered` VALUES ('2011', '+', '1626');
INSERT INTO `registered` VALUES ('2011', '+', '1627');
INSERT INTO `registered` VALUES ('2011', '+', '1628');
INSERT INTO `registered` VALUES ('2011', '+', '1629');
INSERT INTO `registered` VALUES ('2011', '+', '1630');
INSERT INTO `registered` VALUES ('2011', '+', '1631');
INSERT INTO `registered` VALUES ('2011', '+', '1632');
INSERT INTO `registered` VALUES ('2011', '+', '1633');
INSERT INTO `registered` VALUES ('2011', '+', '1634');
INSERT INTO `registered` VALUES ('2011', '+', '1635');
INSERT INTO `registered` VALUES ('2011', '+', '1636');
INSERT INTO `registered` VALUES ('2011', '+', '1637');
INSERT INTO `registered` VALUES ('2011', '+', '1638');
INSERT INTO `registered` VALUES ('2011', '+', '1639');
INSERT INTO `registered` VALUES ('2011', '+', '1640');
INSERT INTO `registered` VALUES ('2011', '+', '1641');
INSERT INTO `registered` VALUES ('2011', '+', '1642');
INSERT INTO `registered` VALUES ('2011', '+', '1643');
INSERT INTO `registered` VALUES ('2011', '+', '1644');
INSERT INTO `registered` VALUES ('2011', '+', '1645');
INSERT INTO `registered` VALUES ('2011', '+', '1646');
INSERT INTO `registered` VALUES ('2011', '+', '1647');
INSERT INTO `registered` VALUES ('2011', '+', '1648');
INSERT INTO `registered` VALUES ('2011', '+', '1649');
INSERT INTO `registered` VALUES ('2011', '+', '1650');
INSERT INTO `registered` VALUES ('2011', '+', '1651');
INSERT INTO `registered` VALUES ('2011', '+', '1652');
INSERT INTO `registered` VALUES ('2011', '+', '1653');
INSERT INTO `registered` VALUES ('2011', '+', '1654');
INSERT INTO `registered` VALUES ('2011', '+', '1655');
INSERT INTO `registered` VALUES ('2011', '+', '1656');
INSERT INTO `registered` VALUES ('2011', '+', '1657');
INSERT INTO `registered` VALUES ('2011', '+', '1658');
INSERT INTO `registered` VALUES ('2011', '+', '1659');
INSERT INTO `registered` VALUES ('2011', '+', '1660');
INSERT INTO `registered` VALUES ('2011', '+', '1661');
INSERT INTO `registered` VALUES ('2011', '+', '1662');
INSERT INTO `registered` VALUES ('2011', '-', '1663');
INSERT INTO `registered` VALUES ('2011', '+', '1664');
INSERT INTO `registered` VALUES ('2011', '+', '1665');
INSERT INTO `registered` VALUES ('2011', '+', '1666');
INSERT INTO `registered` VALUES ('2011', '+', '1667');
INSERT INTO `registered` VALUES ('2011', '+', '1668');
INSERT INTO `registered` VALUES ('2011', '+', '1669');
INSERT INTO `registered` VALUES ('2011', '+', '1670');
INSERT INTO `registered` VALUES ('2011', '+', '1671');
INSERT INTO `registered` VALUES ('2011', '+', '1672');
INSERT INTO `registered` VALUES ('2011', 'probe', '1673');
INSERT INTO `registered` VALUES ('2011', 'probe', '1674');
INSERT INTO `registered` VALUES ('2011', 'probe', '1675');
INSERT INTO `registered` VALUES ('2011', 'probe', '1676');
INSERT INTO `registered` VALUES ('2011', 'probe', '1677');
INSERT INTO `registered` VALUES ('2011', 'probe', '1678');
INSERT INTO `registered` VALUES ('2011', '+', '1679');
INSERT INTO `registered` VALUES ('2011', '+', '1680');
INSERT INTO `registered` VALUES ('2011', '+', '1681');
INSERT INTO `registered` VALUES ('2011', '+', '1682');
INSERT INTO `registered` VALUES ('2011', '+', '1683');
INSERT INTO `registered` VALUES ('2011', 'probe', '1684');
INSERT INTO `registered` VALUES ('2011', '+', '1685');
INSERT INTO `registered` VALUES ('2010', '+', '1686');
INSERT INTO `registered` VALUES ('2010', '+', '1687');
INSERT INTO `registered` VALUES ('2010', '-', '1688');
INSERT INTO `registered` VALUES ('2010', '-', '1689');
INSERT INTO `registered` VALUES ('2010', '+', '1690');
INSERT INTO `registered` VALUES ('2010', '-', '1691');
INSERT INTO `registered` VALUES ('2010', '-', '1692');
INSERT INTO `registered` VALUES ('2010', '-', '1693');
INSERT INTO `registered` VALUES ('2010', '+', '1694');
INSERT INTO `registered` VALUES ('2010', '-', '1695');
INSERT INTO `registered` VALUES ('2010', '+', '1696');
INSERT INTO `registered` VALUES ('2010', 'probe', '1697');
INSERT INTO `registered` VALUES ('2010', 'probe', '1698');
INSERT INTO `registered` VALUES ('2010', 'probe', '1699');
INSERT INTO `registered` VALUES ('2010', 'probe', '1700');
INSERT INTO `registered` VALUES ('2010', '-', '1701');
INSERT INTO `registered` VALUES ('2010', '-', '1702');
INSERT INTO `registered` VALUES ('2010', '+', '1703');
INSERT INTO `registered` VALUES ('2010', '+', '1704');
INSERT INTO `registered` VALUES ('2010', 'probe', '1705');
INSERT INTO `registered` VALUES ('2010', '-', '1706');
INSERT INTO `registered` VALUES ('2010', '+', '1707');
INSERT INTO `registered` VALUES ('2010', '+', '1708');
INSERT INTO `registered` VALUES ('2010', '-', '1709');
INSERT INTO `registered` VALUES ('2010', '+', '1710');
INSERT INTO `registered` VALUES ('2010', '+', '1711');
INSERT INTO `registered` VALUES ('2010', 'probe', '1712');
INSERT INTO `registered` VALUES ('2010', 'probe', '1713');
INSERT INTO `registered` VALUES ('2010', '+', '1714');
INSERT INTO `registered` VALUES ('2010', 'probe', '1715');
INSERT INTO `registered` VALUES ('2010', 'probe', '1716');
INSERT INTO `registered` VALUES ('2010', 'probe', '1717');
INSERT INTO `registered` VALUES ('2010', 'probe', '1718');
INSERT INTO `registered` VALUES ('2010', 'probe', '1719');
INSERT INTO `registered` VALUES ('2010', 'probe', '1720');
INSERT INTO `registered` VALUES ('2010', 'probe', '1721');
INSERT INTO `registered` VALUES ('2010', 'probe', '1722');
INSERT INTO `registered` VALUES ('2010', 'probe', '1723');
INSERT INTO `registered` VALUES ('2010', 'probe', '1724');
INSERT INTO `registered` VALUES ('2010', '+', '1725');
INSERT INTO `registered` VALUES ('2010', '+', '1726');
INSERT INTO `registered` VALUES ('2010', '-', '1727');
INSERT INTO `registered` VALUES ('2010', '+', '1728');
INSERT INTO `registered` VALUES ('2010', 'probe', '1729');
INSERT INTO `registered` VALUES ('2010', '+', '1730');
INSERT INTO `registered` VALUES ('2010', '+', '1731');
INSERT INTO `registered` VALUES ('2010', '+', '1732');
INSERT INTO `registered` VALUES ('2010', '+', '1733');
INSERT INTO `registered` VALUES ('2010', '+', '1734');
INSERT INTO `registered` VALUES ('2010', '-', '1735');
INSERT INTO `registered` VALUES ('2010', '-', '1736');
INSERT INTO `registered` VALUES ('2010', '+', '1737');
INSERT INTO `registered` VALUES ('2010', '+', '1738');
INSERT INTO `registered` VALUES ('2010', 'probe', '1739');
INSERT INTO `registered` VALUES ('2010', 'probe', '1740');
INSERT INTO `registered` VALUES ('2010', '+', '1741');
INSERT INTO `registered` VALUES ('2010', '+', '1742');
INSERT INTO `registered` VALUES ('2010', 'probe', '1743');
INSERT INTO `registered` VALUES ('2010', 'probe', '1744');
INSERT INTO `registered` VALUES ('2010', 'probe', '1745');
INSERT INTO `registered` VALUES ('2010', 'probe', '1746');
INSERT INTO `registered` VALUES ('2010', '+', '1747');
INSERT INTO `registered` VALUES ('2010', '-', '1748');
INSERT INTO `registered` VALUES ('2010', '+', '1749');
INSERT INTO `registered` VALUES ('2010', 'probe', '1750');
INSERT INTO `registered` VALUES ('2010', '+', '1751');
INSERT INTO `registered` VALUES ('2010', 'probe', '1752');
INSERT INTO `registered` VALUES ('2010', '+', '1753');
INSERT INTO `registered` VALUES ('2010', '+', '1754');
INSERT INTO `registered` VALUES ('2010', '+', '1755');
INSERT INTO `registered` VALUES ('2010', '+', '1756');
INSERT INTO `registered` VALUES ('2010', '+', '1757');
INSERT INTO `registered` VALUES ('2010', '+', '1758');
INSERT INTO `registered` VALUES ('2010', '+', '1759');
INSERT INTO `registered` VALUES ('2010', '+', '1760');
INSERT INTO `registered` VALUES ('2010', '-', '1761');
INSERT INTO `registered` VALUES ('2010', '+', '1762');
INSERT INTO `registered` VALUES ('2010', '+', '1763');
INSERT INTO `registered` VALUES ('2010', '+', '1764');
INSERT INTO `registered` VALUES ('2010', 'probe', '1765');
INSERT INTO `registered` VALUES ('2010', '+', '1766');
INSERT INTO `registered` VALUES ('2010', '+', '1767');
INSERT INTO `registered` VALUES ('2010', '+', '1768');
INSERT INTO `registered` VALUES ('2010', '+', '1769');
INSERT INTO `registered` VALUES ('2010', '-', '1770');
INSERT INTO `registered` VALUES ('2010', '+', '1771');
INSERT INTO `registered` VALUES ('2010', 'probe', '1772');
INSERT INTO `registered` VALUES ('2010', 'probe', '1773');
INSERT INTO `registered` VALUES ('2010', 'probe', '1774');
INSERT INTO `registered` VALUES ('2010', '+', '1775');
INSERT INTO `registered` VALUES ('2010', 'probe', '1776');
INSERT INTO `registered` VALUES ('2010', '+', '1777');
INSERT INTO `registered` VALUES ('2010', '-', '1778');
INSERT INTO `registered` VALUES ('2010', 'probe', '1779');
INSERT INTO `registered` VALUES ('2010', 'probe', '1780');
INSERT INTO `registered` VALUES ('2010', '+', '1781');
INSERT INTO `registered` VALUES ('2010', '-', '1782');
INSERT INTO `registered` VALUES ('2010', '+', '1783');
INSERT INTO `registered` VALUES ('2010', '-', '1784');
INSERT INTO `registered` VALUES ('2010', '+', '1785');
INSERT INTO `registered` VALUES ('2010', '+', '1786');
INSERT INTO `registered` VALUES ('2010', '+', '1787');
INSERT INTO `registered` VALUES ('2010', '+', '1788');
INSERT INTO `registered` VALUES ('2010', '+', '1789');
INSERT INTO `registered` VALUES ('2010', '-', '1790');
INSERT INTO `registered` VALUES ('2010', '-', '1791');
INSERT INTO `registered` VALUES ('2010', '+', '1792');
INSERT INTO `registered` VALUES ('2010', '-', '1793');
INSERT INTO `registered` VALUES ('2010', '-', '1794');
INSERT INTO `registered` VALUES ('2010', '-', '1795');
INSERT INTO `registered` VALUES ('2010', '-', '1796');
INSERT INTO `registered` VALUES ('2010', '+', '1797');
INSERT INTO `registered` VALUES ('2010', '+', '1798');
INSERT INTO `registered` VALUES ('2010', '+', '1799');
INSERT INTO `registered` VALUES ('2010', '+', '1800');
INSERT INTO `registered` VALUES ('2010', '+', '1801');
INSERT INTO `registered` VALUES ('2010', 'probe', '1802');
INSERT INTO `registered` VALUES ('2010', '-', '1803');
INSERT INTO `registered` VALUES ('2010', '+', '1804');
INSERT INTO `registered` VALUES ('2010', '+', '1805');
INSERT INTO `registered` VALUES ('2010', '+', '1806');
INSERT INTO `registered` VALUES ('2010', '+', '1807');
INSERT INTO `registered` VALUES ('2010', '-', '1808');
INSERT INTO `registered` VALUES ('2010', '+', '1809');
INSERT INTO `registered` VALUES ('2010', '+', '1810');
INSERT INTO `registered` VALUES ('2010', '+', '1811');
INSERT INTO `registered` VALUES ('2010', '+', '1812');
INSERT INTO `registered` VALUES ('2010', '+', '1813');
INSERT INTO `registered` VALUES ('2010', '+', '1814');
INSERT INTO `registered` VALUES ('2010', '+', '1815');
INSERT INTO `registered` VALUES ('2010', '-', '1816');
INSERT INTO `registered` VALUES ('2010', '+', '1817');
INSERT INTO `registered` VALUES ('2010', 'probe', '1818');
INSERT INTO `registered` VALUES ('2010', 'probe', '1819');
INSERT INTO `registered` VALUES ('2010', 'probe', '1820');
INSERT INTO `registered` VALUES ('2010', '-', '1821');
INSERT INTO `registered` VALUES ('2010', '+', '1822');
INSERT INTO `registered` VALUES ('2010', '+', '1823');
INSERT INTO `registered` VALUES ('2010', '+', '1824');
INSERT INTO `registered` VALUES ('2010', 'probe', '1825');
INSERT INTO `registered` VALUES ('2010', '+', '1826');
INSERT INTO `registered` VALUES ('2010', '+', '1827');
INSERT INTO `registered` VALUES ('2010', '-', '1828');
INSERT INTO `registered` VALUES ('2010', '-', '1829');
INSERT INTO `registered` VALUES ('2010', '-', '1830');
INSERT INTO `registered` VALUES ('2010', 'probe', '1831');
INSERT INTO `registered` VALUES ('2010', '+', '1832');
INSERT INTO `registered` VALUES ('2010', '+', '1833');
INSERT INTO `registered` VALUES ('2010', '+', '1834');
INSERT INTO `registered` VALUES ('2010', '+', '1835');
INSERT INTO `registered` VALUES ('2010', 'probe', '1836');
INSERT INTO `registered` VALUES ('2010', '+', '1837');
INSERT INTO `registered` VALUES ('2010', '+', '1838');
INSERT INTO `registered` VALUES ('2010', '+', '1839');
INSERT INTO `registered` VALUES ('2010', 'probe', '1840');
INSERT INTO `registered` VALUES ('2010', 'probe', '1841');
INSERT INTO `registered` VALUES ('2010', '+', '1842');
INSERT INTO `registered` VALUES ('2010', 'probe', '1843');
INSERT INTO `registered` VALUES ('2010', 'probe', '1844');
INSERT INTO `registered` VALUES ('2010', '+', '1845');
INSERT INTO `registered` VALUES ('2010', 'probe', '1846');
INSERT INTO `registered` VALUES ('2010', 'probe', '1847');
INSERT INTO `registered` VALUES ('2010', '+', '1848');
INSERT INTO `registered` VALUES ('2010', '-', '1849');
INSERT INTO `registered` VALUES ('2010', '-', '1850');
INSERT INTO `registered` VALUES ('2010', 'probe', '1851');
INSERT INTO `registered` VALUES ('2010', 'probe', '1852');
INSERT INTO `registered` VALUES ('2010', '+', '1853');
INSERT INTO `registered` VALUES ('2010', '-', '1854');
INSERT INTO `registered` VALUES ('2010', '-', '1855');
INSERT INTO `registered` VALUES ('2010', '-', '1856');
INSERT INTO `registered` VALUES ('2010', '-', '1857');
INSERT INTO `registered` VALUES ('2010', '-', '1858');
INSERT INTO `registered` VALUES ('2010', '-', '1859');
INSERT INTO `registered` VALUES ('2010', '-', '1860');
INSERT INTO `registered` VALUES ('2010', '-', '1861');
INSERT INTO `registered` VALUES ('2010', '+', '1862');
INSERT INTO `registered` VALUES ('2010', '+', '1863');
INSERT INTO `registered` VALUES ('2010', 'probe', '1864');
INSERT INTO `registered` VALUES ('2010', '+', '1865');
INSERT INTO `registered` VALUES ('2010', '+', '1866');
INSERT INTO `registered` VALUES ('2010', '+', '1867');
INSERT INTO `registered` VALUES ('2010', '+', '1868');
INSERT INTO `registered` VALUES ('2010', '+', '1869');
INSERT INTO `registered` VALUES ('2010', '+', '1870');
INSERT INTO `registered` VALUES ('2010', '+', '1871');
INSERT INTO `registered` VALUES ('2010', 'probe', '1872');
INSERT INTO `registered` VALUES ('2010', 'probe', '1873');
INSERT INTO `registered` VALUES ('2010', 'probe', '1874');
INSERT INTO `registered` VALUES ('2010', '+', '1875');
INSERT INTO `registered` VALUES ('2010', 'probe', '1876');
INSERT INTO `registered` VALUES ('2010', '+', '1877');
INSERT INTO `registered` VALUES ('2010', '+', '1878');
INSERT INTO `registered` VALUES ('2010', '+', '1879');
INSERT INTO `registered` VALUES ('2010', '+', '1880');
INSERT INTO `registered` VALUES ('2010', '+', '1881');
INSERT INTO `registered` VALUES ('2010', 'probe', '1882');
INSERT INTO `registered` VALUES ('2010', '+', '1883');
INSERT INTO `registered` VALUES ('2010', '+', '1884');
INSERT INTO `registered` VALUES ('2010', 'probe', '1885');
INSERT INTO `registered` VALUES ('2010', '+', '1886');
INSERT INTO `registered` VALUES ('2010', '+', '1887');
INSERT INTO `registered` VALUES ('2010', '+', '1888');

r937 · May 30, 2013, 8:09pm

that’s actually just a TABLE

what i meant is this –

CREATE VIEW annual_totals
AS
SELECT …

in some places/companies/organizations, you are not allowed to define a VIEW

Miguel61 · May 31, 2013, 5:12pm

thank you, I understand … possible solution for my problem …

mysql&gt; CREATE TABLE
IF NOT EXISTS foo SELECT
	`YEAR`,
	g,
	COUNT(*) AS number
FROM
	`registered`
WHERE
	(
		`YEAR` &gt; 1970
		AND g NOT IN ('probe')
	)
GROUP BY
	`YEAR`,
	g
ORDER BY
	`YEAR` DESC,
	number DESC;

SELECT
	a. YEAR,
	a.g,
	a.number,
	CONCAT(
		ROUND(
			(a.number - b.number) / b.number * 100,
			1
		),
		'%'
	) AS output
FROM
	foo AS a
LEFT JOIN foo AS b ON a. YEAR = b. YEAR + 1
AND a.g = b.g;

DROP TABLE foo;
Query OK, 8 rows affected
Records: 8  Duplicates: 0  Warnings: 0

+------+---+--------+--------+
| YEAR | g | number | output |
+------+---+--------+--------+
| 2013 | + |     52 | -87.8% |
| 2013 | - |     31 | -65.6% |
| 2012 | + |    426 | 0.9%   |
| 2012 | - |     90 | 1.1%   |
| 2011 | + |    422 | 298.1% |
| 2011 | - |     89 | 111.9% |
| 2010 | + |    106 | NULL   |
| 2010 | - |     42 | NULL   |
+------+---+--------+--------+
8 rows in set

Query OK, 0 rows affected

r937 · May 31, 2013, 5:33pm

so, are you allowed to create a VIEW or not?

Miguel61 · June 1, 2013, 7:14am

Yes Sir:

CREATE VIEW SalePerOrder
   AS
  SELECT
	`YEAR`,
	g,
	COUNT(*) AS number
FROM
	`registered`
WHERE
	(
		`YEAR` &gt; 1970
		AND g NOT IN ('probe')
	)
GROUP BY
	`YEAR`,
	g
ORDER BY
	`YEAR` DESC,
	number DESC;

SELECT
	`registered`.`Year` AS `YEAR`,
	`registered`.`G` AS `g`,
	count(0) AS `number`
FROM
	`registered`
WHERE
	(
		(`registered`.`Year` > 1970)
		AND (`registered`.`G` &lt;&gt; 'probe')
	)
GROUP BY
	`registered`.`Year`,
	`registered`.`G`
ORDER BY
	`registered`.`Year` DESC,
	count(0) DESC;

ALTER 
ALGORITHM=UNDEFINED 
DEFINER=`root`@`localhost` 
SQL SECURITY DEFINER 
VIEW `saleperorder` AS 
SELECT
	`registered`.`Year` AS `YEAR`,
	`registered`.`G` AS `g`,
	count(0) AS `number`
FROM
	`registered`
WHERE
	(
		(`registered`.`Year` > 1970)
		AND (`registered`.`G` &lt;&gt; 'probe')
	)
GROUP BY
	`registered`.`Year`,
	`registered`.`G`
ORDER BY
	`registered`.`Year` DESC,
	count(0) DESC;

+------+---+--------+
| YEAR | g | number |
+------+---+--------+
| 2013 | + |     52 |
| 2013 | - |     31 |
| 2012 | + |    426 |
| 2012 | - |     90 |
| 2011 | + |    422 |
| 2011 | - |     89 |
| 2010 | + |    106 |
| 2010 | - |     42 |
+------+---+--------+

r937 · June 1, 2013, 9:41am

okay, omit the ORDER BY clause from your view, and then use your view like the way you used the “foo” table earlier

Miguel61 · June 3, 2013, 5:57pm

Very nice, thank you

Topic		Replies	Views
Query COUNT (*) Databases	7	978	October 8, 2014
How to create a MySQL View to select the smallest and largest Records? Databases mysql	3	1805	October 31, 2020
[MySQL] Query Databases	20	909	April 28, 2010
Difficult problem in output query Databases	5	685	October 8, 2014
Problem with GROUP BY Databases	10	707	May 3, 2010

Compare records in table

Related topics