Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)),SUM(year)
- -> FROM wp_med_monthly GROUP BY SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE))
- -> ORDER BY SUM(year) DESC;
- +---------------------------------------------+------------+
- | SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)) | SUM(year) |
- +---------------------------------------------+------------+
- | en | 2277403987 |
- | es | 658556909 |
- | de | 348355902 |
- | ja | 253740601 |
- | fr | 218518275 |
- | pt | 212465002 |
- | ru | 150138801 |
- | pl | 147488961 |
- | it | 147115245 |
- | nl | 75543607 |
- | zh | 35564390 |
- | tr | 33904861 |
- | ar | 32834324 |
- | sv | 30557682 |
- | fi | 22843456 |
- | id | 22732356 |
- | cs | 21949832 |
- | fa | 17695775 |
- | he | 16288412 |
- | vi | 12449359 |
- | hu | 12119560 |
- | no | 12099698 |
- | th | 11120603 |
- | uk | 11050301 |
- | hr | 8679378 |
- | el | 7860165 |
- | ro | 7800273 |
- | bg | 7098983 |
- | da | 6702468 |
- | ko | 6539177 |
- | ca | 4764627 |
- | sk | 4279143 |
- | simple | 4174878 |
- | lt | 4121584 |
- | sl | 3063597 |
- | sr | 2662780 |
- | ms | 2544733 |
- | bs | 2176668 |
- | sh | 2125685 |
- | et | 1532219 |
- | tl | 1463212 |
- | hi | 1403768 |
- | kk | 1230008 |
- | sq | 972307 |
- | lv | 947009 |
- | ka | 784613 |
- | az | 740011 |
- | mk | 725421 |
- | ta | 698695 |
- | eu | 675583 |
- | af | 631599 |
- | gl | 613123 |
- | eo | 586283 |
- | zh-yue | 560532 |
- | nn | 447281 |
- | arz | 361395 |
- | is | 355538 |
- | mr | 347165 |
- | ml | 329692 |
- | hy | 319555 |
- | sw | 314559 |
- | la | 294252 |
- | be | 251609 |
- | bn | 248354 |
- | te | 221948 |
- | an | 219980 |
- | ur | 203685 |
- | cy | 195804 |
- | ky | 185936 |
- | io | 185647 |
- | be-x-old | 161245 |
- | jv | 148449 |
- | oc | 128136 |
- | uz | 127581 |
- | ga | 120259 |
- | mn | 117104 |
- | kn | 111915 |
- | br | 110960 |
- | nds | 106792 |
- | dv | 103582 |
- | gu | 99152 |
- | qu | 97617 |
- | war | 97462 |
- | yi | 96814 |
- | ast | 95289 |
- | ia | 93982 |
- | ku | 93764 |
- | ne | 92166 |
- | su | 91655 |
- | scn | 90524 |
- | zh-min-nan | 84227 |
- | fy | 83836 |
- | als | 83577 |
- | lb | 79643 |
- | ckb | 77768 |
- | si | 76353 |
- | ps | 60285 |
- | pnb | 60084 |
- | ht | 55625 |
- | my | 55419 |
- | wa | 49859 |
- | mzn | 48580 |
- | sn | 45993 |
- | bat-smg | 45448 |
- | wuu | 44879 |
- | new | 43604 |
- | pam | 43570 |
- | bar | 43420 |
- | cv | 38910 |
- | ln | 38591 |
- | gd | 37627 |
- | tt | 37482 |
- | so | 37288 |
- | ceb | 36149 |
- | am | 36127 |
- | fo | 35676 |
- | fiu-vro | 33474 |
- | gan | 33115 |
- | arc | 32678 |
- | hif | 31516 |
- | ay | 30581 |
- | yo | 29933 |
- | ilo | 29883 |
- | bjn | 28502 |
- | sco | 27936 |
- | tg | 27802 |
- | sa | 25364 |
- | vec | 25222 |
- | rue | 24077 |
- | gn | 24014 |
- | sah | 23065 |
- | ba | 22660 |
- | nah | 22234 |
- | ksh | 22049 |
- | mt | 21669 |
- | szl | 21348 |
- | tk | 21025 |
- | ang | 20900 |
- | gv | 20714 |
- | li | 20168 |
- | nds-nl | 19903 |
- | or | 19893 |
- | bo | 19858 |
- | rw | 18978 |
- | iu | 18606 |
- | as | 18534 |
- | hak | 18457 |
- | pms | 17331 |
- | lij | 16722 |
- | zh-classical | 15962 |
- | mwl | 15658 |
- | pa | 15516 |
- | diq | 15331 |
- | mg | 14970 |
- | ext | 14645 |
- | av | 14502 |
- | vls | 14223 |
- | ug | 14146 |
- | nov | 14136 |
- | nrm | 13901 |
- | lbe | 13884 |
- | lmo | 13327 |
- | fur | 13181 |
- | om | 12061 |
- | nv | 10801 |
- | stq | 10775 |
- | map-bms | 10368 |
- | bm | 10185 |
- | pdc | 10010 |
- | za | 9766 |
- | ace | 9729 |
- | frr | 9590 |
- | mhr | 9532 |
- | os | 9523 |
- | km | 9468 |
- | xmf | 9440 |
- | rn | 8761 |
- | kaa | 8736 |
- | nap | 8490 |
- | sc | 8347 |
- | lad | 7986 |
- | vep | 7707 |
- | co | 7658 |
- | pag | 7527 |
- | hsb | 7367 |
- | jbo | 7211 |
- | lo | 6991 |
- | csb | 6125 |
- | kg | 5934 |
- | bcl | 5605 |
- | kw | 5365 |
- | ha | 5294 |
- | lez | 5267 |
- | myv | 5190 |
- | frp | 5090 |
- | kv | 5017 |
- | se | 4998 |
- | vo | 4897 |
- | mdf | 4765 |
- | ie | 4641 |
- | ti | 4609 |
- | pap | 4423 |
- | koi | 4349 |
- | ki | 4141 |
- | ce | 3811 |
- | wo | 3719 |
- | kl | 3672 |
- | zea | 3465 |
- | roa-tara | 3311 |
- | ik | 3116 |
- | ab | 3103 |
- | eml | 3058 |
- | ig | 3056 |
- | mi | 3055 |
- | kab | 2926 |
- | zu | 2853 |
- | srn | 2847 |
- | udm | 2830 |
- | xal | 2582 |
- | pfl | 2535 |
- | mrj | 2522 |
- | dsb | 2389 |
- | xh | 2382 |
- | ltg | 2330 |
- | tum | 2277 |
- | min | 2060 |
- | kbd | 1985 |
- | bpy | 1962 |
- | glk | 1825 |
- | krc | 1759 |
- | cdo | 1725 |
- | ch | 1683 |
- | to | 1681 |
- | pcd | 1575 |
- | chy | 1499 |
- | roa-rup | 1440 |
- | haw | 1431 |
- | tpi | 1313 |
- | pih | 1225 |
- | cbk-zam | 1174 |
- | tet | 1140 |
- | crh | 1121 |
- | ve | 1078 |
- | cu | 1041 |
- | ks | 986 |
- | bxr | 928 |
- | bh | 488 |
- | tyv | 443 |
- | fj | 395 |
- | na | 386 |
- | ny | 371 |
- | tn | 342 |
- | sm | 210 |
- | nb | 44 |
- | got | 0 |
- +---------------------------------------------+------------+
- 255 rows in set (0.34 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement