Created

Embed URL

HTTPS clone URL

SSH clone URL

You can clone with HTTPS or SSH.

Download Gist
View gist:9713775
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106
MariaDB [enwiki_p]> select count(*) as num, page_namespace, page_title from geo_tags, page where gt_page_id=page_id group by gt_page_id order by num desc limit 100;
+------+----------------+-------------------------------------------------------------------------------------------------------+
| num | page_namespace | page_title |
+------+----------------+-------------------------------------------------------------------------------------------------------+
| 2000 | 2 | EncMstr/List_of_Oregon_GNIS_features |
| 1531 | 2 | ClemRutter/sandbox |
| 1184 | 2 | EncMstr/test1/coord |
| 1139 | 0 | Sortable_list_of_islands_of_Western_Australia |
| 1080 | 2 | NevilleDNZ/globe:earth |
| 959 | 0 | List_of_Sites_of_Community_Importance_in_Spain |
| 949 | 2 | JohnArmagh/England_Monasteries_Coordinates |
| 668 | 0 | List_of_monastic_houses_in_Ireland |
| 662 | 0 | List_of_canals_in_Oregon |
| 622 | 2 | Emarsee/cbctx |
| 607 | 0 | List_of_villages_in_Ingapu_Township |
| 595 | 0 | List_of_mines_in_Oregon |
| 586 | 0 | List_of_villages_in_Hinthada_Township |
| 562 | 0 | List_of_mountains_of_the_Alps_above_3000_m |
| 542 | 0 | List_of_United_Kingdom_locations:_Sg-Sh |
| 540 | 0 | List_of_Nike_missile_sites |
| 532 | 0 | List_of_mountains_of_the_Alps_(2500–2999_m) |
| 532 | 2 | JohnArmagh/Test |
| 523 | 0 | List_of_United_Kingdom_locations:_Litn-Liz |
| 522 | 0 | List_of_airports_in_Ontario |
| 517 | 0 | List_of_United_Kingdom_locations:_Pe-Pen |
| 516 | 0 | List_of_United_Kingdom_locations:_As-Az |
| 516 | 0 | List_of_United_Kingdom_locations:_Low-Loz |
| 516 | 0 | List_of_United_Kingdom_locations:_Ros-Rz |
| 512 | 0 | List_of_cities,_towns_and_villages_in_Groningen |
| 510 | 0 | List_of_United_Kingdom_locations:_Gree-Gz |
| 510 | 0 | List_of_United_Kingdom_locations:_La-Laz |
| 510 | 1 | List_of_tallest_structures_in_Norway |
| 508 | 0 | List_of_tallest_structures_in_Poland |
| 507 | 0 | List_of_villages_in_Hordaland |
| 500 | 0 | List_of_cities,_towns_and_villages_in_North_Holland |
| 500 | 10 | Coord/speedtest |
| 499 | 2 | Emijrp/GNS/SP/1 |
| 499 | 2 | Emijrp/GNS/AC/1 |
| 497 | 0 | List_of_North_African_airfields_during_World_War_II |
| 495 | 0 | List_of_United_Kingdom_locations:_Car-Cd |
| 490 | 2 | Ethansmith/Sandbox |
| 489 | 0 | List_of_United_Kingdom_locations:_Bur-Bz |
| 489 | 0 | List_of_United_Kingdom_locations:_Po-Poz |
| 489 | 0 | List_of_United_Kingdom_locations:_Wi-Win |
| 486 | 0 | List_of_cathedrals_in_the_United_States |
| 485 | 0 | List_of_United_Kingdom_locations:_Aa-Ak |
| 484 | 0 | Finnish_exonyms_for_places_in_Norway:_Finnmark |
| 482 | 0 | List_of_homesteads_in_Western_Australia:_B |
| 480 | 0 | List_of_United_Kingdom_locations:_Stu-Sz |
| 479 | 0 | List_of_United_Kingdom_locations:_Wir-Wood |
| 473 | 0 | List_of_Presbyterian_churches_in_the_United_States |
| 472 | 0 | List_of_villages_in_Myanaung_Township |
| 471 | 0 | List_of_listed_buildings_in_Stirling,_Stirling |
| 468 | 0 | List_of_lakes_of_Nova_Scotia |
| 468 | 0 | List_of_United_Kingdom_locations:_Ho-Hoo |
| 458 | 0 | List_of_United_Kingdom_locations:_Peo-Pn |
| 457 | 0 | List_of_United_Kingdom_locations:_Al |
| 454 | 0 | List_of_United_Kingdom_locations:_Kib-Kin |
| 452 | 0 | List_of_Category_A_listed_buildings_in_the_New_Town,_Edinburgh |
| 451 | 0 | List_of_mountains_of_Switzerland |
| 449 | 0 | List_of_listed_buildings_in_Ayr,_South_Ayrshire |
| 446 | 0 | List_of_United_Kingdom_locations:_Sow-Stao |
| 446 | 0 | List_of_United_Kingdom_locations:_Wd-West_End |
| 442 | 0 | List_of_United_Kingdom_locations:_Stap-St_N |
| 442 | 2 | JohnArmagh/MySandbox |
| 440 | 2 | AussieLegend/NSW_rivers |
| 439 | 0 | List_of_installations_for_15kV_AC_railway_electrification_in_Germany,_Austria_and_Switzerland |
| 438 | 0 | List_of_villages_in_Nordland |
| 438 | 2 | Mdupont/GNSNames |
| 437 | 0 | List_of_mountains_of_Switzerland_above_3000_m |
| 435 | 0 | List_of_cities,_towns_and_villages_in_Gelderland,_A-K |
| 435 | 0 | List_of_United_Kingdom_locations:_Ta-Tha |
| 434 | 0 | List_of_United_Kingdom_locations:_Si-Sm |
| 434 | 0 | List_of_cities,_towns_and_villages_in_South_Holland |
| 433 | 0 | List_of_United_Kingdom_locations:_Fa-Fe |
| 432 | 0 | List_of_United_Kingdom_locations:_Ca-Cap |
| 431 | 0 | 15_kV_AC_railway_electrification |
| 431 | 2 | Calliopejen1/sandbox/peru |
| 431 | 2 | Ebyabe/Googley_maps/I-95_SC_NC |
| 431 | 2 | Cyclonebiskit/List_of_United_States_tornadoes_of_2008 |
| 429 | 2 | Sander_Säde/reserves |
| 429 | 0 | List_of_United_Kingdom_locations:_Tr-Tre |
| 428 | 0 | List_of_United_Kingdom_locations:_Am-Ar |
| 427 | 0 | List_of_United_Kingdom_locations:_Co-Col |
| 427 | 0 | List_of_mountains_of_Queen_Maud_Land |
| 424 | 0 | List_of_United_Kingdom_locations:_Cl-Cn |
| 422 | 0 | Advanced_Landing_Ground |
| 422 | 0 | List_of_cities,_towns_and_villages_in_Dutch_Limburg,_A-L |
| 421 | 0 | List_of_United_Kingdom_locations:_Tri-Tz |
| 420 | 0 | List_of_United_Kingdom_locations:_Kip-Kz |
| 418 | 0 | List_of_United_Kingdom_locations:_Ri-Ror |
| 418 | 0 | List_of_villages_in_Yegyi_Township |
| 417 | 0 | List_of_United_Kingdom_locations:_Gr-Gred |
| 416 | 0 | List_of_tallest_structures_in_Austria |
| 414 | 0 | List_of_civil_parishes_in_Somerset |
| 413 | 0 | List_of_United_Kingdom_locations:_Ge-Gl |
| 413 | 4 | Requested_articles/Social_sciences/Geography,_cities,_regions_and_named_places/Kosovo/Region_Border01 |
| 412 | 0 | List_of_shipwrecks_in_the_mid-Atlantic_Ocean |
| 411 | 0 | List_of_United_Kingdom_locations:_Wam-Way |
| 410 | 0 | List_of_cities,_towns_and_villages_in_Overijssel |
| 409 | 0 | List_of_cities,_towns_and_villages_in_Gelderland,_L-Z |
| 408 | 0 | List_of_United_Kingdom_locations:_Ha-Ham |
| 406 | 2 | Tobyc75/Sandbox/Heritage_sites |
| 403 | 0 | List_of_villages_in_Troms |
+------+----------------+-------------------------------------------------------------------------------------------------------+
100 rows in set (5.96 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.