trang/gist:eb29e33b5133b6179739554a491c8df9 Secret

## gistfile1.txt
MariaDB [tatoeba]> select count(*) from sentences;
+----------+
| count(*) |
+----------+
|  7799945 |
+----------+
1 row in set (2.09 sec)


MariaDB [tatoeba]> select lang, count(*) from sentences group by lang order by count(*);
+------+----------+
| lang | count(*) |
+------+----------+
| ssw  |        1 |
| tkl  |        1 |
| lou  |        1 |
| cyo  |        1 |
| urh  |        1 |
| crs  |        1 |
| mnc  |        1 |
| oji  |        1 |
| tsn  |        2 |
| aym  |        2 |
| sot  |        2 |
| kxi  |        2 |
| lug  |        2 |
| div  |        2 |
| tig  |        2 |
| gan  |        3 |
| snd  |        3 |
| tso  |        3 |
| osx  |        3 |
| ban  |        3 |
| gaa  |        3 |
| hak  |        3 |
| pfl  |        3 |
| hsn  |        4 |
| cos  |        4 |
| hnj  |        4 |
| mwl  |        4 |
| aii  |        5 |
| bcl  |        5 |
|      |        5 |
| alt  |        5 |
| bjn  |        5 |
| otk  |        5 |
| izh  |        6 |
| tmw  |        6 |
| cpi  |        6 |
| oar  |        6 |
| mfe  |        6 |
| mad  |        7 |
| fuc  |        7 |
| mdf  |        7 |
| quc  |        7 |
| sag  |        8 |
| mai  |        8 |
| mic  |        8 |
| kaa  |        8 |
| mnw  |        9 |
| jdt  |        9 |
| cjy  |        9 |
| kam  |       10 |
| brx  |       11 |
| nau  |       11 |
| gag  |       11 |
| vep  |       12 |
| bam  |       13 |
| non  |       14 |
| gil  |       14 |
| tvl  |       14 |
| nan  |       15 |
| vro  |       15 |
| fur  |       15 |
| nlv  |       15 |
| mvv  |       15 |
| srd  |       15 |
| lmo  |       17 |
| moh  |       17 |
| cay  |       18 |
| ngt  |       19 |
| scn  |       19 |
| roh  |       20 |
| enm  |       20 |
| tyv  |       20 |
| ibo  |       21 |
| ain  |       23 |
| rap  |       23 |
| kin  |       24 |
| myv  |       24 |
| kek  |       24 |
| ton  |       24 |
| aoz  |       24 |
| nya  |       25 |
| lkt  |       25 |
| vec  |       25 |
| jam  |       26 |
| ewe  |       26 |
| chr  |       26 |
| frm  |       27 |
| mah  |       27 |
| abk  |       27 |
| akl  |       27 |
| ksh  |       28 |
| aln  |       28 |
| che  |       28 |
| wol  |       28 |
| sco  |       29 |
| tah  |       29 |
| umb  |       30 |
| dng  |       30 |
| sun  |       31 |
| ady  |       31 |
| niu  |       32 |
| pau  |       34 |
| hif  |       34 |
| liv  |       34 |
| glv  |       34 |
| pnb  |       36 |
| cycl |       36 |
| gbm  |       36 |
| kjh  |       36 |
| yor  |       36 |
| fuv  |       36 |
| sjn  |       38 |
| lao  |       38 |
| nch  |       39 |
| bho  |       40 |
| lin  |       40 |
| iba  |       42 |
| sna  |       43 |
| ngu  |       43 |
| koi  |       43 |
| fij  |       43 |
| asm  |       43 |
| sin  |       44 |
| hil  |       44 |
| kpv  |       45 |
| apc  |       46 |
| sma  |       46 |
| sgs  |       47 |
| ike  |       48 |
| acm  |       49 |
| kas  |       49 |
| som  |       50 |
| tet  |       52 |
| ary  |       53 |
| wln  |       53 |
| krc  |       53 |
| mlg  |       55 |
| pag  |       55 |
| bvy  |       56 |
| bod  |       56 |
| lzz  |       56 |
| dws  |       57 |
| pdc  |       57 |
| pus  |       57 |
| ppl  |       59 |
| mgm  |       60 |
| rif  |       60 |
| hau  |       61 |
| zul  |       61 |
| tgk  |       64 |
| hat  |       64 |
| ext  |       66 |
| tly  |       66 |
| udm  |       67 |
| pap  |       67 |
| sme  |       67 |
| kal  |       75 |
| afh  |       79 |
| smo  |       81 |
| mww  |       82 |
| mrj  |       83 |
| cmo  |       85 |
| lld  |       86 |
| nav  |       86 |
| zlm  |       92 |
| tpi  |       92 |
| ldn  |       95 |
| shs  |       95 |
| cho  |       98 |
| tir  |      102 |
| arg  |      103 |
| pcd  |      107 |
| lij  |      108 |
| kum  |      110 |
| mya  |      113 |
| rue  |      116 |
| nog  |      116 |
| afb  |      119 |
| min  |      120 |
| npi  |      122 |
| ltz  |      129 |
| krl  |      130 |
| qya  |      133 |
| san  |      142 |
| egl  |      144 |
| ang  |      144 |
| bar  |      147 |
| fkv  |      151 |
| sux  |      152 |
| xho  |      153 |
| guj  |      169 |
| ast  |      177 |
| kan  |      181 |
| haw  |      182 |
| tzl  |      187 |
| bak  |      189 |
| pan  |      202 |
| shy  |      202 |
| nah  |      209 |
| amh  |      211 |
| mlt  |      211 |
| gsw  |      213 |
| fry  |      227 |
| oss  |      232 |
| kir  |      234 |
| tel  |      248 |
| awa  |      253 |
| got  |      266 |
| jav  |      296 |
| fao  |      305 |
| crh  |      309 |
| nov  |      311 |
| tam  |      322 |
| cha  |      345 |
| lad  |      346 |
| ori  |      359 |
| mri  |      367 |
| que  |      411 |
| max  |      427 |
| swh  |      465 |
| NULL |      495 |
| ckt  |      531 |
| bos  |      546 |
| mon  |      559 |
| tpw  |      560 |
| thv  |      566 |
| arz  |      612 |
| kur  |      624 |
| hoc  |      651 |
| uzb  |      680 |
| grc  |      734 |
| hrx  |      741 |
| dsb  |      758 |
| hsb  |      776 |
| rom  |      787 |
| nst  |      793 |
| bua  |      803 |
| zza  |      816 |
| pms  |      823 |
| mal  |      827 |
| prg  |      838 |
| xal  |      869 |
| csb  |      880 |
| sah  |      926 |
| cym  |      971 |
| gla  |     1005 |
| slv  |     1058 |
| swg  |     1109 |
| grn  |     1117 |
| tha  |     1190 |
| sqi  |     1272 |
| kat  |     1278 |
| ota  |     1279 |
| orv  |     1306 |
| nno  |     1325 |
| kha  |     1332 |
| gcf  |     1348 |
| ceb  |     1432 |
| pam  |     1482 |
| khm  |     1502 |
| chv  |     1530 |
| yid  |     1638 |
| lzh  |     1822 |
| lvs  |     1895 |
| urd  |     1936 |
| kzj  |     1953 |
| war  |     2026 |
| arq  |     2073 |
| hye  |     2247 |
| gle  |     2313 |
| zsm  |     2357 |
| ilo  |     2454 |
| run  |     2479 |
| dtp  |     2490 |
| cbk  |     2568 |
| kaz  |     2610 |
| est  |     2984 |
| vol  |     2994 |
| gos  |     3113 |
| slk  |     3884 |
| avk  |     3909 |
| cor  |     3909 |
| afr  |     3926 |
| kor  |     4067 |
| mhr  |     4300 |
| wuu  |     4312 |
| glg  |     4400 |
| ben  |     4693 |
| aze  |     4998 |
| hrv  |     5115 |
| ido  |     5119 |
| oci  |     5625 |
| yue  |     5916 |
| cat  |     5995 |
| eus  |     6063 |
| ile  |     6245 |
| tuk  |     6724 |
| bre  |     7125 |
| uig  |     7595 |
| lfn  |     7880 |
| vie  |    10424 |
| bel  |    11008 |
| isl  |    11068 |
| hin  |    12091 |
| ind  |    12376 |
| tgl  |    13364 |
| tat  |    13518 |
| nob  |    13563 |
| jbo  |    15466 |
| tlh  |    17228 |
| nds  |    17568 |
| ron  |    18390 |
| pes  |    21199 |
| ina  |    23740 |
| bul  |    24229 |
| ell  |    30421 |
| srp  |    30551 |
| lat  |    32746 |
| toki |    33159 |
| ara  |    33483 |
| ces  |    34225 |
| swe  |    35033 |
| lit  |    35552 |
| dan  |    42715 |
| mar  |    51292 |
| cmn  |    60912 |
| mkd  |    77778 |
| nld  |    98799 |
| pol  |    99366 |
| fin  |   100242 |
| kab  |   100437 |
| ukr  |   150845 |
| jpn  |   187351 |
| heb  |   195052 |
| ber  |   205557 |
| hun  |   257481 |
| spa  |   311332 |
| por  |   335893 |
| fra  |   398937 |
| deu  |   475826 |
| epo  |   602893 |
| tur  |   674888 |
| rus  |   713691 |
| ita  |   729476 |
| eng  |  1220425 |
+------+----------+
345 rows in set (3.24 sec)
	MariaDB [tatoeba]> select count(*) from sentences;
	+----------+
	\| count(*) \|
	+----------+
	\| 7799945 \|
	+----------+
	1 row in set (2.09 sec)


	MariaDB [tatoeba]> select lang, count() from sentences group by lang order by count();
	+------+----------+
	\| lang \| count(*) \|
	+------+----------+
	\| ssw \| 1 \|
	\| tkl \| 1 \|
	\| lou \| 1 \|
	\| cyo \| 1 \|
	\| urh \| 1 \|
	\| crs \| 1 \|
	\| mnc \| 1 \|
	\| oji \| 1 \|
	\| tsn \| 2 \|
	\| aym \| 2 \|
	\| sot \| 2 \|
	\| kxi \| 2 \|
	\| lug \| 2 \|
	\| div \| 2 \|
	\| tig \| 2 \|
	\| gan \| 3 \|
	\| snd \| 3 \|
	\| tso \| 3 \|
	\| osx \| 3 \|
	\| ban \| 3 \|
	\| gaa \| 3 \|
	\| hak \| 3 \|
	\| pfl \| 3 \|
	\| hsn \| 4 \|
	\| cos \| 4 \|
	\| hnj \| 4 \|
	\| mwl \| 4 \|
	\| aii \| 5 \|
	\| bcl \| 5 \|
	\| \| 5 \|
	\| alt \| 5 \|
	\| bjn \| 5 \|
	\| otk \| 5 \|
	\| izh \| 6 \|
	\| tmw \| 6 \|
	\| cpi \| 6 \|
	\| oar \| 6 \|
	\| mfe \| 6 \|
	\| mad \| 7 \|
	\| fuc \| 7 \|
	\| mdf \| 7 \|
	\| quc \| 7 \|
	\| sag \| 8 \|
	\| mai \| 8 \|
	\| mic \| 8 \|
	\| kaa \| 8 \|
	\| mnw \| 9 \|
	\| jdt \| 9 \|
	\| cjy \| 9 \|
	\| kam \| 10 \|
	\| brx \| 11 \|
	\| nau \| 11 \|
	\| gag \| 11 \|
	\| vep \| 12 \|
	\| bam \| 13 \|
	\| non \| 14 \|
	\| gil \| 14 \|
	\| tvl \| 14 \|
	\| nan \| 15 \|
	\| vro \| 15 \|
	\| fur \| 15 \|
	\| nlv \| 15 \|
	\| mvv \| 15 \|
	\| srd \| 15 \|
	\| lmo \| 17 \|
	\| moh \| 17 \|
	\| cay \| 18 \|
	\| ngt \| 19 \|
	\| scn \| 19 \|
	\| roh \| 20 \|
	\| enm \| 20 \|
	\| tyv \| 20 \|
	\| ibo \| 21 \|
	\| ain \| 23 \|
	\| rap \| 23 \|
	\| kin \| 24 \|
	\| myv \| 24 \|
	\| kek \| 24 \|
	\| ton \| 24 \|
	\| aoz \| 24 \|
	\| nya \| 25 \|
	\| lkt \| 25 \|
	\| vec \| 25 \|
	\| jam \| 26 \|
	\| ewe \| 26 \|
	\| chr \| 26 \|
	\| frm \| 27 \|
	\| mah \| 27 \|
	\| abk \| 27 \|
	\| akl \| 27 \|
	\| ksh \| 28 \|
	\| aln \| 28 \|
	\| che \| 28 \|
	\| wol \| 28 \|
	\| sco \| 29 \|
	\| tah \| 29 \|
	\| umb \| 30 \|
	\| dng \| 30 \|
	\| sun \| 31 \|
	\| ady \| 31 \|
	\| niu \| 32 \|
	\| pau \| 34 \|
	\| hif \| 34 \|
	\| liv \| 34 \|
	\| glv \| 34 \|
	\| pnb \| 36 \|
	\| cycl \| 36 \|
	\| gbm \| 36 \|
	\| kjh \| 36 \|
	\| yor \| 36 \|
	\| fuv \| 36 \|
	\| sjn \| 38 \|
	\| lao \| 38 \|
	\| nch \| 39 \|
	\| bho \| 40 \|
	\| lin \| 40 \|
	\| iba \| 42 \|
	\| sna \| 43 \|
	\| ngu \| 43 \|
	\| koi \| 43 \|
	\| fij \| 43 \|
	\| asm \| 43 \|
	\| sin \| 44 \|
	\| hil \| 44 \|
	\| kpv \| 45 \|
	\| apc \| 46 \|
	\| sma \| 46 \|
	\| sgs \| 47 \|
	\| ike \| 48 \|
	\| acm \| 49 \|
	\| kas \| 49 \|
	\| som \| 50 \|
	\| tet \| 52 \|
	\| ary \| 53 \|
	\| wln \| 53 \|
	\| krc \| 53 \|
	\| mlg \| 55 \|
	\| pag \| 55 \|
	\| bvy \| 56 \|
	\| bod \| 56 \|
	\| lzz \| 56 \|
	\| dws \| 57 \|
	\| pdc \| 57 \|
	\| pus \| 57 \|
	\| ppl \| 59 \|
	\| mgm \| 60 \|
	\| rif \| 60 \|
	\| hau \| 61 \|
	\| zul \| 61 \|
	\| tgk \| 64 \|
	\| hat \| 64 \|
	\| ext \| 66 \|
	\| tly \| 66 \|
	\| udm \| 67 \|
	\| pap \| 67 \|
	\| sme \| 67 \|
	\| kal \| 75 \|
	\| afh \| 79 \|
	\| smo \| 81 \|
	\| mww \| 82 \|
	\| mrj \| 83 \|
	\| cmo \| 85 \|
	\| lld \| 86 \|
	\| nav \| 86 \|
	\| zlm \| 92 \|
	\| tpi \| 92 \|
	\| ldn \| 95 \|
	\| shs \| 95 \|
	\| cho \| 98 \|
	\| tir \| 102 \|
	\| arg \| 103 \|
	\| pcd \| 107 \|
	\| lij \| 108 \|
	\| kum \| 110 \|
	\| mya \| 113 \|
	\| rue \| 116 \|
	\| nog \| 116 \|
	\| afb \| 119 \|
	\| min \| 120 \|
	\| npi \| 122 \|
	\| ltz \| 129 \|
	\| krl \| 130 \|
	\| qya \| 133 \|
	\| san \| 142 \|
	\| egl \| 144 \|
	\| ang \| 144 \|
	\| bar \| 147 \|
	\| fkv \| 151 \|
	\| sux \| 152 \|
	\| xho \| 153 \|
	\| guj \| 169 \|
	\| ast \| 177 \|
	\| kan \| 181 \|
	\| haw \| 182 \|
	\| tzl \| 187 \|
	\| bak \| 189 \|
	\| pan \| 202 \|
	\| shy \| 202 \|
	\| nah \| 209 \|
	\| amh \| 211 \|
	\| mlt \| 211 \|
	\| gsw \| 213 \|
	\| fry \| 227 \|
	\| oss \| 232 \|
	\| kir \| 234 \|
	\| tel \| 248 \|
	\| awa \| 253 \|
	\| got \| 266 \|
	\| jav \| 296 \|
	\| fao \| 305 \|
	\| crh \| 309 \|
	\| nov \| 311 \|
	\| tam \| 322 \|
	\| cha \| 345 \|
	\| lad \| 346 \|
	\| ori \| 359 \|
	\| mri \| 367 \|
	\| que \| 411 \|
	\| max \| 427 \|
	\| swh \| 465 \|
	\| NULL \| 495 \|
	\| ckt \| 531 \|
	\| bos \| 546 \|
	\| mon \| 559 \|
	\| tpw \| 560 \|
	\| thv \| 566 \|
	\| arz \| 612 \|
	\| kur \| 624 \|
	\| hoc \| 651 \|
	\| uzb \| 680 \|
	\| grc \| 734 \|
	\| hrx \| 741 \|
	\| dsb \| 758 \|
	\| hsb \| 776 \|
	\| rom \| 787 \|
	\| nst \| 793 \|
	\| bua \| 803 \|
	\| zza \| 816 \|
	\| pms \| 823 \|
	\| mal \| 827 \|
	\| prg \| 838 \|
	\| xal \| 869 \|
	\| csb \| 880 \|
	\| sah \| 926 \|
	\| cym \| 971 \|
	\| gla \| 1005 \|
	\| slv \| 1058 \|
	\| swg \| 1109 \|
	\| grn \| 1117 \|
	\| tha \| 1190 \|
	\| sqi \| 1272 \|
	\| kat \| 1278 \|
	\| ota \| 1279 \|
	\| orv \| 1306 \|
	\| nno \| 1325 \|
	\| kha \| 1332 \|
	\| gcf \| 1348 \|
	\| ceb \| 1432 \|
	\| pam \| 1482 \|
	\| khm \| 1502 \|
	\| chv \| 1530 \|
	\| yid \| 1638 \|
	\| lzh \| 1822 \|
	\| lvs \| 1895 \|
	\| urd \| 1936 \|
	\| kzj \| 1953 \|
	\| war \| 2026 \|
	\| arq \| 2073 \|
	\| hye \| 2247 \|
	\| gle \| 2313 \|
	\| zsm \| 2357 \|
	\| ilo \| 2454 \|
	\| run \| 2479 \|
	\| dtp \| 2490 \|
	\| cbk \| 2568 \|
	\| kaz \| 2610 \|
	\| est \| 2984 \|
	\| vol \| 2994 \|
	\| gos \| 3113 \|
	\| slk \| 3884 \|
	\| avk \| 3909 \|
	\| cor \| 3909 \|
	\| afr \| 3926 \|
	\| kor \| 4067 \|
	\| mhr \| 4300 \|
	\| wuu \| 4312 \|
	\| glg \| 4400 \|
	\| ben \| 4693 \|
	\| aze \| 4998 \|
	\| hrv \| 5115 \|
	\| ido \| 5119 \|
	\| oci \| 5625 \|
	\| yue \| 5916 \|
	\| cat \| 5995 \|
	\| eus \| 6063 \|
	\| ile \| 6245 \|
	\| tuk \| 6724 \|
	\| bre \| 7125 \|
	\| uig \| 7595 \|
	\| lfn \| 7880 \|
	\| vie \| 10424 \|
	\| bel \| 11008 \|
	\| isl \| 11068 \|
	\| hin \| 12091 \|
	\| ind \| 12376 \|
	\| tgl \| 13364 \|
	\| tat \| 13518 \|
	\| nob \| 13563 \|
	\| jbo \| 15466 \|
	\| tlh \| 17228 \|
	\| nds \| 17568 \|
	\| ron \| 18390 \|
	\| pes \| 21199 \|
	\| ina \| 23740 \|
	\| bul \| 24229 \|
	\| ell \| 30421 \|
	\| srp \| 30551 \|
	\| lat \| 32746 \|
	\| toki \| 33159 \|
	\| ara \| 33483 \|
	\| ces \| 34225 \|
	\| swe \| 35033 \|
	\| lit \| 35552 \|
	\| dan \| 42715 \|
	\| mar \| 51292 \|
	\| cmn \| 60912 \|
	\| mkd \| 77778 \|
	\| nld \| 98799 \|
	\| pol \| 99366 \|
	\| fin \| 100242 \|
	\| kab \| 100437 \|
	\| ukr \| 150845 \|
	\| jpn \| 187351 \|
	\| heb \| 195052 \|
	\| ber \| 205557 \|
	\| hun \| 257481 \|
	\| spa \| 311332 \|
	\| por \| 335893 \|
	\| fra \| 398937 \|
	\| deu \| 475826 \|
	\| epo \| 602893 \|
	\| tur \| 674888 \|
	\| rus \| 713691 \|
	\| ita \| 729476 \|
	\| eng \| 1220425 \|
	+------+----------+
	345 rows in set (3.24 sec)