CREATE TABLE ADIF (ADIFName UNIQUE NOT NULL, Type NOT NULL);
INSERT INTO ADIF VALUES('BAND','E');
INSERT INTO ADIF VALUES('CALL','S');
INSERT INTO ADIF VALUES('COMMENT','S');
INSERT INTO ADIF VALUES('GRIDSQUARE','G');
INSERT INTO ADIF VALUES('APP_LinLog_GRID4','G');
INSERT INTO ADIF VALUES('MODE','E');
INSERT INTO ADIF VALUES('NAME','S');
INSERT INTO ADIF VALUES('QSLMSG','M');
INSERT INTO ADIF VALUES('QSLRDATE','D');
INSERT INTO ADIF VALUES('QSLSDATE','D');
INSERT INTO ADIF VALUES('QSL_RCVD','E');
INSERT INTO ADIF VALUES('QSL_SENT','E');
INSERT INTO ADIF VALUES('QSL_SENT_VIA','E');
INSERT INTO ADIF VALUES('QSL_VIA','S');
INSERT INTO ADIF VALUES('QSO_DATE','D');
INSERT INTO ADIF VALUES('QTH','S');
INSERT INTO ADIF VALUES('RST_RCVD','S');
INSERT INTO ADIF VALUES('RST_SENT','S');
INSERT INTO ADIF VALUES('TIME_ON','T');
INSERT INTO ADIF VALUES('TX_PWR','N');
INSERT INTO ADIF VALUES('EQSL_QSLRDATE','D');
INSERT INTO ADIF VALUES('EQSL_QSLSDATE','D');
INSERT INTO ADIF VALUES('LOTW_QSLRDATE','D');
INSERT INTO ADIF VALUES('LOTW_QSLSDATE','D');
INSERT INTO ADIF VALUES('EQSL_QSL_RCVD','E');
INSERT INTO ADIF VALUES('EQSL_QSL_SENT','E');
INSERT INTO ADIF VALUES('LOTW_QSL_RCVD','E');
INSERT INTO ADIF VALUES('LOTW_QSL_SENT','E');
INSERT INTO ADIF VALUES('STATE','E');
INSERT INTO ADIF VALUES('MY_GRID','G');
INSERT INTO ADIF VALUES('MY_CALL','E');
INSERT INTO ADIF VALUES('DX','N');
INSERT INTO ADIF VALUES('COUNTY','S');
CREATE TABLE LinLogFields (ADIFName UNIQUE Not NULL,Type,LinLogName UNIQUE Not NULL,DefaultValue );
INSERT INTO LinLogFields VALUES('QSO_DATE','D','QSO date','');
INSERT INTO LinLogFields VALUES('TIME_ON','T','time','');
INSERT INTO LinLogFields VALUES('BAND','E','Band','11');
INSERT INTO LinLogFields VALUES('MODE','E','Mode','4');
INSERT INTO LinLogFields VALUES('CALL','S','Call','');
INSERT INTO LinLogFields VALUES('GRIDSQUARE','G','Locator','');
INSERT INTO LinLogFields VALUES('APP_LinLog_GRID4','G','Grid','');
INSERT INTO LinLogFields VALUES('STATE','E','State','');
INSERT INTO LinLogFields VALUES('COUNTY','S','County','');
INSERT INTO LinLogFields VALUES('TX_PWR','N','Tx power','20');
INSERT INTO LinLogFields VALUES('DX','N','Dx','1');
INSERT INTO LinLogFields VALUES('MY_GRID','G','My QTH','FN32pb');
INSERT INTO LinLogFields VALUES('MY_CALL','E','My Call','N1QLM');
INSERT INTO LinLogFields VALUES('RST_RCVD','S','RST rcvd','59');
INSERT INTO LinLogFields VALUES('RST_SENT','S','RST sent','59');
INSERT INTO LinLogFields VALUES('COMMENT','S','Comment','');
INSERT INTO LinLogFields VALUES('QSL_VIA','S','QSL via','');
INSERT INTO LinLogFields VALUES('QSL_SENT','E','QSL sent','2');
INSERT INTO LinLogFields VALUES('QSL_SENT_VIA','E','QSL sent via','');
INSERT INTO LinLogFields VALUES('QSLSDATE','D','QSL date sent','');
INSERT INTO LinLogFields VALUES('QSL_RCVD','E','QSL rcvd','2');
INSERT INTO LinLogFields VALUES('QSLRDATE','D','QSL date rcvd','');
INSERT INTO LinLogFields VALUES('LOTW_QSL_SENT','E','LOTW sent','2');
INSERT INTO LinLogFields VALUES('LOTW_QSLSDATE','D','LOTW sent date','');
INSERT INTO LinLogFields VALUES('LOTW_QSL_RCVD','E','LOTW rcvd','2');
INSERT INTO LinLogFields VALUES('LOTW_QSLRDATE','D','LOTW date rcvd','');
INSERT INTO LinLogFields VALUES('EQSL_QSL_RCVD','E','EQSL rcvd','2');
INSERT INTO LinLogFields VALUES('EQSL_QSL_SENT','E','EQSL sent','2');
INSERT INTO LinLogFields VALUES('EQSL_QSLRDATE','D','EQSL date rcvd','');
INSERT INTO LinLogFields VALUES('EQSL_QSLSDATE','D','EQSL date sent','');
INSERT INTO LinLogFields VALUES('QSLMSG','M','QSL msg','');
CREATE TABLE BAND (Id INTEGER PRIMARY KEY AUTOINCREMENT,BANDvalue UNIQUE NOT NULL);
INSERT INTO BAND VALUES('0','-');
INSERT INTO BAND VALUES('1','160m');
INSERT INTO BAND VALUES('2','80m');
INSERT INTO BAND VALUES('3','60m');
INSERT INTO BAND VALUES('4','40m');
INSERT INTO BAND VALUES('5','30m');
INSERT INTO BAND VALUES('6','20m');
INSERT INTO BAND VALUES('7','17m');
INSERT INTO BAND VALUES('8','15m');
INSERT INTO BAND VALUES('9','12m');
INSERT INTO BAND VALUES('10','10m');
INSERT INTO BAND VALUES('11','6m');
INSERT INTO BAND VALUES('12','2m');
INSERT INTO BAND VALUES('13','70cm');
INSERT INTO BAND VALUES('14','1.25m');
INSERT INTO BAND VALUES('15','33cm');
INSERT INTO BAND VALUES('16','23cm');
INSERT INTO BAND VALUES('17','13cm');
INSERT INTO BAND VALUES('18','9cm');
INSERT INTO BAND VALUES('19','6cm');
INSERT INTO BAND VALUES('20','3cm');
CREATE TABLE MODE (Id INTEGER PRIMARY KEY AUTOINCREMENT,MODEvalue UNIQUE);
INSERT INTO MODE VALUES('0','-');
INSERT INTO MODE VALUES('1','FM');
INSERT INTO MODE VALUES('2','MFSK16');
INSERT INTO MODE VALUES('3','PSK31');
INSERT INTO MODE VALUES('4','SSB');
INSERT INTO MODE VALUES('5','CW');
INSERT INTO MODE VALUES('6','RTTY');
INSERT INTO MODE VALUES('7','FSK441');
INSERT INTO MODE VALUES('8','JT65B');
INSERT INTO MODE VALUES('9','JT65A');
CREATE TABLE MY_CALL (Id INTEGER PRIMARY KEY AUTOINCREMENT,MY_CALLvalue UNIQUE);
INSERT INTO MY_CALL VALUES('0','-');
INSERT INTO MY_CALL VALUES('1','N1QLM');
INSERT INTO MY_CALL VALUES('2','N1QLM/P');
INSERT INTO MY_CALL VALUES('3','AA1I');
INSERT INTO MY_CALL VALUES('4','AA1I/P');
INSERT INTO MY_CALL VALUES('5','AA1I/R');
CREATE TABLE QSL_RCVD(Id INTEGER PRIMARY KEY AUTOINCREMENT,QSL_RCVDvalue UNIQUE);
INSERT INTO QSL_RCVD VALUES('0','-');
INSERT INTO QSL_RCVD VALUES('1','Y');
INSERT INTO QSL_RCVD VALUES('2','N');
INSERT INTO QSL_RCVD VALUES('3','R');
INSERT INTO QSL_RCVD VALUES('4','I');
CREATE TABLE QSL_SENT(Id INTEGER PRIMARY KEY AUTOINCREMENT,QSL_SENTvalue UNIQUE);
INSERT INTO QSL_SENT VALUES('0','-');
INSERT INTO QSL_SENT VALUES('1','Y');
INSERT INTO QSL_SENT VALUES('2','N');
INSERT INTO QSL_SENT VALUES('3','R');
INSERT INTO QSL_SENT VALUES('4','I');
INSERT INTO QSL_SENT VALUES('5','Q');
CREATE TABLE QSL_SENT_VIA(Id INTEGER PRIMARY KEY AUTOINCREMENT,QSL_SENT_VIAvalue UNIQUE);
INSERT INTO QSL_SENT_VIA VALUES('0','-');
INSERT INTO QSL_SENT_VIA VALUES('1','B');
INSERT INTO QSL_SENT_VIA VALUES('2','D');
INSERT INTO QSL_SENT_VIA VALUES('3','E');
INSERT INTO QSL_SENT_VIA VALUES('4','');
INSERT INTO QSL_SENT_VIA VALUES('5','L');
CREATE TABLE EQSL_QSL_RCVD(Id INTEGER PRIMARY KEY AUTOINCREMENT,EQSL_QSL_RCVDvalue UNIQUE);
INSERT INTO EQSL_QSL_RCVD VALUES('0','-');
INSERT INTO EQSL_QSL_RCVD VALUES('1','Y');
INSERT INTO EQSL_QSL_RCVD VALUES('2','N');
INSERT INTO EQSL_QSL_RCVD VALUES('3','R');
INSERT INTO EQSL_QSL_RCVD VALUES('4','I');
CREATE TABLE EQSL_QSL_SENT(Id INTEGER PRIMARY KEY AUTOINCREMENT,EQSL_QSL_SENTvalue UNIQUE);
INSERT INTO EQSL_QSL_SENT VALUES('0','-');
INSERT INTO EQSL_QSL_SENT VALUES('1','Y');
INSERT INTO EQSL_QSL_SENT VALUES('2','N');
INSERT INTO EQSL_QSL_SENT VALUES('3','R');
INSERT INTO EQSL_QSL_SENT VALUES('4','Q');
INSERT INTO EQSL_QSL_SENT VALUES('5','I');
CREATE TABLE LOTW_QSL_RCVD(Id INTEGER PRIMARY KEY AUTOINCREMENT,LOTW_QSL_RCVDvalue UNIQUE);
INSERT INTO LOTW_QSL_RCVD VALUES('0','-');
INSERT INTO LOTW_QSL_RCVD VALUES('1','Y');
INSERT INTO LOTW_QSL_RCVD VALUES('2','N');
INSERT INTO LOTW_QSL_RCVD VALUES('3','R');
INSERT INTO LOTW_QSL_RCVD VALUES('4','I');
CREATE TABLE LOTW_QSL_SENT(Id INTEGER PRIMARY KEY AUTOINCREMENT,LOTW_QSL_SENTvalue UNIQUE);
INSERT INTO LOTW_QSL_SENT VALUES('0','-');
INSERT INTO LOTW_QSL_SENT VALUES('1','Y');
INSERT INTO LOTW_QSL_SENT VALUES('2','N');
INSERT INTO LOTW_QSL_SENT VALUES('3','R');
INSERT INTO LOTW_QSL_SENT VALUES('4','Q');
INSERT INTO LOTW_QSL_SENT VALUES('5','I');
CREATE TABLE STATE(Id INTEGER PRIMARY KEY AUTOINCREMENT,STATEvalue UNIQUE);
INSERT INTO STATE VALUES('0','-');
INSERT INTO STATE VALUES('1','AL');
INSERT INTO STATE VALUES('2','AK');
INSERT INTO STATE VALUES('3','AZ');
INSERT INTO STATE VALUES('4','AR');
INSERT INTO STATE VALUES('5','CA');
INSERT INTO STATE VALUES('6','CO');
INSERT INTO STATE VALUES('7','CT');
INSERT INTO STATE VALUES('8','DE');
INSERT INTO STATE VALUES('9','FL');
INSERT INTO STATE VALUES('10','GA');
INSERT INTO STATE VALUES('11','HI');
INSERT INTO STATE VALUES('12','ID');
INSERT INTO STATE VALUES('13','IL');
INSERT INTO STATE VALUES('14','IN');
INSERT INTO STATE VALUES('15','IA');
INSERT INTO STATE VALUES('16','KS');
INSERT INTO STATE VALUES('17','KY');
INSERT INTO STATE VALUES('18','LA');
INSERT INTO STATE VALUES('19','ME');
INSERT INTO STATE VALUES('20','MD');
INSERT INTO STATE VALUES('21','MA');
INSERT INTO STATE VALUES('22','MI');
INSERT INTO STATE VALUES('23','MN');
INSERT INTO STATE VALUES('24','MS');
INSERT INTO STATE VALUES('25','MO');
INSERT INTO STATE VALUES('26','MT');
INSERT INTO STATE VALUES('27','NE');
INSERT INTO STATE VALUES('28','NV');
INSERT INTO STATE VALUES('29','NH');
INSERT INTO STATE VALUES('30','NJ');
INSERT INTO STATE VALUES('31','NM');
INSERT INTO STATE VALUES('32','NY');
INSERT INTO STATE VALUES('33','NC');
INSERT INTO STATE VALUES('34','ND');
INSERT INTO STATE VALUES('35','OH');
INSERT INTO STATE VALUES('36','OK');
INSERT INTO STATE VALUES('37','OR');
INSERT INTO STATE VALUES('38','PA');
INSERT INTO STATE VALUES('39','RI');
INSERT INTO STATE VALUES('40','SC');
INSERT INTO STATE VALUES('41','SD');
INSERT INTO STATE VALUES('42','TN');
INSERT INTO STATE VALUES('43','TX');
INSERT INTO STATE VALUES('44','UT');
INSERT INTO STATE VALUES('45','VT');
INSERT INTO STATE VALUES('46','VA');
INSERT INTO STATE VALUES('47','WA');
INSERT INTO STATE VALUES('48','WV');
INSERT INTO STATE VALUES('49','WI');
INSERT INTO STATE VALUES('50','WY');
CREATE TABLE countrylist(mainPrefix PRIMARY KEY not null,countryName not null,continent not null);
INSERT INTO countrylist VALUES('1A','Sov Mil Order of Malta','EU');
INSERT INTO countrylist VALUES('1S','Spratly Is.','AS');
INSERT INTO countrylist VALUES('3A','Monaco','EU');
INSERT INTO countrylist VALUES('3B6','Agalega & St. Brandon','AF');
INSERT INTO countrylist VALUES('3B8','Mauritius','AF');
INSERT INTO countrylist VALUES('3B9','Rodriguez I.','AF');
INSERT INTO countrylist VALUES('3C','Equatorial Guinea','AF');
INSERT INTO countrylist VALUES('3C0','Annobon','AF');
INSERT INTO countrylist VALUES('3D2','Fiji','OC');
INSERT INTO countrylist VALUES('3D2/c','Conway Reef','OC');
INSERT INTO countrylist VALUES('3D2/r','Rotuma','OC');
INSERT INTO countrylist VALUES('3DA','Swaziland','AF');
INSERT INTO countrylist VALUES('3V','Tunisia','AF');
INSERT INTO countrylist VALUES('3W','Vietnam','AS');
INSERT INTO countrylist VALUES('3X','Guinea','AF');
INSERT INTO countrylist VALUES('3Y/b','Bouvet','AF');
INSERT INTO countrylist VALUES('3Y/p','Peter I I.','SA');
INSERT INTO countrylist VALUES('4J','Azerbaijan','AS');
INSERT INTO countrylist VALUES('4L','Georgia','AS');
INSERT INTO countrylist VALUES('4O','Montenegro','EU');
INSERT INTO countrylist VALUES('4S','Sri Lanka','AS');
INSERT INTO countrylist VALUES('4U1I','ITU HQ Geneva','EU');
INSERT INTO countrylist VALUES('4U1U','United Nations HQ','NA');
INSERT INTO countrylist VALUES('*4U1V','Vienna Intl Ctr','EU');
INSERT INTO countrylist VALUES('4W','Timor-Leste','OC');
INSERT INTO countrylist VALUES('4X','Israel','AS');
INSERT INTO countrylist VALUES('5A','Libya','AF');
INSERT INTO countrylist VALUES('5B','Cyprus','AS');
INSERT INTO countrylist VALUES('5H','Tanzania','AF');
INSERT INTO countrylist VALUES('5N','Nigeria','AF');
INSERT INTO countrylist VALUES('5R','Madagascar','AF');
INSERT INTO countrylist VALUES('5T','Mauritania','AF');
INSERT INTO countrylist VALUES('5U','Niger','AF');
INSERT INTO countrylist VALUES('5V','Togo','AF');
INSERT INTO countrylist VALUES('5W','Samoa','OC');
INSERT INTO countrylist VALUES('5X','Uganda','AF');
INSERT INTO countrylist VALUES('5Z','Kenya','AF');
INSERT INTO countrylist VALUES('6W','Senegal','AF');
INSERT INTO countrylist VALUES('6Y','Jamaica','NA');
INSERT INTO countrylist VALUES('7O','Yemen','AS');
INSERT INTO countrylist VALUES('7P','Lesotho','AF');
INSERT INTO countrylist VALUES('7Q','Malawi','AF');
INSERT INTO countrylist VALUES('7X','Algeria','AF');
INSERT INTO countrylist VALUES('8P','Barbados','NA');
INSERT INTO countrylist VALUES('8Q','Maldives','AS');
INSERT INTO countrylist VALUES('8R','Guyana','SA');
INSERT INTO countrylist VALUES('9A','Croatia','EU');
INSERT INTO countrylist VALUES('9G','Ghana','AF');
INSERT INTO countrylist VALUES('9H','Malta','EU');
INSERT INTO countrylist VALUES('9J','Zambia','AF');
INSERT INTO countrylist VALUES('9K','Kuwait','AS');
INSERT INTO countrylist VALUES('9L','Sierra Leone','AF');
INSERT INTO countrylist VALUES('9M2','West Malaysia','AS');
INSERT INTO countrylist VALUES('9M6','East Malaysia','OC');
INSERT INTO countrylist VALUES('9N','Nepal','AS');
INSERT INTO countrylist VALUES('9Q','Rep. of Congo','AF');
INSERT INTO countrylist VALUES('9U','Burundi','AF');
INSERT INTO countrylist VALUES('9V','Singapore','AS');
INSERT INTO countrylist VALUES('9X','Rwanda','AF');
INSERT INTO countrylist VALUES('9Y','Trinidad & Tobago','SA');
INSERT INTO countrylist VALUES('A2','Botswana','AF');
INSERT INTO countrylist VALUES('A3','Tonga','OC');
INSERT INTO countrylist VALUES('A4','Oman','AS');
INSERT INTO countrylist VALUES('A5','Bhutan','AS');
INSERT INTO countrylist VALUES('A6','United Arab Emirates','AS');
INSERT INTO countrylist VALUES('A7','Qatar','AS');
INSERT INTO countrylist VALUES('A9','Bahrain','AS');
INSERT INTO countrylist VALUES('AP','Pakistan','AS');
INSERT INTO countrylist VALUES('BS7','Scarborough Reef','AS');
INSERT INTO countrylist VALUES('BV','Taiwan','AS');
INSERT INTO countrylist VALUES('BV9P','Pratas Island','AS');
INSERT INTO countrylist VALUES('BY','China','AS');
INSERT INTO countrylist VALUES('C2','Nauru','OC');
INSERT INTO countrylist VALUES('C3','Andorra','EU');
INSERT INTO countrylist VALUES('C5','Gambia','AF');
INSERT INTO countrylist VALUES('C6','Bahamas','NA');
INSERT INTO countrylist VALUES('C9','Mozambique','AF');
INSERT INTO countrylist VALUES('CE','Chile','SA');
INSERT INTO countrylist VALUES('CE0X','San Felix I.','SA');
INSERT INTO countrylist VALUES('CE0Y','Easter Island','SA');
INSERT INTO countrylist VALUES('CE0Z','Juan Fernandez Is.','SA');
INSERT INTO countrylist VALUES('CE9','Antarctica','SA');
INSERT INTO countrylist VALUES('CM','Cuba','NA');
INSERT INTO countrylist VALUES('CN','Morocco','AF');
INSERT INTO countrylist VALUES('CP','Bolivia','SA');
INSERT INTO countrylist VALUES('CT','Portugal','EU');
INSERT INTO countrylist VALUES('CT3','Madeira Is.','AF');
INSERT INTO countrylist VALUES('CU','Azores','EU');
INSERT INTO countrylist VALUES('CX','Uruguay','SA');
INSERT INTO countrylist VALUES('CY0','Sable I.','NA');
INSERT INTO countrylist VALUES('CY9','St. Paul I.','NA');
INSERT INTO countrylist VALUES('D2','Angola','AF');
INSERT INTO countrylist VALUES('D4','Cape Verde','AF');
INSERT INTO countrylist VALUES('D6','Comoros','AF');
INSERT INTO countrylist VALUES('DL','Germany','EU');
INSERT INTO countrylist VALUES('DU','Philippines','OC');
INSERT INTO countrylist VALUES('E3','Eritrea','AF');
INSERT INTO countrylist VALUES('E4','Palestine','AS');
INSERT INTO countrylist VALUES('E5/n','North Cook Is.','OC');
INSERT INTO countrylist VALUES('E5/s','South Cook Is.','OC');
INSERT INTO countrylist VALUES('E7','Bosnia-Herzegovina','EU');
INSERT INTO countrylist VALUES('EA','Spain','EU');
INSERT INTO countrylist VALUES('EA6','Balearic Is.','EU');
INSERT INTO countrylist VALUES('EA8','Canary Is.','AF');
INSERT INTO countrylist VALUES('EA9','Ceuta and Melilla','AF');
INSERT INTO countrylist VALUES('EI','Ireland','EU');
INSERT INTO countrylist VALUES('EK','Armenia','AS');
INSERT INTO countrylist VALUES('EL','Liberia','AF');
INSERT INTO countrylist VALUES('EP','Iran','AS');
INSERT INTO countrylist VALUES('ER','Moldova','EU');
INSERT INTO countrylist VALUES('ES','Estonia','EU');
INSERT INTO countrylist VALUES('ET','Ethiopia','AF');
INSERT INTO countrylist VALUES('EU','Belarus','EU');
INSERT INTO countrylist VALUES('EX','Kyrgyzstan','AS');
INSERT INTO countrylist VALUES('EY','Tajikistan','AS');
INSERT INTO countrylist VALUES('EZ','Turkmenistan','AS');
INSERT INTO countrylist VALUES('F','France','EU');
INSERT INTO countrylist VALUES('FG','Guadeloupe','NA');
INSERT INTO countrylist VALUES('FH','Mayotte','AF');
INSERT INTO countrylist VALUES('FJ','St. Barthelemy','NA');
INSERT INTO countrylist VALUES('FK','New Caledonia','OC');
INSERT INTO countrylist VALUES('FK/c','Chesterfield Is.','OC');
INSERT INTO countrylist VALUES('FM','Martinique','NA');
INSERT INTO countrylist VALUES('FO','French Polynesia','OC');
INSERT INTO countrylist VALUES('FO/a','Austral Is.','OC');
INSERT INTO countrylist VALUES('FO/c','Clipperton I.','NA');
INSERT INTO countrylist VALUES('FO/m','Marquesas Is.','OC');
INSERT INTO countrylist VALUES('FP','St. Pierre & Miquelon','NA');
INSERT INTO countrylist VALUES('FR','Reunion','AF');
INSERT INTO countrylist VALUES('FR/g','Glorioso','AF');
INSERT INTO countrylist VALUES('FR/j','Juan de Nova & Europa','AF');
INSERT INTO countrylist VALUES('FR/t','Tromelin','AF');
INSERT INTO countrylist VALUES('FS','French St. Martin','NA');
INSERT INTO countrylist VALUES('FT5W','Crozet','AF');
INSERT INTO countrylist VALUES('FT5X','Kerguelen','AF');
INSERT INTO countrylist VALUES('FT5Z','Amsterdam & St. Paul','AF');
INSERT INTO countrylist VALUES('FW','Wallis & Futuna Is.','OC');
INSERT INTO countrylist VALUES('FY','French Guiana','SA');
INSERT INTO countrylist VALUES('G','England','EU');
INSERT INTO countrylist VALUES('GD','Isle of Man','EU');
INSERT INTO countrylist VALUES('GI','Northern Ireland','EU');
INSERT INTO countrylist VALUES('GJ','Jersey','EU');
INSERT INTO countrylist VALUES('GM','Scotland','EU');
INSERT INTO countrylist VALUES('*GM/s','Shetland','EU');
INSERT INTO countrylist VALUES('GU','Guernsey','EU');
INSERT INTO countrylist VALUES('GW','Wales','EU');
INSERT INTO countrylist VALUES('H4','Solomon Islands','OC');
INSERT INTO countrylist VALUES('H40','Temotu','OC');
INSERT INTO countrylist VALUES('HA','Hungary','EU');
INSERT INTO countrylist VALUES('HB','Switzerland','EU');
INSERT INTO countrylist VALUES('HB0','Liechtenstein','EU');
INSERT INTO countrylist VALUES('HC','Ecuador','SA');
INSERT INTO countrylist VALUES('HC8','Galapagos Is.','SA');
INSERT INTO countrylist VALUES('HH','Haiti','NA');
INSERT INTO countrylist VALUES('HI','Dominican Republic','NA');
INSERT INTO countrylist VALUES('HK','Colombia','SA');
INSERT INTO countrylist VALUES('HK0/a','San Andres/Providencia','NA');
INSERT INTO countrylist VALUES('HK0/m','Malpelo I.','SA');
INSERT INTO countrylist VALUES('HL','South Korea','AS');
INSERT INTO countrylist VALUES('HM','North Korea','AS');
INSERT INTO countrylist VALUES('HP','Panama','NA');
INSERT INTO countrylist VALUES('HR','Honduras','NA');
INSERT INTO countrylist VALUES('HS','Thailand','AS');
INSERT INTO countrylist VALUES('HV','Vatican City','EU');
INSERT INTO countrylist VALUES('HZ','Saudi Arabia','AS');
INSERT INTO countrylist VALUES('I','Italy','EU');
INSERT INTO countrylist VALUES('*IG9','Italy (Africa)','AF');
INSERT INTO countrylist VALUES('IS','Sardinia','EU');
INSERT INTO countrylist VALUES('*IT9','Sicily','EU');
INSERT INTO countrylist VALUES('J2','Djibouti','AF');
INSERT INTO countrylist VALUES('J3','Grenada','NA');
INSERT INTO countrylist VALUES('J5','Guinea-Bissau','AF');
INSERT INTO countrylist VALUES('J6','St. Lucia','NA');
INSERT INTO countrylist VALUES('J7','Dominica','NA');
INSERT INTO countrylist VALUES('J8','St. Vincent','NA');
INSERT INTO countrylist VALUES('JA','Japan','AS');
INSERT INTO countrylist VALUES('JD/m','Minami Torishima','OC');
INSERT INTO countrylist VALUES('JD/o','Ogasawara','AS');
INSERT INTO countrylist VALUES('JT','Mongolia','AS');
INSERT INTO countrylist VALUES('JW','Svalbard','EU');
INSERT INTO countrylist VALUES('*JW/b','Bear I.','EU');
INSERT INTO countrylist VALUES('JX','Jan Mayen','EU');
INSERT INTO countrylist VALUES('JY','Jordan','AS');
INSERT INTO countrylist VALUES('K','United States','NA');
INSERT INTO countrylist VALUES('KG4','Guantanamo Bay','NA');
INSERT INTO countrylist VALUES('KH0','Mariana Is.','OC');
INSERT INTO countrylist VALUES('KH1','Baker & Howland Is.','OC');
INSERT INTO countrylist VALUES('KH2','Guam','OC');
INSERT INTO countrylist VALUES('KH3','Johnston I.','OC');
INSERT INTO countrylist VALUES('KH4','Midway I.','OC');
INSERT INTO countrylist VALUES('KH5','Palmyra & Jarvis Is.','OC');
INSERT INTO countrylist VALUES('KH5K','Kingman Reef','OC');
INSERT INTO countrylist VALUES('KH6','Hawaii','OC');
INSERT INTO countrylist VALUES('KH7K','Kure I.','OC');
INSERT INTO countrylist VALUES('KH8','American Samoa','OC');
INSERT INTO countrylist VALUES('KH8/s','Swains Island','OC');
INSERT INTO countrylist VALUES('KH9','Wake I.','OC');
INSERT INTO countrylist VALUES('KL','Alaska','NA');
INSERT INTO countrylist VALUES('KP1','Navassa I.','NA');
INSERT INTO countrylist VALUES('KP2','Virgin Is.','NA');
INSERT INTO countrylist VALUES('KP4','Puerto Rico','NA');
INSERT INTO countrylist VALUES('KP5','Desecheo I.','NA');
INSERT INTO countrylist VALUES('LA','Norway','EU');
INSERT INTO countrylist VALUES('LU','Argentina','SA');
INSERT INTO countrylist VALUES('LX','Luxembourg','EU');
INSERT INTO countrylist VALUES('LY','Lithuania','EU');
INSERT INTO countrylist VALUES('LZ','Bulgaria','EU');
INSERT INTO countrylist VALUES('OA','Peru','SA');
INSERT INTO countrylist VALUES('OD','Lebanon','AS');
INSERT INTO countrylist VALUES('OE','Austria','EU');
INSERT INTO countrylist VALUES('OH','Finland','EU');
INSERT INTO countrylist VALUES('OH0','Aland Is.','EU');
INSERT INTO countrylist VALUES('OJ0','Market Reef','EU');
INSERT INTO countrylist VALUES('OK','Czech Republic','EU');
INSERT INTO countrylist VALUES('OM','Slovakia','EU');
INSERT INTO countrylist VALUES('ON','Belgium','EU');
INSERT INTO countrylist VALUES('OX','Greenland','NA');
INSERT INTO countrylist VALUES('OY','Faroe Is.','EU');
INSERT INTO countrylist VALUES('OZ','Denmark','EU');
INSERT INTO countrylist VALUES('P2','Papua New Guinea','OC');
INSERT INTO countrylist VALUES('P4','Aruba','SA');
INSERT INTO countrylist VALUES('PA','Netherlands','EU');
INSERT INTO countrylist VALUES('PJ2','Netherlands Antilles','SA');
INSERT INTO countrylist VALUES('PJ7','Sint Maarten','NA');
INSERT INTO countrylist VALUES('PY','Brazil','SA');
INSERT INTO countrylist VALUES('PY0F','Fernando de Noronha','SA');
INSERT INTO countrylist VALUES('PY0S','St. Peter & St. Paul','SA');
INSERT INTO countrylist VALUES('PY0T','Trindade & Martim Vaz','SA');
INSERT INTO countrylist VALUES('PZ','Suriname','SA');
INSERT INTO countrylist VALUES('R1FJ','Franz Josef Land','EU');
INSERT INTO countrylist VALUES('R1MV','Malyj Vysotskij','EU');
INSERT INTO countrylist VALUES('S0','Western Sahara','AF');
INSERT INTO countrylist VALUES('S2','Bangladesh','AS');
INSERT INTO countrylist VALUES('S5','Slovenia','EU');
INSERT INTO countrylist VALUES('S7','Seychelles','AF');
INSERT INTO countrylist VALUES('S9','Sao Tome & Principe','AF');
INSERT INTO countrylist VALUES('SM','Sweden','EU');
INSERT INTO countrylist VALUES('SP','Poland','EU');
INSERT INTO countrylist VALUES('ST','Sudan','AF');
INSERT INTO countrylist VALUES('SU','Egypt','AF');
INSERT INTO countrylist VALUES('SV','Greece','EU');
INSERT INTO countrylist VALUES('SV/a','Mount Athos','EU');
INSERT INTO countrylist VALUES('SV5','Dodecanese','EU');
INSERT INTO countrylist VALUES('SV9','Crete','EU');
INSERT INTO countrylist VALUES('T2','Tuvalu','OC');
INSERT INTO countrylist VALUES('T30','Western Kiribati','OC');
INSERT INTO countrylist VALUES('T31','Central Kiribati','OC');
INSERT INTO countrylist VALUES('T32','Eastern Kiribati','OC');
INSERT INTO countrylist VALUES('T33','Banaba','OC');
INSERT INTO countrylist VALUES('T5','Somalia','AF');
INSERT INTO countrylist VALUES('T7','San Marino','EU');
INSERT INTO countrylist VALUES('T8','Palau','OC');
INSERT INTO countrylist VALUES('TA','Turkey','AS');
INSERT INTO countrylist VALUES('*TA1','Turkey (Europe)','EU');
INSERT INTO countrylist VALUES('TF','Iceland','EU');
INSERT INTO countrylist VALUES('TG','Guatemala','NA');
INSERT INTO countrylist VALUES('TI','Costa Rica','NA');
INSERT INTO countrylist VALUES('TI9','Cocos I.','NA');
INSERT INTO countrylist VALUES('TJ','Cameroon','AF');
INSERT INTO countrylist VALUES('TK','Corsica','EU');
INSERT INTO countrylist VALUES('TL','Central African Rep','AF');
INSERT INTO countrylist VALUES('TN','Congo','AF');
INSERT INTO countrylist VALUES('TR','Gabon','AF');
INSERT INTO countrylist VALUES('TT','Chad','AF');
INSERT INTO countrylist VALUES('TU','Cote d''Ivoire','AF');
INSERT INTO countrylist VALUES('TY','Benin','AF');
INSERT INTO countrylist VALUES('TZ','Mali','AF');
INSERT INTO countrylist VALUES('UA','European Russia','EU');
INSERT INTO countrylist VALUES('UA2','Kaliningrad','EU');
INSERT INTO countrylist VALUES('UA9','Asiatic Russia','AS');
INSERT INTO countrylist VALUES('UK','Uzbekistan','AS');
INSERT INTO countrylist VALUES('UN','Kazakhstan','AS');
INSERT INTO countrylist VALUES('UR','Ukraine','EU');
INSERT INTO countrylist VALUES('V2','Antigua & Barbuda','NA');
INSERT INTO countrylist VALUES('V3','Belize','NA');
INSERT INTO countrylist VALUES('V4','St. Kitts & Nevis','NA');
INSERT INTO countrylist VALUES('V5','Namibia','AF');
INSERT INTO countrylist VALUES('V6','Micronesia','OC');
INSERT INTO countrylist VALUES('V7','Marshall Is.','OC');
INSERT INTO countrylist VALUES('V8','Brunei','OC');
INSERT INTO countrylist VALUES('VE','Canada','NA');
INSERT INTO countrylist VALUES('VK','Australia','OC');
INSERT INTO countrylist VALUES('VK0H','Heard I.','AF');
INSERT INTO countrylist VALUES('VK0M','Macquarie I.','OC');
INSERT INTO countrylist VALUES('VK9C','Cocos-Keeling','OC');
INSERT INTO countrylist VALUES('VK9L','Lord Howe I.','OC');
INSERT INTO countrylist VALUES('VK9M','Mellish Reef','OC');
INSERT INTO countrylist VALUES('VK9N','Norfolk I.','OC');
INSERT INTO countrylist VALUES('VK9W','Willis I.','OC');
INSERT INTO countrylist VALUES('VK9X','Christmas I.','OC');
INSERT INTO countrylist VALUES('VP2E','Anguilla','NA');
INSERT INTO countrylist VALUES('VP2M','Montserrat','NA');
INSERT INTO countrylist VALUES('VP2V','British Virgin Is.','NA');
INSERT INTO countrylist VALUES('VP5','Turks & Caicos','NA');
INSERT INTO countrylist VALUES('VP6','Pitcairn I.','OC');
INSERT INTO countrylist VALUES('VP6/d','Ducie I.','OC');
INSERT INTO countrylist VALUES('VP8','Falkland Is.','SA');
INSERT INTO countrylist VALUES('VP8/g','South Georgia','SA');
INSERT INTO countrylist VALUES('VP8/h','South Shetland','SA');
INSERT INTO countrylist VALUES('VP8/o','South Orkney','SA');
INSERT INTO countrylist VALUES('VP8/s','South Sandwich','SA');
INSERT INTO countrylist VALUES('VP9','Bermuda','NA');
INSERT INTO countrylist VALUES('VQ9','Chagos Is.','AF');
INSERT INTO countrylist VALUES('VR','Hong Kong','AS');
INSERT INTO countrylist VALUES('VU','India','AS');
INSERT INTO countrylist VALUES('VU4','Andaman & Nicobar','AS');
INSERT INTO countrylist VALUES('VU7','Laccadive Is.','AS');
INSERT INTO countrylist VALUES('XE','Mexico','NA');
INSERT INTO countrylist VALUES('XF4','Revilla Gigedo','NA');
INSERT INTO countrylist VALUES('XT','Burkina Faso','AF');
INSERT INTO countrylist VALUES('XU','Kampuchea','AS');
INSERT INTO countrylist VALUES('XW','Laos','AS');
INSERT INTO countrylist VALUES('XX9','Macau','AS');
INSERT INTO countrylist VALUES('XZ','Myanmar','AS');
INSERT INTO countrylist VALUES('YA','Afghanistan','AS');
INSERT INTO countrylist VALUES('YB','Indonesia','OC');
INSERT INTO countrylist VALUES('YI','Iraq','AS');
INSERT INTO countrylist VALUES('YJ','Vanuatu','OC');
INSERT INTO countrylist VALUES('YK','Syria','AS');
INSERT INTO countrylist VALUES('YL','Latvia','EU');
INSERT INTO countrylist VALUES('YN','Nicaragua','NA');
INSERT INTO countrylist VALUES('YO','Romania','EU');
INSERT INTO countrylist VALUES('YS','El Salvador','NA');
INSERT INTO countrylist VALUES('YU','Serbia','EU');
INSERT INTO countrylist VALUES('*YU8','Kosova','EU');
INSERT INTO countrylist VALUES('YV','Venezuela','SA');
INSERT INTO countrylist VALUES('YV0','Aves I.','NA');
INSERT INTO countrylist VALUES('Z2','Zimbabwe','AF');
INSERT INTO countrylist VALUES('Z3','Macedonia','EU');
INSERT INTO countrylist VALUES('ZA','Albania','EU');
INSERT INTO countrylist VALUES('ZB','Gibraltar','EU');
INSERT INTO countrylist VALUES('ZC4','UK Bases on Cyprus','AS');
INSERT INTO countrylist VALUES('ZD7','Saint Helena','AF');
INSERT INTO countrylist VALUES('ZD8','Ascension I.','AF');
INSERT INTO countrylist VALUES('ZD9','Tristan da Cunha','AF');
INSERT INTO countrylist VALUES('ZF','Cayman Is.','NA');
INSERT INTO countrylist VALUES('ZK2','Niue','OC');
INSERT INTO countrylist VALUES('ZK3','Tokelau','OC');
INSERT INTO countrylist VALUES('ZL','New Zealand','OC');
INSERT INTO countrylist VALUES('ZL7','Chatham Is.','OC');
INSERT INTO countrylist VALUES('ZL8','Kermadec Is.','OC');
INSERT INTO countrylist VALUES('ZL9','Auckland & Campbell','OC');
INSERT INTO countrylist VALUES('ZP','Paraguay','SA');
INSERT INTO countrylist VALUES('ZS','South Africa','AF');
INSERT INTO countrylist VALUES('ZS8','Marion I.','AF');
CREATE TABLE prefixlist(prefix PRIMARY KEY not null,mainPrefix,WAZ,ITU);
INSERT INTO prefixlist VALUES('1A','1A','15','28');
INSERT INTO prefixlist VALUES('1S','1S','26','50');
INSERT INTO prefixlist VALUES('9M0','1S','26','50');
INSERT INTO prefixlist VALUES('BV9S','1S','26','50');
INSERT INTO prefixlist VALUES('3A','3A','14','27');
INSERT INTO prefixlist VALUES('3B6','3B6','39','53');
INSERT INTO prefixlist VALUES('3B7','3B6','39','53');
INSERT INTO prefixlist VALUES('3B8','3B8','39','53');
INSERT INTO prefixlist VALUES('3B9','3B9','39','53');
INSERT INTO prefixlist VALUES('3C','3C','36','47');
INSERT INTO prefixlist VALUES('3C0','3C0','36','52');
INSERT INTO prefixlist VALUES('3D2','3D2','32','56');
INSERT INTO prefixlist VALUES('=3D2CI','3D2/c','32','56');
INSERT INTO prefixlist VALUES('=3D2CY','3D2/c','32','56');
INSERT INTO prefixlist VALUES('=3D2AGP','3D2/r','32','56');
INSERT INTO prefixlist VALUES('3DA','3DA','38','57');
INSERT INTO prefixlist VALUES('3V','3V','33','37');
INSERT INTO prefixlist VALUES('TS','3V','33','37');
INSERT INTO prefixlist VALUES('3W','3W','26','49');
INSERT INTO prefixlist VALUES('XV','3W','26','49');
INSERT INTO prefixlist VALUES('3X','3X','35','46');
INSERT INTO prefixlist VALUES('3Y','3Y/b','38','67');
INSERT INTO prefixlist VALUES('=3Y0X','3Y/p','12','72');
INSERT INTO prefixlist VALUES('4J','4J','21','29');
INSERT INTO prefixlist VALUES('4K','4J','21','29');
INSERT INTO prefixlist VALUES('4L','4L','21','29');
INSERT INTO prefixlist VALUES('4O','4O','15','28');
INSERT INTO prefixlist VALUES('4P','4S','22','41');
INSERT INTO prefixlist VALUES('4Q','4S','22','41');
INSERT INTO prefixlist VALUES('4R','4S','22','41');
INSERT INTO prefixlist VALUES('4S','4S','22','41');
INSERT INTO prefixlist VALUES('4U1ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U0ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U1WRC','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U2ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U3ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U4ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U5ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U6ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U7ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U8ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U9ITU','4U1I','14','28');
INSERT INTO prefixlist VALUES('=4U0UN','4U1U','05','08');
INSERT INTO prefixlist VALUES('=4U1UN','4U1U','05','08');
INSERT INTO prefixlist VALUES('=4U2UN','4U1U','05','08');
INSERT INTO prefixlist VALUES('=4U3UN','4U1U','05','08');
INSERT INTO prefixlist VALUES('=4U4UN','4U1U','05','08');
INSERT INTO prefixlist VALUES('=4U5UN','4U1U','05','08');
INSERT INTO prefixlist VALUES('=4U6UN','4U1U','05','08');
INSERT INTO prefixlist VALUES('=4U1VIC','*4U1V','15','28');
INSERT INTO prefixlist VALUES('=4U1WED','*4U1V','15','28');
INSERT INTO prefixlist VALUES('4W','4W','28','54');
INSERT INTO prefixlist VALUES('4X','4X','20','39');
INSERT INTO prefixlist VALUES('4Z','4X','20','39');
INSERT INTO prefixlist VALUES('5A','5A','34','38');
INSERT INTO prefixlist VALUES('5B','5B','20','39');
INSERT INTO prefixlist VALUES('C4','5B','20','39');
INSERT INTO prefixlist VALUES('H2','5B','20','39');
INSERT INTO prefixlist VALUES('P3','5B','20','39');
INSERT INTO prefixlist VALUES('5H','5H','37','53');
INSERT INTO prefixlist VALUES('5I','5H','37','53');
INSERT INTO prefixlist VALUES('5N','5N','35','46');
INSERT INTO prefixlist VALUES('5O','5N','35','46');
INSERT INTO prefixlist VALUES('5R','5R','39','53');
INSERT INTO prefixlist VALUES('5S','5R','39','53');
INSERT INTO prefixlist VALUES('6X','5R','39','53');
INSERT INTO prefixlist VALUES('5T','5T','35','46');
INSERT INTO prefixlist VALUES('5U','5U','35','46');
INSERT INTO prefixlist VALUES('5V','5V','35','46');
INSERT INTO prefixlist VALUES('5W','5W','32','62');
INSERT INTO prefixlist VALUES('5X','5X','37','48');
INSERT INTO prefixlist VALUES('5Y','5Z','37','48');
INSERT INTO prefixlist VALUES('5Z','5Z','37','48');
INSERT INTO prefixlist VALUES('6V','6W','35','46');
INSERT INTO prefixlist VALUES('6W','6W','35','46');
INSERT INTO prefixlist VALUES('6Y','6Y','08','11');
INSERT INTO prefixlist VALUES('7O','7O','21','39');
INSERT INTO prefixlist VALUES('7P','7P','38','57');
INSERT INTO prefixlist VALUES('7Q','7Q','37','53');
INSERT INTO prefixlist VALUES('7R','7X','33','37');
INSERT INTO prefixlist VALUES('7T','7X','33','37');
INSERT INTO prefixlist VALUES('7U','7X','33','37');
INSERT INTO prefixlist VALUES('7V','7X','33','37');
INSERT INTO prefixlist VALUES('7W','7X','33','37');
INSERT INTO prefixlist VALUES('7X','7X','33','37');
INSERT INTO prefixlist VALUES('7Y','7X','33','37');
INSERT INTO prefixlist VALUES('8P','8P','08','11');
INSERT INTO prefixlist VALUES('8Q','8Q','22','41');
INSERT INTO prefixlist VALUES('8R','8R','09','12');
INSERT INTO prefixlist VALUES('9A','9A','15','28');
INSERT INTO prefixlist VALUES('9G','9G','35','46');
INSERT INTO prefixlist VALUES('9H','9H','15','28');
INSERT INTO prefixlist VALUES('9I','9J','36','53');
INSERT INTO prefixlist VALUES('9J','9J','36','53');
INSERT INTO prefixlist VALUES('9K','9K','21','39');
INSERT INTO prefixlist VALUES('9L','9L','35','46');
INSERT INTO prefixlist VALUES('9M1','9M2','28','54');
INSERT INTO prefixlist VALUES('9M2','9M2','28','54');
INSERT INTO prefixlist VALUES('9M4','9M2','28','54');
INSERT INTO prefixlist VALUES('9W2','9M2','28','54');
INSERT INTO prefixlist VALUES('9W4','9M2','28','54');
INSERT INTO prefixlist VALUES('9M6','9M6','28','54');
INSERT INTO prefixlist VALUES('9M8','9M6','28','54');
INSERT INTO prefixlist VALUES('9W6','9M6','28','54');
INSERT INTO prefixlist VALUES('9W8','9M6','28','54');
INSERT INTO prefixlist VALUES('=9M1CSQ','9M6','28','54');
INSERT INTO prefixlist VALUES('=9M1CSS','9M6','28','54');
INSERT INTO prefixlist VALUES('9N','9N','22','42');
INSERT INTO prefixlist VALUES('9O','9Q','36','52');
INSERT INTO prefixlist VALUES('9P','9Q','36','52');
INSERT INTO prefixlist VALUES('9Q','9Q','36','52');
INSERT INTO prefixlist VALUES('9R','9Q','36','52');
INSERT INTO prefixlist VALUES('9S','9Q','36','52');
INSERT INTO prefixlist VALUES('9T','9Q','36','52');
INSERT INTO prefixlist VALUES('9U','9U','36','52');
INSERT INTO prefixlist VALUES('9V','9V','28','54');
INSERT INTO prefixlist VALUES('S6','9V','28','54');
INSERT INTO prefixlist VALUES('9X','9X','36','52');
INSERT INTO prefixlist VALUES('9Y','9Y','09','11');
INSERT INTO prefixlist VALUES('9Z','9Y','09','11');
INSERT INTO prefixlist VALUES('8O','A2','38','57');
INSERT INTO prefixlist VALUES('A2','A2','38','57');
INSERT INTO prefixlist VALUES('A3','A3','32','62');
INSERT INTO prefixlist VALUES('A4','A4','21','39');
INSERT INTO prefixlist VALUES('A5','A5','22','41');
INSERT INTO prefixlist VALUES('A6','A6','21','39');
INSERT INTO prefixlist VALUES('A7','A7','21','39');
INSERT INTO prefixlist VALUES('A9','A9','21','39');
INSERT INTO prefixlist VALUES('6P','AP','21','41');
INSERT INTO prefixlist VALUES('6Q','AP','21','41');
INSERT INTO prefixlist VALUES('6R','AP','21','41');
INSERT INTO prefixlist VALUES('6S','AP','21','41');
INSERT INTO prefixlist VALUES('AP','AP','21','41');
INSERT INTO prefixlist VALUES('AQ','AP','21','41');
INSERT INTO prefixlist VALUES('AR','AP','21','41');
INSERT INTO prefixlist VALUES('AS','AP','21','41');
INSERT INTO prefixlist VALUES('BS7','BS7','27','50');
INSERT INTO prefixlist VALUES('BM','BV','24','44');
INSERT INTO prefixlist VALUES('BN','BV','24','44');
INSERT INTO prefixlist VALUES('BO','BV','24','44');
INSERT INTO prefixlist VALUES('BP','BV','24','44');
INSERT INTO prefixlist VALUES('BQ','BV','24','44');
INSERT INTO prefixlist VALUES('BU','BV','24','44');
INSERT INTO prefixlist VALUES('BV','BV','24','44');
INSERT INTO prefixlist VALUES('BW','BV','24','44');
INSERT INTO prefixlist VALUES('BX','BV','24','44');
INSERT INTO prefixlist VALUES('BM9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BN9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BO9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BP9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BQ9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BU9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BV9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BW9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('BX9P','BV9P','24','44');
INSERT INTO prefixlist VALUES('3H','BY','24','44');
INSERT INTO prefixlist VALUES('3I','BY','24','44');
INSERT INTO prefixlist VALUES('3J','BY','24','44');
INSERT INTO prefixlist VALUES('3K','BY','24','44');
INSERT INTO prefixlist VALUES('3L','BY','24','44');
INSERT INTO prefixlist VALUES('3M','BY','24','44');
INSERT INTO prefixlist VALUES('3N','BY','24','44');
INSERT INTO prefixlist VALUES('3O','BY','24','44');
INSERT INTO prefixlist VALUES('3P','BY','24','44');
INSERT INTO prefixlist VALUES('3Q','BY','24','44');
INSERT INTO prefixlist VALUES('3R','BY','24','44');
INSERT INTO prefixlist VALUES('3S','BY','24','44');
INSERT INTO prefixlist VALUES('3T','BY','24','44');
INSERT INTO prefixlist VALUES('3U','BY','24','44');
INSERT INTO prefixlist VALUES('B1','BY','24','44');
INSERT INTO prefixlist VALUES('B2','BY','24','44');
INSERT INTO prefixlist VALUES('B3','BY','24','44');
INSERT INTO prefixlist VALUES('B3G','BY','23','33');
INSERT INTO prefixlist VALUES('B3H','BY','23','33');
INSERT INTO prefixlist VALUES('B3I','BY','23','33');
INSERT INTO prefixlist VALUES('B3J','BY','23','33');
INSERT INTO prefixlist VALUES('B3K','BY','23','33');
INSERT INTO prefixlist VALUES('B3L','BY','23','33');
INSERT INTO prefixlist VALUES('B4','BY','24','44');
INSERT INTO prefixlist VALUES('B5','BY','24','44');
INSERT INTO prefixlist VALUES('B6','BY','24','44');
INSERT INTO prefixlist VALUES('B7','BY','24','44');
INSERT INTO prefixlist VALUES('B8','BY','24','44');
INSERT INTO prefixlist VALUES('B9','BY','24','44');
INSERT INTO prefixlist VALUES('B9M','BY','24','33');
INSERT INTO prefixlist VALUES('B9N','BY','24','33');
INSERT INTO prefixlist VALUES('B9O','BY','24','33');
INSERT INTO prefixlist VALUES('B9P','BY','24','33');
INSERT INTO prefixlist VALUES('B9Q','BY','24','33');
INSERT INTO prefixlist VALUES('B9R','BY','24','33');
INSERT INTO prefixlist VALUES('B9S','BY','24','33');
INSERT INTO prefixlist VALUES('BA','BY','24','44');
INSERT INTO prefixlist VALUES('BA3G','BY','23','33');
INSERT INTO prefixlist VALUES('BA3H','BY','23','33');
INSERT INTO prefixlist VALUES('BA3I','BY','23','33');
INSERT INTO prefixlist VALUES('BA3J','BY','23','33');
INSERT INTO prefixlist VALUES('BA3K','BY','23','33');
INSERT INTO prefixlist VALUES('BA3L','BY','23','33');
INSERT INTO prefixlist VALUES('BA9M','BY','24','33');
INSERT INTO prefixlist VALUES('BA9N','BY','24','33');
INSERT INTO prefixlist VALUES('BA9O','BY','24','33');
INSERT INTO prefixlist VALUES('BA9P','BY','24','33');
INSERT INTO prefixlist VALUES('BA9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BA9R','BY','24','33');
INSERT INTO prefixlist VALUES('BA9S','BY','24','33');
INSERT INTO prefixlist VALUES('BD','BY','24','44');
INSERT INTO prefixlist VALUES('BD3G','BY','23','33');
INSERT INTO prefixlist VALUES('BD3H','BY','23','33');
INSERT INTO prefixlist VALUES('BD3I','BY','23','33');
INSERT INTO prefixlist VALUES('BD3J','BY','23','33');
INSERT INTO prefixlist VALUES('BD3K','BY','23','33');
INSERT INTO prefixlist VALUES('BD3L','BY','23','33');
INSERT INTO prefixlist VALUES('BD9M','BY','24','33');
INSERT INTO prefixlist VALUES('BD9N','BY','24','33');
INSERT INTO prefixlist VALUES('BD9O','BY','24','33');
INSERT INTO prefixlist VALUES('BD9P','BY','24','33');
INSERT INTO prefixlist VALUES('BD9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BD9R','BY','24','33');
INSERT INTO prefixlist VALUES('BD9S','BY','24','33');
INSERT INTO prefixlist VALUES('BG','BY','24','44');
INSERT INTO prefixlist VALUES('BG3G','BY','23','33');
INSERT INTO prefixlist VALUES('BG3H','BY','23','33');
INSERT INTO prefixlist VALUES('BG3I','BY','23','33');
INSERT INTO prefixlist VALUES('BG3J','BY','23','33');
INSERT INTO prefixlist VALUES('BG3K','BY','23','33');
INSERT INTO prefixlist VALUES('BG3L','BY','23','33');
INSERT INTO prefixlist VALUES('BG9M','BY','24','33');
INSERT INTO prefixlist VALUES('BG9N','BY','24','33');
INSERT INTO prefixlist VALUES('BG9O','BY','24','33');
INSERT INTO prefixlist VALUES('BG9P','BY','24','33');
INSERT INTO prefixlist VALUES('BG9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BG9R','BY','24','33');
INSERT INTO prefixlist VALUES('BG9S','BY','24','33');
INSERT INTO prefixlist VALUES('BH','BY','24','44');
INSERT INTO prefixlist VALUES('BH3G','BY','23','33');
INSERT INTO prefixlist VALUES('BH3H','BY','23','33');
INSERT INTO prefixlist VALUES('BH3I','BY','23','33');
INSERT INTO prefixlist VALUES('BH3J','BY','23','33');
INSERT INTO prefixlist VALUES('BH3K','BY','23','33');
INSERT INTO prefixlist VALUES('BH3L','BY','23','33');
INSERT INTO prefixlist VALUES('BH9M','BY','24','33');
INSERT INTO prefixlist VALUES('BH9N','BY','24','33');
INSERT INTO prefixlist VALUES('BH9O','BY','24','33');
INSERT INTO prefixlist VALUES('BH9P','BY','24','33');
INSERT INTO prefixlist VALUES('BH9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BH9R','BY','24','33');
INSERT INTO prefixlist VALUES('BH9S','BY','24','33');
INSERT INTO prefixlist VALUES('BI','BY','24','44');
INSERT INTO prefixlist VALUES('BL','BY','24','44');
INSERT INTO prefixlist VALUES('BL3G','BY','23','33');
INSERT INTO prefixlist VALUES('BL3H','BY','23','33');
INSERT INTO prefixlist VALUES('BL3I','BY','23','33');
INSERT INTO prefixlist VALUES('BL3J','BY','23','33');
INSERT INTO prefixlist VALUES('BL3K','BY','23','33');
INSERT INTO prefixlist VALUES('BL3L','BY','23','33');
INSERT INTO prefixlist VALUES('BL9M','BY','24','33');
INSERT INTO prefixlist VALUES('BL9N','BY','24','33');
INSERT INTO prefixlist VALUES('BL9O','BY','24','33');
INSERT INTO prefixlist VALUES('BL9P','BY','24','33');
INSERT INTO prefixlist VALUES('BL9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BL9R','BY','24','33');
INSERT INTO prefixlist VALUES('BL9S','BY','24','33');
INSERT INTO prefixlist VALUES('BT','BY','24','44');
INSERT INTO prefixlist VALUES('BT3G','BY','23','33');
INSERT INTO prefixlist VALUES('BT3H','BY','23','33');
INSERT INTO prefixlist VALUES('BT3I','BY','23','33');
INSERT INTO prefixlist VALUES('BT3J','BY','23','33');
INSERT INTO prefixlist VALUES('BT3K','BY','23','33');
INSERT INTO prefixlist VALUES('BT3L','BY','23','33');
INSERT INTO prefixlist VALUES('BT9M','BY','24','33');
INSERT INTO prefixlist VALUES('BT9N','BY','24','33');
INSERT INTO prefixlist VALUES('BT9O','BY','24','33');
INSERT INTO prefixlist VALUES('BT9P','BY','24','33');
INSERT INTO prefixlist VALUES('BT9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BT9R','BY','24','33');
INSERT INTO prefixlist VALUES('BT9S','BY','24','33');
INSERT INTO prefixlist VALUES('BY','BY','24','44');
INSERT INTO prefixlist VALUES('BY3G','BY','23','33');
INSERT INTO prefixlist VALUES('BY3H','BY','23','33');
INSERT INTO prefixlist VALUES('BY3I','BY','23','33');
INSERT INTO prefixlist VALUES('BY3J','BY','23','33');
INSERT INTO prefixlist VALUES('BY3K','BY','23','33');
INSERT INTO prefixlist VALUES('BY3L','BY','23','33');
INSERT INTO prefixlist VALUES('BY9M','BY','24','33');
INSERT INTO prefixlist VALUES('BY9N','BY','24','33');
INSERT INTO prefixlist VALUES('BY9O','BY','24','33');
INSERT INTO prefixlist VALUES('BY9P','BY','24','33');
INSERT INTO prefixlist VALUES('BY9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BY9R','BY','24','33');
INSERT INTO prefixlist VALUES('BY9S','BY','24','33');
INSERT INTO prefixlist VALUES('BZ','BY','24','44');
INSERT INTO prefixlist VALUES('BZ3G','BY','23','33');
INSERT INTO prefixlist VALUES('BZ3H','BY','23','33');
INSERT INTO prefixlist VALUES('BZ3I','BY','23','33');
INSERT INTO prefixlist VALUES('BZ3J','BY','23','33');
INSERT INTO prefixlist VALUES('BZ3K','BY','23','33');
INSERT INTO prefixlist VALUES('BZ3L','BY','23','33');
INSERT INTO prefixlist VALUES('BZ9M','BY','24','33');
INSERT INTO prefixlist VALUES('BZ9N','BY','24','33');
INSERT INTO prefixlist VALUES('BZ9O','BY','24','33');
INSERT INTO prefixlist VALUES('BZ9P','BY','24','33');
INSERT INTO prefixlist VALUES('BZ9Q','BY','24','33');
INSERT INTO prefixlist VALUES('BZ9R','BY','24','33');
INSERT INTO prefixlist VALUES('BZ9S','BY','24','33');
INSERT INTO prefixlist VALUES('XS','BY','24','44');
INSERT INTO prefixlist VALUES('C2','C2','31','65');
INSERT INTO prefixlist VALUES('C3','C3','14','27');
INSERT INTO prefixlist VALUES('C5','C5','35','46');
INSERT INTO prefixlist VALUES('C6','C6','08','11');
INSERT INTO prefixlist VALUES('C8','C9','37','53');
INSERT INTO prefixlist VALUES('C9','C9','37','53');
INSERT INTO prefixlist VALUES('3G','CE','12','14');
INSERT INTO prefixlist VALUES('CA','CE','12','14');
INSERT INTO prefixlist VALUES('CB','CE','12','14');
INSERT INTO prefixlist VALUES('CC','CE','12','14');
INSERT INTO prefixlist VALUES('CD','CE','12','14');
INSERT INTO prefixlist VALUES('CE','CE','12','14');
INSERT INTO prefixlist VALUES('XQ','CE','12','14');
INSERT INTO prefixlist VALUES('XR','CE','12','14');
INSERT INTO prefixlist VALUES('3G0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('CA0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('CB0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('CC0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('CD0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('CE0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('XQ0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('XR0X','CE0X','12','14');
INSERT INTO prefixlist VALUES('3G0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('CA0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('CB0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('CC0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('CD0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('CE0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('XQ0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('XR0','CE0Y','12','63');
INSERT INTO prefixlist VALUES('3G0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('CA0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('CB0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('CC0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('CD0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('CE0I','CE0Z','12','14');
INSERT INTO prefixlist VALUES('CE0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('XQ0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('XR0Z','CE0Z','12','14');
INSERT INTO prefixlist VALUES('ANT','CE9','13','74');
INSERT INTO prefixlist VALUES('AX0','CE9','13','74');
INSERT INTO prefixlist VALUES('FT0Y','CE9','30','70');
INSERT INTO prefixlist VALUES('FT2Y','CE9','30','70');
INSERT INTO prefixlist VALUES('FT4Y','CE9','30','70');
INSERT INTO prefixlist VALUES('FT5Y','CE9','30','70');
INSERT INTO prefixlist VALUES('FT8Y','CE9','30','70');
INSERT INTO prefixlist VALUES('LU1Z','CE9','13','73');
INSERT INTO prefixlist VALUES('R1AN','CE9','13','74');
INSERT INTO prefixlist VALUES('VH0','CE9','39','69');
INSERT INTO prefixlist VALUES('VI0','CE9','39','69');
INSERT INTO prefixlist VALUES('VJ0','CE9','39','69');
INSERT INTO prefixlist VALUES('VK0','CE9','39','69');
INSERT INTO prefixlist VALUES('VL0','CE9','39','69');
INSERT INTO prefixlist VALUES('VM0','CE9','39','69');
INSERT INTO prefixlist VALUES('VN0','CE9','39','69');
INSERT INTO prefixlist VALUES('VZ0','CE9','39','69');
INSERT INTO prefixlist VALUES('ZL0','CE9','30','71');
INSERT INTO prefixlist VALUES('ZL5','CE9','30','71');
INSERT INTO prefixlist VALUES('ZM5','CE9','30','71');
INSERT INTO prefixlist VALUES('ZS7','CE9','38','67');
INSERT INTO prefixlist VALUES('=8J1RF','CE9','39','67');
INSERT INTO prefixlist VALUES('=8J1RL','CE9','39','67');
INSERT INTO prefixlist VALUES('=DP0GVN','CE9','38','67');
INSERT INTO prefixlist VALUES('=KC4K2ARB','CE9','30','71');
INSERT INTO prefixlist VALUES('=KC4AAA','CE9','39','74');
INSERT INTO prefixlist VALUES('=KC4AAC','CE9','13','73');
INSERT INTO prefixlist VALUES('=KC4USB','CE9','12','72');
INSERT INTO prefixlist VALUES('=KC4USV','CE9','30','71');
INSERT INTO prefixlist VALUES('=LU4ZS','CE9','13','73');
INSERT INTO prefixlist VALUES('=OP0LE','CE9','38','67');
INSERT INTO prefixlist VALUES('=VP8DJB','CE9','13','73');
INSERT INTO prefixlist VALUES('=VP8DKF','CE9','30','71');
INSERT INTO prefixlist VALUES('=VP8DLJ','CE9','13','73');
INSERT INTO prefixlist VALUES('=VP8PJ','CE9','13','73');
INSERT INTO prefixlist VALUES('=VP8ROT','CE9','13','73');
INSERT INTO prefixlist VALUES('CL','CM','08','11');
INSERT INTO prefixlist VALUES('CM','CM','08','11');
INSERT INTO prefixlist VALUES('CO','CM','08','11');
INSERT INTO prefixlist VALUES('T4','CM','08','11');
INSERT INTO prefixlist VALUES('5C','CN','33','37');
INSERT INTO prefixlist VALUES('5D','CN','33','37');
INSERT INTO prefixlist VALUES('5E','CN','33','37');
INSERT INTO prefixlist VALUES('5F','CN','33','37');
INSERT INTO prefixlist VALUES('5G','CN','33','37');
INSERT INTO prefixlist VALUES('CN','CN','33','37');
INSERT INTO prefixlist VALUES('CP','CP','10','12');
INSERT INTO prefixlist VALUES('CQ','CT','14','37');
INSERT INTO prefixlist VALUES('CR','CT','14','37');
INSERT INTO prefixlist VALUES('CS','CT','14','37');
INSERT INTO prefixlist VALUES('CT','CT','14','37');
INSERT INTO prefixlist VALUES('CQ3','CT3','33','36');
INSERT INTO prefixlist VALUES('CQ9','CT3','33','36');
INSERT INTO prefixlist VALUES('CR3','CT3','33','36');
INSERT INTO prefixlist VALUES('CR9','CT3','33','36');
INSERT INTO prefixlist VALUES('CS3','CT3','33','36');
INSERT INTO prefixlist VALUES('CS9','CT3','33','36');
INSERT INTO prefixlist VALUES('CT3','CT3','33','36');
INSERT INTO prefixlist VALUES('CT9','CT3','33','36');
INSERT INTO prefixlist VALUES('XX','CT3','33','36');
INSERT INTO prefixlist VALUES('CU','CU','14','36');
INSERT INTO prefixlist VALUES('CV','CX','13','14');
INSERT INTO prefixlist VALUES('CW','CX','13','14');
INSERT INTO prefixlist VALUES('CX','CX','13','14');
INSERT INTO prefixlist VALUES('CY0','CY0','05','09');
INSERT INTO prefixlist VALUES('CY9','CY9','05','09');
INSERT INTO prefixlist VALUES('D2','D2','36','52');
INSERT INTO prefixlist VALUES('D3','D2','36','52');
INSERT INTO prefixlist VALUES('D4','D4','35','46');
INSERT INTO prefixlist VALUES('D6','D6','39','53');
INSERT INTO prefixlist VALUES('DA','DL','14','28');
INSERT INTO prefixlist VALUES('DB','DL','14','28');
INSERT INTO prefixlist VALUES('DC','DL','14','28');
INSERT INTO prefixlist VALUES('DD','DL','14','28');
INSERT INTO prefixlist VALUES('DE','DL','14','28');
INSERT INTO prefixlist VALUES('DF','DL','14','28');
INSERT INTO prefixlist VALUES('DG','DL','14','28');
INSERT INTO prefixlist VALUES('DH','DL','14','28');
INSERT INTO prefixlist VALUES('DI','DL','14','28');
INSERT INTO prefixlist VALUES('DJ','DL','14','28');
INSERT INTO prefixlist VALUES('DK','DL','14','28');
INSERT INTO prefixlist VALUES('DL','DL','14','28');
INSERT INTO prefixlist VALUES('DM','DL','14','28');
INSERT INTO prefixlist VALUES('DN','DL','14','28');
INSERT INTO prefixlist VALUES('DO','DL','14','28');
INSERT INTO prefixlist VALUES('DP','DL','14','28');
INSERT INTO prefixlist VALUES('DQ','DL','14','28');
INSERT INTO prefixlist VALUES('DR','DL','14','28');
INSERT INTO prefixlist VALUES('4D','DU','27','50');
INSERT INTO prefixlist VALUES('4E','DU','27','50');
INSERT INTO prefixlist VALUES('4F','DU','27','50');
INSERT INTO prefixlist VALUES('4G','DU','27','50');
INSERT INTO prefixlist VALUES('4H','DU','27','50');
INSERT INTO prefixlist VALUES('4I','DU','27','50');
INSERT INTO prefixlist VALUES('DU','DU','27','50');
INSERT INTO prefixlist VALUES('DV','DU','27','50');
INSERT INTO prefixlist VALUES('DW','DU','27','50');
INSERT INTO prefixlist VALUES('DX','DU','27','50');
INSERT INTO prefixlist VALUES('DY','DU','27','50');
INSERT INTO prefixlist VALUES('DZ','DU','27','50');
INSERT INTO prefixlist VALUES('E3','E3','37','48');
INSERT INTO prefixlist VALUES('E4','E4','20','39');
INSERT INTO prefixlist VALUES('=E51WL','E5/n','32','62');
INSERT INTO prefixlist VALUES('E5','E5/s','32','62');
INSERT INTO prefixlist VALUES('E7','E7','15','28');
INSERT INTO prefixlist VALUES('T9','E7','15','28');
INSERT INTO prefixlist VALUES('AM','EA','14','37');
INSERT INTO prefixlist VALUES('AN','EA','14','37');
INSERT INTO prefixlist VALUES('AO','EA','14','37');
INSERT INTO prefixlist VALUES('EA','EA','14','37');
INSERT INTO prefixlist VALUES('EB','EA','14','37');
INSERT INTO prefixlist VALUES('EC','EA','14','37');
INSERT INTO prefixlist VALUES('ED','EA','14','37');
INSERT INTO prefixlist VALUES('EE','EA','14','37');
INSERT INTO prefixlist VALUES('EF','EA','14','37');
INSERT INTO prefixlist VALUES('EG','EA','14','37');
INSERT INTO prefixlist VALUES('EH','EA','14','37');
INSERT INTO prefixlist VALUES('AM6','EA6','14','37');
INSERT INTO prefixlist VALUES('AN6','EA6','14','37');
INSERT INTO prefixlist VALUES('AO6','EA6','14','37');
INSERT INTO prefixlist VALUES('EA6','EA6','14','37');
INSERT INTO prefixlist VALUES('EB6','EA6','14','37');
INSERT INTO prefixlist VALUES('EC6','EA6','14','37');
INSERT INTO prefixlist VALUES('ED6','EA6','14','37');
INSERT INTO prefixlist VALUES('EE6','EA6','14','37');
INSERT INTO prefixlist VALUES('EF6','EA6','14','37');
INSERT INTO prefixlist VALUES('EG6','EA6','14','37');
INSERT INTO prefixlist VALUES('EH6','EA6','14','37');
INSERT INTO prefixlist VALUES('AM8','EA8','33','36');
INSERT INTO prefixlist VALUES('AN8','EA8','33','36');
INSERT INTO prefixlist VALUES('AO8','EA8','33','36');
INSERT INTO prefixlist VALUES('EA8','EA8','33','36');
INSERT INTO prefixlist VALUES('EB8','EA8','33','36');
INSERT INTO prefixlist VALUES('EC8','EA8','33','36');
INSERT INTO prefixlist VALUES('ED8','EA8','33','36');
INSERT INTO prefixlist VALUES('EE8','EA8','33','36');
INSERT INTO prefixlist VALUES('EF8','EA8','33','36');
INSERT INTO prefixlist VALUES('EG8','EA8','33','36');
INSERT INTO prefixlist VALUES('EH8','EA8','33','36');
INSERT INTO prefixlist VALUES('AM9','EA9','33','37');
INSERT INTO prefixlist VALUES('AN9','EA9','33','37');
INSERT INTO prefixlist VALUES('AO9','EA9','33','37');
INSERT INTO prefixlist VALUES('EA9','EA9','33','37');
INSERT INTO prefixlist VALUES('EB9','EA9','33','37');
INSERT INTO prefixlist VALUES('EC9','EA9','33','37');
INSERT INTO prefixlist VALUES('ED9','EA9','33','37');
INSERT INTO prefixlist VALUES('EE9','EA9','33','37');
INSERT INTO prefixlist VALUES('EF9','EA9','33','37');
INSERT INTO prefixlist VALUES('EG9','EA9','33','37');
INSERT INTO prefixlist VALUES('EH9','EA9','33','37');
INSERT INTO prefixlist VALUES('EI','EI','14','27');
INSERT INTO prefixlist VALUES('EJ','EI','14','27');
INSERT INTO prefixlist VALUES('EK','EK','21','29');
INSERT INTO prefixlist VALUES('5L','EL','35','46');
INSERT INTO prefixlist VALUES('5M','EL','35','46');
INSERT INTO prefixlist VALUES('6Z','EL','35','46');
INSERT INTO prefixlist VALUES('A8','EL','35','46');
INSERT INTO prefixlist VALUES('D5','EL','35','46');
INSERT INTO prefixlist VALUES('EL','EL','35','46');
INSERT INTO prefixlist VALUES('9B','EP','21','40');
INSERT INTO prefixlist VALUES('9C','EP','21','40');
INSERT INTO prefixlist VALUES('9D','EP','21','40');
INSERT INTO prefixlist VALUES('EP','EP','21','40');
INSERT INTO prefixlist VALUES('EQ','EP','21','40');
INSERT INTO prefixlist VALUES('ER','ER','16','29');
INSERT INTO prefixlist VALUES('ES','ES','15','29');
INSERT INTO prefixlist VALUES('9E','ET','37','48');
INSERT INTO prefixlist VALUES('9F','ET','37','48');
INSERT INTO prefixlist VALUES('ET','ET','37','48');
INSERT INTO prefixlist VALUES('EU','EU','16','29');
INSERT INTO prefixlist VALUES('EV','EU','16','29');
INSERT INTO prefixlist VALUES('EW','EU','16','29');
INSERT INTO prefixlist VALUES('EX','EX','17','31');
INSERT INTO prefixlist VALUES('EY','EY','17','30');
INSERT INTO prefixlist VALUES('EZ','EZ','17','30');
INSERT INTO prefixlist VALUES('F','F','14','27');
INSERT INTO prefixlist VALUES('HW','F','14','27');
INSERT INTO prefixlist VALUES('HX','F','14','27');
INSERT INTO prefixlist VALUES('HY','F','14','27');
INSERT INTO prefixlist VALUES('TH','F','14','27');
INSERT INTO prefixlist VALUES('TM','F','14','27');
INSERT INTO prefixlist VALUES('TP','F','14','27');
INSERT INTO prefixlist VALUES('TQ','F','14','27');
INSERT INTO prefixlist VALUES('TV','F','14','27');
INSERT INTO prefixlist VALUES('TW','F','14','27');
INSERT INTO prefixlist VALUES('FG','FG','08','11');
INSERT INTO prefixlist VALUES('=TO1T','FG','08','11');
INSERT INTO prefixlist VALUES('=TO1USB','FG','08','11');
INSERT INTO prefixlist VALUES('=TO2ANT','FG','08','11');
INSERT INTO prefixlist VALUES('=TO2FG','FG','08','11');
INSERT INTO prefixlist VALUES('=TO4T','FG','08','11');
INSERT INTO prefixlist VALUES('=TO5BG','FG','08','11');
INSERT INTO prefixlist VALUES('=TO5C','FG','08','11');
INSERT INTO prefixlist VALUES('=TO5G','FG','08','11');
INSERT INTO prefixlist VALUES('=TO5GI','FG','08','11');
INSERT INTO prefixlist VALUES('=TO5S','FG','08','11');
INSERT INTO prefixlist VALUES('=TO6T','FG','08','11');
INSERT INTO prefixlist VALUES('=TO7T','FG','08','11');
INSERT INTO prefixlist VALUES('=TO8RR','FG','08','11');
INSERT INTO prefixlist VALUES('=TO8S','FG','08','11');
INSERT INTO prefixlist VALUES('=TO9T','FG','08','11');
INSERT INTO prefixlist VALUES('FH','FH','39','53');
INSERT INTO prefixlist VALUES('=TX7LX','FH','39','53');
INSERT INTO prefixlist VALUES('FJ','FJ','08','11');
INSERT INTO prefixlist VALUES('=TO5DX','FJ','08','11');
INSERT INTO prefixlist VALUES('=TO5E','FJ','08','11');
INSERT INTO prefixlist VALUES('=TO5FJ','FJ','08','11');
INSERT INTO prefixlist VALUES('=TO5RZ','FJ','08','11');
INSERT INTO prefixlist VALUES('FK','FK','32','56');
INSERT INTO prefixlist VALUES('TX8','FK','32','56');
INSERT INTO prefixlist VALUES('=TX1A','FK','32','56');
INSERT INTO prefixlist VALUES('=TX3SAM','FK','32','56');
INSERT INTO prefixlist VALUES('=TX5CW','FK','32','56');
INSERT INTO prefixlist VALUES('=TX0AT','FK/c','30','56');
INSERT INTO prefixlist VALUES('=TX0C','FK/c','30','56');
INSERT INTO prefixlist VALUES('=TX0DX','FK/c','30','56');
INSERT INTO prefixlist VALUES('=TX9','FK/c','30','56');
INSERT INTO prefixlist VALUES('FM','FM','08','11');
INSERT INTO prefixlist VALUES('=TO0O','FM','08','11');
INSERT INTO prefixlist VALUES('=TO0P','FM','08','11');
INSERT INTO prefixlist VALUES('=TO1A','FM','08','11');
INSERT INTO prefixlist VALUES('=TO1C','FM','08','11');
INSERT INTO prefixlist VALUES('=TO1YR','FM','08','11');
INSERT INTO prefixlist VALUES('=TO2DX','FM','08','11');
INSERT INTO prefixlist VALUES('=TO3M','FM','08','11');
INSERT INTO prefixlist VALUES('=TO3T','FM','08','11');
INSERT INTO prefixlist VALUES('=TO3W','FM','08','11');
INSERT INTO prefixlist VALUES('=TO4A','FM','08','11');
INSERT INTO prefixlist VALUES('=TO4X','FM','08','11');
INSERT INTO prefixlist VALUES('=TO5A','FM','08','11');
INSERT INTO prefixlist VALUES('=TO5AA','FM','08','11');
INSERT INTO prefixlist VALUES('=TO5J','FM','08','11');
INSERT INTO prefixlist VALUES('=TO5MM','FM','08','11');
INSERT INTO prefixlist VALUES('=TO5T','FM','08','11');
INSERT INTO prefixlist VALUES('=TO5X','FM','08','11');
INSERT INTO prefixlist VALUES('=TO6M','FM','08','11');
INSERT INTO prefixlist VALUES('=TO7HAM','FM','08','11');
INSERT INTO prefixlist VALUES('=TO7X','FM','08','11');
INSERT INTO prefixlist VALUES('=TO8B','FM','08','11');
INSERT INTO prefixlist VALUES('=TO9A','FM','08','11');
INSERT INTO prefixlist VALUES('=TX4B','FM','08','11');
INSERT INTO prefixlist VALUES('FO','FO','32','63');
INSERT INTO prefixlist VALUES('=FODL1AWI','FO/a','32','63');
INSERT INTO prefixlist VALUES('=FODL5XU','FO/a','32','63');
INSERT INTO prefixlist VALUES('=FODL9AWI','FO/a','32','63');
INSERT INTO prefixlist VALUES('=TX5C','FO/c','07','10');
INSERT INTO prefixlist VALUES('=FODJ7RJ','FO/m','31','63');
INSERT INTO prefixlist VALUES('FP','FP','05','09');
INSERT INTO prefixlist VALUES('FR','FR','39','53');
INSERT INTO prefixlist VALUES('=TO4G','FR/g','39','53');
INSERT INTO prefixlist VALUES('=TO4E','FR/j','39','53');
INSERT INTO prefixlist VALUES('=FR5ZUT','FR/t','39','53');
INSERT INTO prefixlist VALUES('FS','FS','08','11');
INSERT INTO prefixlist VALUES('=TO5D','FS','08','11');
INSERT INTO prefixlist VALUES('FT0W','FT5W','39','68');
INSERT INTO prefixlist VALUES('FT2W','FT5W','39','68');
INSERT INTO prefixlist VALUES('FT4W','FT5W','39','68');
INSERT INTO prefixlist VALUES('FT5W','FT5W','39','68');
INSERT INTO prefixlist VALUES('FT8W','FT5W','39','68');
INSERT INTO prefixlist VALUES('FT0X','FT5X','39','68');
INSERT INTO prefixlist VALUES('FT2X','FT5X','39','68');
INSERT INTO prefixlist VALUES('FT4X','FT5X','39','68');
INSERT INTO prefixlist VALUES('FT5X','FT5X','39','68');
INSERT INTO prefixlist VALUES('FT8X','FT5X','39','68');
INSERT INTO prefixlist VALUES('FT0Z','FT5Z','39','68');
INSERT INTO prefixlist VALUES('FT2Z','FT5Z','39','68');
INSERT INTO prefixlist VALUES('FT4Z','FT5Z','39','68');
INSERT INTO prefixlist VALUES('FT5Z','FT5Z','39','68');
INSERT INTO prefixlist VALUES('FT8Z','FT5Z','39','68');
INSERT INTO prefixlist VALUES('FW','FW','32','62');
INSERT INTO prefixlist VALUES('FY','FY','09','12');
INSERT INTO prefixlist VALUES('=TO7C','FY','09','12');
INSERT INTO prefixlist VALUES('=TO7IR','FY','09','12');
INSERT INTO prefixlist VALUES('=TO7R','FY','09','12');
INSERT INTO prefixlist VALUES('=TX0A','FY','09','12');
INSERT INTO prefixlist VALUES('2E','G','14','27');
INSERT INTO prefixlist VALUES('G','G','14','27');
INSERT INTO prefixlist VALUES('M','G','14','27');
INSERT INTO prefixlist VALUES('2D','GD','14','27');
INSERT INTO prefixlist VALUES('2T','GD','14','27');
INSERT INTO prefixlist VALUES('GD','GD','14','27');
INSERT INTO prefixlist VALUES('GT','GD','14','27');
INSERT INTO prefixlist VALUES('MD','GD','14','27');
INSERT INTO prefixlist VALUES('MT','GD','14','27');
INSERT INTO prefixlist VALUES('=GB0MST','GD','14','27');
INSERT INTO prefixlist VALUES('=GB0WCY','GD','14','27');
INSERT INTO prefixlist VALUES('=GB100MER','GD','14','27');
INSERT INTO prefixlist VALUES('=GB100TT','GD','14','27');
INSERT INTO prefixlist VALUES('=GB125SR','GD','14','27');
INSERT INTO prefixlist VALUES('=GB2IOM','GD','14','27');
INSERT INTO prefixlist VALUES('=GB2MAD','GD','14','27');
INSERT INTO prefixlist VALUES('=GB2WB','GD','14','27');
INSERT INTO prefixlist VALUES('=GB3GD','GD','14','27');
INSERT INTO prefixlist VALUES('=GB4IOM','GD','14','27');
INSERT INTO prefixlist VALUES('=GB4MNH','GD','14','27');
INSERT INTO prefixlist VALUES('=GB4WXMP','GD','14','27');
INSERT INTO prefixlist VALUES('=GB50UN','GD','14','27');
INSERT INTO prefixlist VALUES('=GB5MOB','GD','14','27');
INSERT INTO prefixlist VALUES('=GB6SPC','GD','14','27');
INSERT INTO prefixlist VALUES('2I','GI','14','27');
INSERT INTO prefixlist VALUES('2N','GI','14','27');
INSERT INTO prefixlist VALUES('GI','GI','14','27');
INSERT INTO prefixlist VALUES('GN','GI','14','27');
INSERT INTO prefixlist VALUES('MI','GI','14','27');
INSERT INTO prefixlist VALUES('MN','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0BTC','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0BVC','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0CI','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0CSC','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0DDF','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0GPF','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0MFD','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0PSM','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0REL','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0SHC','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0SIC','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0SPD','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0TCH','GI','14','27');
INSERT INTO prefixlist VALUES('=GB0WOA','GI','14','27');
INSERT INTO prefixlist VALUES('=GB1AFP','GI','14','27');
INSERT INTO prefixlist VALUES('=GB1SPD','GI','14','27');
INSERT INTO prefixlist VALUES('=GB1SRI','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2IL','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2LL','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2MGY','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2MRI','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2NIC','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2NTU','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2STI','GI','14','27');
INSERT INTO prefixlist VALUES('=GB2TCA','GI','14','27');
INSERT INTO prefixlist VALUES('=GB3MNI','GI','14','27');
INSERT INTO prefixlist VALUES('=GB4CSC','GI','14','27');
INSERT INTO prefixlist VALUES('=GB4ES','GI','14','27');
INSERT INTO prefixlist VALUES('=GB4SPD','GI','14','27');
INSERT INTO prefixlist VALUES('=GB50AAD','GI','14','27');
INSERT INTO prefixlist VALUES('=GB5BIG','GI','14','27');
INSERT INTO prefixlist VALUES('=GB5BL','GI','14','27');
INSERT INTO prefixlist VALUES('=GB5SPD','GI','14','27');
INSERT INTO prefixlist VALUES('=GB90SOM','GI','14','27');
INSERT INTO prefixlist VALUES('2H','GJ','14','27');
INSERT INTO prefixlist VALUES('2J','GJ','14','27');
INSERT INTO prefixlist VALUES('GH','GJ','14','27');
INSERT INTO prefixlist VALUES('GJ','GJ','14','27');
INSERT INTO prefixlist VALUES('MH','GJ','14','27');
INSERT INTO prefixlist VALUES('MJ','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB0CLR','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB0GUD','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB0JSA','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB0SHL','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB2BYL','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB2JSA','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB4BHF','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB50JSA','GJ','14','27');
INSERT INTO prefixlist VALUES('=GB8LMI','GJ','14','27');
INSERT INTO prefixlist VALUES('2A','GM','14','27');
INSERT INTO prefixlist VALUES('2M','GM','14','27');
INSERT INTO prefixlist VALUES('2S','GM','14','27');
INSERT INTO prefixlist VALUES('GM','GM','14','27');
INSERT INTO prefixlist VALUES('GS','GM','14','27');
INSERT INTO prefixlist VALUES('MM','GM','14','27');
INSERT INTO prefixlist VALUES('MS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0AC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0BNC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0BWT','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0DGL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0FFS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0FLA','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0GDS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0GEI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0GHD','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0GKR','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0GNE','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0HHW','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0KGS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0KTC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0LCS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0LTM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0MFG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0MLM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0MOL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0NHL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0OS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0OYT','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0PPE','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0QWM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0RBS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0SHP','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0SI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0SK','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0SKY','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0SS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0SSF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB0TI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB100MAS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB125BRC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB150NRL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB1EPC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB1FVT','GM','14','27');
INSERT INTO prefixlist VALUES('=GB1OL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2AGG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2AST','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2AYR','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2CHG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2DHS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2DTM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2FBM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2FIO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2FSM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2GEO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2GNL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2GTM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2HI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2HRH','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2HST','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2HSW','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2IAS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2IGB','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2IGS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2IMM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2IOC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2IOG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2IOT','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2JUNO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2KDS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2KHL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LAY','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LBN','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LCL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LCP','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LGB','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LHI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LMG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LNM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LP','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LSS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LT','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LTH','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2LTN','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2MAS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2MDG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2MOD','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2MOF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2MSL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2MUL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2NAG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2NBC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2NCL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2NEF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2NL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2NTS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2OWM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2OYC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2PBF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2PS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2RB','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2RRL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2SKG','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2SLH','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2SPD','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2SSF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2STB','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2TDS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2TI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB2WBB','GM','14','27');
INSERT INTO prefixlist VALUES('=GB3GM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB400CA','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4AAS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4CGW','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4DAS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4GM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4LNM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4NFE','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4PMS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4RAF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4SLH','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4TSR','GM','14','27');
INSERT INTO prefixlist VALUES('=GB4ZBS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB50ATC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB50JS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB50SWL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5AST','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5BBS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5CO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5FHC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5OL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5RO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5SI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB5TI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB60BBC','GM','14','27');
INSERT INTO prefixlist VALUES('=GB60CRB','GM','14','27');
INSERT INTO prefixlist VALUES('=GB60NTS','GM','14','27');
INSERT INTO prefixlist VALUES('=GB6MI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB6SA','GM','14','27');
INSERT INTO prefixlist VALUES('=GB6SM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB6TAA','GM','14','27');
INSERT INTO prefixlist VALUES('=GB6WW','GM','14','27');
INSERT INTO prefixlist VALUES('=GB700BSB','GM','14','27');
INSERT INTO prefixlist VALUES('=GB75GD','GM','14','27');
INSERT INTO prefixlist VALUES('=GB75SCP','GM','14','27');
INSERT INTO prefixlist VALUES('=GB75STT','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8AYR','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CA','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CI','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CM','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CN','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CSL','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8CY','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8FF','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8OO','GM','14','27');
INSERT INTO prefixlist VALUES('=GB8RU','GM','14','27');
INSERT INTO prefixlist VALUES('=GB93AM','GM','14','27');
INSERT INTO prefixlist VALUES('GZ','*GM/s','14','27');
INSERT INTO prefixlist VALUES('MZ','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=2M0ZET','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GB2ELH','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM0AVR','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM0CXQ','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM0CYJ','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM0DJI','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM0EKM','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM0ILB','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM0ULK','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM1ZNR','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM3KLA','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM3WHT','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM3ZET','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM3ZNM','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4GPP','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4GQM','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4IPK','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4LBE','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4LER','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4SLV','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4SSA','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4SWU','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4WXQ','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM4ZHL','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM7AFE','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM7GWW','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM8LNH','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM8MMA','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=GM8YEC','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=MM0LSM','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=MM0XAU','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=MM0ZAL','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=MM1FJM','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=MM3VQO','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=MM5PSL','*GM/s','14','27');
INSERT INTO prefixlist VALUES('=MS0ZCG','*GM/s','14','27');
INSERT INTO prefixlist VALUES('2P','GU','14','27');
INSERT INTO prefixlist VALUES('2U','GU','14','27');
INSERT INTO prefixlist VALUES('GP','GU','14','27');
INSERT INTO prefixlist VALUES('GU','GU','14','27');
INSERT INTO prefixlist VALUES('MP','GU','14','27');
INSERT INTO prefixlist VALUES('MU','GU','14','27');
INSERT INTO prefixlist VALUES('=GB0GUC','GU','14','27');
INSERT INTO prefixlist VALUES('=GB0JAG','GU','14','27');
INSERT INTO prefixlist VALUES('=GB0ON','GU','14','27');
INSERT INTO prefixlist VALUES('=GB0U','GU','14','27');
INSERT INTO prefixlist VALUES('=GB2ECG','GU','14','27');
INSERT INTO prefixlist VALUES('=GB2FG','GU','14','27');
INSERT INTO prefixlist VALUES('=GB2GU','GU','14','27');
INSERT INTO prefixlist VALUES('=GB50LIB','GU','14','27');
INSERT INTO prefixlist VALUES('2C','GW','14','27');
INSERT INTO prefixlist VALUES('2W','GW','14','27');
INSERT INTO prefixlist VALUES('2X','GW','14','27');
INSERT INTO prefixlist VALUES('2Y','GW','14','27');
INSERT INTO prefixlist VALUES('GC','GW','14','27');
INSERT INTO prefixlist VALUES('GW','GW','14','27');
INSERT INTO prefixlist VALUES('MC','GW','14','27');
INSERT INTO prefixlist VALUES('MW','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0CCE','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0CLC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0CVA','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0GCR','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0GIW','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0GLV','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0HEL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0HMT','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0ML','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0MPA','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0MWL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0NEW','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0PSG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0RPO','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0RSC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0SDD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0SH','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0SOA','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0SPS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0SRH','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0TD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0TTT','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0VK','GW','14','27');
INSERT INTO prefixlist VALUES('=GB0WRC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB100BD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB100FI','GW','14','27');
INSERT INTO prefixlist VALUES('=GB100LP','GW','14','27');
INSERT INTO prefixlist VALUES('=GB1CCC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB1LSG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB1SL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB1SSL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB1TDS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2000SET','GW','14','27');
INSERT INTO prefixlist VALUES('=GB200A','GW','14','27');
INSERT INTO prefixlist VALUES('=GB200HNT','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2ANG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2CI','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2CPC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2GGM','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2GLS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2GOL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2GSG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2GSS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2HDG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2IMD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2LNP','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2LSA','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2MHL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2MIL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2MLM','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2MOP','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2RFS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2RSC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2RTB','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2SAC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2SDD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2SIP','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2TD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2TTA','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2VK','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2WDS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2WFF','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2WHO','GW','14','27');
INSERT INTO prefixlist VALUES('=GB2WSF','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4BPL','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4CI','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4DPS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4HMD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4HMM','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4LRG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4LSG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4MD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4MDI','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4MUU','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4NDG','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4SA','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4SDD','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4SMM','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4SNF','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4TMS','GW','14','27');
INSERT INTO prefixlist VALUES('=GB4XXX','GW','14','27');
INSERT INTO prefixlist VALUES('=GB5BSJ','GW','14','27');
INSERT INTO prefixlist VALUES('=GB5FI','GW','14','27');
INSERT INTO prefixlist VALUES('=GB5SIP','GW','14','27');
INSERT INTO prefixlist VALUES('=GB60VLY','GW','14','27');
INSERT INTO prefixlist VALUES('=GB6AR','GW','14','27');
INSERT INTO prefixlist VALUES('=GB6GW','GW','14','27');
INSERT INTO prefixlist VALUES('=GB6OQA','GW','14','27');
INSERT INTO prefixlist VALUES('=GB750CC','GW','14','27');
INSERT INTO prefixlist VALUES('=GB8OQE','GW','14','27');
INSERT INTO prefixlist VALUES('H4','H4','28','51');
INSERT INTO prefixlist VALUES('H40','H40','32','51');
INSERT INTO prefixlist VALUES('HA','HA','15','28');
INSERT INTO prefixlist VALUES('HG','HA','15','28');
INSERT INTO prefixlist VALUES('HB','HB','14','28');
INSERT INTO prefixlist VALUES('HE','HB','14','28');
INSERT INTO prefixlist VALUES('HB0','HB0','14','28');
INSERT INTO prefixlist VALUES('HE0','HB0','14','28');
INSERT INTO prefixlist VALUES('HC','HC','10','12');
INSERT INTO prefixlist VALUES('HD','HC','10','12');
INSERT INTO prefixlist VALUES('HC8','HC8','10','12');
INSERT INTO prefixlist VALUES('HD8','HC8','10','12');
INSERT INTO prefixlist VALUES('4V','HH','08','11');
INSERT INTO prefixlist VALUES('HH','HH','08','11');
INSERT INTO prefixlist VALUES('HI','HI','08','11');
INSERT INTO prefixlist VALUES('5J','HK','09','12');
INSERT INTO prefixlist VALUES('5K','HK','09','12');
INSERT INTO prefixlist VALUES('HJ','HK','09','12');
INSERT INTO prefixlist VALUES('HK','HK','09','12');
INSERT INTO prefixlist VALUES('5J0','HK0/a','07','11');
INSERT INTO prefixlist VALUES('5K0','HK0/a','07','11');
INSERT INTO prefixlist VALUES('HJ0','HK0/a','07','11');
INSERT INTO prefixlist VALUES('HK0','HK0/a','07','11');
INSERT INTO prefixlist VALUES('=HK0TU','HK0/m','09','12');
INSERT INTO prefixlist VALUES('6K','HL','25','44');
INSERT INTO prefixlist VALUES('6L','HL','25','44');
INSERT INTO prefixlist VALUES('6M','HL','25','44');
INSERT INTO prefixlist VALUES('6N','HL','25','44');
INSERT INTO prefixlist VALUES('D7','HL','25','44');
INSERT INTO prefixlist VALUES('D8','HL','25','44');
INSERT INTO prefixlist VALUES('D9','HL','25','44');
INSERT INTO prefixlist VALUES('DS','HL','25','44');
INSERT INTO prefixlist VALUES('DT','HL','25','44');
INSERT INTO prefixlist VALUES('HL','HL','25','44');
INSERT INTO prefixlist VALUES('HM','HM','25','44');
INSERT INTO prefixlist VALUES('P5','HM','25','44');
INSERT INTO prefixlist VALUES('P6','HM','25','44');
INSERT INTO prefixlist VALUES('P7','HM','25','44');
INSERT INTO prefixlist VALUES('P8','HM','25','44');
INSERT INTO prefixlist VALUES('P9','HM','25','44');
INSERT INTO prefixlist VALUES('3E','HP','07','11');
INSERT INTO prefixlist VALUES('3F','HP','07','11');
INSERT INTO prefixlist VALUES('H3','HP','07','11');
INSERT INTO prefixlist VALUES('H8','HP','07','11');
INSERT INTO prefixlist VALUES('H9','HP','07','11');
INSERT INTO prefixlist VALUES('HO','HP','07','11');
INSERT INTO prefixlist VALUES('HP','HP','07','11');
INSERT INTO prefixlist VALUES('HQ','HR','07','11');
INSERT INTO prefixlist VALUES('HR','HR','07','11');
INSERT INTO prefixlist VALUES('E2','HS','26','49');
INSERT INTO prefixlist VALUES('HS','HS','26','49');
INSERT INTO prefixlist VALUES('HV','HV','15','28');
INSERT INTO prefixlist VALUES('7Z','HZ','21','39');
INSERT INTO prefixlist VALUES('8Z','HZ','21','39');
INSERT INTO prefixlist VALUES('HZ','HZ','21','39');
INSERT INTO prefixlist VALUES('I','I','15','28');
INSERT INTO prefixlist VALUES('IG9','*IG9','33','37');
INSERT INTO prefixlist VALUES('IH9','*IG9','33','37');
INSERT INTO prefixlist VALUES('IM0','IS','15','28');
INSERT INTO prefixlist VALUES('IS','IS','15','28');
INSERT INTO prefixlist VALUES('IW0U','IS','15','28');
INSERT INTO prefixlist VALUES('IW0V','IS','15','28');
INSERT INTO prefixlist VALUES('IW0W','IS','15','28');
INSERT INTO prefixlist VALUES('IW0X','IS','15','28');
INSERT INTO prefixlist VALUES('IW0Y','IS','15','28');
INSERT INTO prefixlist VALUES('IW0Z','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0AG','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0AH','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0AI','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0AK','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0AL','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0AM','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0EH','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0HO','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0QP','IS','15','28');
INSERT INTO prefixlist VALUES('=IQ0SS','IS','15','28');
INSERT INTO prefixlist VALUES('IB9','*IT9','15','28');
INSERT INTO prefixlist VALUES('ID9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IE9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IF9','*IT9','15','28');
INSERT INTO prefixlist VALUES('II9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IJ9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IO9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IQ9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IR9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IT','*IT9','15','28');
INSERT INTO prefixlist VALUES('IU9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IW9','*IT9','15','28');
INSERT INTO prefixlist VALUES('IZ9','*IT9','15','28');
INSERT INTO prefixlist VALUES('J2','J2','37','48');
INSERT INTO prefixlist VALUES('J3','J3','08','11');
INSERT INTO prefixlist VALUES('J5','J5','35','46');
INSERT INTO prefixlist VALUES('J6','J6','08','11');
INSERT INTO prefixlist VALUES('J7','J7','08','11');
INSERT INTO prefixlist VALUES('J8','J8','08','11');
INSERT INTO prefixlist VALUES('7J','JA','25','45');
INSERT INTO prefixlist VALUES('7K','JA','25','45');
INSERT INTO prefixlist VALUES('7L','JA','25','45');
INSERT INTO prefixlist VALUES('7M','JA','25','45');
INSERT INTO prefixlist VALUES('7N','JA','25','45');
INSERT INTO prefixlist VALUES('8J','JA','25','45');
INSERT INTO prefixlist VALUES('8K','JA','25','45');
INSERT INTO prefixlist VALUES('8L','JA','25','45');
INSERT INTO prefixlist VALUES('8M','JA','25','45');
INSERT INTO prefixlist VALUES('8N','JA','25','45');
INSERT INTO prefixlist VALUES('JA','JA','25','45');
INSERT INTO prefixlist VALUES('JB','JA','25','45');
INSERT INTO prefixlist VALUES('JC','JA','25','45');
INSERT INTO prefixlist VALUES('JE','JA','25','45');
INSERT INTO prefixlist VALUES('JF','JA','25','45');
INSERT INTO prefixlist VALUES('JG','JA','25','45');
INSERT INTO prefixlist VALUES('JH','JA','25','45');
INSERT INTO prefixlist VALUES('JI','JA','25','45');
INSERT INTO prefixlist VALUES('JJ','JA','25','45');
INSERT INTO prefixlist VALUES('JK','JA','25','45');
INSERT INTO prefixlist VALUES('JL','JA','25','45');
INSERT INTO prefixlist VALUES('JM','JA','25','45');
INSERT INTO prefixlist VALUES('JN','JA','25','45');
INSERT INTO prefixlist VALUES('JO','JA','25','45');
INSERT INTO prefixlist VALUES('JP','JA','25','45');
INSERT INTO prefixlist VALUES('JQ','JA','25','45');
INSERT INTO prefixlist VALUES('JR','JA','25','45');
INSERT INTO prefixlist VALUES('JS','JA','25','45');
INSERT INTO prefixlist VALUES('=JD1BME','JD/m','27','90');
INSERT INTO prefixlist VALUES('=JD1BMM','JD/m','27','90');
INSERT INTO prefixlist VALUES('=JD1YAA','JD/m','27','90');
INSERT INTO prefixlist VALUES('=JD1YBJ','JD/m','27','90');
INSERT INTO prefixlist VALUES('JD1','JD/o','27','45');
INSERT INTO prefixlist VALUES('JT','JT','23','32');
INSERT INTO prefixlist VALUES('JU','JT','23','32');
INSERT INTO prefixlist VALUES('JV','JT','23','32');
INSERT INTO prefixlist VALUES('JW','JW','40','18');
INSERT INTO prefixlist VALUES('=JW2FL','*JW/b','40','18');
INSERT INTO prefixlist VALUES('=JW5RIA','*JW/b','40','18');
INSERT INTO prefixlist VALUES('=JW7FD','*JW/b','40','18');
INSERT INTO prefixlist VALUES('JX','JX','40','18');
INSERT INTO prefixlist VALUES('JY','JY','20','39');
INSERT INTO prefixlist VALUES('4U1WB','K','05','08');
INSERT INTO prefixlist VALUES('AA','K','05','08');
INSERT INTO prefixlist VALUES('AB','K','05','08');
INSERT INTO prefixlist VALUES('AC','K','05','08');
INSERT INTO prefixlist VALUES('AD','K','05','08');
INSERT INTO prefixlist VALUES('AE','K','05','08');
INSERT INTO prefixlist VALUES('AF','K','05','08');
INSERT INTO prefixlist VALUES('AG','K','05','08');
INSERT INTO prefixlist VALUES('AI','K','05','08');
INSERT INTO prefixlist VALUES('AJ','K','05','08');
INSERT INTO prefixlist VALUES('AK','K','05','08');
INSERT INTO prefixlist VALUES('K','K','05','08');
INSERT INTO prefixlist VALUES('N','K','05','08');
INSERT INTO prefixlist VALUES('W','K','05','08');
INSERT INTO prefixlist VALUES('=AA0CY','K','5','8');
INSERT INTO prefixlist VALUES('=AA3VA','K','4','08');
INSERT INTO prefixlist VALUES('=AB4EJ','K','4','08');
INSERT INTO prefixlist VALUES('=AB4GG','K','4','08');
INSERT INTO prefixlist VALUES('=AC4PY','K','4','08');
INSERT INTO prefixlist VALUES('=AD4EB','K','4','08');
INSERT INTO prefixlist VALUES('=AD8J','K','5','08');
INSERT INTO prefixlist VALUES('=AE9F','K','3','6');
INSERT INTO prefixlist VALUES('=AG3V','K','4','7');
INSERT INTO prefixlist VALUES('=AG4W','K','4','08');
INSERT INTO prefixlist VALUES('=AH0AH','K','5','8');
INSERT INTO prefixlist VALUES('=AH2AK','K','5','8');
INSERT INTO prefixlist VALUES('=AH6HJ','K','5','8');
INSERT INTO prefixlist VALUES('=AH6HR','K','4','8');
INSERT INTO prefixlist VALUES('=AH6RI','K','3','6');
INSERT INTO prefixlist VALUES('=AH8M','K','5','8');
INSERT INTO prefixlist VALUES('=AL0F','K','3','6');
INSERT INTO prefixlist VALUES('=AL1VE','K','5','8');
INSERT INTO prefixlist VALUES('=AL4T','K','5','8');
INSERT INTO prefixlist VALUES('=AL7C','K','4','8');
INSERT INTO prefixlist VALUES('=AL7KT','K','5','8');
INSERT INTO prefixlist VALUES('=AL7LV','K','5','8');
INSERT INTO prefixlist VALUES('=AL7NS','K','5','8');
INSERT INTO prefixlist VALUES('=AL7O','K','4','7');
INSERT INTO prefixlist VALUES('=AL7QQ','K','4','7');
INSERT INTO prefixlist VALUES('=AL7W','K','3','6');
INSERT INTO prefixlist VALUES('=K0COP','K','5','8');
INSERT INTO prefixlist VALUES('=K0JJ','K','3','6');
INSERT INTO prefixlist VALUES('=K0JJM','K','4','7');
INSERT INTO prefixlist VALUES('=K0JJR','K','4','7');
INSERT INTO prefixlist VALUES('=K0LUZ','K','5','8');
INSERT INTO prefixlist VALUES('=K0TV','K','5','8');
INSERT INTO prefixlist VALUES('=K0TVD','K','4','7');
INSERT INTO prefixlist VALUES('=K1GU','K','4','08');
INSERT INTO prefixlist VALUES('=K1GUG','K','5','08');
INSERT INTO prefixlist VALUES('=K1LKR','K','3','6');
INSERT INTO prefixlist VALUES('=K1LT','K','4','08');
INSERT INTO prefixlist VALUES('=K1NG','K','4','08');
INSERT INTO prefixlist VALUES('=K1NT','K','4','7');
INSERT INTO prefixlist VALUES('=K1NTR','K','5','8');
INSERT INTO prefixlist VALUES('=K1TN','K','4','08');
INSERT INTO prefixlist VALUES('=K1TU','K','4','7');
INSERT INTO prefixlist VALUES('=K2AAW','K','4','08');
INSERT INTO prefixlist VALUES('=K2BA','K','4','7');
INSERT INTO prefixlist VALUES('=K2HT','K','4','7');
INSERT INTO prefixlist VALUES('=K2HTO','K','5','8');
INSERT INTO prefixlist VALUES('=K2RD','K','3','6');
INSERT INTO prefixlist VALUES('=K2VCO','K','3','6');
INSERT INTO prefixlist VALUES('=K2VV','K','4','7');
INSERT INTO prefixlist VALUES('=K3CQ','K','4','08');
INSERT INTO prefixlist VALUES('=K3GP','K','4','08');
INSERT INTO prefixlist VALUES('=K3IE','K','4','08');
INSERT INTO prefixlist VALUES('=K3PA','K','4','7');
INSERT INTO prefixlist VALUES('=K3WT','K','4','7');
INSERT INTO prefixlist VALUES('=K4AMC','K','4','08');
INSERT INTO prefixlist VALUES('=K4BEV','K','4','08');
INSERT INTO prefixlist VALUES('=K4BP','K','4','08');
INSERT INTO prefixlist VALUES('=K4BX','K','4','08');
INSERT INTO prefixlist VALUES('=K4BXC','K','5','08');
INSERT INTO prefixlist VALUES('=K4EJQ','K','4','08');
INSERT INTO prefixlist VALUES('=K4FXN','K','4','08');
INSERT INTO prefixlist VALUES('=K4HAL','K','4','08');
INSERT INTO prefixlist VALUES('=K4IE','K','4','08');
INSERT INTO prefixlist VALUES('=K4IU','K','4','7');
INSERT INTO prefixlist VALUES('=K4JA','K','4','08');
INSERT INTO prefixlist VALUES('=K4JNY','K','4','08');
INSERT INTO prefixlist VALUES('=K4LTA','K','4','08');
INSERT INTO prefixlist VALUES('=K4NO','K','4','08');
INSERT INTO prefixlist VALUES('=K4OAQ','K','4','08');
INSERT INTO prefixlist VALUES('=K4RO','K','4','08');
INSERT INTO prefixlist VALUES('=K4SAC','K','4','08');
INSERT INTO prefixlist VALUES('=K4TD','K','4','08');
INSERT INTO prefixlist VALUES('=K4VU','K','3','6');
INSERT INTO prefixlist VALUES('=K4VUD','K','5','8');
INSERT INTO prefixlist VALUES('=K4WI','K','4','08');
INSERT INTO prefixlist VALUES('=K4WW','K','4','08');
INSERT INTO prefixlist VALUES('=K4WX','K','4','08');
INSERT INTO prefixlist VALUES('=K4XG','K','4','08');
INSERT INTO prefixlist VALUES('=K4XU','K','3','6');
INSERT INTO prefixlist VALUES('=K4ZGB','K','4','08');
INSERT INTO prefixlist VALUES('=K5KG','K','5','8');
INSERT INTO prefixlist VALUES('=K5MA','K','5','8');
INSERT INTO prefixlist VALUES('=K5RC','K','3','6');
INSERT INTO prefixlist VALUES('=K5RR','K','3','6');
INSERT INTO prefixlist VALUES('=K5ZD','K','5','8');
INSERT INTO prefixlist VALUES('=K5ZDG','K','4','7');
INSERT INTO prefixlist VALUES('=K6EID','K','5','8');
INSERT INTO prefixlist VALUES('=K6XT','K','4','7');
INSERT INTO prefixlist VALUES('=K7ABV','K','4','6');
INSERT INTO prefixlist VALUES('=K7BG','K','4','6');
INSERT INTO prefixlist VALUES('=K7CMZ','K','5','8');
INSERT INTO prefixlist VALUES('=K7CS','K','5','8');
INSERT INTO prefixlist VALUES('=K7GM','K','5','8');
INSERT INTO prefixlist VALUES('=K7GMF','K','3','6');
INSERT INTO prefixlist VALUES('=K7IA','K','4','7');
INSERT INTO prefixlist VALUES('=K7RE','K','4','7');
INSERT INTO prefixlist VALUES('=K7REL','K','3','6');
INSERT INTO prefixlist VALUES('=K7SV','K','5','8');
INSERT INTO prefixlist VALUES('=K7TD','K','4','7');
INSERT INTO prefixlist VALUES('=K7UP','K','4','7');
INSERT INTO prefixlist VALUES('=K7VU','K','4','7');
INSERT INTO prefixlist VALUES('=K8AC','K','5','08');
INSERT INTO prefixlist VALUES('=K8IA','K','3','6');
INSERT INTO prefixlist VALUES('=K8JQ','K','5','08');
INSERT INTO prefixlist VALUES('=K8OQL','K','5','08');
INSERT INTO prefixlist VALUES('=K8OSF','K','5','08');
INSERT INTO prefixlist VALUES('=K8XS','K','5','08');
INSERT INTO prefixlist VALUES('=K8YC','K','5','08');
INSERT INTO prefixlist VALUES('=K9AW','K','5','08');
INSERT INTO prefixlist VALUES('=K9ES','K','5','08');
INSERT INTO prefixlist VALUES('=K9FY','K','5','08');
INSERT INTO prefixlist VALUES('=K9HUY','K','5','08');
INSERT INTO prefixlist VALUES('=K9JF','K','3','6');
INSERT INTO prefixlist VALUES('=K9OM','K','5','08');
INSERT INTO prefixlist VALUES('=K9VV','K','5','08');
INSERT INTO prefixlist VALUES('=KA2EYH','K','4','08');
INSERT INTO prefixlist VALUES('=KA8Q','K','5','08');
INSERT INTO prefixlist VALUES('=KB7Q','K','4','6');
INSERT INTO prefixlist VALUES('=KC3MR','K','4','08');
INSERT INTO prefixlist VALUES('=KC7UP','K','4','6');
INSERT INTO prefixlist VALUES('=KD5M','K','5','8');
INSERT INTO prefixlist VALUES('=KD5MDO','K','4','7');
INSERT INTO prefixlist VALUES('=KE4MBP','K','4','08');
INSERT INTO prefixlist VALUES('=KE4OAR','K','4','08');
INSERT INTO prefixlist VALUES('=KE7NO','K','4','6');
INSERT INTO prefixlist VALUES('=KH2AR','K','4','8');
INSERT INTO prefixlist VALUES('=KH2D','K','5','8');
INSERT INTO prefixlist VALUES('=KH6DX','K','3','6');
INSERT INTO prefixlist VALUES('=KH6GJV','K','3','6');
INSERT INTO prefixlist VALUES('=KH6HHS','K','5','8');
INSERT INTO prefixlist VALUES('=KH6HTV0','K','4','7');
INSERT INTO prefixlist VALUES('=KH6ILR','K','5','8');
INSERT INTO prefixlist VALUES('=KH6JIM7','K','3','6');
INSERT INTO prefixlist VALUES('=KH6JTM','K','4','7');
INSERT INTO prefixlist VALUES('=KH6OE','K','4','8');
INSERT INTO prefixlist VALUES('=KH6QAI','K','3','6');
INSERT INTO prefixlist VALUES('=KH6QAJ','K','3','6');
INSERT INTO prefixlist VALUES('=KH6RW','K','3','6');
INSERT INTO prefixlist VALUES('=KI6DY','K','4','7');
INSERT INTO prefixlist VALUES('=KK9A','K','5','08');
INSERT INTO prefixlist VALUES('=KL0ET','K','4','8');
INSERT INTO prefixlist VALUES('=KL0LN','K','4','8');
INSERT INTO prefixlist VALUES('=KL1IF','K','4','8');
INSERT INTO prefixlist VALUES('=KL7FDQ','K','3','6');
INSERT INTO prefixlist VALUES('=KL7WP','K','3','6');
INSERT INTO prefixlist VALUES('=KL7XX','K','4','8');
INSERT INTO prefixlist VALUES('=KM4FO','K','4','08');
INSERT INTO prefixlist VALUES('=KM6JD','K','5','8');
INSERT INTO prefixlist VALUES('=KN4Q','K','4','08');
INSERT INTO prefixlist VALUES('=KN4QS','K','4','7');
INSERT INTO prefixlist VALUES('=KN5H','K','3','6');
INSERT INTO prefixlist VALUES('=KN6RO','K','5','8');
INSERT INTO prefixlist VALUES('=KN8J','K','5','08');
INSERT INTO prefixlist VALUES('=KO7X','K','4','7');
INSERT INTO prefixlist VALUES('=KP2N','K','5','8');
INSERT INTO prefixlist VALUES('=KS7T','K','4','6');
INSERT INTO prefixlist VALUES('=KU1CW','K','4','7');
INSERT INTO prefixlist VALUES('=KU8E','K','5','08');
INSERT INTO prefixlist VALUES('=KY1V','K','4','08');
INSERT INTO prefixlist VALUES('=KY4AA','K','4','08');
INSERT INTO prefixlist VALUES('=KY4Z','K','4','7');
INSERT INTO prefixlist VALUES('=N0AX','K','3','6');
INSERT INTO prefixlist VALUES('=N1LN','K','4','7');
INSERT INTO prefixlist VALUES('=N1SZ','K','4','7');
INSERT INTO prefixlist VALUES('=N1WI','K','4','08');
INSERT INTO prefixlist VALUES('=N1ZP','K','4','08');
INSERT INTO prefixlist VALUES('=N2BJ','K','4','08');
INSERT INTO prefixlist VALUES('=N2BJL','K','5','08');
INSERT INTO prefixlist VALUES('=N2IC','K','4','7');
INSERT INTO prefixlist VALUES('=N2LA','K','4','7');
INSERT INTO prefixlist VALUES('=N2NB','K','3','6');
INSERT INTO prefixlist VALUES('=N2WN','K','4','08');
INSERT INTO prefixlist VALUES('=N3AIU','K','4','7');
INSERT INTO prefixlist VALUES('=N3BB','K','4','7');
INSERT INTO prefixlist VALUES('=N3ZZ','K','3','6');
INSERT INTO prefixlist VALUES('=N4CVO','K','4','08');
INSERT INTO prefixlist VALUES('=N4DD','K','4','08');
INSERT INTO prefixlist VALUES('=N4DW','K','4','08');
INSERT INTO prefixlist VALUES('=N4GK','K','4','08');
INSERT INTO prefixlist VALUES('=N4GN','K','4','08');
INSERT INTO prefixlist VALUES('=N4IR','K','4','08');
INSERT INTO prefixlist VALUES('=N4IRR','K','5','08');
INSERT INTO prefixlist VALUES('=N4JF','K','4','08');
INSERT INTO prefixlist VALUES('=N4KG','K','4','08');
INSERT INTO prefixlist VALUES('=N4KZ','K','4','08');
INSERT INTO prefixlist VALUES('=N4NO','K','4','08');
INSERT INTO prefixlist VALUES('=N4OGW','K','4','8');
INSERT INTO prefixlist VALUES('=N4QS','K','4','08');
INSERT INTO prefixlist VALUES('=N4SL','K','3','6');
INSERT INTO prefixlist VALUES('=N4TN','K','4','08');
INSERT INTO prefixlist VALUES('=N4TZ','K','4','08');
INSERT INTO prefixlist VALUES('=N4UW','K','4','08');
INSERT INTO prefixlist VALUES('=N4VV','K','4','08');
INSERT INTO prefixlist VALUES('=N4XM','K','4','08');
INSERT INTO prefixlist VALUES('=N4ZZ','K','4','08');
INSERT INTO prefixlist VALUES('=N6AR','K','5','8');
INSERT INTO prefixlist VALUES('=N6MW','K','5','8');
INSERT INTO prefixlist VALUES('=N6MWA','K','3','6');
INSERT INTO prefixlist VALUES('=N6RFM','K','5','8');
INSERT INTO prefixlist VALUES('=N6ZO','K','5','8');
INSERT INTO prefixlist VALUES('=N6ZZ','K','4','7');
INSERT INTO prefixlist VALUES('=N7DC','K','5','8');
INSERT INTO prefixlist VALUES('=N7DF','K','4','7');
INSERT INTO prefixlist VALUES('=N7FLT','K','4','6');
INSERT INTO prefixlist VALUES('=N7IV','K','4','7');
INSERT INTO prefixlist VALUES('=N7NG','K','4','6');
INSERT INTO prefixlist VALUES('=N7VMR','K','4','6');
INSERT INTO prefixlist VALUES('=N8FF','K','5','08');
INSERT INTO prefixlist VALUES('=N8II','K','5','08');
INSERT INTO prefixlist VALUES('=N8NA','K','5','08');
INSERT INTO prefixlist VALUES('=N8PR','K','5','08');
INSERT INTO prefixlist VALUES('=N8RA','K','5','08');
INSERT INTO prefixlist VALUES('=N8WXQ','K','5','08');
INSERT INTO prefixlist VALUES('=N9ADG','K','3','6');
INSERT INTO prefixlist VALUES('=NA4K','K','4','08');
INSERT INTO prefixlist VALUES('=NA4M','K','4','7');
INSERT INTO prefixlist VALUES('=NA4MA','K','5','8');
INSERT INTO prefixlist VALUES('=ND2T','K','3','6');
INSERT INTO prefixlist VALUES('=ND9M','K','5','08');
INSERT INTO prefixlist VALUES('=NH7C','K','5','8');
INSERT INTO prefixlist VALUES('=NJ4I','K','4','08');
INSERT INTO prefixlist VALUES('=NL7AU','K','5','8');
INSERT INTO prefixlist VALUES('=NL7CO','K','4','7');
INSERT INTO prefixlist VALUES('=NL7XM','K','5','8');
INSERT INTO prefixlist VALUES('=NP3D','K','5','8');
INSERT INTO prefixlist VALUES('=NQ4U','K','4','08');
INSERT INTO prefixlist VALUES('=NU4B','K','4','08');
INSERT INTO prefixlist VALUES('=NU4BP','K','5','08');
INSERT INTO prefixlist VALUES('=NW7MT','K','4','6');
INSERT INTO prefixlist VALUES('=NW8U','K','5','08');
INSERT INTO prefixlist VALUES('=NX9T','K','5','08');
INSERT INTO prefixlist VALUES('=NY4N','K','4','08');
INSERT INTO prefixlist VALUES('=NY6DX','K','5','8');
INSERT INTO prefixlist VALUES('=W0RLI','K','3','6');
INSERT INTO prefixlist VALUES('=W0UCE','K','5','8');
INSERT INTO prefixlist VALUES('=W0YK','K','3','6');
INSERT INTO prefixlist VALUES('=W0YR','K','5','8');
INSERT INTO prefixlist VALUES('=W0YRN','K','4','7');
INSERT INTO prefixlist VALUES('=W0ZZ','K','3','6');
INSERT INTO prefixlist VALUES('=W0ZZQ','K','4','7');
INSERT INTO prefixlist VALUES('=W1AAMSC','K','5','8');
INSERT INTO prefixlist VALUES('=W1DY','K','4','7');
INSERT INTO prefixlist VALUES('=W1DYH','K','5','8');
INSERT INTO prefixlist VALUES('=W1DYJ','K','5','8');
INSERT INTO prefixlist VALUES('=W1MVY','K','3','6');
INSERT INTO prefixlist VALUES('=W1RH','K','3','6');
INSERT INTO prefixlist VALUES('=W1SRD','K','3','6');
INSERT INTO prefixlist VALUES('=W2OO','K','4','08');
INSERT INTO prefixlist VALUES('=W2VJN','K','3','6');
INSERT INTO prefixlist VALUES('=W3CP','K','3','6');
INSERT INTO prefixlist VALUES('=W3HDH','K','4','08');
INSERT INTO prefixlist VALUES('=W4BCG','K','4','08');
INSERT INTO prefixlist VALUES('=W4CID','K','4','08');
INSERT INTO prefixlist VALUES('=W4DAN','K','4','08');
INSERT INTO prefixlist VALUES('=W4DHE','K','4','08');
INSERT INTO prefixlist VALUES('=W4DVG','K','4','08');
INSERT INTO prefixlist VALUES('=W4EEH','K','4','08');
INSERT INTO prefixlist VALUES('=W4EF','K','3','6');
INSERT INTO prefixlist VALUES('=W4FMS','K','4','08');
INSERT INTO prefixlist VALUES('=W4GKM','K','4','08');
INSERT INTO prefixlist VALUES('=W4HZD','K','4','08');
INSERT INTO prefixlist VALUES('=W4JSI','K','4','08');
INSERT INTO prefixlist VALUES('=W4KW','K','4','08');
INSERT INTO prefixlist VALUES('=W4LC','K','4','08');
INSERT INTO prefixlist VALUES('=W4LIA','K','4','08');
INSERT INTO prefixlist VALUES('=W4NBS','K','4','08');
INSERT INTO prefixlist VALUES('=W4NI','K','4','08');
INSERT INTO prefixlist VALUES('=W4NTI','K','4','08');
INSERT INTO prefixlist VALUES('=W4NZ','K','4','08');
INSERT INTO prefixlist VALUES('=W4PA','K','4','08');
INSERT INTO prefixlist VALUES('=W4RYW','K','4','08');
INSERT INTO prefixlist VALUES('=W4TDB','K','4','08');
INSERT INTO prefixlist VALUES('=W4TYU','K','4','08');
INSERT INTO prefixlist VALUES('=W4YOK','K','4','7');
INSERT INTO prefixlist VALUES('=W5KI','K','5','8');
INSERT INTO prefixlist VALUES('=W5REA','K','5','8');
INSERT INTO prefixlist VALUES('=W6AAN','K','5','8');
INSERT INTO prefixlist VALUES('=W6DSQ','K','4','8');
INSERT INTO prefixlist VALUES('=W6FC','K','5','8');
INSERT INTO prefixlist VALUES('=W6IHG','K','5','8');
INSERT INTO prefixlist VALUES('=W6JV','K','5','8');
INSERT INTO prefixlist VALUES('=W6LFB','K','4','7');
INSERT INTO prefixlist VALUES('=W6NWS','K','5','8');
INSERT INTO prefixlist VALUES('=W6TER','K','4','7');
INSERT INTO prefixlist VALUES('=W6UB','K','4','8');
INSERT INTO prefixlist VALUES('=W6XR','K','5','8');
INSERT INTO prefixlist VALUES('=W6YJ','K','4','7');
INSERT INTO prefixlist VALUES('=W7FG','K','4','7');
INSERT INTO prefixlist VALUES('=W7LPF','K','5','8');
INSERT INTO prefixlist VALUES('=W7LR','K','4','6');
INSERT INTO prefixlist VALUES('=W7LRD','K','3','6');
INSERT INTO prefixlist VALUES('=W7QF','K','5','8');
INSERT INTO prefixlist VALUES('=W7SE','K','4','7');
INSERT INTO prefixlist VALUES('=W8AEF','K','3','6');
INSERT INTO prefixlist VALUES('=W8FJ','K','5','08');
INSERT INTO prefixlist VALUES('=W8HGH','K','5','08');
INSERT INTO prefixlist VALUES('=W8TN','K','5','08');
INSERT INTO prefixlist VALUES('=W8WEJ','K','5','08');
INSERT INTO prefixlist VALUES('=W8ZA','K','5','08');
INSERT INTO prefixlist VALUES('=W9GE','K','5','08');
INSERT INTO prefixlist VALUES('=W9GEN','K','4','08');
INSERT INTO prefixlist VALUES('=W9IGJ','K','5','08');
INSERT INTO prefixlist VALUES('=W9MAK','K','3','6');
INSERT INTO prefixlist VALUES('=W9NGA','K','3','6');
INSERT INTO prefixlist VALUES('=WA0KDS','K','3','6');
INSERT INTO prefixlist VALUES('=WA1FCN','K','4','08');
INSERT INTO prefixlist VALUES('=WA1MKE','K','4','08');
INSERT INTO prefixlist VALUES('=WA1UJU','K','4','08');
INSERT INTO prefixlist VALUES('=WA2MNO','K','4','7');
INSERT INTO prefixlist VALUES('=WA4GLH','K','4','08');
INSERT INTO prefixlist VALUES('=WA4JA','K','4','08');
INSERT INTO prefixlist VALUES('=WA4OSD','K','4','08');
INSERT INTO prefixlist VALUES('=WA5VGI','K','3','6');
INSERT INTO prefixlist VALUES('=WA8WV','K','5','08');
INSERT INTO prefixlist VALUES('=WB2ORD','K','4','08');
INSERT INTO prefixlist VALUES('=WB4YDL','K','4','08');
INSERT INTO prefixlist VALUES('=WB4ZBI','K','4','08');
INSERT INTO prefixlist VALUES('=WB6BWZ','K','5','8');
INSERT INTO prefixlist VALUES('=WB8YQJ','K','3','6');
INSERT INTO prefixlist VALUES('=WB8YYY','K','5','08');
INSERT INTO prefixlist VALUES('=WD4K','K','4','08');
INSERT INTO prefixlist VALUES('=WD4OHD','K','4','08');
INSERT INTO prefixlist VALUES('=WG7Y','K','4','7');
INSERT INTO prefixlist VALUES('=WH0AI','K','4','8');
INSERT INTO prefixlist VALUES('=WH6ASWM','K','3','6');
INSERT INTO prefixlist VALUES('=WJ9B','K','5','08');
INSERT INTO prefixlist VALUES('=WL7BPY','K','4','7');
INSERT INTO prefixlist VALUES('=WL7K','K','3','6');
INSERT INTO prefixlist VALUES('=WN4M','K','4','08');
INSERT INTO prefixlist VALUES('=WO4O','K','4','08');
INSERT INTO prefixlist VALUES('=WO5D','K','5','8');
INSERT INTO prefixlist VALUES('=WP4JBG','K','4','8');
INSERT INTO prefixlist VALUES('=WS4Y','K','4','7');
INSERT INTO prefixlist VALUES('=WT5L','K','5','8');
INSERT INTO prefixlist VALUES('=WX4TM','K','4','08');
INSERT INTO prefixlist VALUES('KG4','KG4','08','11');
INSERT INTO prefixlist VALUES('AH0','KH0','27','64');
INSERT INTO prefixlist VALUES('KH0','KH0','27','64');
INSERT INTO prefixlist VALUES('NH0','KH0','27','64');
INSERT INTO prefixlist VALUES('WH0','KH0','27','64');
INSERT INTO prefixlist VALUES('=KG6SL','KH0','27','64');
INSERT INTO prefixlist VALUES('AH1','KH1','31','61');
INSERT INTO prefixlist VALUES('KH1','KH1','31','61');
INSERT INTO prefixlist VALUES('NH1','KH1','31','61');
INSERT INTO prefixlist VALUES('WH1','KH1','31','61');
INSERT INTO prefixlist VALUES('AH2','KH2','27','64');
INSERT INTO prefixlist VALUES('KH2','KH2','27','64');
INSERT INTO prefixlist VALUES('NH2','KH2','27','64');
INSERT INTO prefixlist VALUES('WH2','KH2','27','64');
INSERT INTO prefixlist VALUES('=KG6ASO','KH2','27','64');
INSERT INTO prefixlist VALUES('=KG6DX','KH2','27','64');
INSERT INTO prefixlist VALUES('AH3','KH3','31','61');
INSERT INTO prefixlist VALUES('KH3','KH3','31','61');
INSERT INTO prefixlist VALUES('NH3','KH3','31','61');
INSERT INTO prefixlist VALUES('WH3','KH3','31','61');
INSERT INTO prefixlist VALUES('=KJ6BZ','KH3','31','61');
INSERT INTO prefixlist VALUES('AH4','KH4','31','61');
INSERT INTO prefixlist VALUES('KH4','KH4','31','61');
INSERT INTO prefixlist VALUES('NH4','KH4','31','61');
INSERT INTO prefixlist VALUES('WH4','KH4','31','61');
INSERT INTO prefixlist VALUES('AH5','KH5','31','61');
INSERT INTO prefixlist VALUES('KH5','KH5','31','61');
INSERT INTO prefixlist VALUES('NH5','KH5','31','61');
INSERT INTO prefixlist VALUES('WH5','KH5','31','61');
INSERT INTO prefixlist VALUES('AH5K','KH5K','31','61');
INSERT INTO prefixlist VALUES('KH5K','KH5K','31','61');
INSERT INTO prefixlist VALUES('NH5K','KH5K','31','61');
INSERT INTO prefixlist VALUES('WH5K','KH5K','31','61');
INSERT INTO prefixlist VALUES('AH6','KH6','31','61');
INSERT INTO prefixlist VALUES('AH7','KH6','31','61');
INSERT INTO prefixlist VALUES('KH6','KH6','31','61');
INSERT INTO prefixlist VALUES('KH7','KH6','31','61');
INSERT INTO prefixlist VALUES('N6KB','KH6','31','61');
INSERT INTO prefixlist VALUES('NH6','KH6','31','61');
INSERT INTO prefixlist VALUES('NH7','KH6','31','61');
INSERT INTO prefixlist VALUES('WH6','KH6','31','61');
INSERT INTO prefixlist VALUES('WH7','KH6','31','61');
INSERT INTO prefixlist VALUES('AH7K','KH7K','31','61');
INSERT INTO prefixlist VALUES('KH7K','KH7K','31','61');
INSERT INTO prefixlist VALUES('NH7K','KH7K','31','61');
INSERT INTO prefixlist VALUES('WH7K','KH7K','31','61');
INSERT INTO prefixlist VALUES('AH8','KH8','32','62');
INSERT INTO prefixlist VALUES('KH8','KH8','32','62');
INSERT INTO prefixlist VALUES('NH8','KH8','32','62');
INSERT INTO prefixlist VALUES('WH8','KH8','32','62');
INSERT INTO prefixlist VALUES('=KH8SI','KH8/s','32','62');
INSERT INTO prefixlist VALUES('AH9','KH9','31','65');
INSERT INTO prefixlist VALUES('KH9','KH9','31','65');
INSERT INTO prefixlist VALUES('NH9','KH9','31','65');
INSERT INTO prefixlist VALUES('WH9','KH9','31','65');
INSERT INTO prefixlist VALUES('AL','KL','01','01');
INSERT INTO prefixlist VALUES('KL','KL','01','01');
INSERT INTO prefixlist VALUES('NL','KL','01','01');
INSERT INTO prefixlist VALUES('WL','KL','01','01');
INSERT INTO prefixlist VALUES('=K7A','KL','01','01');
INSERT INTO prefixlist VALUES('=KW1W','KL','01','01');
INSERT INTO prefixlist VALUES('KP1','KP1','08','11');
INSERT INTO prefixlist VALUES('NP1','KP1','08','11');
INSERT INTO prefixlist VALUES('WP1','KP1','08','11');
INSERT INTO prefixlist VALUES('KP2','KP2','08','11');
INSERT INTO prefixlist VALUES('NP2','KP2','08','11');
INSERT INTO prefixlist VALUES('WP2','KP2','08','11');
INSERT INTO prefixlist VALUES('=KV4FZ','KP2','08','11');
INSERT INTO prefixlist VALUES('KP3','KP4','08','11');
INSERT INTO prefixlist VALUES('KP4','KP4','08','11');
INSERT INTO prefixlist VALUES('NP3','KP4','08','11');
INSERT INTO prefixlist VALUES('NP4','KP4','08','11');
INSERT INTO prefixlist VALUES('WP3','KP4','08','11');
INSERT INTO prefixlist VALUES('WP4','KP4','08','11');
INSERT INTO prefixlist VALUES('KP5','KP5','08','11');
INSERT INTO prefixlist VALUES('NP5','KP5','08','11');
INSERT INTO prefixlist VALUES('WP5','KP5','08','11');
INSERT INTO prefixlist VALUES('LA','LA','14','18');
INSERT INTO prefixlist VALUES('LB','LA','14','18');
INSERT INTO prefixlist VALUES('LC','LA','14','18');
INSERT INTO prefixlist VALUES('LD','LA','14','18');
INSERT INTO prefixlist VALUES('LE','LA','14','18');
INSERT INTO prefixlist VALUES('LF','LA','14','18');
INSERT INTO prefixlist VALUES('LG','LA','14','18');
INSERT INTO prefixlist VALUES('LH','LA','14','18');
INSERT INTO prefixlist VALUES('LI','LA','14','18');
INSERT INTO prefixlist VALUES('LJ','LA','14','18');
INSERT INTO prefixlist VALUES('LK','LA','14','18');
INSERT INTO prefixlist VALUES('LL','LA','14','18');
INSERT INTO prefixlist VALUES('LM','LA','14','18');
INSERT INTO prefixlist VALUES('LN','LA','14','18');
INSERT INTO prefixlist VALUES('AY','LU','13','14');
INSERT INTO prefixlist VALUES('AZ','LU','13','14');
INSERT INTO prefixlist VALUES('L2','LU','13','14');
INSERT INTO prefixlist VALUES('L3','LU','13','14');
INSERT INTO prefixlist VALUES('L4','LU','13','14');
INSERT INTO prefixlist VALUES('L5','LU','13','14');
INSERT INTO prefixlist VALUES('L6','LU','13','14');
INSERT INTO prefixlist VALUES('L7','LU','13','14');
INSERT INTO prefixlist VALUES('L8','LU','13','14');
INSERT INTO prefixlist VALUES('L9','LU','13','14');
INSERT INTO prefixlist VALUES('LO','LU','13','14');
INSERT INTO prefixlist VALUES('LP','LU','13','14');
INSERT INTO prefixlist VALUES('LQ','LU','13','14');
INSERT INTO prefixlist VALUES('LR','LU','13','14');
INSERT INTO prefixlist VALUES('LS','LU','13','14');
INSERT INTO prefixlist VALUES('LT','LU','13','14');
INSERT INTO prefixlist VALUES('LU','LU','13','14');
INSERT INTO prefixlist VALUES('LV','LU','13','14');
INSERT INTO prefixlist VALUES('LW','LU','13','14');
INSERT INTO prefixlist VALUES('=AY0NX','LU','13','14');
INSERT INTO prefixlist VALUES('=AY3DRD','LU','13','14');
INSERT INTO prefixlist VALUES('=AY4EJD','LU','13','14');
INSERT INTO prefixlist VALUES('=AY5ED','LU','13','14');
INSERT INTO prefixlist VALUES('=AY7DSYD','LU','13','14');
INSERT INTO prefixlist VALUES('=DJ4SNLUX','LU','13','14');
INSERT INTO prefixlist VALUES('=L20ARCD','LU','13','14');
INSERT INTO prefixlist VALUES('=L21ESCLH','LU','13','14');
INSERT INTO prefixlist VALUES('=L25ED','LU','13','14');
INSERT INTO prefixlist VALUES('=L30EYD','LU','13','14');
INSERT INTO prefixlist VALUES('=L30EYV','LU','13','14');
INSERT INTO prefixlist VALUES('=L40ED','LU','13','14');
INSERT INTO prefixlist VALUES('=L44DD','LU','13','14');
INSERT INTO prefixlist VALUES('=L80AAD','LU','13','14');
INSERT INTO prefixlist VALUES('=L84VID','LU','13','14');
INSERT INTO prefixlist VALUES('=L8DX','LU','13','14');
INSERT INTO prefixlist VALUES('=LO0DD','LU','13','14');
INSERT INTO prefixlist VALUES('=LO7ED','LU','13','14');
INSERT INTO prefixlist VALUES('=LUDH4PBR','LU','13','14');
INSERT INTO prefixlist VALUES('=LUDH4PBS','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1AEED','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1AFD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1CDPD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DHOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DKD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DMAE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DZE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DZP','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DZQ','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DZR','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DZS','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1DZX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1EJW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1EQD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1EUUW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1EYWD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1OFNI','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1VOFD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1VZV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1XAWX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1XWCE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1XYX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1YUD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU1YYY','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2CRMXA','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2DTD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2DTLH','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2DVIH','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2EED','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2EEE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2EJBX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2VCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2VDVD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2WVO','LU','13','14');
INSERT INTO prefixlist VALUES('=LU2XXX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3CQD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DJID','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DJIW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DOCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DRD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DRV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DXGD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3DZOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3EOUD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3ESD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3ESV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3ESW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU3HKAD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4AAOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4DAD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4DBPD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4DBTD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4DQD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4DRCY','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4DRHD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4DRHE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4EHPV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4EJD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4ELED','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4ESPD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4ETND','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4ETNW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4EVQ','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4UZWD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU4WGW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5BED','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5BOJO','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DEMD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DEMV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DEMW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DITD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DITV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DITW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DRVD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DRVV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DTD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DVD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5DWSD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5EAOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5EFXY','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5EJLD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5EWOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5FZD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5VATD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU5XCX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6DBLD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6DBLW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6DKTD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6DRDD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6DRDE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6DRND','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6DRRD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6ECW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6EJJD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6EPED','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6EPRD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6EPRE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6EUD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6EYKX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6JJD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6UALD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6UOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6UOP','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6UOQ','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6UOR','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6UOS','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6UOX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU6XAHX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7ACD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7BTOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DBLD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DIDV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DIDY','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DIRD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DJJW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DPD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DRD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DSYD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DSYV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DSYW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DWD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DZLD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7DZLE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7EGHV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7EGYD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7EHLD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7EOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7EPCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7EPCW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7HWD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7VCHD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7WFMW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU7WWW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8ADXD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DCHD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DCHQ','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DIPD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DRD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DRAW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DRHD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DSJD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DWRD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8DWRV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EBJD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EBJE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EBKD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EBKE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8ECFD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8ECFE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EEMD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EFFD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EGSD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EHQD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EHQE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EHQW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EKBW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EKCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EOTX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EOTY','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8ERHD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EXJD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8EXND','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8FOZV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8VCCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8WFTQ','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8XCX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8XWX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU8XWXD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9ARBD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9AUCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9DBKX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9DKXX','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9DPDXA','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9EIF','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9EJSE','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9ESDD','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9ESDF','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9ESDV','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9ESDW','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9ESDY','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9EVLH','LU','13','14');
INSERT INTO prefixlist VALUES('=LU9JMGJ','LU','13','14');
INSERT INTO prefixlist VALUES('=LW1DALD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW1EXUD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW1EXUY','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2DXE','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2DXP','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2DXQ','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2DXR','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2DXS','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2DXY','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2EFSD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW2ENBD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW3DKCD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW3DKCE','LU','13','14');
INSERT INTO prefixlist VALUES('=LW3DKOD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW3DKOE','LU','13','14');
INSERT INTO prefixlist VALUES('=LW3HAQD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW4DRHD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW4DRHE','LU','13','14');
INSERT INTO prefixlist VALUES('=LW4DRVD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW4ECVD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW4EME','LU','13','14');
INSERT INTO prefixlist VALUES('=LW4EMLH','LU','13','14');
INSERT INTO prefixlist VALUES('=LW5DRLH','LU','13','14');
INSERT INTO prefixlist VALUES('=LW5DWXD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW5EED','LU','13','14');
INSERT INTO prefixlist VALUES('=LW5EEV','LU','13','14');
INSERT INTO prefixlist VALUES('=LW5EOLD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW6DTMD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW7DAFD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW7DAFW','LU','13','14');
INSERT INTO prefixlist VALUES('=LW7DLYD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW7DNSE','LU','13','14');
INSERT INTO prefixlist VALUES('=LW7EJVD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW7WFMW','LU','13','14');
INSERT INTO prefixlist VALUES('=LW8DMKD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW8DMKW','LU','13','14');
INSERT INTO prefixlist VALUES('=LW8EAGD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW8ECQD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW8EUD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW8EXFD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW9DCFY','LU','13','14');
INSERT INTO prefixlist VALUES('=LW9DXD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW9EAGD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW9EAGV','LU','13','14');
INSERT INTO prefixlist VALUES('=LW9EAGW','LU','13','14');
INSERT INTO prefixlist VALUES('=LW9EVAD','LU','13','14');
INSERT INTO prefixlist VALUES('=LW9EVAE','LU','13','14');
INSERT INTO prefixlist VALUES('LX','LX','14','27');
INSERT INTO prefixlist VALUES('LY','LY','15','29');
INSERT INTO prefixlist VALUES('LZ','LZ','20','28');
INSERT INTO prefixlist VALUES('4T','OA','10','12');
INSERT INTO prefixlist VALUES('OA','OA','10','12');
INSERT INTO prefixlist VALUES('OB','OA','10','12');
INSERT INTO prefixlist VALUES('OC','OA','10','12');
INSERT INTO prefixlist VALUES('OD','OD','20','39');
INSERT INTO prefixlist VALUES('OE','OE','15','28');
INSERT INTO prefixlist VALUES('OF','OH','15','18');
INSERT INTO prefixlist VALUES('OG','OH','15','18');
INSERT INTO prefixlist VALUES('OH','OH','15','18');
INSERT INTO prefixlist VALUES('OI','OH','15','18');
INSERT INTO prefixlist VALUES('OJ','OH','15','18');
INSERT INTO prefixlist VALUES('OF0','OH0','15','18');
INSERT INTO prefixlist VALUES('OG0','OH0','15','18');
INSERT INTO prefixlist VALUES('OH0','OH0','15','18');
INSERT INTO prefixlist VALUES('OI0','OH0','15','18');
INSERT INTO prefixlist VALUES('OJ0','OJ0','15','18');
INSERT INTO prefixlist VALUES('OK','OK','15','28');
INSERT INTO prefixlist VALUES('OL','OK','15','28');
INSERT INTO prefixlist VALUES('OM','OM','15','28');
INSERT INTO prefixlist VALUES('ON','ON','14','27');
INSERT INTO prefixlist VALUES('OO','ON','14','27');
INSERT INTO prefixlist VALUES('OP','ON','14','27');
INSERT INTO prefixlist VALUES('OQ','ON','14','27');
INSERT INTO prefixlist VALUES('OR','ON','14','27');
INSERT INTO prefixlist VALUES('OS','ON','14','27');
INSERT INTO prefixlist VALUES('OT','ON','14','27');
INSERT INTO prefixlist VALUES('OX','OX','40','05');
INSERT INTO prefixlist VALUES('XP','OX','40','05');
INSERT INTO prefixlist VALUES('OW','OY','14','18');
INSERT INTO prefixlist VALUES('OY','OY','14','18');
INSERT INTO prefixlist VALUES('5P','OZ','14','18');
INSERT INTO prefixlist VALUES('5Q','OZ','14','18');
INSERT INTO prefixlist VALUES('OU','OZ','14','18');
INSERT INTO prefixlist VALUES('OV','OZ','14','18');
INSERT INTO prefixlist VALUES('OZ','OZ','14','18');
INSERT INTO prefixlist VALUES('P2','P2','28','51');
INSERT INTO prefixlist VALUES('P4','P4','09','11');
INSERT INTO prefixlist VALUES('PA','PA','14','27');
INSERT INTO prefixlist VALUES('PB','PA','14','27');
INSERT INTO prefixlist VALUES('PC','PA','14','27');
INSERT INTO prefixlist VALUES('PD','PA','14','27');
INSERT INTO prefixlist VALUES('PE','PA','14','27');
INSERT INTO prefixlist VALUES('PF','PA','14','27');
INSERT INTO prefixlist VALUES('PG','PA','14','27');
INSERT INTO prefixlist VALUES('PH','PA','14','27');
INSERT INTO prefixlist VALUES('PI','PA','14','27');
INSERT INTO prefixlist VALUES('PJ0','PJ2','09','11');
INSERT INTO prefixlist VALUES('PJ1','PJ2','09','11');
INSERT INTO prefixlist VALUES('PJ2','PJ2','09','11');
INSERT INTO prefixlist VALUES('PJ3','PJ2','09','11');
INSERT INTO prefixlist VALUES('PJ4','PJ2','09','11');
INSERT INTO prefixlist VALUES('PJ9','PJ2','09','11');
INSERT INTO prefixlist VALUES('PJ5','PJ7','08','11');
INSERT INTO prefixlist VALUES('PJ6','PJ7','08','11');
INSERT INTO prefixlist VALUES('PJ7','PJ7','08','11');
INSERT INTO prefixlist VALUES('PJ8','PJ7','08','11');
INSERT INTO prefixlist VALUES('PP','PY','11','15');
INSERT INTO prefixlist VALUES('PQ','PY','11','15');
INSERT INTO prefixlist VALUES('PR','PY','11','15');
INSERT INTO prefixlist VALUES('PS','PY','11','15');
INSERT INTO prefixlist VALUES('PT','PY','11','15');
INSERT INTO prefixlist VALUES('PU','PY','11','15');
INSERT INTO prefixlist VALUES('PV','PY','11','15');
INSERT INTO prefixlist VALUES('PW','PY','11','15');
INSERT INTO prefixlist VALUES('PX','PY','11','15');
INSERT INTO prefixlist VALUES('PY','PY','11','15');
INSERT INTO prefixlist VALUES('ZV','PY','11','15');
INSERT INTO prefixlist VALUES('ZW','PY','11','15');
INSERT INTO prefixlist VALUES('ZX','PY','11','15');
INSERT INTO prefixlist VALUES('ZY','PY','11','15');
INSERT INTO prefixlist VALUES('ZZ','PY','11','15');
INSERT INTO prefixlist VALUES('PP0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PP0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PP0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PP0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PQ0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PQ0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PQ0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PQ0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PR0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PR0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PR0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PR0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PS0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PS0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PS0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PS0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PT0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PT0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PT0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PT0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PU0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PU0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PU0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PU0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PV0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PV0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PV0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PV0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PW0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PW0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PW0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PW0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PX0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PX0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PX0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PX0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PY0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('PY0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('PY0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('PY0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZV0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZV0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZV0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZV0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZW0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZW0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZW0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZW0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZX0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZX0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZX0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZX0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZY0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZY0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZY0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZY0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZZ0F','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZZ0R','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZZ0ZF','PY0F','11','13');
INSERT INTO prefixlist VALUES('ZZ0ZR','PY0F','11','13');
INSERT INTO prefixlist VALUES('PP0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PP0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PQ0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PQ0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PR0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PR0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PS0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PS0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PT0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PT0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PU0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PU0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PV0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PV0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PW0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PW0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PX0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PX0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PY0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('PY0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZV0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZV0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZW0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZW0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZX0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZX0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZY0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZY0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZZ0S','PY0S','11','13');
INSERT INTO prefixlist VALUES('ZZ0ZS','PY0S','11','13');
INSERT INTO prefixlist VALUES('PP0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PP0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PQ0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PQ0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PR0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PR0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PS0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PS0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PT0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PT0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PU0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PU0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PV0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PV0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PW0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PW0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PX0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PX0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PY0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('PY0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZV0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZV0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZW0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZW0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZX0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZX0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZY0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZY0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZZ0T','PY0T','11','15');
INSERT INTO prefixlist VALUES('ZZ0ZT','PY0T','11','15');
INSERT INTO prefixlist VALUES('PZ','PZ','09','12');
INSERT INTO prefixlist VALUES('FJL','R1FJ','40','75');
INSERT INTO prefixlist VALUES('R1FJ','R1FJ','40','75');
INSERT INTO prefixlist VALUES('MVI','R1MV','16','29');
INSERT INTO prefixlist VALUES('R1MV','R1MV','16','29');
INSERT INTO prefixlist VALUES('S0','S0','33','46');
INSERT INTO prefixlist VALUES('S2','S2','22','41');
INSERT INTO prefixlist VALUES('S3','S2','22','41');
INSERT INTO prefixlist VALUES('S5','S5','15','28');
INSERT INTO prefixlist VALUES('S7','S7','39','53');
INSERT INTO prefixlist VALUES('S9','S9','36','47');
INSERT INTO prefixlist VALUES('7S','SM','14','18');
INSERT INTO prefixlist VALUES('8S','SM','14','18');
INSERT INTO prefixlist VALUES('SA','SM','14','18');
INSERT INTO prefixlist VALUES('SB','SM','14','18');
INSERT INTO prefixlist VALUES('SC','SM','14','18');
INSERT INTO prefixlist VALUES('SD','SM','14','18');
INSERT INTO prefixlist VALUES('SE','SM','14','18');
INSERT INTO prefixlist VALUES('SF','SM','14','18');
INSERT INTO prefixlist VALUES('SG','SM','14','18');
INSERT INTO prefixlist VALUES('SH','SM','14','18');
INSERT INTO prefixlist VALUES('SI','SM','14','18');
INSERT INTO prefixlist VALUES('SJ','SM','14','18');
INSERT INTO prefixlist VALUES('SK','SM','14','18');
INSERT INTO prefixlist VALUES('SL','SM','14','18');
INSERT INTO prefixlist VALUES('SM','SM','14','18');
INSERT INTO prefixlist VALUES('3Z','SP','15','28');
INSERT INTO prefixlist VALUES('HF','SP','15','28');
INSERT INTO prefixlist VALUES('SN','SP','15','28');
INSERT INTO prefixlist VALUES('SO','SP','15','28');
INSERT INTO prefixlist VALUES('SP','SP','15','28');
INSERT INTO prefixlist VALUES('SQ','SP','15','28');
INSERT INTO prefixlist VALUES('SR','SP','15','28');
INSERT INTO prefixlist VALUES('6T','ST','34','48');
INSERT INTO prefixlist VALUES('6U','ST','34','48');
INSERT INTO prefixlist VALUES('ST','ST','34','48');
INSERT INTO prefixlist VALUES('6A','SU','34','38');
INSERT INTO prefixlist VALUES('6B','SU','34','38');
INSERT INTO prefixlist VALUES('SS','SU','34','38');
INSERT INTO prefixlist VALUES('SU','SU','34','38');
INSERT INTO prefixlist VALUES('J4','SV','20','28');
INSERT INTO prefixlist VALUES('SV','SV','20','28');
INSERT INTO prefixlist VALUES('SW','SV','20','28');
INSERT INTO prefixlist VALUES('SX','SV','20','28');
INSERT INTO prefixlist VALUES('SY','SV','20','28');
INSERT INTO prefixlist VALUES('SZ','SV','20','28');
INSERT INTO prefixlist VALUES('=SV2ASPA','SV/a','20','28');
INSERT INTO prefixlist VALUES('J45','SV5','20','28');
INSERT INTO prefixlist VALUES('SV5','SV5','20','28');
INSERT INTO prefixlist VALUES('SW5','SV5','20','28');
INSERT INTO prefixlist VALUES('SX5','SV5','20','28');
INSERT INTO prefixlist VALUES('SY5','SV5','20','28');
INSERT INTO prefixlist VALUES('SZ5','SV5','20','28');
INSERT INTO prefixlist VALUES('J49','SV9','20','28');
INSERT INTO prefixlist VALUES('SV9','SV9','20','28');
INSERT INTO prefixlist VALUES('SW9','SV9','20','28');
INSERT INTO prefixlist VALUES('SX9','SV9','20','28');
INSERT INTO prefixlist VALUES('SY9','SV9','20','28');
INSERT INTO prefixlist VALUES('SZ9','SV9','20','28');
INSERT INTO prefixlist VALUES('=SV0LB','SV9','20','28');
INSERT INTO prefixlist VALUES('=SV0XAZ','SV9','20','28');
INSERT INTO prefixlist VALUES('T2','T2','31','65');
INSERT INTO prefixlist VALUES('T30','T30','31','65');
INSERT INTO prefixlist VALUES('T31','T31','31','62');
INSERT INTO prefixlist VALUES('T32','T32','31','61');
INSERT INTO prefixlist VALUES('T33','T33','31','65');
INSERT INTO prefixlist VALUES('6O','T5','37','48');
INSERT INTO prefixlist VALUES('T5','T5','37','48');
INSERT INTO prefixlist VALUES('T7','T7','15','28');
INSERT INTO prefixlist VALUES('T8','T8','27','64');
INSERT INTO prefixlist VALUES('TA','TA','20','39');
INSERT INTO prefixlist VALUES('TB','TA','20','39');
INSERT INTO prefixlist VALUES('TC','TA','20','39');
INSERT INTO prefixlist VALUES('YM','TA','20','39');
INSERT INTO prefixlist VALUES('TA1','*TA1','20','39');
INSERT INTO prefixlist VALUES('TB1','*TA1','20','39');
INSERT INTO prefixlist VALUES('TC1','*TA1','20','39');
INSERT INTO prefixlist VALUES('YM1','*TA1','20','39');
INSERT INTO prefixlist VALUES('TF','TF','40','17');
INSERT INTO prefixlist VALUES('TD','TG','07','11');
INSERT INTO prefixlist VALUES('TG','TG','07','11');
INSERT INTO prefixlist VALUES('TE','TI','07','11');
INSERT INTO prefixlist VALUES('TI','TI','07','11');
INSERT INTO prefixlist VALUES('TE9','TI9','07','11');
INSERT INTO prefixlist VALUES('TI9','TI9','07','11');
INSERT INTO prefixlist VALUES('TJ','TJ','36','47');
INSERT INTO prefixlist VALUES('TK','TK','15','28');
INSERT INTO prefixlist VALUES('TL','TL','36','47');
INSERT INTO prefixlist VALUES('TN','TN','36','52');
INSERT INTO prefixlist VALUES('TR','TR','36','52');
INSERT INTO prefixlist VALUES('TT','TT','36','47');
INSERT INTO prefixlist VALUES('TU','TU','35','46');
INSERT INTO prefixlist VALUES('TY','TY','35','46');
INSERT INTO prefixlist VALUES('TZ','TZ','35','46');
INSERT INTO prefixlist VALUES('R','UA','16','29');
INSERT INTO prefixlist VALUES('RD4W','UA','16','30');
INSERT INTO prefixlist VALUES('RK4W','UA','16','30');
INSERT INTO prefixlist VALUES('RM4W','UA','16','30');
INSERT INTO prefixlist VALUES('RN4W','UA','16','30');
INSERT INTO prefixlist VALUES('RU4W','UA','16','30');
INSERT INTO prefixlist VALUES('RV4W','UA','16','30');
INSERT INTO prefixlist VALUES('RW4W','UA','16','30');
INSERT INTO prefixlist VALUES('U','UA','16','29');
INSERT INTO prefixlist VALUES('UA4W','UA','16','30');
INSERT INTO prefixlist VALUES('=R7C','UA','16','29');
INSERT INTO prefixlist VALUES('=R7C1','UA','16','29');
INSERT INTO prefixlist VALUES('=R7C3','UA','16','29');
INSERT INTO prefixlist VALUES('=R7C4','UA','16','29');
INSERT INTO prefixlist VALUES('R2','UA2','15','29');
INSERT INTO prefixlist VALUES('RA2','UA2','15','29');
INSERT INTO prefixlist VALUES('RB2','UA2','15','29');
INSERT INTO prefixlist VALUES('RC2','UA2','15','29');
INSERT INTO prefixlist VALUES('RD2','UA2','15','29');
INSERT INTO prefixlist VALUES('RE2','UA2','15','29');
INSERT INTO prefixlist VALUES('RF2','UA2','15','29');
INSERT INTO prefixlist VALUES('RG2','UA2','15','29');
INSERT INTO prefixlist VALUES('RH2','UA2','15','29');
INSERT INTO prefixlist VALUES('RI2','UA2','15','29');
INSERT INTO prefixlist VALUES('RJ2','UA2','15','29');
INSERT INTO prefixlist VALUES('RK2','UA2','15','29');
INSERT INTO prefixlist VALUES('RL2','UA2','15','29');
INSERT INTO prefixlist VALUES('RM2','UA2','15','29');
INSERT INTO prefixlist VALUES('RN2','UA2','15','29');
INSERT INTO prefixlist VALUES('RO2','UA2','15','29');
INSERT INTO prefixlist VALUES('RP2','UA2','15','29');
INSERT INTO prefixlist VALUES('RQ2','UA2','15','29');
INSERT INTO prefixlist VALUES('RR2','UA2','15','29');
INSERT INTO prefixlist VALUES('RS2','UA2','15','29');
INSERT INTO prefixlist VALUES('RT2','UA2','15','29');
INSERT INTO prefixlist VALUES('RU2','UA2','15','29');
INSERT INTO prefixlist VALUES('RV2','UA2','15','29');
INSERT INTO prefixlist VALUES('RW2','UA2','15','29');
INSERT INTO prefixlist VALUES('RX2','UA2','15','29');
INSERT INTO prefixlist VALUES('RY2','UA2','15','29');
INSERT INTO prefixlist VALUES('RZ2','UA2','15','29');
INSERT INTO prefixlist VALUES('U2','UA2','15','29');
INSERT INTO prefixlist VALUES('UA2','UA2','15','29');
INSERT INTO prefixlist VALUES('UB2','UA2','15','29');
INSERT INTO prefixlist VALUES('UC2','UA2','15','29');
INSERT INTO prefixlist VALUES('UD2','UA2','15','29');
INSERT INTO prefixlist VALUES('UE2','UA2','15','29');
INSERT INTO prefixlist VALUES('UF2','UA2','15','29');
INSERT INTO prefixlist VALUES('UG2','UA2','15','29');
INSERT INTO prefixlist VALUES('UH2','UA2','15','29');
INSERT INTO prefixlist VALUES('UI2','UA2','15','29');
INSERT INTO prefixlist VALUES('R0','UA9','17','30');
INSERT INTO prefixlist VALUES('R7','UA9','17','30');
INSERT INTO prefixlist VALUES('R8','UA9','17','30');
INSERT INTO prefixlist VALUES('R8T','UA9','18','32');
INSERT INTO prefixlist VALUES('R8V','UA9','18','33');
INSERT INTO prefixlist VALUES('R9','UA9','17','30');
INSERT INTO prefixlist VALUES('R9I','UA9','18','31');
INSERT INTO prefixlist VALUES('R9M','UA9','17','30');
INSERT INTO prefixlist VALUES('R9S','UA9','16','30');
INSERT INTO prefixlist VALUES('R9T','UA9','16','30');
INSERT INTO prefixlist VALUES('R9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RA0','UA9','17','30');
INSERT INTO prefixlist VALUES('RA7','UA9','17','30');
INSERT INTO prefixlist VALUES('RA8','UA9','17','30');
INSERT INTO prefixlist VALUES('RA8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RA8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RA9','UA9','17','30');
INSERT INTO prefixlist VALUES('RA9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RA9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RA9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RA9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RA9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RA9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RB0','UA9','17','30');
INSERT INTO prefixlist VALUES('RB7','UA9','17','30');
INSERT INTO prefixlist VALUES('RB8','UA9','17','30');
INSERT INTO prefixlist VALUES('RB8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RB8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RB9','UA9','17','30');
INSERT INTO prefixlist VALUES('RB9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RB9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RB9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RB9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RB9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RB9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RC0','UA9','17','30');
INSERT INTO prefixlist VALUES('RC7','UA9','17','30');
INSERT INTO prefixlist VALUES('RC8','UA9','17','30');
INSERT INTO prefixlist VALUES('RC8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RC8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RC9','UA9','17','30');
INSERT INTO prefixlist VALUES('RC9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RC9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RC9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RC9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RC9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RC9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RD0','UA9','17','30');
INSERT INTO prefixlist VALUES('RD7','UA9','17','30');
INSERT INTO prefixlist VALUES('RD8','UA9','17','30');
INSERT INTO prefixlist VALUES('RD8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RD8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RD9','UA9','17','30');
INSERT INTO prefixlist VALUES('RD9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RD9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RD9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RD9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RD9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RD9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RE0','UA9','17','30');
INSERT INTO prefixlist VALUES('RE7','UA9','17','30');
INSERT INTO prefixlist VALUES('RE8','UA9','17','30');
INSERT INTO prefixlist VALUES('RE8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RE8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RE9','UA9','17','30');
INSERT INTO prefixlist VALUES('RE9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RE9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RE9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RE9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RE9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RE9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RF0','UA9','17','30');
INSERT INTO prefixlist VALUES('RF7','UA9','17','30');
INSERT INTO prefixlist VALUES('RF8','UA9','17','30');
INSERT INTO prefixlist VALUES('RF8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RF8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RF9','UA9','17','30');
INSERT INTO prefixlist VALUES('RF9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RF9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RF9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RF9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RF9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RF9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RG0','UA9','17','30');
INSERT INTO prefixlist VALUES('RG7','UA9','17','30');
INSERT INTO prefixlist VALUES('RG8','UA9','17','30');
INSERT INTO prefixlist VALUES('RG8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RG8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RG9','UA9','17','30');
INSERT INTO prefixlist VALUES('RG9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RG9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RG9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RG9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RG9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RG9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RH0','UA9','17','30');
INSERT INTO prefixlist VALUES('RH7','UA9','17','30');
INSERT INTO prefixlist VALUES('RH8','UA9','17','30');
INSERT INTO prefixlist VALUES('RH8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RH8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RH9','UA9','17','30');
INSERT INTO prefixlist VALUES('RH9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RH9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RH9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RH9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RH9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RH9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RI0','UA9','17','30');
INSERT INTO prefixlist VALUES('RI7','UA9','17','30');
INSERT INTO prefixlist VALUES('RI8','UA9','17','30');
INSERT INTO prefixlist VALUES('RI8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RI8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RI9','UA9','17','30');
INSERT INTO prefixlist VALUES('RI9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RI9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RI9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RI9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RI9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RI9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RJ0','UA9','17','30');
INSERT INTO prefixlist VALUES('RJ7','UA9','17','30');
INSERT INTO prefixlist VALUES('RJ8','UA9','17','30');
INSERT INTO prefixlist VALUES('RJ8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RJ8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RJ9','UA9','17','30');
INSERT INTO prefixlist VALUES('RJ9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RJ9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RJ9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RJ9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RJ9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RJ9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RK0','UA9','17','30');
INSERT INTO prefixlist VALUES('RK7','UA9','17','30');
INSERT INTO prefixlist VALUES('RK8','UA9','17','30');
INSERT INTO prefixlist VALUES('RK8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RK8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RK9','UA9','17','30');
INSERT INTO prefixlist VALUES('RK9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RK9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RK9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RK9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RK9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RK9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RL0','UA9','17','30');
INSERT INTO prefixlist VALUES('RL7','UA9','17','30');
INSERT INTO prefixlist VALUES('RL8','UA9','17','30');
INSERT INTO prefixlist VALUES('RL8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RL8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RL9','UA9','17','30');
INSERT INTO prefixlist VALUES('RL9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RL9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RL9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RL9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RL9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RL9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RM0','UA9','17','30');
INSERT INTO prefixlist VALUES('RM7','UA9','17','30');
INSERT INTO prefixlist VALUES('RM8','UA9','17','30');
INSERT INTO prefixlist VALUES('RM8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RM8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RM9','UA9','17','30');
INSERT INTO prefixlist VALUES('RM9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RM9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RM9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RM9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RM9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RM9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RN0','UA9','17','30');
INSERT INTO prefixlist VALUES('RN7','UA9','17','30');
INSERT INTO prefixlist VALUES('RN8','UA9','17','30');
INSERT INTO prefixlist VALUES('RN8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RN8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RN9','UA9','17','30');
INSERT INTO prefixlist VALUES('RN9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RN9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RN9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RN9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RN9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RN9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RO0','UA9','17','30');
INSERT INTO prefixlist VALUES('RO7','UA9','17','30');
INSERT INTO prefixlist VALUES('RO8','UA9','17','30');
INSERT INTO prefixlist VALUES('RO8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RO8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RO9','UA9','17','30');
INSERT INTO prefixlist VALUES('RO9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RO9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RO9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RO9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RO9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RO9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RP0','UA9','17','30');
INSERT INTO prefixlist VALUES('RP7','UA9','17','30');
INSERT INTO prefixlist VALUES('RP8','UA9','17','30');
INSERT INTO prefixlist VALUES('RP8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RP8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RP9','UA9','17','30');
INSERT INTO prefixlist VALUES('RP9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RP9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RP9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RP9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RP9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RP9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RQ0','UA9','17','30');
INSERT INTO prefixlist VALUES('RQ7','UA9','17','30');
INSERT INTO prefixlist VALUES('RQ8','UA9','17','30');
INSERT INTO prefixlist VALUES('RQ8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RQ8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RQ9','UA9','17','30');
INSERT INTO prefixlist VALUES('RQ9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RQ9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RQ9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RQ9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RQ9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RQ9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RR0','UA9','17','30');
INSERT INTO prefixlist VALUES('RR7','UA9','17','30');
INSERT INTO prefixlist VALUES('RR8','UA9','17','30');
INSERT INTO prefixlist VALUES('RR8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RR8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RR9','UA9','17','30');
INSERT INTO prefixlist VALUES('RR9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RR9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RR9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RR9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RR9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RR9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RS0','UA9','17','30');
INSERT INTO prefixlist VALUES('RS7','UA9','17','30');
INSERT INTO prefixlist VALUES('RS8','UA9','17','30');
INSERT INTO prefixlist VALUES('RS8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RS8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RS9','UA9','17','30');
INSERT INTO prefixlist VALUES('RS9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RS9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RS9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RS9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RS9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RS9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RT0','UA9','17','30');
INSERT INTO prefixlist VALUES('RT7','UA9','17','30');
INSERT INTO prefixlist VALUES('RT8','UA9','17','30');
INSERT INTO prefixlist VALUES('RT8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RT8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RT9','UA9','17','30');
INSERT INTO prefixlist VALUES('RT9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RT9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RT9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RT9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RT9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RT9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RU0','UA9','17','30');
INSERT INTO prefixlist VALUES('RU7','UA9','17','30');
INSERT INTO prefixlist VALUES('RU8','UA9','17','30');
INSERT INTO prefixlist VALUES('RU8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RU8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RU9','UA9','17','30');
INSERT INTO prefixlist VALUES('RU9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RU9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RU9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RU9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RU9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RU9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RV0','UA9','17','30');
INSERT INTO prefixlist VALUES('RV7','UA9','17','30');
INSERT INTO prefixlist VALUES('RV8','UA9','17','30');
INSERT INTO prefixlist VALUES('RV8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RV8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RV9','UA9','17','30');
INSERT INTO prefixlist VALUES('RV9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RV9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RV9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RV9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RV9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RV9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RW0','UA9','17','30');
INSERT INTO prefixlist VALUES('RW7','UA9','17','30');
INSERT INTO prefixlist VALUES('RW8','UA9','17','30');
INSERT INTO prefixlist VALUES('RW8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RW8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RW9','UA9','17','30');
INSERT INTO prefixlist VALUES('RW9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RW9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RW9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RW9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RW9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RW9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RX0','UA9','17','30');
INSERT INTO prefixlist VALUES('RX7','UA9','17','30');
INSERT INTO prefixlist VALUES('RX8','UA9','17','30');
INSERT INTO prefixlist VALUES('RX8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RX8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RX9','UA9','17','30');
INSERT INTO prefixlist VALUES('RX9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RX9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RX9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RX9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RX9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RX9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RY0','UA9','17','30');
INSERT INTO prefixlist VALUES('RY7','UA9','17','30');
INSERT INTO prefixlist VALUES('RY8','UA9','17','30');
INSERT INTO prefixlist VALUES('RY8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RY8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RY9','UA9','17','30');
INSERT INTO prefixlist VALUES('RY9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RY9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RY9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RY9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RY9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RY9W','UA9','16','30');
INSERT INTO prefixlist VALUES('RZ0','UA9','17','30');
INSERT INTO prefixlist VALUES('RZ7','UA9','17','30');
INSERT INTO prefixlist VALUES('RZ8','UA9','17','30');
INSERT INTO prefixlist VALUES('RZ8T','UA9','18','32');
INSERT INTO prefixlist VALUES('RZ8V','UA9','18','33');
INSERT INTO prefixlist VALUES('RZ9','UA9','17','30');
INSERT INTO prefixlist VALUES('RZ9I','UA9','18','31');
INSERT INTO prefixlist VALUES('RZ9M','UA9','17','30');
INSERT INTO prefixlist VALUES('RZ9P','UA9','18','31');
INSERT INTO prefixlist VALUES('RZ9S','UA9','16','30');
INSERT INTO prefixlist VALUES('RZ9T','UA9','16','30');
INSERT INTO prefixlist VALUES('RZ9W','UA9','16','30');
INSERT INTO prefixlist VALUES('U0','UA9','17','30');
INSERT INTO prefixlist VALUES('U7','UA9','17','30');
INSERT INTO prefixlist VALUES('U8','UA9','17','30');
INSERT INTO prefixlist VALUES('U8T','UA9','18','32');
INSERT INTO prefixlist VALUES('U8V','UA9','18','33');
INSERT INTO prefixlist VALUES('U9','UA9','17','30');
INSERT INTO prefixlist VALUES('U9I','UA9','18','31');
INSERT INTO prefixlist VALUES('U9M','UA9','17','30');
INSERT INTO prefixlist VALUES('U9P','UA9','18','31');
INSERT INTO prefixlist VALUES('U9S','UA9','16','30');
INSERT INTO prefixlist VALUES('U9T','UA9','16','30');
INSERT INTO prefixlist VALUES('U9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UA0','UA9','17','30');
INSERT INTO prefixlist VALUES('UA7','UA9','17','30');
INSERT INTO prefixlist VALUES('UA8','UA9','17','30');
INSERT INTO prefixlist VALUES('UA8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UA8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UA9','UA9','17','30');
INSERT INTO prefixlist VALUES('UA9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UA9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UA9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UA9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UA9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UA9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UB0','UA9','17','30');
INSERT INTO prefixlist VALUES('UB7','UA9','17','30');
INSERT INTO prefixlist VALUES('UB8','UA9','17','30');
INSERT INTO prefixlist VALUES('UB8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UB8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UB9','UA9','17','30');
INSERT INTO prefixlist VALUES('UB9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UB9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UB9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UB9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UB9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UB9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UC0','UA9','17','30');
INSERT INTO prefixlist VALUES('UC7','UA9','17','30');
INSERT INTO prefixlist VALUES('UC8','UA9','17','30');
INSERT INTO prefixlist VALUES('UC8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UC8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UC9','UA9','17','30');
INSERT INTO prefixlist VALUES('UC9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UC9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UC9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UC9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UC9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UC9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UD0','UA9','17','30');
INSERT INTO prefixlist VALUES('UD7','UA9','17','30');
INSERT INTO prefixlist VALUES('UD8','UA9','17','30');
INSERT INTO prefixlist VALUES('UD8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UD8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UD9','UA9','17','30');
INSERT INTO prefixlist VALUES('UD9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UD9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UD9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UD9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UD9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UD9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UE0','UA9','17','30');
INSERT INTO prefixlist VALUES('UE7','UA9','17','30');
INSERT INTO prefixlist VALUES('UE8','UA9','17','30');
INSERT INTO prefixlist VALUES('UE8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UE8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UE9','UA9','17','30');
INSERT INTO prefixlist VALUES('UE9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UE9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UE9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UE9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UE9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UE9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UF0','UA9','17','30');
INSERT INTO prefixlist VALUES('UF7','UA9','17','30');
INSERT INTO prefixlist VALUES('UF8','UA9','17','30');
INSERT INTO prefixlist VALUES('UF8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UF8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UF9','UA9','17','30');
INSERT INTO prefixlist VALUES('UF9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UF9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UF9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UF9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UF9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UF9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UG0','UA9','17','30');
INSERT INTO prefixlist VALUES('UG7','UA9','17','30');
INSERT INTO prefixlist VALUES('UG8','UA9','17','30');
INSERT INTO prefixlist VALUES('UG8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UG8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UG9','UA9','17','30');
INSERT INTO prefixlist VALUES('UG9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UG9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UG9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UG9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UG9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UG9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UH0','UA9','17','30');
INSERT INTO prefixlist VALUES('UH7','UA9','17','30');
INSERT INTO prefixlist VALUES('UH8','UA9','17','30');
INSERT INTO prefixlist VALUES('UH8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UH8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UH9','UA9','17','30');
INSERT INTO prefixlist VALUES('UH9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UH9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UH9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UH9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UH9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UH9W','UA9','16','30');
INSERT INTO prefixlist VALUES('UI0','UA9','17','30');
INSERT INTO prefixlist VALUES('UI7','UA9','17','30');
INSERT INTO prefixlist VALUES('UI8','UA9','17','30');
INSERT INTO prefixlist VALUES('UI8T','UA9','18','32');
INSERT INTO prefixlist VALUES('UI8V','UA9','18','33');
INSERT INTO prefixlist VALUES('UI9','UA9','17','30');
INSERT INTO prefixlist VALUES('UI9I','UA9','18','31');
INSERT INTO prefixlist VALUES('UI9M','UA9','17','30');
INSERT INTO prefixlist VALUES('UI9P','UA9','18','31');
INSERT INTO prefixlist VALUES('UI9S','UA9','16','30');
INSERT INTO prefixlist VALUES('UI9T','UA9','16','30');
INSERT INTO prefixlist VALUES('UI9W','UA9','16','30');
INSERT INTO prefixlist VALUES('=R150C','UA9','19','33');
INSERT INTO prefixlist VALUES('=R35NP','UA9','17','30');
INSERT INTO prefixlist VALUES('=R3F9','UA9','17','30');
INSERT INTO prefixlist VALUES('=R9HQ','UA9','17','30');
INSERT INTO prefixlist VALUES('UJ','UK','17','30');
INSERT INTO prefixlist VALUES('UK','UK','17','30');
INSERT INTO prefixlist VALUES('UL','UK','17','30');
INSERT INTO prefixlist VALUES('UM','UK','17','30');
INSERT INTO prefixlist VALUES('UN','UN','17','30');
INSERT INTO prefixlist VALUES('UO','UN','17','30');
INSERT INTO prefixlist VALUES('UP','UN','17','30');
INSERT INTO prefixlist VALUES('UQ','UN','17','30');
INSERT INTO prefixlist VALUES('EM','UR','16','29');
INSERT INTO prefixlist VALUES('EN','UR','16','29');
INSERT INTO prefixlist VALUES('EO','UR','16','29');
INSERT INTO prefixlist VALUES('U5','UR','16','29');
INSERT INTO prefixlist VALUES('UR','UR','16','29');
INSERT INTO prefixlist VALUES('US','UR','16','29');
INSERT INTO prefixlist VALUES('UT','UR','16','29');
INSERT INTO prefixlist VALUES('UU','UR','16','29');
INSERT INTO prefixlist VALUES('UV','UR','16','29');
INSERT INTO prefixlist VALUES('UW','UR','16','29');
INSERT INTO prefixlist VALUES('UX','UR','16','29');
INSERT INTO prefixlist VALUES('UY','UR','16','29');
INSERT INTO prefixlist VALUES('UZ','UR','16','29');
INSERT INTO prefixlist VALUES('V2','V2','08','11');
INSERT INTO prefixlist VALUES('V3','V3','07','11');
INSERT INTO prefixlist VALUES('V4','V4','08','11');
INSERT INTO prefixlist VALUES('V5','V5','38','57');
INSERT INTO prefixlist VALUES('V6','V6','27','65');
INSERT INTO prefixlist VALUES('V7','V7','31','65');
INSERT INTO prefixlist VALUES('V8','V8','28','54');
INSERT INTO prefixlist VALUES('CF','VE','05','09');
INSERT INTO prefixlist VALUES('CG','VE','05','09');
INSERT INTO prefixlist VALUES('CH1','VE','5','9');
INSERT INTO prefixlist VALUES('CH2','VE','2','9');
INSERT INTO prefixlist VALUES('CI0','VE','2','4');
INSERT INTO prefixlist VALUES('CI1','VE','1','2');
INSERT INTO prefixlist VALUES('CI2','VE','5','9');
INSERT INTO prefixlist VALUES('CJ','VE','05','09');
INSERT INTO prefixlist VALUES('CK','VE','05','09');
INSERT INTO prefixlist VALUES('CY1','VE','5','9');
INSERT INTO prefixlist VALUES('CY2','VE','2','9');
INSERT INTO prefixlist VALUES('CZ0','VE','2','4');
INSERT INTO prefixlist VALUES('CZ1','VE','1','2');
INSERT INTO prefixlist VALUES('CZ2','VE','5','9');
INSERT INTO prefixlist VALUES('VA','VE','05','09');
INSERT INTO prefixlist VALUES('VB','VE','05','09');
INSERT INTO prefixlist VALUES('VC','VE','05','09');
INSERT INTO prefixlist VALUES('VD1','VE','5','9');
INSERT INTO prefixlist VALUES('VD2','VE','2','9');
INSERT INTO prefixlist VALUES('VE','VE','05','09');
INSERT INTO prefixlist VALUES('VF0','VE','2','4');
INSERT INTO prefixlist VALUES('VF1','VE','1','2');
INSERT INTO prefixlist VALUES('VF2','VE','5','9');
INSERT INTO prefixlist VALUES('VG','VE','05','09');
INSERT INTO prefixlist VALUES('VO1','VE','5','9');
INSERT INTO prefixlist VALUES('VO2','VE','2','9');
INSERT INTO prefixlist VALUES('VX','VE','05','09');
INSERT INTO prefixlist VALUES('VY0','VE','2','4');
INSERT INTO prefixlist VALUES('VY1','VE','1','2');
INSERT INTO prefixlist VALUES('VY2','VE','5','9');
INSERT INTO prefixlist VALUES('XJ1','VE','5','9');
INSERT INTO prefixlist VALUES('XJ2','VE','2','9');
INSERT INTO prefixlist VALUES('XK0','VE','2','4');
INSERT INTO prefixlist VALUES('XK1','VE','1','2');
INSERT INTO prefixlist VALUES('XK2','VE','5','9');
INSERT INTO prefixlist VALUES('XL','VE','05','09');
INSERT INTO prefixlist VALUES('XM','VE','05','09');
INSERT INTO prefixlist VALUES('XN1','VE','5','9');
INSERT INTO prefixlist VALUES('XN2','VE','2','9');
INSERT INTO prefixlist VALUES('XO0','VE','2','4');
INSERT INTO prefixlist VALUES('XO1','VE','1','2');
INSERT INTO prefixlist VALUES('XO2','VE','5','9');
INSERT INTO prefixlist VALUES('=K3FMQVE2','VE','2','09');
INSERT INTO prefixlist VALUES('=KD3RFVE2','VE','2','09');
INSERT INTO prefixlist VALUES('=KD3TBVE2','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2BY','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2CT','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2DO','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2DXE','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2KCE','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2RHJ','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2UA','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2VFT','VE','2','09');
INSERT INTO prefixlist VALUES('=VA2ZM','VE','2','09');
INSERT INTO prefixlist VALUES('=VA3NA2','VE','2','09');
INSERT INTO prefixlist VALUES('=VB2C','VE','2','09');
INSERT INTO prefixlist VALUES('=VB2R','VE','2','09');
INSERT INTO prefixlist VALUES('=VB2V','VE','2','09');
INSERT INTO prefixlist VALUES('=VC2C','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2K3FMQ','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2ACP','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2AE','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2AG','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2AOF','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2AQS','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2AS','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2BQB','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2CSI','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2CVI','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2DMG','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2DS','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2DWU','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2DXY','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2DYW','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2DYX','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2EAK','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2EDL','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2EDX','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2ELL','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2ENB','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2END','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2ENR','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2ERU','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2FCV','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2GSA','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2GSO','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2III','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2IM','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2KK','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2MTA','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2MTB','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2NN','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2NRK','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2PR','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2QRZ','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2RB','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2TVU','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2UA','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2VH','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2WDX','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2WT','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2XAA2','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2XY','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2YM','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2Z','VE','2','09');
INSERT INTO prefixlist VALUES('=VE2ZC','VE','5','09');
INSERT INTO prefixlist VALUES('=VE2ZM','VE','5','09');
INSERT INTO prefixlist VALUES('=VE2ZV','VE','5','09');
INSERT INTO prefixlist VALUES('=VE3EY2','VE','2','09');
INSERT INTO prefixlist VALUES('=VE3NE2','VE','2','09');
INSERT INTO prefixlist VALUES('=VE3RHJ2','VE','2','09');
INSERT INTO prefixlist VALUES('=VE8AJ','VE','2','09');
INSERT INTO prefixlist VALUES('=VE8PW','VE','2','09');
INSERT INTO prefixlist VALUES('=VE8RCS','VE','2','09');
INSERT INTO prefixlist VALUES('=VER20081001','VE','05','09');
INSERT INTO prefixlist VALUES('=VY0AA','VE','4','3');
INSERT INTO prefixlist VALUES('=VY0PW','VE','4','3');
INSERT INTO prefixlist VALUES('=VY2MGY3','VE','4','4');
INSERT INTO prefixlist VALUES('AX','VK','30','59');
INSERT INTO prefixlist VALUES('VH','VK','30','59');
INSERT INTO prefixlist VALUES('VI','VK','30','59');
INSERT INTO prefixlist VALUES('VJ','VK','30','59');
INSERT INTO prefixlist VALUES('VK','VK','30','59');
INSERT INTO prefixlist VALUES('VL','VK','30','59');
INSERT INTO prefixlist VALUES('VM','VK','30','59');
INSERT INTO prefixlist VALUES('VN','VK','30','59');
INSERT INTO prefixlist VALUES('VZ','VK','30','59');
INSERT INTO prefixlist VALUES('=VK0HI','VK0H','39','68');
INSERT INTO prefixlist VALUES('=VK0IR','VK0H','39','68');
INSERT INTO prefixlist VALUES('AX0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VH0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VI0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VJ0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VK0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VL0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VM0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VN0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('VZ0M','VK0M','30','60');
INSERT INTO prefixlist VALUES('AX9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('AX9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VH9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VH9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VI9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VI9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VJ9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VJ9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VK9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VK9FC','VK9C','29','54');
INSERT INTO prefixlist VALUES('VK9KC','VK9C','29','54');
INSERT INTO prefixlist VALUES('VK9KY','VK9C','29','54');
INSERT INTO prefixlist VALUES('VK9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VL9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VL9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VM9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VM9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VN9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VN9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('VZ9C','VK9C','29','54');
INSERT INTO prefixlist VALUES('VZ9Y','VK9C','29','54');
INSERT INTO prefixlist VALUES('=VK9AA','VK9C','29','54');
INSERT INTO prefixlist VALUES('AX9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VH9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VI9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VJ9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VK9AL','VK9L','30','60');
INSERT INTO prefixlist VALUES('VK9CL','VK9L','30','60');
INSERT INTO prefixlist VALUES('VK9FL','VK9L','30','60');
INSERT INTO prefixlist VALUES('VK9GL','VK9L','30','60');
INSERT INTO prefixlist VALUES('VK9KL','VK9L','30','60');
INSERT INTO prefixlist VALUES('VK9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VL9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VM9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VN9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('VZ9L','VK9L','30','60');
INSERT INTO prefixlist VALUES('AX9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VH9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VI9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VJ9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VK9FM','VK9M','30','56');
INSERT INTO prefixlist VALUES('VK9KM','VK9M','30','56');
INSERT INTO prefixlist VALUES('VK9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VL9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VM9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VN9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('VZ9M','VK9M','30','56');
INSERT INTO prefixlist VALUES('AX9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VH9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VI9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VJ9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VK9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VK9CN','VK9N','32','60');
INSERT INTO prefixlist VALUES('VL9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VM9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VN9','VK9N','32','60');
INSERT INTO prefixlist VALUES('VZ9','VK9N','32','60');
INSERT INTO prefixlist VALUES('AX9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VH9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VI9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VJ9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VK9FW','VK9W','30','55');
INSERT INTO prefixlist VALUES('VK9KW','VK9W','30','55');
INSERT INTO prefixlist VALUES('VK9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VL9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VM9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VN9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('VZ9W','VK9W','30','55');
INSERT INTO prefixlist VALUES('=VK9DWX','VK9W','30','55');
INSERT INTO prefixlist VALUES('AX9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VH9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VI9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VJ9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VK9FX','VK9X','29','54');
INSERT INTO prefixlist VALUES('VK9KX','VK9X','29','54');
INSERT INTO prefixlist VALUES('VK9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VL9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VM9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VN9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VZ9X','VK9X','29','54');
INSERT INTO prefixlist VALUES('VP2E','VP2E','08','11');
INSERT INTO prefixlist VALUES('VP2M','VP2M','08','11');
INSERT INTO prefixlist VALUES('VP2V','VP2V','08','11');
INSERT INTO prefixlist VALUES('VP5','VP5','08','11');
INSERT INTO prefixlist VALUES('VQ5','VP5','08','11');
INSERT INTO prefixlist VALUES('VP6','VP6','32','63');
INSERT INTO prefixlist VALUES('=VP6DX','VP6/d','32','63');
INSERT INTO prefixlist VALUES('VP8','VP8','13','16');
INSERT INTO prefixlist VALUES('=VP8DIF','VP8/g','13','73');
INSERT INTO prefixlist VALUES('=VP8SGK','VP8/g','13','73');
INSERT INTO prefixlist VALUES('=DT8A','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=ED3RKL','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=HF0POL','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=HL8KSJ','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=LU1ZC','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=LZ0A','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=R1ANF','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=VP8LZ1UQ','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=VP8DJK','VP8/h','13','73');
INSERT INTO prefixlist VALUES('=AY1ZA','VP8/o','13','73');
INSERT INTO prefixlist VALUES('=LU1ZA','VP8/o','13','73');
INSERT INTO prefixlist VALUES('=VP8SSI','VP8/s','13','73');
INSERT INTO prefixlist VALUES('=VP8THU','VP8/s','13','73');
INSERT INTO prefixlist VALUES('VP9','VP9','05','11');
INSERT INTO prefixlist VALUES('VQ9','VQ9','39','41');
INSERT INTO prefixlist VALUES('VR','VR','24','44');
INSERT INTO prefixlist VALUES('8T','VU','22','41');
INSERT INTO prefixlist VALUES('8U','VU','22','41');
INSERT INTO prefixlist VALUES('8V','VU','22','41');
INSERT INTO prefixlist VALUES('8W','VU','22','41');
INSERT INTO prefixlist VALUES('8X','VU','22','41');
INSERT INTO prefixlist VALUES('8Y','VU','22','41');
INSERT INTO prefixlist VALUES('AT','VU','22','41');
INSERT INTO prefixlist VALUES('AU','VU','22','41');
INSERT INTO prefixlist VALUES('AV','VU','22','41');
INSERT INTO prefixlist VALUES('AW','VU','22','41');
INSERT INTO prefixlist VALUES('VT','VU','22','41');
INSERT INTO prefixlist VALUES('VU','VU','22','41');
INSERT INTO prefixlist VALUES('VV','VU','22','41');
INSERT INTO prefixlist VALUES('VW','VU','22','41');
INSERT INTO prefixlist VALUES('VU4','VU4','26','49');
INSERT INTO prefixlist VALUES('=VU3VPX','VU4','26','49');
INSERT INTO prefixlist VALUES('=VU3VPY','VU4','26','49');
INSERT INTO prefixlist VALUES('VU7','VU7','22','41');
INSERT INTO prefixlist VALUES('4A','XE','06','10');
INSERT INTO prefixlist VALUES('4B','XE','06','10');
INSERT INTO prefixlist VALUES('4C','XE','06','10');
INSERT INTO prefixlist VALUES('6D','XE','06','10');
INSERT INTO prefixlist VALUES('6E','XE','06','10');
INSERT INTO prefixlist VALUES('6F','XE','06','10');
INSERT INTO prefixlist VALUES('6G','XE','06','10');
INSERT INTO prefixlist VALUES('6H','XE','06','10');
INSERT INTO prefixlist VALUES('6I','XE','06','10');
INSERT INTO prefixlist VALUES('6J','XE','06','10');
INSERT INTO prefixlist VALUES('XA','XE','06','10');
INSERT INTO prefixlist VALUES('XB','XE','06','10');
INSERT INTO prefixlist VALUES('XC','XE','06','10');
INSERT INTO prefixlist VALUES('XD','XE','06','10');
INSERT INTO prefixlist VALUES('XE','XE','06','10');
INSERT INTO prefixlist VALUES('XF','XE','06','10');
INSERT INTO prefixlist VALUES('XG','XE','06','10');
INSERT INTO prefixlist VALUES('XH','XE','06','10');
INSERT INTO prefixlist VALUES('XI','XE','06','10');
INSERT INTO prefixlist VALUES('4A4','XF4','06','10');
INSERT INTO prefixlist VALUES('4B4','XF4','06','10');
INSERT INTO prefixlist VALUES('4C4','XF4','06','10');
INSERT INTO prefixlist VALUES('6D4','XF4','06','10');
INSERT INTO prefixlist VALUES('6E4','XF4','06','10');
INSERT INTO prefixlist VALUES('6F4','XF4','06','10');
INSERT INTO prefixlist VALUES('6G4','XF4','06','10');
INSERT INTO prefixlist VALUES('6H4','XF4','06','10');
INSERT INTO prefixlist VALUES('6I4','XF4','06','10');
INSERT INTO prefixlist VALUES('6J4','XF4','06','10');
INSERT INTO prefixlist VALUES('XA4','XF4','06','10');
INSERT INTO prefixlist VALUES('XB4','XF4','06','10');
INSERT INTO prefixlist VALUES('XC4','XF4','06','10');
INSERT INTO prefixlist VALUES('XD4','XF4','06','10');
INSERT INTO prefixlist VALUES('XE4','XF4','06','10');
INSERT INTO prefixlist VALUES('XF4','XF4','06','10');
INSERT INTO prefixlist VALUES('XG4','XF4','06','10');
INSERT INTO prefixlist VALUES('XH4','XF4','06','10');
INSERT INTO prefixlist VALUES('XI4','XF4','06','10');
INSERT INTO prefixlist VALUES('XT','XT','35','46');
INSERT INTO prefixlist VALUES('XU','XU','26','49');
INSERT INTO prefixlist VALUES('XW','XW','26','49');
INSERT INTO prefixlist VALUES('XX9','XX9','24','44');
INSERT INTO prefixlist VALUES('1Z','XZ','26','49');
INSERT INTO prefixlist VALUES('XY','XZ','26','49');
INSERT INTO prefixlist VALUES('XZ','XZ','26','49');
INSERT INTO prefixlist VALUES('T6','YA','21','40');
INSERT INTO prefixlist VALUES('YA','YA','21','40');
INSERT INTO prefixlist VALUES('7A','YB','28','54');
INSERT INTO prefixlist VALUES('7B','YB','28','54');
INSERT INTO prefixlist VALUES('7C','YB','28','54');
INSERT INTO prefixlist VALUES('7D','YB','28','54');
INSERT INTO prefixlist VALUES('7E','YB','28','54');
INSERT INTO prefixlist VALUES('7F','YB','28','54');
INSERT INTO prefixlist VALUES('7G','YB','28','54');
INSERT INTO prefixlist VALUES('7H','YB','28','54');
INSERT INTO prefixlist VALUES('7I','YB','28','54');
INSERT INTO prefixlist VALUES('8A','YB','28','54');
INSERT INTO prefixlist VALUES('8B','YB','28','54');
INSERT INTO prefixlist VALUES('8C','YB','28','54');
INSERT INTO prefixlist VALUES('8D','YB','28','54');
INSERT INTO prefixlist VALUES('8E','YB','28','54');
INSERT INTO prefixlist VALUES('8F','YB','28','54');
INSERT INTO prefixlist VALUES('8G','YB','28','54');
INSERT INTO prefixlist VALUES('8H','YB','28','54');
INSERT INTO prefixlist VALUES('8I','YB','28','54');
INSERT INTO prefixlist VALUES('JZ','YB','28','54');
INSERT INTO prefixlist VALUES('PK','YB','28','54');
INSERT INTO prefixlist VALUES('PL','YB','28','54');
INSERT INTO prefixlist VALUES('PM','YB','28','54');
INSERT INTO prefixlist VALUES('PN','YB','28','54');
INSERT INTO prefixlist VALUES('PO','YB','28','54');
INSERT INTO prefixlist VALUES('YB','YB','28','54');
INSERT INTO prefixlist VALUES('YC','YB','28','54');
INSERT INTO prefixlist VALUES('YD','YB','28','54');
INSERT INTO prefixlist VALUES('YE','YB','28','54');
INSERT INTO prefixlist VALUES('YF','YB','28','54');
INSERT INTO prefixlist VALUES('YG','YB','28','54');
INSERT INTO prefixlist VALUES('YH','YB','28','54');
INSERT INTO prefixlist VALUES('HN','YI','21','39');
INSERT INTO prefixlist VALUES('YI','YI','21','39');
INSERT INTO prefixlist VALUES('YJ','YJ','32','56');
INSERT INTO prefixlist VALUES('6C','YK','20','39');
INSERT INTO prefixlist VALUES('YK','YK','20','39');
INSERT INTO prefixlist VALUES('YL','YL','15','29');
INSERT INTO prefixlist VALUES('H6','YN','07','11');
INSERT INTO prefixlist VALUES('H7','YN','07','11');
INSERT INTO prefixlist VALUES('HT','YN','07','11');
INSERT INTO prefixlist VALUES('YN','YN','07','11');
INSERT INTO prefixlist VALUES('YO','YO','20','28');
INSERT INTO prefixlist VALUES('YP','YO','20','28');
INSERT INTO prefixlist VALUES('YQ','YO','20','28');
INSERT INTO prefixlist VALUES('YR','YO','20','28');
INSERT INTO prefixlist VALUES('HU','YS','07','11');
INSERT INTO prefixlist VALUES('YS','YS','07','11');
INSERT INTO prefixlist VALUES('4N','YU','15','28');
INSERT INTO prefixlist VALUES('YT','YU','15','28');
INSERT INTO prefixlist VALUES('YU','YU','15','28');
INSERT INTO prefixlist VALUES('YZ','YU','15','28');
INSERT INTO prefixlist VALUES('=YU8CT1FKN','*YU8','15','28');
INSERT INTO prefixlist VALUES('=YU8HB4FG','*YU8','15','28');
INSERT INTO prefixlist VALUES('=YU8IW0HEU','*YU8','15','28');
INSERT INTO prefixlist VALUES('=YU8LZ1BJ','*YU8','15','28');
INSERT INTO prefixlist VALUES('=YU8OH2R','*YU8','15','28');
INSERT INTO prefixlist VALUES('=YU8S56M','*YU8','15','28');
INSERT INTO prefixlist VALUES('4M','YV','09','12');
INSERT INTO prefixlist VALUES('YV','YV','09','12');
INSERT INTO prefixlist VALUES('YW','YV','09','12');
INSERT INTO prefixlist VALUES('YX','YV','09','12');
INSERT INTO prefixlist VALUES('YY','YV','09','12');
INSERT INTO prefixlist VALUES('4M0','YV0','08','11');
INSERT INTO prefixlist VALUES('YV0','YV0','08','11');
INSERT INTO prefixlist VALUES('YW0','YV0','08','11');
INSERT INTO prefixlist VALUES('YX0','YV0','08','11');
INSERT INTO prefixlist VALUES('YY0','YV0','08','11');
INSERT INTO prefixlist VALUES('Z2','Z2','38','53');
INSERT INTO prefixlist VALUES('Z3','Z3','15','28');
INSERT INTO prefixlist VALUES('ZA','ZA','15','28');
INSERT INTO prefixlist VALUES('ZB','ZB','14','37');
INSERT INTO prefixlist VALUES('ZG','ZB','14','37');
INSERT INTO prefixlist VALUES('ZC4','ZC4','20','39');
INSERT INTO prefixlist VALUES('ZD7','ZD7','36','66');
INSERT INTO prefixlist VALUES('ZD8','ZD8','36','66');
INSERT INTO prefixlist VALUES('ZD9','ZD9','38','66');
INSERT INTO prefixlist VALUES('ZF','ZF','08','11');
INSERT INTO prefixlist VALUES('ZK2','ZK2','32','62');
INSERT INTO prefixlist VALUES('ZK3','ZK3','31','62');
INSERT INTO prefixlist VALUES('ZK','ZL','32','60');
INSERT INTO prefixlist VALUES('ZL','ZL','32','60');
INSERT INTO prefixlist VALUES('ZM','ZL','32','60');
INSERT INTO prefixlist VALUES('ZL7','ZL7','32','60');
INSERT INTO prefixlist VALUES('ZM7','ZL7','32','60');
INSERT INTO prefixlist VALUES('ZL8','ZL8','32','60');
INSERT INTO prefixlist VALUES('ZM8','ZL8','32','60');
INSERT INTO prefixlist VALUES('ZL9','ZL9','32','60');
INSERT INTO prefixlist VALUES('ZM9','ZL9','32','60');
INSERT INTO prefixlist VALUES('ZP','ZP','11','14');
INSERT INTO prefixlist VALUES('H5','ZS','38','57');
INSERT INTO prefixlist VALUES('S4','ZS','38','57');
INSERT INTO prefixlist VALUES('S8','ZS','38','57');
INSERT INTO prefixlist VALUES('V9','ZS','38','57');
INSERT INTO prefixlist VALUES('ZR','ZS','38','57');
INSERT INTO prefixlist VALUES('ZS','ZS','38','57');
INSERT INTO prefixlist VALUES('ZT','ZS','38','57');
INSERT INTO prefixlist VALUES('ZU','ZS','38','57');
INSERT INTO prefixlist VALUES('ZR8','ZS8','38','57');
INSERT INTO prefixlist VALUES('ZS8','ZS8','38','57');
INSERT INTO prefixlist VALUES('ZT8','ZS8','38','57');
INSERT INTO prefixlist VALUES('ZU8','ZS8','38','57');
CREATE TABLE statistics (MenuText UNIQUE NOT NULL,sql NOT NULL);
INSERT INTO statistics VALUES('Qso Statistic','select count(rcvdcount) as ''Qsos confirmed'',count(missingcount) as ''Qso unconfirmed'',bandvalue as Band ,modevalue as Mode from qsocount group by band,mode');
INSERT INTO statistics VALUES('Worked Countries','select countryname as Country ,count(countrystat.call) as Worked,count(countrystat.rcvd) as Confirmed from countrystat,countrylist where countrystat.mainprefix = countrylist.mainprefix group by countrystat.mainprefix order by countryname');
INSERT INTO statistics VALUES('LOtW Qso Statistic','select count(rcvdcount) as ''Qsos confirmed'',count(lotwcount) as ''LOtW confirmed'',count(missingcount) as ''Qso unconfirmed'',bandvalue as Band ,modevalue as Mode from myqsocount group by band,mode');
INSERT INTO statistics VALUES('WAS overall',' select count(rcvdcount)  as ''LOtW confirmed'',count(missingcount) as ''Qso unconfirmed'',statevalue from wasstat group by statevalue');
INSERT INTO statistics VALUES('WAS overall summary',' select worked, confirmed from wassum');
INSERT INTO statistics VALUES('WAS by band','select count(rcvdcount)  as ''LotW confirmed'',count(missingcount) as ''Qso unconfirmed'',bandvalue,statevalue from wasbandstat group by band,state');
INSERT INTO statistics VALUES('VUCC by band','select count(rcvdcount)  as ''confirmed'', count(lotwcount) as ''LotW confirmed'', count(grid) as ''worked'', bandvalue,grid from vuccstat group by band,grid');
INSERT INTO statistics VALUES('VUCC 2m grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''2m'' group by grid');
INSERT INTO statistics VALUES('VUCC 2m summary','select worked, confirmed, lotw from vuccstat2m');
INSERT INTO statistics VALUES('VUCC 6m grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''6m'' group by grid');
INSERT INTO statistics VALUES('VUCC 6m summary','select worked, confirmed, lotw from vuccstat6m');
INSERT INTO statistics VALUES('VUCC 70cm grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''70cm'' group by grid');
INSERT INTO statistics VALUES('VUCC 70cm summary','select worked, confirmed, lotw from vuccstat70cm');
INSERT INTO statistics VALUES('VUCC 1.25m grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''1.25m'' group by grid');
INSERT INTO statistics VALUES('VUCC 1.25m summary','select worked, confirmed, lotw from vuccstat1_25m');
INSERT INTO statistics VALUES('VUCC 33cm grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''33cm'' group by grid');
INSERT INTO statistics VALUES('VUCC 33cm summary','select worked, confirmed, lotw from vuccstat33cm');
INSERT INTO statistics VALUES('VUCC 23cm grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''23cm'' group by grid');
INSERT INTO statistics VALUES('VUCC 23cm summary','select worked, confirmed, lotw from vuccstat23cm');
INSERT INTO statistics VALUES('VUCC 13cm grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''13cm'' group by grid');
INSERT INTO statistics VALUES('VUCC 13cm summary','select worked, confirmed, lotw from vuccstat13cm');
INSERT INTO statistics VALUES('VUCC 9cm grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''9cm'' group by grid');
INSERT INTO statistics VALUES('VUCC 9cm summary','select worked, confirmed, lotw from vuccstat9cm');
INSERT INTO statistics VALUES('VUCC 6cm grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''6cm'' group by grid');
INSERT INTO statistics VALUES('VUCC 6cm summary','select worked, confirmed, lotw from vuccstat6cm');
INSERT INTO statistics VALUES('VUCC 3cm grids','select count(rcvdcount) as ''confirmed'',count(lotwcount) as ''LotW confirmed'',count(grid) as ''worked'',grid from vuccstat where bandvalue=''3cm'' group by grid');
INSERT INTO statistics VALUES('VUCC 3cm summary','select worked, confirmed, lotw from vuccstat3cm');
UPDATE dbStatus set status= 2;
