tech@linguistik-web:/var/www/cqpweb/bin$ php offline-freqlists.php SR201 /***********************/ This script runs all the setup for frequency lists for a corpus. Full debug messages are printed, unless the flag --quiet is provided. Note, if you run this script before setting up the text metdata table, things WILL go badly wrong. About to run the function populating corpus CQP positions... About to run the following MySQL query: select * from corpus_info where corpus = 'SR201' /* from User: setup | Function: get_corpus_info() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: drop table if exists `___temp_cqp_text_positions_for_SR201` /* from User: setup | Function: populate_corpus_cqp_positions() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: create table `___temp_cqp_text_positions_for_SR201` ( `text_id` varchar(255) NOT NULL, `cqp_begin` BIGINT UNSIGNED NOT NULL default '0', `cqp_end` BIGINT UNSIGNED NOT NULL default '0', primary key (text_id) ) CHARSET utf8 COLLATE utf8_bin /* from User: setup | Function: populate_corpus_cqp_positions() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: insert into `___temp_cqp_text_positions_for_SR201` (text_id, cqp_begin, cqp_end) VALUES ('101',0,16936),('111',16937,17023),('112_1',17024,17207),('112',17208,18178),('116',18179,18405),('120_253',18406,18635),('120_31',18636,18781),('120_421',18782,18971),('120_422',18972,19093),('120_423',19094,19377),('120_424',19378,19530),('120_4',19531,23431),('120_52',23432,26575),('120_6',26576,27359),('120_72',27360,29266),('120',29267,36720),('121_1',36721,41691),('121_22',41692,41894),('121_2',41895,45325),('121',45326,46090),('122',46091,46372),('124',46373,47750),('125',47751,48159),('131_211',48160,55550),('131_212',55551,64114),('131_213',64115,68317),('131_214',68318,74515),('131_215',74516,79217),('131_216_1',79218,86261),('131_216_2',86262,92569),('131_217',92570,102125),('131_218',102126,106270),('131_219',106271,113090),('131_221',113091,120685),('131_222_1',120686,128940),('131_222_2',128941,137958),('131_223',137959,144395),('131_224_1',144396,150403),('131_224_2',150404,154035),('131_225',154036,160612),('131_226',160613,166910),('131_227',166911,175367),('131_228',175368,179552),('131_229',179553,185366),('131_231',185367,195416),('131_232',195417,202190),('131_233',202191,208051),('131_234',208052,221079),('131_235',221080,228048),('138_1',228049,228551),('141_0',228552,232156),('141_21',232157,232508),('142_201',232509,244547),('142_203',244548,247722),('142_204',247723,254580),('142_205',254581,256928),('142_209',256929,258401),('142_20',258402,275910),('142_281',275911,278745),('142_311_23',278746,279896),('142_311',279897,284169),('142_312',284170,294566),('142_314',294567,296629),('142_31',296630,310814),('142_512',310815,314859),('142_513',314860,319564),('142_51',319565,322101),('143_111',322102,325138),('143_116',325139,327725),('143_11',327726,333446),('143_13',333447,333783),('143_1',333784,336037),('143_21',336038,336250),('143_5',336251,338891),('150_1',338892,339790),('151_15',339791,340332),('151_18',340333,340773),('151_1',340774,342228),('151_21',342229,343056),('151_31',343057,345545),('151_342',345546,348160),('151_34',348161,350220),('151_3',350221,352731),('152_11',352732,355481),('152_12',355482,356491),('152_13',356492,357506),('152_1',357507,359392),('152_21',359393,360576),('152_31',360577,362865),('152_3',362866,364814),('161_11',364815,369242),('161_12',369243,369348),('161_15',369349,369720),('161_1',369721,377194),('161_51',377195,378303),('161_5',378304,378934),('170_321',378935,379869),('170_32',379870,382606),('170_512_1',382607,386416),('170_512',386417,388040),('171_105',388041,388704),('171_10',388705,405420),('171_115',405421,408690),('171_117',408691,410181),('171_13',410182,416754),('171_14',416755,420508),('171_211',420509,422155),('171_21',422156,423316),('172_010_14',423317,424199),('172_010_1',424200,431538),('172_010_21',431539,436349),('172_010_311',436350,437122),('172_010_31',437123,438152),('172_010_321',438153,440666),('172_010_331',440667,441406),('172_010_58',441407,444131),('172_010',444132,450271),('172_018',450272,451040),('172_021_2',451041,452383),('172_021',452384,459415),('172_041_0',459416,460745),('172_041_11',460746,461322),('172_041_14',461323,461547),('172_041_15',461548,461916),('172_041_17',461917,462190),('172_041_18',462191,462441),('172_041_1',462442,463333),('172_042_110',463334,464498),('172_044_13',464499,465013),('172_045_103',465014,465605),('172_047_40',465606,466050),('172_056_111',466051,466449),('172_056_11',466450,473770),('172_056_15',473771,476184),('172_056_1',476185,478938),('172_058_41',478939,479462),('172_061_1',479463,480747),('172_061',480748,481528),('172_072',481529,482849),('172_081',482850,484230),('172_091',484231,485058),('172_121_1',485059,486076),('172_121_2',486077,486318),('172_121',486319,486703),('172_210_10',486704,488039),('172_211_1',488040,490369),('172_211_31',490370,491158),('172_212_1',491159,494371),('172_213_1',494372,498370),('172_213_80',498371,499485),('172_214_1',499486,502074),('172_215_1',502075,505783),('172_216_1',505784,508486),('172_217_1',508487,511075),('172_217_2',511076,511658),('172_217_3',511659,512336),('172_220_111_310_1',512337,513678),('172_220_111_310_2',513679,517792),('172_220_111_31',517793,524039),('172_220_111_341',524040,524413),('172_220_111_342_1',524414,525294),('172_220_111_342_3',525295,525673),('172_220_111_343_1',525674,526037),('172_220_111_343_2',526038,526357),('172_220_111_343_3',526358,539127),('172_220_111_3',539128,555361),('172_220_111_4',555362,557679),('172_220_111_5',557680,558622),('172_220_111_6',558623,558995),('172_220_111_71',558996,559287),('172_220_111_7',559288,559592),('172_220_111_91',559593,560581),('172_220_111_9',560582,564229),('172_220_113_11',564230,565661),('172_220_113_40',565662,569654),('172_220_113_41',569655,570188),('172_220_113_43',570189,570669),('172_220_113',570670,578218),('172_220_114',578219,586550),('172_220_115',586551,592577),('172_220_116',592578,592778),('172_220_117',592779,593616),('172_220_11',593617,595250),('172_220_12',595251,596554),('172_220_141_1',596555,611058),('172_220_141_2',611059,611091),('172_220_141',611092,611598),('172_220_142_1',611599,626013),('172_220_142_2',626014,640073),('172_220_142',640074,640511),('172_220_143_1',640512,640535),('172_220_143_2',640536,640567),('172_220_143_3',640568,640596),('172_220_143_4',640597,640627),('172_220_143_5',640628,640654),('172_220_143_6',640655,640683),('172_220_143_7',640684,640707),('172_220_143_8',640708,640736),('172_220_1',640737,648644),('172_222_023',648645,650027),('172_222_15',650028,650240),('172_222_1',650241,653219),('172_327_1',653220,654173),('172_327_7',654174,654456),('172_327_8',654457,655557),('172_327_9',655558,655983),('173_110_131',655984,661825),('173_110_132',661826,662506),('173_110_133',662507,663578),('173_110_1',663579,663732),('173_110_210_1',663733,663922),('173_110_210_2',663923,664457),('173_110_210_3',664458,665139),('173_110_29',665140,665589),('173_110_3',665590,665683),('173_110_47',665684,665867),('173_110',665868,677224),('173_320_11',677225,677832),('173_320_1',677833,682004),('173_320_2',682005,683524),('173_320_3',683525,684094),('173_320_4',684095,685612),('173_321',685613,685730),('173_32',685731,689413),('173_411',689414,689558),('173_413_1',689559,690819),('173_413_2',690820,691620),('173_413_3',691621,692136),('173_413_4',692137,692929),('173_41',692930,695734),('173_711_33',695735,697071),('173_712_22',697072,698635),('173_712_23',698636,699487),('173_712_243',699488,700112),('173_712_24',700113,701060),('173_713_151',701061,701827),('173_713_161',701828,703981),('173_713_162',703982,706174),('173_71',706175,711283),('191_11',711284,712383),('191_1',712384,714889),('192_121',714890,719927),('192_126',719928,729197),('192_12',729198,732349),('193_9',732350,732921),('194_11',732922,733421),('194_1',733422,733777),('194_2',733778,734249),('195_11',734250,734462),('196_1',734463,735592),('210',735593,811919),('211_111_1',811920,812699),('211_112_2',812700,826657),('211_121_3',826658,826853),('211_221_31',826854,829140),('211_221_36',829141,831558),('211_222_32',831559,832772),('211_222_338',832773,835496),('211_231',835497,837848),('211_412_110',837849,838704),('211_412_11',838705,848333),('211_412_411',848334,851648),('211_412_41',851649,856427),('211_413_11',856428,856914),('211_413_1',856915,858760),('211_423_1',858761,860801),('211_423_41',860802,862395),('211_423_4',862396,865104),('211_432_11',865105,866491),('211_432_1',866492,882416),('211_432_21',882417,887300),('211_432_261',887301,890101),('211_432_27',890102,890454),('211_432_2',890455,894436),('220',894437,1011361),('221_112_944',1011362,1012277),('221_211_22',1012278,1013261),('221_213_111',1013262,1013695),('221_213_11',1013696,1016373),('221_213_151',1016374,1017035),('221_213_15',1017036,1018468),('221_213_221',1018469,1019427),('221_213_2',1019428,1023912),('221_214_11',1023913,1024763),('221_214_1',1024764,1028767),('221_215_311',1028768,1030811),('221_215_324_1',1030812,1032030),('221_215_328_1',1032031,1032857),('221_215_328_4',1032858,1034504),('221_215_328_6',1034505,1034841),('221_215_329_2',1034842,1035850),('221_215_329_3',1035851,1037418),('221_215_329_4',1037419,1038183),('221_218_2',1038184,1039817),('221_229_11',1039818,1039950),('221_229_1',1039951,1050183),('221_301',1050184,1060815),('221_302_32',1060816,1061239),('221_302_33',1061240,1062318),('221_302_3',1062319,1066143),('221_302',1066144,1070223),('221_411_1',1070224,1072344),('221_411',1072345,1097767),('221_415',1097768,1098713),('221_431',1098714,1099598),('221_522_1',1099599,1100294),('231_11',1100295,1102748),('231_1',1102749,1111849),('231_21',1111850,1113491),('231_2',1113492,1114753),('231_5',1114754,1115150),('232_111',1115151,1119714),('232_119',1119715,1120665),('232_11',1120666,1126999),('232_121',1127000,1130298),('232_12',1130299,1134208),('232_141',1134209,1152845),('232_148',1152846,1153645),('232_149_336',1153646,1153785),('232_14',1153786,1166634),('232_161',1166635,1168025),('232_16',1168026,1171867),('232_21',1171868,1174054),('232_22',1174055,1175382),('232_23',1175383,1176328),('235_11',1176329,1180686),('235_13',1180687,1182109),('235_154',1182110,1183363),('235_1',1183364,1189006),('235_21',1189007,1190478),('235_22',1190479,1191870),('235_23',1191871,1193052),('235_24',1193053,1194187),('235_2',1194188,1195228),('241_3',1195229,1195416),('241',1195417,1198117),('251_1',1198118,1199812),('251_2',1199813,1200322),('251_4',1200323,1202943),('251_5',1202944,1204426),('251',1204427,1209490),('272_1',1209491,1210815),('272',1210816,1236584),('273',1236585,1242965),('281_112_1',1242966,1243707),('281_11',1243708,1244044),('281_1',1244045,1275249),('281_31',1275250,1276998),('281_32',1276999,1285291),('281_33',1285292,1285556),('281_35',1285557,1289355),('281_41',1289356,1291031),('281_42',1291032,1308030),('281_51',1308031,1310154),('281_52',1310155,1312474),('282_111',1312475,1312578),('282_11',1312579,1316506),('291',1316507,1332724),('292_741_1',1332725,1332965),('311_01',1332966,1335010),('311_039_1',1335011,1335966),('311_0',1335967,1378454),('311_1',1378455,1382996),('312_057',1382997,1383242),('312_0',1383243,1423952),('312_1',1423953,1428242),('312_3',1428243,1429420),('312_4',1429421,1431124),('312_51',1431125,1432045),('312_5',1432046,1434810),('312_81',1434811,1435737),('313_041',1435738,1437376),('313_0',1437377,1447650),('313_32',1447651,1449175),('321_0',1449176,1474602),('321_1',1474603,1474896),('322_1',1474897,1493752),('322_2',1493753,1499957),('331',1499958,1504285),('341_14',1504286,1506463),('341_1',1506464,1510183),('341',1510184,1512031),('351_11',1512032,1515225),('351_12',1515226,1517197),('351_1',1517198,1528941),('351_201_11',1528942,1529064),('351_201_12',1529065,1529186),('351_20',1529187,1531614),('351_21',1531615,1533627),('351_6',1533628,1539565),('351_93',1539566,1543943),('354_1',1543944,1545793),('360_1',1545794,1548101),('360_2',1548102,1553334),('360',1553335,1554409),('361_0',1554410,1557986),('361_2',1557987,1559838),('361_3',1559839,1561523),('361_4',1561524,1562797),('361',1562798,1567736),('362_0',1567737,1573773),('362_1',1573774,1574765),('362_2',1574766,1576372),('362',1576373,1576871),('363_11',1576872,1579047),('363_1',1579048,1581008),('363',1581009,1583512),('364_3',1583513,1586086),('364',1586087,1587880),('371',1587881,1588576),('410_1',1588577,1588807),('411_3',1588808,1588984),('412_101_220_01',1588985,1589012),('412_101_220_02',1589013,1589046),('412_101_220_03',1589047,1589080),('412_101_220_04',1589081,1589108),('412_101_220_05',1589109,1589136),('412_101_220_06',1589137,1589164),('412_101_220_07',1589165,1589192),('412_101_220_08',1589193,1589220),('412_101_220_09',1589221,1589249),('412_101_220_10',1589250,1589277),('412_101_220_12',1589278,1589438),('412_101_220_13',1589439,1589599),('412_101_220_14',1589600,1589629),('412_101_220_15',1589630,1589657),('412_101_220_16',1589658,1589685),('412_101_220_17',1589686,1589713),('412_101_220_18',1589714,1589741),('412_101_220_19',1589742,1589769),('412_101_220_20',1589770,1589799),('412_101_220_21',1589800,1589833),('412_101_220_22',1589834,1589863),('412_101_220_23',1589864,1589897),('412_101_220_25',1589898,1589925),('412_101_220_26',1589926,1589957),('412_101_220_27',1589958,1589988),('412_101_220_28',1589989,1590018),('412_101_220_29',1590019,1590050),('412_101_220_30',1590051,1590082),('412_101_220_31',1590083,1590114),('412_101_220_32',1590115,1590146),('412_101_220_33',1590147,1590178),('412_101_220_34',1590179,1590210),('412_101_220_35',1590211,1590242),('412_101_220_36',1590243,1590274),('412_101_220_37',1590275,1590310),('412_101_220_38',1590311,1590344),('412_101_220_39',1590345,1590374),('412_101_220_40',1590375,1590408),('412_101_220_41',1590409,1590442),('412_101_220_42',1590443,1590476),('412_101_220_43',1590477,1590510),('412_101_220_44',1590511,1590544),('412_101_220_45',1590545,1590578),('412_101_220_46',1590579,1590612),('412_101_220_47',1590613,1590646),('412_101_220_48',1590647,1590680),('412_101_220_49',1590681,1590714),('412_101_220_50',1590715,1590748),('412_101_220_51',1590749,1590782),('412_101_220_52',1590783,1590929),('412_101_220_53',1590930,1591076),('412_101_220_54',1591077,1591221),('412_101_220_55',1591222,1591368),('412_101_220_56',1591369,1591400),('412_101_220_57',1591401,1591430),('412_101_220_58',1591431,1591462),('412_101_220_59',1591463,1591494),('412_101_220_60',1591495,1591524),('412_101_220_61',1591525,1591554),('412_101_220_62',1591555,1591584),('412_101_220_63',1591585,1591614),('412_101_220_64',1591615,1591646),('412_101_220_65',1591647,1591676),('412_101_220_66',1591677,1591706),('412_101_220_67',1591707,1591736),('412_101_220_68',1591737,1591766),('412_101_220_69',1591767,1591798),('412_101_220_70',1591799,1591828),('412_101_220_71',1591829,1591858),('412_101_220_72',1591859,1591888),('412_101_220_73',1591889,1591918),('412_101_220_74',1591919,1591948),('412_101_220_75',1591949,1591978),('412_101_220_76',1591979,1592008),('412_101_220_77',1592009,1592038),('412_101_220_78',1592039,1592068),('412_101_220_79',1592069,1592214),('412_101_220_80',1592215,1592242),('412_101_220_81',1592243,1592268),('412_101_220_82',1592269,1592410),('412_101_220_83',1592411,1592523),('412_101_220_84',1592524,1592553),('412_101_220_85',1592554,1592589),('412_101_220_86',1592590,1592619),('412_101_220_87',1592620,1592649),('412_101_220_88',1592650,1592679),('412_101_220_89',1592680,1592711),('412_101_220_90',1592712,1592741),('412_101_220_91',1592742,1592771),('412_101_220_92',1592772,1592801),('412_101_220_93',1592802,1592831),('412_101_220_94',1592832,1592861),('412_101_220_95',1592862,1592891),('412_101_220_96',1592892,1592923),('412_101_220_97',1592924,1592953),('412_101_220_98',1592954,1592983),('412_101_220_99',1592984,1593013),('412_101_221_00',1593014,1593047),('412_101_221_01',1593048,1593077),('412_101_221_02',1593078,1593109),('412_101_221_03',1593110,1593139),('412_101_221_04',1593140,1593169),('412_101_221_05',1593170,1593199),('412_101_221_06',1593200,1593229),('412_101_221_07',1593230,1593263),('412_101_221_08',1593264,1593295),('412_101_221_09',1593296,1593325),('412_101_221_10',1593326,1593357),('412_101_221_11',1593358,1593389),('412_101_221_12',1593390,1593419),('412_101_221_13',1593420,1593449),('412_101_221_14',1593450,1593479),('412_101_221_15',1593480,1593514),('412_101_221_16',1593515,1593544),('412_101_221_17',1593545,1593574),('412_101_221_18',1593575,1593604),('412_101_221_19',1593605,1593634),('412_101_221_20',1593635,1593664),('412_101_221_21',1593665,1593695),('412_101_221_22',1593696,1593726),('412_101_221_23',1593727,1593756),('412_101_221_24',1593757,1593786),('412_101_221_25',1593787,1593816),('412_101_221_26',1593817,1593846),('412_101_221_27',1593847,1593876),('412_101_221_28',1593877,1593906),('412_101_221_29',1593907,1593938),('412_101_221_30',1593939,1593970),('412_101_221_31',1593971,1594000),('412_101_221_32',1594001,1594030),('412_101_221_33',1594031,1594059),('412_101_221_34',1594060,1594089),('412_101_221_35',1594090,1594119),('412_101_221_36',1594120,1594149),('412_101_221_37',1594150,1594179),('412_101_221_38',1594180,1594209),('412_101_221_39',1594210,1594239),('412_101_221_40',1594240,1594269),('412_101_221_41',1594270,1594299),('412_101_221_42',1594300,1594329),('412_101_221_43',1594330,1594359),('412_101_221_44',1594360,1594389),('412_101_221_45',1594390,1594419),('412_101_221_46',1594420,1594449),('412_101_221_47',1594450,1594479),('412_101_221_48',1594480,1594509),('412_101_221_49',1594510,1594539),('412_101_221_50',1594540,1594569),('412_101_221_51',1594570,1594599),('412_101_221_52',1594600,1594629),('412_101_221_53',1594630,1594659),('412_101_221_54',1594660,1594802),('412_101_221_55',1594803,1594832),('412_101_221_56',1594833,1594868),('412_101_221_57',1594869,1594908),('412_101_221_58',1594909,1594938),('412_101_221_59',1594939,1595080),('412_101_221_60',1595081,1595114),('412_101_221_61',1595115,1595146),('412_101_221_62',1595147,1595184),('412_101_221_63',1595185,1595216),('412_101_221_64',1595217,1595248),('412_101_221_65',1595249,1595280),('412_101_221_66',1595281,1595312),('412_101_221_67',1595313,1595350),('412_101_221_68',1595351,1595382),('412_101_221_69',1595383,1595414),('412_101_221_70',1595415,1595446),('412_101_221_71',1595447,1595482),('412_101_221_72',1595483,1595514),('412_101_221_73',1595515,1595546),('412_101_221_74',1595547,1595578),('412_101_221_75',1595579,1595610),('412_101_221_76',1595611,1595642),('412_101_221_77',1595643,1595674),('412_101_221_78',1595675,1595706),('412_101_221_79',1595707,1595738),('412_101_221_80',1595739,1595770),('412_101_241',1595771,1597034),('412_101_61',1597035,1598972),('412_101',1598973,1606862),('412_103_1',1606863,1609604),('412_106_12',1609605,1612243),('412_106_141',1612244,1614019),('412_106_16',1614020,1614504),('412_106_1',1614505,1617583),('412_109_3',1617584,1617960),('412_10',1617961,1623930),('412_11',1623931,1624364),('413_11',1624365,1626340),('413_12',1626341,1629444),('413_13',1629445,1629561),('413_14',1629562,1630651),('414_110_11',1630652,1631350),('414_110_12',1631351,1631621),('414_110_1',1631622,1633474),('414_110_21',1633475,1634976),('414_110_2',1634977,1636670),('414_110_372_1',1636671,1638243),('414_110_373_1',1638244,1639544),('414_110_37',1639545,1641179),('414_110_3',1641180,1642990),('414_110_422_3',1642991,1645696),('414_110',1645697,1649736),('414_111',1649737,1650116),('414_119',1650117,1650920),('414_121',1650921,1651506),('414_123',1651507,1652041),('414_131_1',1652042,1653000),('414_131_52',1653001,1657946),('414_131_7',1657947,1659923),('414_132_2',1659924,1663300),('414_132_3',1663301,1664588),('414_133_1',1664589,1667580),('414_133_2',1667581,1669861),('414_134_2',1669862,1671646),('414_135_1',1671647,1676023),('414_136',1676024,1677436),('414_138_1',1677437,1678604),('414_138_2',1678605,1680070),('414_142_32',1680071,1681378),('414_146',1681379,1682221),('414_154',1682222,1683052),('414_161',1683053,1684117),('414_172',1684118,1685220),('414_201',1685221,1690990),('414_205_1',1690991,1691812),('414_205_2',1691813,1692652),('414_205_3',1692653,1697309),('414_205',1697310,1699802),('414_20',1699803,1701844),('414_513',1701845,1703279),('414_51',1703280,1703583),('414_711_12',1703584,1703691),('414_711_43',1703692,1704716),('414_711_5',1704717,1705538),('414_711',1705539,1708562),('414_712',1708563,1709178),('414_713_1',1709179,1709633),('414_713_2',1709634,1709855),('414_715',1709856,1710237),('414_71',1710238,1712968),('415_011_2',1712969,1715819),('415_011',1715820,1722758),('415_012',1722759,1726130),('415_013',1726131,1726700),('415_01',1726701,1734583),('415_0',1734584,1737824),('415_11',1737825,1739329),('415_1',1739330,1740672),('416_0',1740673,1741566),('416_21',1741567,1742266),('416_2',1742267,1742879),('418_01',1742880,1744415),('418_0',1744416,1745508),('418_3',1745509,1745724),('420_11',1745725,1752661),('420_123',1752662,1753230),('420_124_1',1753231,1755287),('420_132',1755288,1756426),('420_1',1756427,1760952),('420_31',1760953,1762623),('425_11',1762624,1764211),('425_15',1764212,1764765),('425_1',1764766,1765723),('427_72',1765724,1766779),('429_11',1766780,1767900),('429_1',1767901,1768626),('431_011',1768627,1770111),('431_012_1',1770112,1772084),('431_01',1772085,1775081),('431_021',1775082,1777249),('431_02',1777250,1779467),('431_031',1779468,1781567),('431_03',1781568,1783161),('431_09',1783162,1784824),('431_112_1',1784825,1786959),('431_112',1786960,1788285),('431_835',1788286,1789749),('431_841',1789750,1792070),('431_903',1792071,1794059),('432_211',1794060,1796625),('432_219_1',1796626,1796740),('432_219',1796741,1797490),('432_21',1797491,1798446),('432_301',1798447,1798607),('432_303_2',1798608,1798640),('432_304',1798641,1799002),('432_30',1799003,1801257),('441_11',1801258,1804186),('441_1',1804187,1805931),('442_11',1805932,1807161),('442_121',1807162,1808434),('442_122',1808435,1809061),('442_123',1809062,1809752),('442_124',1809753,1810427),('442_125',1810428,1811246),('442_126',1811247,1812114),('442_127',1812115,1812932),('442_128',1812933,1813473),('442_132_1',1813474,1815508),('442_132_2',1815509,1817114),('442_132_3',1817115,1817145),('442_1',1817146,1819962),('443_113',1819963,1827353),('443_116',1827354,1828116),('443_11',1828117,1829508),('443_1',1829509,1831868),('444_11',1831869,1834569),('444_1',1834570,1837346),('446_11',1837347,1838641),('446_1',1838642,1839338),('451_11',1839339,1839520),('451_12',1839521,1839723),('451_13',1839724,1840729),('451_1',1840730,1844665),('451_31',1844666,1845478),('451_32',1845479,1846395),('451_33',1846396,1847532),('451_34',1847533,1848679),('451_35',1848680,1849669),('451_36',1849670,1852387),('451_37',1852388,1853622),('451_41',1853623,1853802),('451_46',1853803,1853939),('451_51',1853940,1854472),('451',1854473,1859586),('453_1',1859587,1860102),('453_3',1860103,1860431),('453',1860432,1864805),('454',1864806,1865515),('455_109_1',1865516,1870391),('455_110_1',1870392,1873314),('455_110_2',1873315,1875454),('455_163',1875455,1878583),('455_1',1878584,1901000),('455_61',1901001,1902868),('455',1902869,1906397),('501_2',1906398,1907403),('501_31',1907404,1908420),('501_5',1908421,1908831),('501_7',1908832,1909377),('510_102',1909378,1909693),('510_107_0',1909694,1921800),('510_10',1921801,1934036),('510_211_2',1934037,1935854),('510_211_3',1935855,1937215),('510_215',1937216,1937908),('510_218',1937909,1938640),('510_291',1938641,1940277),('510_292',1940278,1941862),('510_301_1',1941863,1943247),('510_301',1943248,1951642),('510_30',1951643,1954862),('510_32',1954863,1956819),('510_35',1956820,1957908),('510_411',1957909,1959700),('510_413',1959701,1961146),('510_419',1961147,1961707),('510_512',1961708,1964071),('510_514_1',1964072,1965412),('510_514',1965413,1966268),('510_518_1',1966269,1967550),('510_518',1967551,1968110),('510_51',1968111,1970425),('510_620_1',1970426,1971339),('510_620_2',1971340,1971844),('510_620',1971845,1976230),('510_622_4',1976231,1978237),('510_624',1978238,1979827),('510_625',1979828,1982202),('510_626_1',1982203,1983145),('510_626',1983146,1984935),('510_62',1984936,1988584),('510_710',1988585,1995684),('510_725',1995685,1996138),('510_755',1996139,1997846),('510_81',1997847,1998461),('510_911',1998462,2002219),('510_91',2002220,2012393),('511_110',2012394,2014316),('511_11',2014317,2017341),('511_12',2017342,2018276),('511_13',2018277,2018720),('511_22',2018721,2021114),('512_151',2021115,2021660),('512_15',2021661,2022006),('512_21',2022007,2033136),('512_26',2033137,2033648),('512_271_1',2033649,2037215),('512_271_5',2037216,2038199),('512_271',2038200,2039841),('512_301',2039842,2040384),('512_30',2040385,2041645),('512_311',2041646,2047280),('512_312',2047281,2048431),('512_313',2048432,2050475),('512_31',2050476,2054418),('512_38',2054419,2055830),('512_413',2055831,2056510),('513_111',2056511,2056789),('513_11',2056790,2057491),('513_12',2057492,2058386),('513_1',2058387,2059469),('513_311_1',2059470,2060314),('513_316_2',2060315,2060981),('513_316',2060982,2061512),('513_511',2061513,2061660),('513_51',2061661,2062014),('513_52',2062015,2062868),('513_61',2062869,2063748),('513_71',2063749,2064363),('513_72',2064364,2064866),('513_73',2064867,2065359),('513_74',2065360,2066714),('513_75',2066715,2067585),('513_76',2067586,2068072),('514_101',2068073,2070640),('514_10',2070641,2072149),('514_20',2072150,2075472),('514_28',2075473,2075764),('514_31',2075765,2078203),('514_421',2078204,2079870),('514_42',2079871,2080169),('514_432',2080170,2080501),('514_43',2080502,2083137),('514_511',2083138,2086238),('514_51',2086239,2090234),('514_541',2090235,2098488),('514_544_1',2098489,2098852),('514_544_2',2098853,2099102),('514_546_1',2099103,2099485),('514_54',2099486,2107972),('515_08',2107973,2108173),('517_41',2108174,2108613),('518_01',2108614,2110036),('518_0',2110037,2110123),('518_52',2110124,2110398),('520_112',2110399,2110769),('520_11',2110770,2114612),('520_12',2114613,2116635),('520_14',2116636,2117563),('520_15',2117564,2119301),('520_16',2119302,2120040),('520_17',2120041,2122125),('520_18',2122126,2123200),('520_19',2123201,2123403),('520_1',2123404,2128824),('520_31',2128825,2131121),('520_3',2131122,2133284),('522_3',2133285,2133440),('523_51',2133441,2134879),('524_1',2134880,2135039),('531_11',2135040,2136631),('531_12',2136632,2137569),('531_211',2137570,2139142),('531_212',2139143,2140919),('531_215_11',2140920,2141355),('531_215_12',2141356,2141796),('531_215_13',2141797,2142278),('531_215_14',2142279,2142749),('531_215_17',2142750,2143644),('531_215_25',2143645,2144254),('531_215_31',2144255,2144826),('531_215_41',2144827,2145331),('531_215_42',2145332,2145949),('531_32',2145950,2147154),('531_35',2147155,2147538),('531_40',2147539,2148172),('531_44',2148173,2149674),('531_541',2149675,2151055),('531_543',2151056,2151263),('531_54',2151264,2155241),('531_55',2155242,2156423),('531_711',2156424,2157571),('531',2157572,2162669),('611_010',2162670,2162991),('611_01',2162992,2169829),('611_021',2169830,2171086),('611_031',2171087,2171656),('611_032',2171657,2172659),('611_051',2172660,2172845),('611_0',2172846,2178026),('613_11',2178027,2178297),('613_21',2178298,2183254),('613_22',2183255,2183455),('613_23',2183456,2183661),('613_26',2183662,2183799),('613_2',2183800,2186097),('614_0',2186098,2188572),('616_1',2188573,2192222),('631_011',2192223,2192419),('631_012',2192420,2192680),('631_013',2192681,2197882),('631_016',2197883,2198920),('631_01',2198921,2221602),('631_035',2221603,2221817),('631_051',2221818,2222761),('631_052',2222762,2223229),('631_053',2223230,2224106),('631_061',2224107,2225264),('631_062',2225265,2227432),('631_09',2227433,2228282),('631_0',2228283,2240467),('631_144_0',2240468,2245302),('631_145_0',2245303,2251196),('631_253_41',2251197,2251401),('631_253_4',2251402,2257788),('632_104',2257789,2257939),('632_10',2257940,2259197),('632_111_722_1',2259198,2259334),('632_111_722',2259335,2259844),('632_111_723_1',2259845,2260012),('632_111_723',2260013,2261779),('632_111_72',2261780,2262386),('632_115_01',2262387,2262627),('632_13',2262628,2263122),('632_14',2263123,2264304),('632_231',2264305,2264413),('632_319',2264414,2265375),('632_421_0',2265376,2266041),('632_911',2266042,2266848),('632_91',2266849,2267179),('641_101',2267180,2271472),('641_10',2271473,2277088),('641_131',2277089,2277155),('641_153',2277156,2277291),('641_201_511_1',2277292,2277403),('641_201_511',2277404,2279233),('641_201',2279234,2297102),('641_202_2',2297103,2297844),('641_202_62',2297845,2298060),('641_203_2',2298061,2298329),('641_203_3',2298330,2298777),('641_203',2298778,2299106),('641_204',2299107,2299281),('641_207_1',2299282,2299686),('641_20',2299687,2317934),('641_310',2317935,2318148),('641_311',2318149,2321679),('641_315',2321680,2321898),('641_316',2321899,2322900),('641_31',2322901,2327482),('641_411_1',2327483,2329037),('641_411',2329038,2332204),('641_511',2332205,2333105),('641_514',2333106,2333214),('641_51',2333215,2336052),('641_611_21',2336053,2337504),('641_611',2337505,2348210),('641_612',2348211,2349676),('641_613',2349677,2349736),('641_61',2349737,2353715),('641_711_1',2353716,2354212),('641_712_2',2354213,2355053),('641_712',2355054,2358752),('641_713',2358753,2359229),('641_714',2359230,2361400),('641_71',2361401,2364287),('641_811_22',2364288,2364562),('641_811_31',2364563,2364927),('641_811_911',2364928,2365129),('641_811_912',2365130,2365213),('641_811',2365214,2371839),('641_81',2371840,2373761),('641_912_11',2373762,2373854),('641_912_21',2373855,2373945),('641_91',2373946,2376928),('642_110_8',2376929,2377910),('642_112',2377911,2378699),('642_113',2378700,2381121),('642_114',2381122,2382172),('642_116_1',2382173,2382505),('642_116_2',2382506,2382854),('642_116',2382855,2383301),('642_117_1',2383302,2385115),('642_117_2',2385116,2386179),('642_118_1',2386180,2387121),('642_118_2',2387122,2389008),('642_118_3',2389009,2389747),('642_118',2389748,2389890),('642_119_2',2389891,2390271),('642_119_3',2390272,2390693),('642_11',2390694,2414880),('642_121',2414881,2416918),('642_123',2416919,2417422),('642_124',2417423,2417945),('642_132',2417946,2418389),('642_141',2418390,2418877),('642_14',2418878,2432693),('642_211',2432694,2442386),('642_212',2442387,2442526),('642_21',2442527,2450012),('642_31',2450013,2450477),('661_1',2450478,2454604),('661',2454605,2459150),('672_1',2459151,2459480),('672_201_1',2459481,2459763),('672_201_3',2459764,2460010),('672_201',2460011,2462861),('672_202',2462862,2463889),('672_203',2463890,2464541),('672_204',2464542,2466512),('672_2',2466513,2466819),('672_3',2466820,2467111),('672_911_81',2467112,2468215),('672_913_610',2468216,2470391),('672_913_6',2470392,2470662),('672_916_31',2470663,2470953),('672_916_3',2470954,2471194),('672_923_2',2471195,2471452),('672_924_51',2471453,2472587),('672_926_31',2472588,2473724),('672_928_1',2473725,2473985),('672_931_41',2473986,2474698),('672_931_4',2474699,2474939),('672_933_21',2474940,2476079),('672_933_61',2476080,2481393),('672_934_51',2481394,2482517),('672_934_5',2482518,2482758),('672_934_9',2482759,2483005),('672_936_71',2483006,2484193),('672_936_7',2484194,2484448),('672_937_2',2484449,2484822),('672_942_3',2484823,2485080),('672_946_3',2485081,2485506),('672_951_8',2485507,2485750),('672_954_5',2485751,2485995),('672_956_3',2485996,2486241),('672_959_81',2486242,2487412),('672_959_8',2487413,2487675),('672_963_61',2487676,2489460),('672_963_6',2489461,2489764),('672_964_9',2489765,2490082),('672_965_6',2490083,2490308),('672_966_3',2490309,2490568),('672_968_9',2490569,2490815),('672_969_0',2490816,2491080),('672_971_4',2491081,2491342),('672_976_3',2491343,2491647),('672_977_6',2491648,2492013),('680_114',2492014,2492303),('680_11',2492304,2497168),('680',2497169,2504434),('681_41',2504435,2504739),('683_21',2504740,2505074),('689_3',2505075,2505208),('689_5',2505209,2505507),('689_7',2505508,2506036),('700_1',2506037,2511788),('700',2511789,2515443),('704_1',2515444,2516184),('704_5',2516185,2516326),('704',2516327,2517431),('709_17',2517432,2517966),('711_11',2517967,2518246),('711_12',2518247,2518483),('711_1',2518484,2522151),('711_2',2522152,2522964),('711_3',2522965,2524492),('711',2524493,2534135),('721_100_1',2534136,2535919),('721_100',2535920,2536913),('721_102',2536914,2538647),('721_10',2538648,2539374),('721_311',2539375,2540208),('721_312',2540209,2540952),('721_313_1',2540953,2541522),('721_313',2541523,2542257),('721_322',2542258,2542483),('721_325',2542484,2542834),('721_801',2542835,2543219),('721_80',2543220,2550647),('721_821',2550648,2552026),('721_831',2552027,2553657),('721_832',2553658,2553881),('725_111_31',2553882,2555078),('725_111',2555079,2559698),('725_113_111',2559699,2559806),('725_113_11',2559807,2560084),('725_116_21',2560085,2563045),('725_116_22',2563046,2563910),('725_116_2',2563911,2567839),('725_11',2567840,2572578),('725_13',2572579,2573930),('725_14',2573931,2574206),('725_151_1',2574207,2574903),('725_151',2574904,2575116),('730_010_1',2575117,2576204),('730_011_1',2576205,2576877),('730_012_1',2576878,2577366),('730_01',2577367,2587179),('730_05',2587180,2588446),('730_0',2588447,2592707),('732_112_1',2592708,2593251),('732_112_2',2593252,2595043),('732_114_5',2595044,2595766),('732_11',2595767,2603832),('732_12',2603833,2606666),('732_13',2606667,2607467),('732_143_1',2607468,2612918),('732_143_2',2612919,2614862),('732_143_3',2614863,2615450),('732_16',2615451,2616524),('732_17',2616525,2619159),('732_1',2619160,2629650),('732_21',2629651,2630977),('732_221',2630978,2634146),('732_222',2634147,2634694),('732_2',2634695,2636348),('732_33',2636349,2637976),('732_345',2637977,2638649),('732_441',2638650,2639768),('732_44',2639769,2642550),('732_91',2642551,2642681),('734_0',2642682,2645862),('734_1',2645863,2648569),('734_24',2648570,2649627),('734_25',2649628,2651411),('734_26',2651412,2653276),('734_272_3',2653277,2654282),('734_27',2654283,2659370),('734_2',2659371,2667367),('734_31',2667368,2679052),('734_5',2679053,2681712),('734_6',2681713,2683979),('734_713_3',2683980,2685023),('734_71',2685024,2689890),('734_74',2689891,2691082),('734_7',2691083,2695443),('740_12',2695444,2696824),('740_1',2696825,2697568),('741_013_1',2697569,2700692),('741_013',2700693,2706212),('741_01',2706213,2722192),('741_031',2722193,2722464),('741_03',2722465,2723099),('741_11',2723100,2740307),('741_13',2740308,2740435),('741_211_5',2740436,2741140),('741_213_3',2741141,2741644),('741_21',2741645,2765436),('741_272',2765437,2765780),('741_31',2765781,2775350),('741_412',2775351,2775413),('741_413',2775414,2775477),('741_414',2775478,2775557),('741_41',2775558,2815398),('741_435_4',2815399,2815436),('741_437',2815437,2815538),('741_511',2815539,2818970),('741_51',2818971,2840452),('741_521',2840453,2843613),('741_522',2843614,2846453),('741_53',2846454,2848093),('741_55',2848094,2849750),('741_56',2849751,2851984),('741_57',2851985,2854046),('741_618',2854047,2854894),('741_621',2854895,2856735),('741_622',2856736,2859174),('741_631',2859175,2859590),('741_694_541',2859591,2859826),('741_711',2859827,2860610),('741_712',2860611,2860880),('741_71',2860881,2862072),('741_811',2862073,2862419),('741_816',2862420,2863449),('741_817',2863450,2864317),('741_81',2864318,2864925),('742_100',2864926,2865260),('742_101_2',2865261,2866016),('742_101',2866017,2876232),('742_102',2876233,2879600),('742_104_1',2879601,2881648),('742_104',2881649,2883206),('742_120',2883207,2885697),('742_122_4',2885698,2886506),('742_122_7',2886507,2888002),('742_122',2888003,2891601),('742_140_2',2891602,2892855),('742_140_3',2892856,2893602),('742_140',2893603,2894558),('742_141_11',2894559,2894575),('742_141_1',2894576,2901862),('742_141_21',2901863,2907800),('742_141_2',2907801,2912016),('742_141_3',2912017,2916183),('742_141_51',2916184,2917870),('742_141_5',2917871,2919582),('742_142_1',2919583,2920477),('742_143_6',2920478,2920636),('742_144_1',2920637,2923165),('742_144',2923166,2924077),('742_147_2',2924078,2924487),('742_149_1',2924488,2924561),('742_161',2924562,2927486),('742_170',2927487,2927512),('742_173_001',2927513,2927533),('742_211_1',2927534,2928872),('742_211',2928873,2934581),('742_221',2934582,2937076),('742_31',2937077,2938777),('742_32',2938778,2939730),('742_401_6',2939731,2939977),('742_411',2939978,2940448),('742_41',2940449,2941540),('743_011_11',2941541,2948051),('743_011',2948052,2953302),('743_01',2953303,2955687),('743_121_1',2955688,2955717),('743_121_2',2955718,2955747),('743_121_3',2955748,2955774),('743_121_6',2955775,2955801),('743_123',2955802,2956189),('744_103',2956190,2957276),('744_10',2957277,2958320),('744_211',2958321,2960313),('744_21',2960314,2961392),('745_11',2961393,2967983),('745_13',2967984,2969021),('745_16',2969022,2973043),('745_1',2973044,2978749),('745_21',2978750,2979770),('745_2',2979771,2980817),('746_11',2980818,2983932),('746_12',2983933,2987654),('746_1',2987655,2991656),('747_111',2991657,2995171),('747_11',2995172,3001478),('747_201_1',3001479,3022431),('747_201_2',3022432,3023373),('747_201_31',3023374,3024900),('747_201_3',3024901,3029630),('747_201_55',3029631,3030221),('747_201_5',3030222,3030875),('747_201_71',3030876,3030894),('747_201_7',3030895,3034223),('747_201',3034224,3038786),('747_219_1',3038787,3039058),('747_223_1',3039059,3051715),('747_224_010_2',3051716,3051745),('747_224_011',3051746,3052444),('747_224_022',3052445,3053407),('747_224_052',3053408,3053583),('747_224_111_1',3053584,3053885),('747_224_111',3053886,3053904),('747_224_121',3053905,3054154),('747_224_122',3054155,3056211),('747_224_131_1',3056212,3056393),('747_224_131',3056394,3056412),('747_224_141',3056413,3056768),('747_224_211',3056769,3057616),('747_224_221_1',3057617,3057820),('747_224_221',3057821,3062515),('747_224_25',3062516,3062586),('747_224_26',3062587,3063018),('747_224_320',3063019,3063718),('747_301',3063719,3073060),('747_30',3073061,3090943),('747_312_4',3090944,3091628),('747_321_71',3091629,3093469),('747_321_7',3093470,3095826),('747_341_2',3095827,3096215),('748_01',3096216,3106828),('748_0',3106829,3119539),('748_111_1',3119540,3121094),('748_111_2',3121095,3121327),('748_112_11',3121328,3124656),('748_121_11',3124657,3129513),('748_122',3129514,3131233),('748_126_11',3131234,3131891),('748_126_1',3131892,3132315),('748_126_3',3132316,3135588),('748_127_1',3135589,3136076),('748_127_2',3136077,3138601),('748_127_4',3138602,3141136),('748_127_5',3141137,3143012),('748_127_6',3143013,3143460),('748_127_8',3143461,3145473),('748_127_9',3145474,3146831),('748_128',3146832,3147517),('748_131_121_8',3147518,3148536),('748_131_1',3148537,3156916),('748_131_2',3156917,3157819),('748_131_3',3157820,3162061),('748_132_13',3162062,3162387),('748_132_1',3162388,3166623),('748_134_4',3166624,3166679),('748_215_1',3166680,3171804),('748_215_2',3171805,3172726),('748_215_3',3172727,3173670),('748_216_1',3173671,3175130),('748_217_11',3175131,3176778),('748_217_1',3176779,3179713),('748_222_0',3179714,3180402),('748_222_1',3180403,3205229),('748_222_2',3205230,3206811),('748_222_3',3206812,3212171),('748_222_4',3212172,3212600),('748_222_5',3212601,3214275),('748_225_1',3214276,3216292),('748_411',3216293,3219541),('748_941',3219542,3221100),('780_115_1',3221101,3221756),('780_11',3221757,3227100),('780_1',3227101,3228774),('783_01',3228775,3236925),('783_0',3236926,3240745),('783_1',3240746,3242135),('784_101_112',3242136,3243004),('784_101_113',3243005,3243175),('784_101_115',3243176,3244371),('784_101_12',3244372,3244705),('784_101_1',3244706,3257670),('784_101_21',3257671,3259175),('784_101_2',3259176,3263718),('784_102_11',3263719,3264518),('784_102_1',3264519,3269117),('784_104',3269118,3278315),('784_105_11',3278316,3278546),('784_106_12',3278547,3280363),('784_106',3280364,3281808),('784_10',3281809,3289075),('784_11',3289076,3290536),('784_401_11',3290537,3293457),('784_401',3293458,3304160),('784_409',3304161,3305328),('784_40',3305329,3317571),('810_112_2',3317572,3319319),('810_113',3319320,3320130),('810_11',3320131,3323534),('810_122_122',3323535,3323642),('810_122_1',3323643,3326383),('810_122_2',3326384,3328369),('810_12',3328370,3332537),('810_211',3332538,3338159),('810_212_41',3338160,3340935),('810_212_4',3340936,3343729),('810_213',3343730,3347051),('810_215_7',3347052,3347305),('810_21',3347306,3354474),('810_311',3354475,3357430),('810_31',3357431,3360027),('811_112_021',3360028,3360761),('811_112_022',3360762,3360980),('811_112_03',3360981,3361166),('811_112_0',3361167,3363428),('811_113_32',3363429,3364436),('811_113_3',3364437,3367471),('811_115_4',3367472,3367935),('811_117_2',3367936,3369653),('811_117_3',3369654,3371482),('811_11',3371483,3377448),('812_121_11',3377449,3378096),('812_121_1',3378097,3386435),('812_121_6',3386436,3389995),('812_121',3389996,3395266),('812_211',3395267,3395828),('812_212_1',3395829,3402015),('812_212_21',3402016,3408463),('812_212_22',3408464,3410927),('812_212_23',3410928,3415277),('812_212_24',3415278,3419329),('812_212_27',3419330,3424128),('812_212_5',3424129,3427060),('812_213_6',3427061,3427184),('812_213',3427185,3432675),('812_214_11',3432676,3432897),('812_214_2',3432898,3437327),('812_214_5',3437328,3438091),('812_215_4',3438092,3442655),('812_216_2',3442656,3443769),('812_216',3443770,3444373),('812_21',3444374,3454125),('813_112_12',3454126,3454403),('813_112_1',3454404,3456506),('813_113_11',3456507,3457243),('813_11',3457244,3472343),('813_12',3472344,3480179),('813_131_21',3480180,3481254),('813_153_1',3481255,3481694),('813_1',3481695,3487168),('814_011',3487169,3489766),('814_012',3489767,3492278),('814_014',3492279,3492848),('814_017',3492849,3494357),('814_018_21',3494358,3494508),('814_018',3494509,3497027),('814_019',3497028,3497635),('814_01',3497636,3509153),('814_020',3509154,3509773),('814_031',3509774,3509953),('814_076',3509954,3510555),('814_12',3510556,3511863),('814_201_81',3511864,3511989),('814_201',3511990,3522282),('814_20',3522283,3530296),('814_318_142_1',3530297,3535097),('814_412_2',3535098,3536699),('814_41',3536700,3541850),('814_49',3541851,3543458),('814_501_261',3543459,3544793),('814_501_43',3544794,3547251),('814_501_512',3547252,3549969),('814_501_513',3549970,3552340),('814_501_51',3552341,3553511),('814_501',3553512,3567880),('814_50',3567881,3571662),('814_52',3571663,3572749),('814_542_1',3572750,3576212),('814_554',3576213,3581449),('814_557',3581450,3581998),('814_56',3581999,3582456),('814_594_1',3582457,3582901),('814_600',3582902,3587777),('814_610_1',3587778,3587922),('814_610',3587923,3593242),('814_620',3593243,3593978),('814_621_4',3593979,3594138),('814_621',3594139,3596126),('814_670_1',3596127,3596356),('814_680',3596357,3599263),('814_681',3599264,3601097),('814_710',3601098,3602971),('814_812_31',3602972,3604045),('814_812_32',3604046,3605042),('814_812_33',3605043,3606115),('814_812_34',3606116,3607003),('814_812_35',3607004,3607825),('814_812_36',3607826,3608704),('814_812_37',3608705,3609435),('814_812_38',3609436,3610251),('814_81',3610252,3612214),('814_82',3612215,3613954),('814_911',3613955,3624911),('814_912_21',3624912,3626336),('814_912',3626337,3630812),('814_91',3630813,3634980),('817_021_23',3634981,3635688),('817_022_101',3635689,3639153),('817_022_102',3639154,3641582),('817_022_103',3641583,3643726),('817_022_104',3643727,3649894),('817_022_105',3649895,3652269),('817_022_106',3652270,3653688),('817_022_107',3653689,3656476),('817_022_108',3656477,3666304),('817_022_109',3666305,3668746),('817_022_110',3668747,3676578),('817_022_111',3676579,3682587),('817_022_21',3682588,3692383),('817_022_31',3692384,3693642),('817_022_32',3693643,3694489),('817_022_51',3694490,3696327),('817_023_11',3696328,3699188),('817_023_21',3699189,3702119),('817_023_31',3702120,3703135),('817_023_41',3703136,3706382),('817_023_61',3706383,3708139),('817_024_1',3708140,3717224),('817_024_2',3717225,3718207),('817_025_21',3718208,3722169),('817_026_1',3722170,3722814),('817_026_2',3722815,3723644),('817_02',3723645,3733702),('817_042',3733703,3736482),('817_064',3736483,3737065),('817_06',3737066,3740403),('817_0',3740404,3745894),('817_190_1',3745895,3746922),('817_190_4',3746923,3748106),('817_190',3748107,3755337),('817_451',3755338,3755726),('817_45',3755727,3756341),('818_101_21',3756342,3756734),('818_101_23',3756735,3757777),('818_101',3757778,3760695),('818_102',3760696,3761454),('818_116',3761455,3763084),('818_123_1',3763085,3764534),('818_125_11',3764535,3764821),('818_125_12',3764822,3765531),('818_125_1',3765532,3766305),('818_138_1',3766306,3766378),('818_141_11',3766379,3766612),('818_141_1',3766613,3768750),('818_161',3768751,3769641),('818_21',3769642,3770027),('818_311',3770028,3770702),('818_31',3770703,3771249),('818_61',3771250,3772517),('819_121',3772518,3776013),('819_122',3776014,3778262),('819_13',3778263,3780796),('819_14',3780797,3781381),('821_41',3781382,3781672),('821_421',3781673,3782558),('821_42',3782559,3783447),('822_111_1',3783448,3783671),('822_111_52',3783672,3785380),('822_111',3785381,3796051),('822_112_1',3796052,3796261),('822_112',3796262,3801091),('822_113',3801092,3804153),('822_114',3804154,3808941),('822_115_2',3808942,3809397),('822_115_4',3809398,3810871),('822_115',3810872,3812915),('822_116',3812916,3813728),('822_117',3813729,3813858),('822_11',3813859,3821045),('822_14',3821046,3821978),('822_211',3821979,3828022),('822_21',3828023,3830375),('822_221',3830376,3837313),('822_222',3837314,3842410),('822_223',3842411,3843826),('822_22',3843827,3843970),('822_311',3843971,3845350),('822_31',3845351,3846489),('822_321',3846490,3847229),('822_411',3847230,3848400),('822_41',3848401,3850395),('823_111',3850396,3855591),('823_113',3855592,3856373),('823_114',3856374,3857509),('823_11',3857510,3862461),('823_201',3862462,3865180),('823_20',3865181,3867109),('823_321',3867110,3868401),('823_331_2',3868402,3868629),('823_331',3868630,3869780),('823_33',3869781,3871263),('824_01',3871264,3885986),('824_091',3885987,3886646),('824_095',3886647,3887888),('824_0',3887889,3894760),('824_11',3894761,3895386),('830_11',3895387,3897179),('830_1',3897180,3903879),('831_101_4',3903880,3904554),('831_101',3904555,3926661),('831_108',3926662,3927241),('831_10',3927242,3944218),('831_111',3944219,3946151),('831_131_11',3946152,3946896),('831_131_12',3946897,3947494),('831_135_1',3947495,3948069),('831_143_15',3948070,3948419),('831_143_32',3948420,3949361),('831_143_41',3949362,3949513),('831_143_42',3949514,3949803),('831_192_1',3949804,3951605),('831_201_26',3951606,3952269),('831_201_71',3952270,3952931),('831_201_72',3952932,3953272),('831_201_7',3953273,3953687),('831_201',3953688,3968406),('831_20',3968407,3982906),('831_232_21',3982907,3983208),('831_232_51',3983209,3984356),('831_261',3984357,3984546),('831_26',3984547,3985412),('831_27',3985413,3985732),('831_301',3985733,3992317),('831_304',3992318,3992475),('831_309_1',3992476,3992776),('831_30',3992777,3996768),('831_403_2',3996769,4001813),('831_40',4001814,4019490),('831_411',4019491,4021032),('831_425_4',4021033,4021228),('831_425',4021229,4023594),('831_426_3',4023595,4023814),('831_42',4023815,4028280),('831_432_1',4028281,4030262),('831_432_2',4030263,4030730),('831_434',4030731,4031281),('831_435_1',4031282,4033353),('831_435_2',4033354,4033832),('831_441_1',4033833,4046011),('831_461_3',4046012,4047320),('832_102_15',4047321,4048069),('832_102_4',4048070,4049016),('832_102',4049017,4073877),('832_104',4073878,4075449),('832_105_1',4075450,4075729),('832_105',4075730,4077506),('832_10',4077507,4094056),('832_112_1',4094057,4096975),('832_112_31',4096976,4107224),('832_112_4',4107225,4108336),('832_112_51',4108337,4108496),('832_112_5',4108497,4109951),('832_202',4109952,4122774),('832_205_12',4122775,4123158),('832_205_27',4123159,4123356),('832_206_2',4123357,4123433),('832_207',4123434,4124571),('832_208',4124572,4124699),('832_20',4124700,4135668),('832_27',4135669,4135800),('832_30',4135801,4147083),('832_311_12',4147084,4152499),('832_311_141',4152500,4160348),('832_311_18',4160349,4160673),('832_312_12',4160674,4161885),('832_312_15',4161886,4164295),('832_312_17',4164296,4165381),('832_314_12',4165382,4168088),('832_321_11',4168089,4168371),('832_321',4168372,4171414),('832_323_112',4171415,4171968),('833_11',4171969,4176362),('833_12',4176363,4176641),('833_1',4176642,4185742),('834_11',4185743,4189585),('834_13',4189586,4189794),('834_1',4189795,4193288),('836_11',4193289,4194150),('836_1',4194151,4196057),('836_21',4196058,4198955),('836_2',4198956,4201632),('837_022_531',4201633,4202189),('837_023_211',4202190,4202408),('837_023_212',4202409,4202591),('837_023_3',4202592,4203378),('837_02',4203379,4222079),('837_056_2',4222080,4222333),('837_063_1',4222334,4223156),('837_063_2',4223157,4223873),('837_0',4223874,4241187),('837_12',4241188,4241577),('837_141',4241578,4242171),('837_171',4242172,4243009),('837_174',4243010,4243855),('842_11',4243856,4243998),('842_18',4243999,4245709),('842_1',4245710,4249932),('842_4',4249933,4250531),('842',4250532,4253698),('843_123_3',4253699,4253856),('843_142_3',4253857,4254082),('843_143_1',4254083,4254351),('843_1',4254352,4260891),('843',4260892,4265784),('844_12',4265785,4265971),('844_1',4265972,4268650),('844',4268651,4270772),('851_1',4270773,4273219),('852_11',4273220,4275405),('852_1',4275406,4276651),('852_8',4276652,4276979),('855_1',4276980,4277129),('857_51',4277130,4277366),('857_5',4277367,4277657),('861_1',4277658,4279556),('861',4279557,4280423),('901_021',4280424,4280860),('901_022_1',4280861,4281401),('901_022',4281402,4282551),('901_0',4282552,4284453),('901_21',4284454,4285809),('901_2',4285810,4286462),('910_11',4286463,4286864),('910_124',4286865,4287459),('910_12',4287460,4290334),('910_132_4',4290335,4291327),('910_133_2',4291328,4291964),('910_133',4291965,4294957),('910_13',4294958,4304135),('910_14',4304136,4305826),('910_15',4305827,4306768),('910_17',4306769,4308653),('910_181',4308654,4312159),('910_18',4312160,4321184),('910_19',4321185,4322935),('910_1',4322936,4338919),('910_91',4338920,4342641),('912_1',4342642,4343340),('913_1',4343341,4352054),('913_211',4352055,4353098),('914_11',4353099,4355826),('915_1',4355827,4356842),('915_7',4356843,4358506),('916_010_2',4358507,4358748),('916_010',4358749,4360567),('916_013',4360568,4361726),('916_01',4361727,4366074),('916_020_1',4366075,4366680),('916_020',4366681,4367825),('916_111_311_2',4367826,4368188),('916_112_231',4368189,4368554),('916_116_4',4368555,4368754),('916_121_100',4368755,4369159),('916_121_10',4369160,4371339),('916_131_11',4371340,4372606),('916_140',4372607,4377504),('916_145_211',4377505,4377889),('916_148',4377890,4378043),('916_151_1',4378044,4385893),('916_151_2',4385894,4388272),('916_151_3',4388273,4390934),('916_151_6',4390935,4391149),('916_151_7',4391150,4391465),('916_151',4391466,4394960),('916_161',4394961,4411076),('916_171_1',4411077,4413486),('916_171',4413487,4419561),('916_202_1',4419562,4419705),('916_205_1',4419706,4419773),('916_20',4419774,4427235),('916_307_11',4427236,4427413),('916_307_1',4427414,4430097),('916_307',4430098,4441598),('916_310_31',4441599,4442231),('916_310_51',4442232,4442305),('916_310',4442306,4446320),('916_314_1',4446321,4447419),('916_341_21',4447420,4447680),('916_341_22',4447681,4447818),('916_341',4447819,4452005),('916_342',4452006,4452932),('916_344',4452933,4454400),('916_350_2',4454401,4455757),('916_351_021_1',4455758,4458170),('916_351_0',4458171,4459279),('916_361',4459280,4459757),('916_371',4459758,4460589),('916_401',4460590,4494238),('916_402',4494239,4495882),('916_404_1',4495883,4499418),('916_404_2',4499419,4499730),('916_405_4',4499731,4500876),('916_407',4500877,4501358),('916_408',4501359,4503334),('916_40',4503335,4509015),('916_441_22',4509016,4514825),('916_443_105',4514826,4515323),('916_443_106',4515324,4515952),('916_443_10',4515953,4522086),('916_443_12',4522087,4525318),('916_443_13',4525319,4529778),('916_443_14',4529779,4532126),('916_472',4532127,4533354),('916_511',4533355,4533576),('916_51',4533577,4535176),('919_117_71',4535177,4538338),('919_117_72',4538339,4539950),('919_118',4539951,4540679),('921_01',4540680,4546353),('921_0',4546354,4550477),('921_211_1',4550478,4552181),('921_552_1',4552182,4553452),('922_01',4553453,4556169),('922_0',4556170,4558974),('922_27',4558975,4559878),('922_31',4559879,4561849),('922_32',4561850,4563573),('923_01',4563574,4566887),('923_0',4566888,4569074),('923_31',4569075,4573755),('930_111_5',4573756,4574189),('930_111',4574190,4576289),('930_11',4576290,4578510),('933_01',4578511,4579895),('933_0',4579896,4581328),('934_21',4581329,4581936),('935_121',4581937,4582710),('935_12',4582711,4583810),('935_211',4583811,4584847),('935_21',4584848,4585113),('935_221',4585114,4585723),('935_22',4585724,4586193),('935_511',4586194,4586783),('935_51',4586784,4588661),('935_521_21',4588662,4594440),('935_521',4594441,4605131),('935_524',4605132,4606070),('935_52',4606071,4610024),('935_61',4610025,4612917),('935_621_31',4612918,4613065),('935_621',4613066,4616641),('935_62',4616642,4618297),('935_81',4618298,4618610),('941_101',4618611,4619251),('941_103_1',4619252,4619491),('941_103_2',4619492,4619618),('941_103_3',4619619,4619741),('941_10',4619742,4620530),('941_11',4620531,4621003),('941_13',4621004,4621562),('941_15',4621563,4621765),('941_16',4621766,4621996),('941_201',4621997,4623740),('941_202',4623741,4625179),('941_20',4625180,4627206),('941_210_1',4627207,4627610),('941_210_2',4627611,4628430),('941_210_3',4628431,4629291),('941_210_4',4629292,4630049),('941_210',4630050,4632950),('941_211',4632951,4633950),('941_212',4633951,4634912),('941_213',4634913,4637044),('941_214',4637045,4638593),('941_215',4638594,4639428),('941_216',4639429,4639849),('941_221_2',4639850,4640986),('941_231',4640987,4642347),('941_241',4642348,4643226),('941_242',4643227,4644172),('941_251',4644173,4645635),('941_261',4645636,4646355),('941_271',4646356,4646572),('941_27',4646573,4648974),('941_281_1',4648975,4650337),('941_281',4650338,4652862),('941_292',4652863,4654026),('941_293',4654027,4655104),('941_298_1',4655105,4656172),('941_298_2',4656173,4656632),('941_299_1',4656633,4656863),('941_299',4656864,4657002),('941_311_1',4657003,4657021),('941_311',4657022,4667806),('941_319',4667807,4668751),('941_31',4668752,4673366),('941_411',4673367,4685168),('941_413',4685169,4686245),('941_41',4686246,4690043),('942_20',4690044,4691309),('942_211',4691310,4694232),('942_31',4694233,4694445),('943_02',4694446,4695963),('943_032_1',4695964,4696054),('943_032',4696055,4697256),('943_033_1',4697257,4697359),('943_033',4697360,4698627),('943_03',4698628,4701053),('943_11',4701054,4704529),('943_1',4704530,4706413),('944_021_1',4706414,4706532),('944_021',4706533,4707551),('944_055',4707552,4707666),('944_05',4707667,4708487),('944_0',4708488,4709348),('944_1',4709349,4709749),('944_3',4709750,4711710),('946_101',4711711,4713818),('946_10',4713819,4716432),('946_11',4716433,4716781),('946_14',4716782,4717390),('946_201_1',4717391,4717755),('946_201',4717756,4718593),('946_202_1',4718594,4721807),('946_202_21',4721808,4726629),('946_202_8',4726630,4728580),('946_202',4728581,4730566),('946_203',4730567,4731442),('946_206_1',4731443,4731740),('946_206',4731741,4732856),('946_207',4732857,4733309),('946_209_2',4733310,4733945),('946_216',4733946,4734264),('946_231_10',4734265,4734909),('946_231_116_9',4734910,4735545),('946_231_11',4735546,4736192),('946_231_127_6',4736193,4737146),('946_231_128_9',4737147,4737709),('946_231_12',4737710,4738638),('946_231_132_1',4738639,4739202),('946_231_132_9',4739203,4740167),('946_231_138_1',4740168,4741081),('946_231_138_3',4741082,4741814),('946_231_13',4741815,4742655),('946_231_143_6',4742656,4746676),('946_231_148_9',4746677,4747016),('946_231_149_82',4747017,4748294),('946_231_157_5',4748295,4748818),('946_231_169_4',4748819,4749897),('946_231_16',4749898,4750875),('946_231_172_7',4750876,4753542),('946_231_175_8',4753543,4754099),('946_231_18',4754100,4754970),('946_231',4754971,4756479),('946_311',4756480,4757625),('946_31',4757626,4761501),('946_32',4761502,4763341),('946_39',4763342,4770338),('946_511',4770339,4771211),('946_512',4771212,4774182),('946_513_7',4774183,4774790),('946_513_8',4774791,4777784),('946_51',4777785,4782562),('951_11',4782563,4787234),('951_131',4787235,4791559),('951_153',4791560,4794855),('951_181',4794856,4795039),('951_191',4795040,4795176),('951_19',4795177,4795346),('951_251',4795347,4796521),('951_25',4796522,4797318),('951_311',4797319,4811663),('951_312',4811664,4823351),('951_31',4823352,4835411),('951_951',4835412,4835572),('951_95',4835573,4835770),('952_02',4835771,4841318),('952_03',4841319,4853586),('952_0',4853587,4861937),('952_111',4861938,4863206),('952_2',4863207,4863443),('952_812_32',4863444,4867109),('954_11',4867110,4872259),('954_193',4872260,4878291),('954_195_1',4878292,4886766),('954_195_2',4886767,4888592),('954_1',4888593,4894154),('955_021',4894155,4896871),('955_033_0',4896872,4904065),('955_071',4904066,4905530),('955_0',4905531,4909332),('955_23',4909333,4912100),('956_121',4912101,4914959),('956_122',4914960,4918035),('956_124',4918036,4918681),('956_161',4918682,4920480),('956_1',4920481,4925337),('957_1',4925338,4929194),('961_011_1',4929195,4929724),('961_011',4929725,4948087),('961_01',4948088,4955393),('971_119',4955394,4955470),('974_01',4955471,4957852),('974_03',4957853,4959014),('974_0',4959015,4960108),('974_11',4960109,4961074),('974_1',4961075,4962197),('979_1',4962198,4962641),('981_1',4962642,4963582),('981',4963583,4964258) /* from User: setup | Function: populate_corpus_cqp_positions() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update `text_metadata_for_SR201` inner join `___temp_cqp_text_positions_for_SR201` on `text_metadata_for_SR201`.text_id = `___temp_cqp_text_positions_for_SR201`.text_id set `text_metadata_for_SR201`.cqp_begin = `___temp_cqp_text_positions_for_SR201`.cqp_begin, `text_metadata_for_SR201`.cqp_end = `___temp_cqp_text_positions_for_SR201`.cqp_end /* from User: setup | Function: populate_corpus_cqp_positions() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: drop table `___temp_cqp_text_positions_for_SR201` /* from User: setup | Function: populate_corpus_cqp_positions() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update text_metadata_for_SR201 set words = cqp_end - cqp_begin + 1 /* from User: setup | Function: populate_corpus_cqp_positions() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select count(*) from text_metadata_for_SR201 /* from User: setup | Function: update_corpus_size() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select * from corpus_info where corpus = 'SR201' /* from User: setup | Function: get_corpus_info() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update corpus_info set size_tokens = 4964259, size_texts = 1955 where corpus = 'SR201' /* from User: setup | Function: update_corpus_size() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. Done populating corpus CQP positions. About to run the following MySQL query: select handle from text_metadata_fields where corpus = 'SR201' and datatype = 1 /* from User: setup | Function: ???() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the function calculating category sizes... About to run the following MySQL query: select handle from text_metadata_fields where corpus = 'SR201' and datatype = 1 /* from User: setup | Function: metadata_calculate_category_sizes() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select handle from text_metadata_values where corpus = 'SR201' and field_handle = 'text_lang' /* from User: setup | Function: metadata_calculate_category_sizes() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select count(*), sum(words) from text_metadata_for_SR201 where text_lang = 'de' /* from User: setup | Function: metadata_calculate_category_sizes() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update text_metadata_values set category_num_files = '1955', category_num_words = '4964259' where corpus = 'SR201' and field_handle = 'text_lang' and handle = 'de' /* from User: setup | Function: metadata_calculate_category_sizes() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. Done calculating category sizes. About to run the following MySQL query: select count(text_id) from text_metadata_for_SR201 /* from User: setup | Function: ???() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the function making the CWB text-by-text frequency index... About to run the following MySQL query: select * from corpus_info where corpus = 'SR201' /* from User: setup | Function: get_corpus_info() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select count(*) from text_metadata_for_SR201 /* from User: setup | Function: make_cwb_freq_index() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select handle, description from annotation_metadata where corpus = 'SR201' /* from User: setup | Function: get_corpus_annotations() | 2018-Apr-26 12:32:08 */ The query ran successfully in 0 seconds. Beginning to filter data from decode to encode to build the frequency-list-by-text CWB database... Usage error: invalid filename 'SR201__freq' for registry entry. Filename must not contain uppercase letters, '.' or '~'. Encoding of the frequency-list-by-text CWB database is now complete. Computation of huffman codes needs the CORPUS component Stage 1 (huffman code) compression of the frequency-list-by-text CWB database is now complete... Index compression requires the REVCORP component Stage 2 (compress-rdx) compression of the frequency-list-by-text CWB database is now complete... About to run the following MySQL query: select * from corpus_info where corpus = 'SR201' /* from User: setup | Function: get_corpus_info() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update corpus_info set size_bytes_index = 0 where id = 13 /* from User: setup | Function: update_corpus_index_size() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. Done with the frequency-list-by-text CWB database... About to run the following MySQL query: drop table if exists `freq_text_index_SR201` /* from User: setup | Function: make_cwb_freq_index() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE `freq_text_index_SR201` ( `start` int(11) unsigned NOT NULL, `end` int(11) unsigned NOT NULL, `text_id` varchar(50) NOT NULL, KEY `text_id` (`text_id`) ) CHARACTER SET utf8 COLLATE utf8_bin /* from User: setup | Function: make_cwb_freq_index() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: LOAD DATA LOCAL INFILE '/srv/cqpweb/cqpweb-tmp/SR201_freqdb_index.tbl' INTO TABLE `freq_text_index_SR201` FIELDS ESCAPED BY '' /* from User: setup | Function: make_cwb_freq_index() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select * from corpus_info where corpus = 'SR201' /* from User: setup | Function: get_corpus_info() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select sum(INDEX_LENGTH), sum(DATA_LENGTH) from information_schema.TABLES where TABLE_SCHEMA='cqpweb' and TABLE_NAME like 'freq_corpus_SR201%' /* from User: setup | Function: get_mysql_table_size() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select sum(INDEX_LENGTH), sum(DATA_LENGTH) from information_schema.TABLES where TABLE_SCHEMA='cqpweb' and TABLE_NAME like 'freq_text_index_SR201' /* from User: setup | Function: get_mysql_table_size() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update corpus_info set size_bytes_freq = 7553024 where id = 13 /* from User: setup | Function: update_corpus_freqtable_size() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. Done making the CWB text-by-text frequency index. About to run the function creating frequency tables. About to run the following MySQL query: select * from corpus_info where corpus = 'SR201' /* from User: setup | Function: get_corpus_info() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select handle, description from annotation_metadata where corpus = 'SR201' /* from User: setup | Function: get_corpus_annotations() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists __tempfreq_SR201 /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:32:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE __tempfreq_SR201 ( freq int(11) unsigned default NULL, word varchar(255) NOT NULL, deprel varchar(255) NOT NULL, head varchar(255) NOT NULL, lemma varchar(255) NOT NULL, morph varchar(255) NOT NULL, pos varchar(255) NOT NULL, tokpos varchar(255) NOT NULL, key (word), key (deprel), key (head), key (lemma), key (morph), key (pos), key (tokpos) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:32:20 */ The query ran successfully in 1 seconds. About to run the following MySQL query: alter table __tempfreq_SR201 disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:32:26 */ The query ran successfully in 0 seconds. About to run the following MySQL query: LOAD DATA LOCAL INFILE '/srv/cqpweb/cqpweb-tmp/______tempfreq_SR201.tbl' INTO TABLE `__tempfreq_SR201` FIELDS ESCAPED BY '' /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:32:26 */ The query ran successfully in 29 seconds. About to run the following MySQL query: alter table __tempfreq_SR201 enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:32:55 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists freq_corpus_SR201_word /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:32:55 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE freq_corpus_SR201_word ( freq int(11) unsigned default NULL, item varchar(255) NOT NULL, primary key(item) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:32:55 */ The query ran successfully in 0 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_word disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:32:55 */ The query ran successfully in 0 seconds. About to run the following MySQL query: INSERT INTO freq_corpus_SR201_word select sum(freq) as f, `word` as item from __tempfreq_SR201 group by `word` /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:32:55 */ The query ran successfully in 5 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_word enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:33:00 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists freq_corpus_SR201_deprel /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:00 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE freq_corpus_SR201_deprel ( freq int(11) unsigned default NULL, item varchar(255) NOT NULL, primary key(item) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:00 */ The query ran successfully in 0 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_deprel disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:33:00 */ The query ran successfully in 0 seconds. About to run the following MySQL query: INSERT INTO freq_corpus_SR201_deprel select sum(freq) as f, `deprel` as item from __tempfreq_SR201 group by `deprel` /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:00 */ The query ran successfully in 3 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_deprel enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:33:03 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists freq_corpus_SR201_head /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:03 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE freq_corpus_SR201_head ( freq int(11) unsigned default NULL, item varchar(255) NOT NULL, primary key(item) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:03 */ The query ran successfully in 0 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_head disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:33:03 */ The query ran successfully in 0 seconds. About to run the following MySQL query: INSERT INTO freq_corpus_SR201_head select sum(freq) as f, `head` as item from __tempfreq_SR201 group by `head` /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:03 */ The query ran successfully in 3 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_head enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:33:06 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists freq_corpus_SR201_lemma /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:06 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE freq_corpus_SR201_lemma ( freq int(11) unsigned default NULL, item varchar(255) NOT NULL, primary key(item) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:06 */ The query ran successfully in 0 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_lemma disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:33:06 */ The query ran successfully in 0 seconds. About to run the following MySQL query: INSERT INTO freq_corpus_SR201_lemma select sum(freq) as f, `lemma` as item from __tempfreq_SR201 group by `lemma` /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:06 */ The query ran successfully in 4 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_lemma enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:33:10 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists freq_corpus_SR201_morph /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:10 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE freq_corpus_SR201_morph ( freq int(11) unsigned default NULL, item varchar(255) NOT NULL, primary key(item) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:10 */ The query ran successfully in 0 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_morph disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:33:10 */ The query ran successfully in 0 seconds. About to run the following MySQL query: INSERT INTO freq_corpus_SR201_morph select sum(freq) as f, `morph` as item from __tempfreq_SR201 group by `morph` /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:10 */ The query ran successfully in 3 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_morph enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:33:13 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists freq_corpus_SR201_pos /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:13 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE freq_corpus_SR201_pos ( freq int(11) unsigned default NULL, item varchar(255) NOT NULL, primary key(item) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:13 */ The query ran successfully in 0 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_pos disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:33:13 */ The query ran successfully in 0 seconds. About to run the following MySQL query: INSERT INTO freq_corpus_SR201_pos select sum(freq) as f, `pos` as item from __tempfreq_SR201 group by `pos` /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:13 */ The query ran successfully in 3 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_pos enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:33:16 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists freq_corpus_SR201_tokpos /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:16 */ The query ran successfully in 0 seconds. About to run the following MySQL query: CREATE TABLE freq_corpus_SR201_tokpos ( freq int(11) unsigned default NULL, item varchar(255) NOT NULL, primary key(item) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:16 */ The query ran successfully in 0 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_tokpos disable keys /* from User: setup | Function: database_disable_keys() | 2018-Apr-26 12:33:16 */ The query ran successfully in 0 seconds. About to run the following MySQL query: INSERT INTO freq_corpus_SR201_tokpos select sum(freq) as f, `tokpos` as item from __tempfreq_SR201 group by `tokpos` /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:16 */ The query ran successfully in 3 seconds. About to run the following MySQL query: alter table freq_corpus_SR201_tokpos enable keys /* from User: setup | Function: database_enable_keys() | 2018-Apr-26 12:33:19 */ The query ran successfully in 0 seconds. About to run the following MySQL query: DROP TABLE if exists __tempfreq_SR201 /* from User: setup | Function: corpus_make_freqtables() | 2018-Apr-26 12:33:19 */ The query ran successfully in 1 seconds. About to run the following MySQL query: select * from corpus_info where corpus = 'SR201' /* from User: setup | Function: get_corpus_info() | 2018-Apr-26 12:33:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select sum(INDEX_LENGTH), sum(DATA_LENGTH) from information_schema.TABLES where TABLE_SCHEMA='cqpweb' and TABLE_NAME like 'freq_corpus_SR201%' /* from User: setup | Function: get_mysql_table_size() | 2018-Apr-26 12:33:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select sum(INDEX_LENGTH), sum(DATA_LENGTH) from information_schema.TABLES where TABLE_SCHEMA='cqpweb' and TABLE_NAME like 'freq_text_index_SR201' /* from User: setup | Function: get_mysql_table_size() | 2018-Apr-26 12:33:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update corpus_info set size_bytes_freq = 7716864 where id = 13 /* from User: setup | Function: update_corpus_freqtable_size() | 2018-Apr-26 12:33:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: show tables like 'freq_corpus_SR201_word' /* from User: setup | Function: update_corpus_n_types() | 2018-Apr-26 12:33:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: select count(*) from freq_corpus_SR201_word /* from User: setup | Function: update_corpus_n_types() | 2018-Apr-26 12:33:20 */ The query ran successfully in 0 seconds. About to run the following MySQL query: update corpus_info set size_types = 118008 where corpus = 'SR201' /* from User: setup | Function: update_corpus_n_types() | 2018-Apr-26 12:33:20 */ The query ran successfully in 0 seconds. Done creating frequency tables... ======================================================== Frequency-list setup for corpus SR201 is now complete. Began at: Thu, 26 Apr 2018 12:32:08 +0000 Finished at: Thu, 26 Apr 2018 12:33:20 +0000 CQPweb now terminates. ========================================================