Skip to content

Instantly share code, notes, and snippets.

@trang
Created May 15, 2020 22:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save trang/0f474fa5825895beb52caedb4c678c46 to your computer and use it in GitHub Desktop.
Save trang/0f474fa5825895beb52caedb4c678c46 to your computer and use it in GitHub Desktop.
Source language for German sentences
MariaDB [tatoeba]> select t.lang, count(*) from sentences s join sentences t on s.based_on_id = t.id where s.lang = 'deu' group by t.lang order by count(*) desc;
+------+----------+
| lang | count(*) |
+------+----------+
| eng | 225347 |
| epo | 49216 |
| fra | 40064 |
| jpn | 19848 |
| rus | 14355 |
| spa | 12017 |
| ita | 6769 |
| toki | 6337 |
| nld | 5554 |
| nds | 4250 |
| nob | 4212 |
| hun | 3994 |
| cmn | 3566 |
| fin | 3349 |
| tur | 3117 |
| deu | 1744 |
| swe | 1704 |
| por | 1658 |
| pol | 1287 |
| ell | 1064 |
| dan | 956 |
| lat | 796 |
| ceb | 643 |
| jbo | 542 |
| kor | 477 |
| isl | 437 |
| ara | 415 |
| swg | 362 |
| ces | 295 |
| pes | 292 |
| ind | 263 |
| eus | 223 |
| lit | 207 |
| tgl | 204 |
| ukr | 201 |
| tlh | 189 |
| ltz | 187 |
| tat | 186 |
| hrv | 147 |
| heb | 133 |
| kur | 126 |
| yid | 109 |
| est | 100 |
| run | 93 |
| ina | 85 |
| gla | 77 |
| grc | 61 |
| kat | 56 |
| bul | 54 |
| afr | 52 |
| lvs | 51 |
| hin | 49 |
| ksh | 47 |
| ber | 41 |
| srp | 41 |
| ron | 37 |
| bar | 33 |
| yue | 31 |
| cat | 29 |
| mhr | 28 |
| ile | 27 |
| vie | 26 |
| aze | 24 |
| nno | 22 |
| kab | 20 |
| ido | 19 |
| slk | 18 |
| swh | 16 |
| gsw | 16 |
| ast | 16 |
| zsm | 16 |
| bel | 14 |
| oci | 14 |
| orv | 13 |
| sme | 13 |
| ang | 13 |
| sjn | 12 |
| cor | 11 |
| vol | 11 |
| gle | 10 |
| urd | 8 |
| lzh | 8 |
| roh | 8 |
| prg | 8 |
| tha | 7 |
| sah | 7 |
| war | 7 |
| uig | 6 |
| NULL | 6 |
| glg | 6 |
| wuu | 6 |
| slv | 6 |
| lld | 5 |
| mlt | 5 |
| hsb | 5 |
| frr | 4 |
| kan | 4 |
| fry | 4 |
| hye | 4 |
| kaz | 3 |
| acm | 2 |
| qya | 2 |
| bre | 2 |
| chv | 2 |
| pdc | 2 |
| dsb | 2 |
| mar | 2 |
| mon | 2 |
| mkd | 2 |
| bak | 2 |
| uzb | 2 |
| gos | 2 |
| ben | 2 |
| sux | 2 |
| frm | 2 |
| ota | 1 |
| pfl | 1 |
| xal | 1 |
| tsn | 1 |
| lfn | 1 |
| hau | 1 |
| cycl | 1 |
| lad | 1 |
| cym | 1 |
| fao | 1 |
| ain | 1 |
| tpi | 1 |
| pms | 1 |
| xho | 1 |
| mah | 1 |
| que | 1 |
| nah | 1 |
| stq | 1 |
+------+----------+
133 rows in set (6.91 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment