API tools faq
paste
Advertisement
westand

Articles:Viewers corellation by language

westand
Mar 1st, 2014
342
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.31 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)),COUNT(*) as ARTICLES,
  2. -> SUM(year) as YEAR_VIEWS,SUM(year)/COUNT(*) as VIEWERS_PER_ART
  3. -> FROM wp_med_monthly GROUP BY SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE))
  4. -> ORDER BY COUNT(*) DESC;
  5.  
  6. +---------------------------------------------+----------+------------+-----------------+
  7. | SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)) | ARTICLES | YEAR_VIEWS | VIEWERS_PER_ART |
  8. +---------------------------------------------+----------+------------+-----------------+
  9. | en | 29072 | 2277403987 | 78336.6809 |
  10. | de | 7761 | 348355902 | 44885.4403 |
  11. | fr | 6372 | 218518275 | 34293.5146 |
  12. | es | 6367 | 658556909 | 103432.8426 |
  13. | pl | 5999 | 147488961 | 24585.5911 |
  14. | it | 5677 | 147115245 | 25914.2584 |
  15. | pt | 5269 | 212465002 | 40323.5912 |
  16. | ru | 4832 | 150138801 | 31071.7717 |
  17. | nl | 4391 | 75543607 | 17204.1920 |
  18. | ja | 4303 | 253740601 | 58968.3014 |
  19. | ar | 4055 | 32834324 | 8097.2439 |
  20. | sv | 3661 | 30557682 | 8346.8129 |
  21. | ca | 2992 | 4764627 | 1592.4555 |
  22. | zh | 2991 | 35564390 | 11890.4681 |
  23. | fa | 2843 | 17695775 | 6224.3317 |
  24. | fi | 2773 | 22843456 | 8237.8132 |
  25. | he | 2389 | 16288412 | 6818.0879 |
  26. | cs | 2352 | 21949832 | 9332.4116 |
  27. | uk | 2291 | 11050301 | 4823.3527 |
  28. | no | 2175 | 12099698 | 5563.0795 |
  29. | tr | 1822 | 33904861 | 18608.5955 |
  30. | sr | 1771 | 2662780 | 1503.5460 |
  31. | ko | 1686 | 6539177 | 3878.5154 |
  32. | hu | 1528 | 12119560 | 7931.6492 |
  33. | simple | 1436 | 4174878 | 2907.2967 |
  34. | da | 1433 | 6702468 | 4677.2282 |
  35. | id | 1431 | 22732356 | 15885.6436 |
  36. | hr | 1396 | 8679378 | 6217.3195 |
  37. | th | 1278 | 11120603 | 8701.5673 |
  38. | bg | 1242 | 7098983 | 5715.7673 |
  39. | ro | 1213 | 7800273 | 6430.5631 |
  40. | sl | 1191 | 3063597 | 2572.2897 |
  41. | gl | 1172 | 613123 | 523.1425 |
  42. | lt | 1003 | 4121584 | 4109.2562 |
  43. | sk | 1000 | 4279143 | 4279.1430 |
  44. | eo | 982 | 586283 | 597.0295 |
  45. | et | 947 | 1532219 | 1617.9715 |
  46. | eu | 940 | 675583 | 718.7053 |
  47. | el | 852 | 7860165 | 9225.5458 |
  48. | kk | 839 | 1230008 | 1466.0405 |
  49. | hi | 816 | 1403768 | 1720.3039 |
  50. | vi | 809 | 12449359 | 15388.5773 |
  51. | ta | 806 | 698695 | 866.8672 |
  52. | sh | 775 | 2125685 | 2742.8194 |
  53. | ms | 604 | 2544733 | 4213.1341 |
  54. | be | 580 | 251609 | 433.8086 |
  55. | bs | 579 | 2176668 | 3759.3575 |
  56. | az | 544 | 740011 | 1360.3143 |
  57. | la | 537 | 294252 | 547.9553 |
  58. | tl | 524 | 1463212 | 2792.3893 |
  59. | ml | 516 | 329692 | 638.9380 |
  60. | lv | 498 | 947009 | 1901.6245 |
  61. | ky | 492 | 185936 | 377.9187 |
  62. | nn | 486 | 447281 | 920.3313 |
  63. | io | 485 | 185647 | 382.7773 |
  64. | is | 464 | 355538 | 766.2457 |
  65. | mk | 463 | 725421 | 1566.7840 |
  66. | ur | 453 | 203685 | 449.6358 |
  67. | te | 436 | 221948 | 509.0550 |
  68. | ga | 403 | 120259 | 298.4094 |
  69. | ka | 339 | 784613 | 2314.4926 |
  70. | be-x-old | 332 | 161245 | 485.6777 |
  71. | dv | 313 | 103582 | 330.9329 |
  72. | cy | 312 | 195804 | 627.5769 |
  73. | bn | 306 | 248354 | 811.6144 |
  74. | sq | 299 | 972307 | 3251.8629 |
  75. | jv | 275 | 148449 | 539.8145 |
  76. | war | 269 | 97462 | 362.3123 |
  77. | oc | 249 | 128136 | 514.6024 |
  78. | mr | 245 | 347165 | 1417.0000 |
  79. | zh-yue | 236 | 560532 | 2375.1356 |
  80. | hy | 221 | 319555 | 1445.9502 |
  81. | kn | 219 | 111915 | 511.0274 |
  82. | yi | 212 | 96814 | 456.6698 |
  83. | af | 202 | 631599 | 3126.7277 |
  84. | ku | 202 | 93764 | 464.1782 |
  85. | qu | 198 | 97617 | 493.0152 |
  86. | br | 197 | 110960 | 563.2487 |
  87. | ne | 191 | 92166 | 482.5445 |
  88. | zh-min-nan | 186 | 84227 | 452.8333 |
  89. | scn | 183 | 90524 | 494.6667 |
  90. | sw | 176 | 314559 | 1787.2670 |
  91. | lb | 172 | 79643 | 463.0407 |
  92. | si | 164 | 76353 | 465.5671 |
  93. | uz | 160 | 127581 | 797.3813 |
  94. | nds | 160 | 106792 | 667.4500 |
  95. | ckb | 151 | 77768 | 515.0199 |
  96. | fy | 151 | 83836 | 555.2053 |
  97. | pnb | 137 | 60084 | 438.5693 |
  98. | ps | 137 | 60285 | 440.0365 |
  99. | wa | 131 | 49859 | 380.6031 |
  100. | ht | 130 | 55625 | 427.8846 |
  101. | su | 127 | 91655 | 721.6929 |
  102. | ia | 125 | 93982 | 751.8560 |
  103. | my | 120 | 55419 | 461.8250 |
  104. | ast | 118 | 95289 | 807.5339 |
  105. | an | 117 | 219980 | 1880.1709 |
  106. | new | 110 | 43604 | 396.4000 |
  107. | arz | 106 | 361395 | 3409.3868 |
  108. | ceb | 94 | 36149 | 384.5638 |
  109. | gu | 86 | 99152 | 1152.9302 |
  110. | mn | 80 | 117104 | 1463.8000 |
  111. | sa | 73 | 25364 | 347.4521 |
  112. | gd | 72 | 37627 | 522.5972 |
  113. | tt | 69 | 37482 | 543.2174 |
  114. | als | 67 | 83577 | 1247.4179 |
  115. | bat-smg | 64 | 45448 | 710.1250 |
  116. | ln | 63 | 38591 | 612.5556 |
  117. | pam | 62 | 43570 | 702.7419 |
  118. | fo | 60 | 35676 | 594.6000 |
  119. | arc | 59 | 32678 | 553.8644 |
  120. | yo | 58 | 29933 | 516.0862 |
  121. | or | 57 | 19893 | 349.0000 |
  122. | gn | 57 | 24014 | 421.2982 |
  123. | tg | 55 | 27802 | 505.4909 |
  124. | so | 53 | 37288 | 703.5472 |
  125. | fiu-vro | 52 | 33474 | 643.7308 |
  126. | pms | 51 | 17331 | 339.8235 |
  127. | sah | 50 | 23065 | 461.3000 |
  128. | ba | 50 | 22660 | 453.2000 |
  129. | pa | 49 | 15516 | 316.6531 |
  130. | tk | 47 | 21025 | 447.3404 |
  131. | sn | 47 | 45993 | 978.5745 |
  132. | cv | 47 | 38910 | 827.8723 |
  133. | ilo | 46 | 29883 | 649.6304 |
  134. | ay | 46 | 30581 | 664.8043 |
  135. | bo | 44 | 19858 | 451.3182 |
  136. | bjn | 42 | 28502 | 678.6190 |
  137. | bar | 41 | 43420 | 1059.0244 |
  138. | ug | 35 | 14146 | 404.1714 |
  139. | gan | 35 | 33115 | 946.1429 |
  140. | wuu | 34 | 44879 | 1319.9706 |
  141. | rue | 33 | 24077 | 729.6061 |
  142. | hif | 33 | 31516 | 955.0303 |
  143. | mzn | 32 | 48580 | 1518.1250 |
  144. | lbe | 32 | 13884 | 433.8750 |
  145. | am | 32 | 36127 | 1128.9688 |
  146. | as | 30 | 18534 | 617.8000 |
  147. | av | 30 | 14502 | 483.4000 |
  148. | lij | 29 | 16722 | 576.6207 |
  149. | vec | 29 | 25222 | 869.7241 |
  150. | rw | 28 | 18978 | 677.7857 |
  151. | hak | 28 | 18457 | 659.1786 |
  152. | gv | 27 | 20714 | 767.1852 |
  153. | nds-nl | 27 | 19903 | 737.1481 |
  154. | szl | 27 | 21348 | 790.6667 |
  155. | ksh | 26 | 22049 | 848.0385 |
  156. | nah | 25 | 22234 | 889.3600 |
  157. | sco | 25 | 27936 | 1117.4400 |
  158. | li | 25 | 20168 | 806.7200 |
  159. | lmo | 24 | 13327 | 555.2917 |
  160. | vls | 24 | 14223 | 592.6250 |
  161. | xmf | 22 | 9440 | 429.0909 |
  162. | diq | 22 | 15331 | 696.8636 |
  163. | mg | 19 | 14970 | 787.8947 |
  164. | mt | 19 | 21669 | 1140.4737 |
  165. | vep | 19 | 7707 | 405.6316 |
  166. | iu | 18 | 18606 | 1033.6667 |
  167. | nv | 18 | 10801 | 600.0556 |
  168. | km | 17 | 9468 | 556.9412 |
  169. | rn | 17 | 8761 | 515.3529 |
  170. | ang | 17 | 20900 | 1229.4118 |
  171. | ext | 16 | 14645 | 915.3125 |
  172. | pag | 16 | 7527 | 470.4375 |
  173. | jbo | 16 | 7211 | 450.6875 |
  174. | om | 15 | 12061 | 804.0667 |
  175. | fur | 15 | 13181 | 878.7333 |
  176. | za | 14 | 9766 | 697.5714 |
  177. | frr | 14 | 9590 | 685.0000 |
  178. | ace | 13 | 9729 | 748.3846 |
  179. | zh-classical | 13 | 15962 | 1227.8462 |
  180. | mhr | 12 | 9532 | 794.3333 |
  181. | mwl | 12 | 15658 | 1304.8333 |
  182. | os | 12 | 9523 | 793.5833 |
  183. | nov | 11 | 14136 | 1285.0909 |
  184. | pdc | 10 | 10010 | 1001.0000 |
  185. | sc | 10 | 8347 | 834.7000 |
  186. | vo | 10 | 4897 | 489.7000 |
  187. | stq | 10 | 10775 | 1077.5000 |
  188. | nap | 10 | 8490 | 849.0000 |
  189. | hsb | 9 | 7367 | 818.5556 |
  190. | kaa | 9 | 8736 | 970.6667 |
  191. | bm | 9 | 10185 | 1131.6667 |
  192. | roa-rup | 9 | 1440 | 160.0000 |
  193. | kv | 9 | 5017 | 557.4444 |
  194. | nrm | 8 | 13901 | 1737.6250 |
  195. | csb | 8 | 6125 | 765.6250 |
  196. | co | 8 | 7658 | 957.2500 |
  197. | lo | 8 | 6991 | 873.8750 |
  198. | mrj | 8 | 2522 | 315.2500 |
  199. | ik | 7 | 3116 | 445.1429 |
  200. | chy | 7 | 1499 | 214.1429 |
  201. | bcl | 7 | 5605 | 800.7143 |
  202. | udm | 7 | 2830 | 404.2857 |
  203. | ce | 7 | 3811 | 544.4286 |
  204. | pap | 7 | 4423 | 631.8571 |
  205. | lad | 7 | 7986 | 1140.8571 |
  206. | se | 7 | 4998 | 714.0000 |
  207. | zea | 6 | 3465 | 577.5000 |
  208. | lez | 6 | 5267 | 877.8333 |
  209. | ie | 6 | 4641 | 773.5000 |
  210. | map-bms | 6 | 10368 | 1728.0000 |
  211. | eml | 6 | 3058 | 509.6667 |
  212. | koi | 6 | 4349 | 724.8333 |
  213. | myv | 6 | 5190 | 865.0000 |
  214. | ti | 5 | 4609 | 921.8000 |
  215. | kw | 5 | 5365 | 1073.0000 |
  216. | kab | 5 | 2926 | 585.2000 |
  217. | mdf | 5 | 4765 | 953.0000 |
  218. | kg | 4 | 5934 | 1483.5000 |
  219. | ha | 4 | 5294 | 1323.5000 |
  220. | srn | 4 | 2847 | 711.7500 |
  221. | frp | 4 | 5090 | 1272.5000 |
  222. | xal | 4 | 2582 | 645.5000 |
  223. | kl | 4 | 3672 | 918.0000 |
  224. | krc | 4 | 1759 | 439.7500 |
  225. | min | 3 | 2060 | 686.6667 |
  226. | wo | 3 | 3719 | 1239.6667 |
  227. | pfl | 3 | 2535 | 845.0000 |
  228. | mi | 3 | 3055 | 1018.3333 |
  229. | pcd | 3 | 1575 | 525.0000 |
  230. | ig | 3 | 3056 | 1018.6667 |
  231. | roa-tara | 3 | 3311 | 1103.6667 |
  232. | kbd | 3 | 1985 | 661.6667 |
  233. | dsb | 3 | 2389 | 796.3333 |
  234. | to | 2 | 1681 | 840.5000 |
  235. | ltg | 2 | 2330 | 1165.0000 |
  236. | ks | 2 | 986 | 493.0000 |
  237. | cdo | 2 | 1725 | 862.5000 |
  238. | tyv | 2 | 443 | 221.5000 |
  239. | tpi | 2 | 1313 | 656.5000 |
  240. | bpy | 2 | 1962 | 981.0000 |
  241. | zu | 2 | 2853 | 1426.5000 |
  242. | ki | 2 | 4141 | 2070.5000 |
  243. | pih | 2 | 1225 | 612.5000 |
  244. | ny | 2 | 371 | 185.5000 |
  245. | ab | 2 | 3103 | 1551.5000 |
  246. | xh | 2 | 2382 | 1191.0000 |
  247. | tum | 2 | 2277 | 1138.5000 |
  248. | fj | 1 | 395 | 395.0000 |
  249. | bh | 1 | 488 | 488.0000 |
  250. | nb | 1 | 44 | 44.0000 |
  251. | sm | 1 | 210 | 210.0000 |
  252. | ve | 1 | 1078 | 1078.0000 |
  253. | tet | 1 | 1140 | 1140.0000 |
  254. | na | 1 | 386 | 386.0000 |
  255. | got | 1 | 0 | 0.0000 |
  256. | bxr | 1 | 928 | 928.0000 |
  257. | cu | 1 | 1041 | 1041.0000 |
  258. | glk | 1 | 1825 | 1825.0000 |
  259. | cbk-zam | 1 | 1174 | 1174.0000 |
  260. | tn | 1 | 342 | 342.0000 |
  261. | crh | 1 | 1121 | 1121.0000 |
  262. | ch | 1 | 1683 | 1683.0000 |
  263. | haw | 1 | 1431 | 1431.0000 |
  264. +---------------------------------------------+----------+------------+-----------------+
  265. 255 rows in set (0.35 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!