Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)),COUNT(*)
- -> FROM wp_med_monthly GROUP BY SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE))
- -> ORDER BY COUNT(*) DESC;
- +---------------------------------------------+----------+
- | SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)) | COUNT(*) |
- +---------------------------------------------+----------+
- | en | 29072 |
- | de | 7761 |
- | fr | 6372 |
- | es | 6367 |
- | pl | 5999 |
- | it | 5677 |
- | pt | 5269 |
- | ru | 4832 |
- | nl | 4391 |
- | ja | 4303 |
- | ar | 4055 |
- | sv | 3661 |
- | ca | 2992 |
- | zh | 2991 |
- | fa | 2843 |
- | fi | 2773 |
- | he | 2389 |
- | cs | 2352 |
- | uk | 2291 |
- | no | 2175 |
- | tr | 1822 |
- | sr | 1771 |
- | ko | 1686 |
- | hu | 1528 |
- | simple | 1436 |
- | da | 1433 |
- | id | 1431 |
- | hr | 1396 |
- | th | 1278 |
- | bg | 1242 |
- | ro | 1213 |
- | sl | 1191 |
- | gl | 1172 |
- | lt | 1003 |
- | sk | 1000 |
- | eo | 982 |
- | et | 947 |
- | eu | 940 |
- | el | 852 |
- | kk | 839 |
- | hi | 816 |
- | vi | 809 |
- | ta | 806 |
- | sh | 775 |
- | ms | 604 |
- | be | 580 |
- | bs | 579 |
- | az | 544 |
- | la | 537 |
- | tl | 524 |
- | ml | 516 |
- | lv | 498 |
- | ky | 492 |
- | nn | 486 |
- | io | 485 |
- | is | 464 |
- | mk | 463 |
- | ur | 453 |
- | te | 436 |
- | ga | 403 |
- | ka | 339 |
- | be-x-old | 332 |
- | dv | 313 |
- | cy | 312 |
- | bn | 306 |
- | sq | 299 |
- | jv | 275 |
- | war | 269 |
- | oc | 249 |
- | mr | 245 |
- | zh-yue | 236 |
- | hy | 221 |
- | kn | 219 |
- | yi | 212 |
- | ku | 202 |
- | af | 202 |
- | qu | 198 |
- | br | 197 |
- | ne | 191 |
- | zh-min-nan | 186 |
- | scn | 183 |
- | sw | 176 |
- | lb | 172 |
- | si | 164 |
- | nds | 160 |
- | uz | 160 |
- | fy | 151 |
- | ckb | 151 |
- | pnb | 137 |
- | ps | 137 |
- | wa | 131 |
- | ht | 130 |
- | su | 127 |
- | ia | 125 |
- | my | 120 |
- | ast | 118 |
- | an | 117 |
- | new | 110 |
- | arz | 106 |
- | ceb | 94 |
- | gu | 86 |
- | mn | 80 |
- | sa | 73 |
- | gd | 72 |
- | tt | 69 |
- | als | 67 |
- | bat-smg | 64 |
- | ln | 63 |
- | pam | 62 |
- | fo | 60 |
- | arc | 59 |
- | yo | 58 |
- | or | 57 |
- | gn | 57 |
- | tg | 55 |
- | so | 53 |
- | fiu-vro | 52 |
- | pms | 51 |
- | ba | 50 |
- | sah | 50 |
- | pa | 49 |
- | tk | 47 |
- | cv | 47 |
- | sn | 47 |
- | ilo | 46 |
- | ay | 46 |
- | bo | 44 |
- | bjn | 42 |
- | bar | 41 |
- | gan | 35 |
- | ug | 35 |
- | wuu | 34 |
- | hif | 33 |
- | rue | 33 |
- | am | 32 |
- | lbe | 32 |
- | mzn | 32 |
- | as | 30 |
- | av | 30 |
- | vec | 29 |
- | lij | 29 |
- | hak | 28 |
- | rw | 28 |
- | nds-nl | 27 |
- | szl | 27 |
- | gv | 27 |
- | ksh | 26 |
- | sco | 25 |
- | li | 25 |
- | nah | 25 |
- | vls | 24 |
- | lmo | 24 |
- | xmf | 22 |
- | diq | 22 |
- | vep | 19 |
- | mt | 19 |
- | mg | 19 |
- | iu | 18 |
- | nv | 18 |
- | rn | 17 |
- | ang | 17 |
- | km | 17 |
- | pag | 16 |
- | ext | 16 |
- | jbo | 16 |
- | fur | 15 |
- | om | 15 |
- | frr | 14 |
- | za | 14 |
- | ace | 13 |
- | zh-classical | 13 |
- | os | 12 |
- | mwl | 12 |
- | mhr | 12 |
- | nov | 11 |
- | sc | 10 |
- | stq | 10 |
- | vo | 10 |
- | pdc | 10 |
- | nap | 10 |
- | kv | 9 |
- | roa-rup | 9 |
- | hsb | 9 |
- | bm | 9 |
- | kaa | 9 |
- | lo | 8 |
- | mrj | 8 |
- | csb | 8 |
- | nrm | 8 |
- | co | 8 |
- | ik | 7 |
- | se | 7 |
- | bcl | 7 |
- | pap | 7 |
- | lad | 7 |
- | ce | 7 |
- | udm | 7 |
- | chy | 7 |
- | eml | 6 |
- | ie | 6 |
- | zea | 6 |
- | map-bms | 6 |
- | myv | 6 |
- | lez | 6 |
- | koi | 6 |
- | kab | 5 |
- | kw | 5 |
- | mdf | 5 |
- | ti | 5 |
- | frp | 4 |
- | ha | 4 |
- | srn | 4 |
- | kg | 4 |
- | kl | 4 |
- | krc | 4 |
- | xal | 4 |
- | ig | 3 |
- | kbd | 3 |
- | pcd | 3 |
- | roa-tara | 3 |
- | pfl | 3 |
- | mi | 3 |
- | wo | 3 |
- | dsb | 3 |
- | min | 3 |
- | xh | 2 |
- | bpy | 2 |
- | ltg | 2 |
- | to | 2 |
- | ki | 2 |
- | tpi | 2 |
- | cdo | 2 |
- | tum | 2 |
- | tyv | 2 |
- | pih | 2 |
- | zu | 2 |
- | ny | 2 |
- | ks | 2 |
- | ab | 2 |
- | crh | 1 |
- | ve | 1 |
- | haw | 1 |
- | tn | 1 |
- | bxr | 1 |
- | cu | 1 |
- | cbk-zam | 1 |
- | glk | 1 |
- | bh | 1 |
- | sm | 1 |
- | na | 1 |
- | tet | 1 |
- | ch | 1 |
- | fj | 1 |
- | got | 1 |
- | nb | 1 |
- +---------------------------------------------+----------+
- 255 rows in set (0.32 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement