 |
|
| node: | Re[4]: 29.01.2013-11:25:41 |
| template: | 4 |
| parent: | Re[3]: 29.01.2013-11:25:41 |
| owner: | psycho |
| viewed by: | |
| created: | 11.04.2013 - 16:15:23 |
| updated: | 11.04.2013 - 16:21:20 |
|
cwbe coordinatez: 101 63532 63753 7030712 7030752 7030843 7132234 7132256 ABSOLUT KYBERIA |
| permissions | |
| you: | r, |
| system: | public |
| net: | yes |
total descendants::3
total children::3
3 ❤️
2 hlavne zdroje su nejaky wordlist z opensubtitles slovenskych tituliek, a druhy wikipedia
N = N_SUBS + N_WIKI
zaujimave su najma tie rozdiely, ze niektore slova sa pouzivaju len v subtitles, a niektore len na wiki :)
select * from word2 order by n desc limit 10
select * from word2 where n_wiki < 10 order by n_subs
select * from word2 where n_subs < 10 order by n_wiki desc limit 10
N = N_SUBS + N_WIKI
zaujimave su najma tie rozdiely, ze niektore slova sa pouzivaju len v subtitles, a niektore len na wiki :)
select * from word2 order by n desc limit 10
| WORD | N | N_SUBS | N_WIKI |
| a | 824912 | 189462 | 635449 |
| v | 790766 | 108932 | 681833 |
| je | 639788 | 238033 | 401754 |
| sa | 635631 | 242581 | 393049 |
| na | 466848 | 146872 | 319975 |
| to | 365449 | 327146 | 38302 |
| si | 216814 | 194291 | 22522 |
| s | 203466 | 64268 | 139197 |
| ako | 192420 | 83907 | 108512 |
| z | 189312 | 41845 | 147466 |
select * from word2 where n_wiki < 10 order by n_subs
| WORD | N | N_SUBS | N_WIKI |
| ďakujem | 13112 | 13106 | 5 |
| ahoj | 10966 | 10961 | 4 |
| poďme | 9928 | 9926 | 1 |
| poď | 9830 | 9822 | 7 |
| myslíš | 8657 | 8650 | 6 |
| bože | 8089 | 8083 | 5 |
| robíš | 6429 | 6424 | 4 |
| choď | 6259 | 6250 | 8 |
| prepáčte | 5971 | 5969 | 1 |
| prepáč | 5841 | 5840 | 0 |
select * from word2 where n_subs < 10 order by n_wiki desc limit 10
| WORD | N | N_SUBS | N_WIKI |
| V | 120368 | 0 | 120367 |
| rozlohu | 43864 | 8 | 43855 |
| Obyvateľstvo | 38126 | 0 | 38125 |
| Najvyšší | 37009 | 0 | 37008 |
| Poloha | 36872 | 0 | 36871 |
| položený | 36791 | 5 | 36785 |
| departemente | 36772 | 0 | 36771 |
| najnižší | 36668 | 9 | 36658 |
| Obec | 36635 | 0 | 36634 |
| Počet | 35682 | 0 | 35681 |