API tools faq
paste
Advertisement
westand

Medical content growth by lang. in 2013 (Wikidata effects)

westand
Mar 3rd, 2014
88
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.78 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)) as LANG,
  2. -> SUM(bytes_end_2012) AS END_2012, SUM(bytes_end_2013) as END_2013,
  3. -> (SUM(bytes_end_2013)/SUM(bytes_end_2012)) AS GROWTH FROM wp_med_monthly GROUP BY
  4. -> SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE))
  5. -> ORDER BY (1.0*SUM(bytes_end_2013)/SUM(bytes_end_2012)) DESC;
  6.  
  7. +---------------+-----------+-----------+---------+
  8. | LANG | END_2012 | END_2013 | GROWTH |
  9. +---------------+-----------+-----------+---------+
  10. | ce | 6967 | 99725 | 14.3139 |
  11. | uz | 114961 | 531958 | 4.6273 |
  12. | pa | 65205 | 162952 | 2.4991 |
  13. | ceb | 102554 | 203564 | 1.9849 |
  14. | ba | 120641 | 221146 | 1.8331 |
  15. | tt | 262750 | 462430 | 1.7600 |
  16. | or | 669414 | 1090753 | 1.6294 |
  17. | hy | 1111385 | 1731425 | 1.5579 |
  18. | ilo | 91186 | 118081 | 1.2949 |
  19. | gl | 6941075 | 8684699 | 1.2512 |
  20. | fa | 12556638 | 14647002 | 1.1665 |
  21. | ml | 3921668 | 4485948 | 1.1439 |
  22. | uk | 14976080 | 16899378 | 1.1284 |
  23. | ar | 23528403 | 26456419 | 1.1244 |
  24. | be | 1494203 | 1652326 | 1.1058 |
  25. | frr | 31600 | 34447 | 1.0901 |
  26. | tk | 230309 | 250140 | 1.0861 |
  27. | sh | 4799958 | 5204759 | 1.0843 |
  28. | be-x-old | 885935 | 956316 | 1.0794 |
  29. | en | 224463488 | 241092406 | 1.0741 |
  30. | el | 9912227 | 10622610 | 1.0717 |
  31. | ru | 44967604 | 47912770 | 1.0655 |
  32. | mk | 4978443 | 5282581 | 1.0611 |
  33. | it | 41458050 | 43681804 | 1.0536 |
  34. | fr | 54439202 | 57166244 | 1.0501 |
  35. | sl | 6347902 | 6633744 | 1.0450 |
  36. | hr | 6505291 | 6787446 | 1.0434 |
  37. | ja | 34353641 | 35740748 | 1.0404 |
  38. | es | 49857796 | 51432728 | 1.0316 |
  39. | ro | 6836050 | 7044444 | 1.0305 |
  40. | hu | 12585702 | 12962443 | 1.0299 |
  41. | sw | 2642485 | 2708095 | 1.0248 |
  42. | de | 64147461 | 65536100 | 1.0216 |
  43. | vi | 7405699 | 7538054 | 1.0179 |
  44. | ta | 8681809 | 8822604 | 1.0162 |
  45. | et | 3374860 | 3425366 | 1.0150 |
  46. | he | 19472216 | 19745052 | 1.0140 |
  47. | ckb | 493361 | 499209 | 1.0119 |
  48. | hi | 12112630 | 12222399 | 1.0091 |
  49. | as | 648722 | 654267 | 1.0085 |
  50. | bn | 1780657 | 1795236 | 1.0082 |
  51. | nb | 10758 | 10758 | 1.0000 |
  52. | km | 103359 | 103097 | 0.9975 |
  53. | te | 6806231 | 6787225 | 0.9972 |
  54. | pt | 25032002 | 24942527 | 0.9964 |
  55. | gu | 3350775 | 3324668 | 0.9922 |
  56. | zh | 15127046 | 14989334 | 0.9909 |
  57. | tn | 3293 | 3263 | 0.9909 |
  58. | th | 5694886 | 5633837 | 0.9893 |
  59. | sr | 15258509 | 15039312 | 0.9856 |
  60. | sa | 232451 | 229007 | 0.9852 |
  61. | bg | 8769712 | 8610831 | 0.9819 |
  62. | ne | 2194470 | 2150749 | 0.9801 |
  63. | kn | 6618786 | 6483706 | 0.9796 |
  64. | pl | 28674017 | 27915262 | 0.9735 |
  65. | ms | 3876646 | 3704326 | 0.9555 |
  66. | cs | 12942616 | 12335880 | 0.9531 |
  67. | id | 7273165 | 6889780 | 0.9473 |
  68. | roa-tara | 115507 | 108973 | 0.9434 |
  69. | nl | 19464902 | 18358656 | 0.9432 |
  70. | ca | 18360473 | 17315397 | 0.9431 |
  71. | my | 1364789 | 1284064 | 0.9409 |
  72. | si | 1588551 | 1490740 | 0.9384 |
  73. | ka | 1993782 | 1869361 | 0.9376 |
  74. | mr | 1204635 | 1128630 | 0.9369 |
  75. | tl | 2250906 | 2106901 | 0.9360 |
  76. | fi | 11847119 | 10987769 | 0.9275 |
  77. | sv | 12682305 | 11700564 | 0.9226 |
  78. | gv | 132856 | 121122 | 0.9117 |
  79. | kk | 2825482 | 2563088 | 0.9071 |
  80. | no | 9802074 | 8887764 | 0.9067 |
  81. | az | 2063027 | 1869185 | 0.9060 |
  82. | tr | 8378376 | 7582816 | 0.9050 |
  83. | ko | 6885073 | 6225905 | 0.9043 |
  84. | mhr | 49065 | 44329 | 0.9035 |
  85. | zh-yue | 469959 | 424161 | 0.9025 |
  86. | jv | 1240051 | 1117801 | 0.9014 |
  87. | mwl | 246717 | 221609 | 0.8982 |
  88. | simple | 4623934 | 4146653 | 0.8968 |
  89. | nds | 1016377 | 902076 | 0.8875 |
  90. | da | 5224149 | 4632992 | 0.8868 |
  91. | new | 437330 | 384365 | 0.8789 |
  92. | su | 1294359 | 1119375 | 0.8648 |
  93. | ast | 1136414 | 974862 | 0.8578 |
  94. | ny | 482 | 412 | 0.8548 |
  95. | dv | 1499466 | 1278010 | 0.8523 |
  96. | sco | 54255 | 46240 | 0.8523 |
  97. | sk | 4198340 | 3557275 | 0.8473 |
  98. | ky | 2436742 | 2064051 | 0.8471 |
  99. | lt | 3713736 | 3140117 | 0.8455 |
  100. | ps | 756368 | 621062 | 0.8211 |
  101. | sq | 1675988 | 1369080 | 0.8169 |
  102. | als | 428793 | 350181 | 0.8167 |
  103. | bs | 2621781 | 2136781 | 0.8150 |
  104. | pam | 308250 | 250801 | 0.8136 |
  105. | eu | 3120989 | 2512717 | 0.8051 |
  106. | mn | 410425 | 328497 | 0.8004 |
  107. | af | 1116140 | 891315 | 0.7986 |
  108. | lv | 1914084 | 1526413 | 0.7975 |
  109. | fy | 747778 | 588282 | 0.7867 |
  110. | am | 139256 | 109519 | 0.7865 |
  111. | ga | 675743 | 522543 | 0.7733 |
  112. | eo | 3015054 | 2327091 | 0.7718 |
  113. | mt | 160566 | 122693 | 0.7641 |
  114. | cv | 210844 | 160811 | 0.7627 |
  115. | nn | 1886990 | 1432345 | 0.7591 |
  116. | arz | 496845 | 367231 | 0.7391 |
  117. | eml | 10630 | 7730 | 0.7272 |
  118. | ur | 1408771 | 1019122 | 0.7234 |
  119. | li | 144174 | 104217 | 0.7229 |
  120. | yi | 845068 | 608096 | 0.7196 |
  121. | is | 1550780 | 1111807 | 0.7169 |
  122. | mzn | 160447 | 114989 | 0.7167 |
  123. | lb | 481629 | 332145 | 0.6896 |
  124. | myv | 30710 | 21141 | 0.6884 |
  125. | la | 1317352 | 902017 | 0.6847 |
  126. | ia | 398365 | 271487 | 0.6815 |
  127. | co | 18451 | 12571 | 0.6813 |
  128. | bar | 131589 | 88717 | 0.6742 |
  129. | lo | 17215 | 11593 | 0.6734 |
  130. | cy | 993017 | 666526 | 0.6712 |
  131. | pnb | 387410 | 256934 | 0.6632 |
  132. | oc | 786561 | 516193 | 0.6563 |
  133. | wa | 238665 | 156434 | 0.6555 |
  134. | br | 616680 | 402942 | 0.6534 |
  135. | bpy | 11911 | 7782 | 0.6533 |
  136. | war | 331011 | 214669 | 0.6485 |
  137. | ace | 18756 | 12139 | 0.6472 |
  138. | zu | 18024 | 11199 | 0.6213 |
  139. | nv | 65012 | 40099 | 0.6168 |
  140. | nds-nl | 93602 | 57715 | 0.6166 |
  141. | vls | 71247 | 43388 | 0.6090 |
  142. | fo | 154214 | 93536 | 0.6065 |
  143. | pms | 105359 | 63770 | 0.6053 |
  144. | ku | 443144 | 265081 | 0.5982 |
  145. | xmf | 41287 | 24646 | 0.5969 |
  146. | kbd | 17361 | 10222 | 0.5888 |
  147. | nap | 41892 | 24450 | 0.5836 |
  148. | bh | 2317 | 1337 | 0.5770 |
  149. | an | 432220 | 249028 | 0.5762 |
  150. | lij | 89385 | 51362 | 0.5746 |
  151. | tg | 147911 | 84456 | 0.5710 |
  152. | stq | 52129 | 29636 | 0.5685 |
  153. | hsb | 31287 | 17697 | 0.5656 |
  154. | pap | 24882 | 13994 | 0.5624 |
  155. | vec | 85837 | 48200 | 0.5615 |
  156. | ksh | 74483 | 41393 | 0.5557 |
  157. | map-bms | 31840 | 17590 | 0.5524 |
  158. | vep | 30908 | 16940 | 0.5481 |
  159. | lad | 25896 | 14173 | 0.5473 |
  160. | sah | 148062 | 79366 | 0.5360 |
  161. | bjn | 92083 | 48855 | 0.5306 |
  162. | fur | 47547 | 25147 | 0.5289 |
  163. | zh-min-nan | 499128 | 260162 | 0.5212 |
  164. | krc | 15215 | 7910 | 0.5199 |
  165. | to | 5783 | 3005 | 0.5196 |
  166. | vo | 31920 | 16302 | 0.5107 |
  167. | om | 33983 | 17301 | 0.5091 |
  168. | mg | 48018 | 24146 | 0.5029 |
  169. | ha | 19091 | 9241 | 0.4841 |
  170. | lmo | 74680 | 35799 | 0.4794 |
  171. | ln | 166399 | 78475 | 0.4716 |
  172. | rw | 62073 | 29221 | 0.4708 |
  173. | wuu | 86827 | 40728 | 0.4691 |
  174. | tum | 8917 | 4139 | 0.4642 |
  175. | so | 105456 | 46558 | 0.4415 |
  176. | yo | 159681 | 70441 | 0.4411 |
  177. | min | 9330 | 4040 | 0.4330 |
  178. | jbo | 46434 | 19600 | 0.4221 |
  179. | lez | 28953 | 12123 | 0.4187 |
  180. | ie | 16106 | 6603 | 0.4100 |
  181. | szl | 60228 | 24316 | 0.4037 |
  182. | scn | 325323 | 129081 | 0.3968 |
  183. | kab | 13926 | 5475 | 0.3931 |
  184. | ug | 73075 | 28553 | 0.3907 |
  185. | sn | 79388 | 30706 | 0.3868 |
  186. | ang | 29856 | 11488 | 0.3848 |
  187. | os | 43119 | 16511 | 0.3829 |
  188. | zh-classical | 29475 | 11018 | 0.3738 |
  189. | dsb | 8047 | 2940 | 0.3654 |
  190. | bat-smg | 185521 | 67089 | 0.3616 |
  191. | hif | 108438 | 39107 | 0.3606 |
  192. | nov | 36175 | 12999 | 0.3593 |
  193. | kw | 15008 | 5379 | 0.3584 |
  194. | mi | 11491 | 4095 | 0.3564 |
  195. | fj | 875 | 310 | 0.3543 |
  196. | cu | 2630 | 929 | 0.3532 |
  197. | csb | 18004 | 6352 | 0.3528 |
  198. | ht | 220265 | 77623 | 0.3524 |
  199. | rue | 97507 | 34245 | 0.3512 |
  200. | ig | 9445 | 3294 | 0.3488 |
  201. | sc | 26579 | 9109 | 0.3427 |
  202. | bo | 63475 | 21658 | 0.3412 |
  203. | nrm | 24077 | 8204 | 0.3407 |
  204. | io | 595698 | 201770 | 0.3387 |
  205. | cdo | 5993 | 2029 | 0.3386 |
  206. | ext | 54406 | 18203 | 0.3346 |
  207. | xh | 3641 | 1205 | 0.3310 |
  208. | rn | 37165 | 12265 | 0.3300 |
  209. | qu | 358714 | 118295 | 0.3298 |
  210. | gd | 142554 | 46535 | 0.3264 |
  211. | mrj | 13793 | 4495 | 0.3259 |
  212. | pag | 17793 | 5780 | 0.3248 |
  213. | bcl | 24098 | 7616 | 0.3160 |
  214. | gn | 96888 | 30425 | 0.3140 |
  215. | kaa | 28246 | 8623 | 0.3053 |
  216. | tpi | 2677 | 812 | 0.3033 |
  217. | diq | 47048 | 14250 | 0.3029 |
  218. | fiu-vro | 132021 | 38769 | 0.2937 |
  219. | koi | 10253 | 2907 | 0.2835 |
  220. | ltg | 4040 | 1115 | 0.2760 |
  221. | ch | 7601 | 2019 | 0.2656 |
  222. | roa-rup | 665 | 175 | 0.2632 |
  223. | nah | 65607 | 16903 | 0.2576 |
  224. | zea | 15275 | 3786 | 0.2479 |
  225. | mdf | 12115 | 2975 | 0.2456 |
  226. | lbe | 49094 | 12000 | 0.2444 |
  227. | arc | 98893 | 24167 | 0.2444 |
  228. | bm | 24204 | 5899 | 0.2437 |
  229. | hak | 53289 | 12436 | 0.2334 |
  230. | pcd | 6789 | 1583 | 0.2332 |
  231. | kv | 18060 | 4181 | 0.2315 |
  232. | udm | 13026 | 3004 | 0.2306 |
  233. | pfl | 10824 | 2476 | 0.2288 |
  234. | av | 42467 | 9431 | 0.2221 |
  235. | gan | 68476 | 14891 | 0.2175 |
  236. | kl | 11201 | 2394 | 0.2137 |
  237. | sm | 2205 | 468 | 0.2122 |
  238. | se | 19645 | 4166 | 0.2121 |
  239. | kg | 11333 | 2291 | 0.2022 |
  240. | chy | 11996 | 2325 | 0.1938 |
  241. | pdc | 15075 | 2845 | 0.1887 |
  242. | frp | 15064 | 2832 | 0.1880 |
  243. | ki | 9530 | 1735 | 0.1821 |
  244. | ti | 7683 | 1387 | 0.1805 |
  245. | ay | 70819 | 11166 | 0.1577 |
  246. | na | 1910 | 301 | 0.1576 |
  247. | srn | 9791 | 1524 | 0.1557 |
  248. | xal | 12941 | 1954 | 0.1510 |
  249. | wo | 5552 | 750 | 0.1351 |
  250. | ik | 8972 | 1144 | 0.1275 |
  251. | ab | 11798 | 1383 | 0.1172 |
  252. | ve | 3131 | 356 | 0.1137 |
  253. | crh | 6291 | 711 | 0.1130 |
  254. | iu | 29782 | 3276 | 0.1100 |
  255. | ks | 4340 | 442 | 0.1018 |
  256. | za | 27870 | 2774 | 0.0995 |
  257. | tet | 5903 | 358 | 0.0606 |
  258. | haw | 5927 | 346 | 0.0584 |
  259. | pih | 4475 | 239 | 0.0534 |
  260. | glk | 4592 | 142 | 0.0309 |
  261. | tyv | 0 | 2622 | NULL |
  262. | cbk-zam | 0 | 1650 | NULL |
  263. | got | 0 | 0 | NULL |
  264. | bxr | 0 | 2187 | NULL |
  265. +---------------+-----------+-----------+---------+
  266. 255 rows in set (0.52 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!