Ladsgroup added a comment.

  Sigh, this is not very useful:
  
    mysql:[email protected] [enwiki]> select 
page_title, page_namespace, count(*) from wbc_entity_usage join page on 
eu_page_id = page_id where page_namespace = 0 group by eu_page_id order by 
count(*) desc limit 50;
    
+----------------------------------------------------------------+----------------+----------+
    | page_title                                                     | 
page_namespace | count(*) |
    
+----------------------------------------------------------------+----------------+----------+
    | List_of_lighthouses_in_China                                   |          
    0 |     2209 |
    | List_of_dams_in_Hokkaido                                       |          
    0 |     2075 |
    | List_of_lighthouses_in_Scotland                                |          
    0 |     1666 |
    | List_of_Polish_mathematicians                                  |          
    0 |     1363 |
    | List_of_crossings_of_the_River_Thames                          |          
    0 |     1324 |
    | List_of_learned_societies                                      |          
    0 |     1287 |
    | Ying_Fan_Reinfelder                                            |          
    0 |     1260 |
    | List_of_lighthouses_in_Argentina                               |          
    0 |     1216 |
    | Lidia_Morawska                                                 |          
    0 |     1007 |
    | Listed_buildings_at_the_University_of_Leeds                    |          
    0 |      921 |
    | Lightvessel_stations_of_Great_Britain                          |          
    0 |      816 |
    | List_of_learned_societies_in_the_United_Kingdom                |          
    0 |      774 |
    | List_of_dams_in_Akita_Prefecture                               |          
    0 |      742 |
    | List_of_parks_and_open_spaces_in_the_London_Borough_of_Croydon |          
    0 |      731 |
    | List_of_dams_in_Yamaguchi_Prefecture                           |          
    0 |      706 |
    | List_of_dams_in_Toyama_Prefecture                              |          
    0 |      696 |
    | List_of_dams_in_Yamagata_Prefecture                            |          
    0 |      673 |
    | List_of_dams_in_Hyogo_Prefecture                               |          
    0 |      652 |
    | List_of_dams_in_Gifu_Prefecture                                |          
    0 |      638 |
    | List_of_monuments_in_Meknes                                    |          
    0 |      629 |
    | List_of_lighthouses_in_Madagascar                              |          
    0 |      617 |
    | Catenin_beta-1                                                 |          
    0 |      614 |
    | List_of_monuments_in_Rabat,_Morocco                            |          
    0 |      591 |
    | List_of_dams_in_Hiroshima_Prefecture                           |          
    0 |      565 |
    | List_of_dams_in_Chiba_Prefecture                               |          
    0 |      562 |
    | List_of_lightvessels_of_Great_Britain                          |          
    0 |      557 |
    | List_of_dams_in_Nagano_Prefecture                              |          
    0 |      547 |
    | List_of_dams_in_Kagawa_Prefecture                              |          
    0 |      539 |
    | TGF_beta_1                                                     |          
    0 |      533 |
    | List_of_lighthouses_in_Japan                                   |          
    0 |      521 |
    | Bone_morphogenetic_protein_4                                   |          
    0 |      507 |
    | List_of_mountain_peaks_by_prominence                           |          
    0 |      503 |
    | List_of_dams_in_Fukuoka_Prefecture                             |          
    0 |      499 |
    | Notch_1                                                        |          
    0 |      491 |
    | Sonic_hedgehog_protein                                         |          
    0 |      487 |
    | P53                                                            |          
    0 |      483 |
    | Protein_Wnt-5a                                                 |          
    0 |      483 |
    | Dopamine_receptor_D2                                           |          
    0 |      481 |
    | List_of_dams_in_Shimane_Prefecture                             |          
    0 |      480 |
    | AKT1                                                           |          
    0 |      475 |
    | List_of_learned_societies_in_the_United_States                 |          
    0 |      468 |
    | List_of_crossings_of_the_Danube                                |          
    0 |      467 |
    | List_of_monuments_in_Marrakesh                                 |          
    0 |      461 |
    | List_of_dams_in_Fukushima_Prefecture                           |          
    0 |      459 |
    | Proto-oncogene_tyrosine-protein_kinase_Src                     |          
    0 |      457 |
    | Epidermal_growth_factor_receptor                               |          
    0 |      454 |
    | List_of_historic_places_in_the_Edmonton_Capital_Region         |          
    0 |      451 |
    | CALM2                                                          |          
    0 |      450 |
    | HLA-B                                                          |          
    0 |      439 |
    | List_of_dams_in_Iwate_Prefecture                               |          
    0 |      437 |
    
+----------------------------------------------------------------+----------------+----------+
    50 rows in set (2 min 59.544 sec)
  
  Probably we should pick something that has the highest number of properties.

TASK DETAIL
  https://phabricator.wikimedia.org/T290989

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: RLazarus, Ladsgroup
Cc: Clement_Goubert, RLazarus, Lydia_Pintscher, karapayneWMDE, LSobanski, 
Krinkle, Addshore, jcrespo, Marostegui, Lucas_Werkmeister_WMDE, Ladsgroup, 
Legoktm, Aklapper, Themindcoder, Adamm71, Jersione, Hellket777, LisafBia6531, 
Astuthiodit_1, Lmlmljs, 786, Biggs657, Invadibot, maantietaja, Juan90264, 
Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, 
joker88john, CucyNoiD, Nandana, jijiki, Gaboe420, Giuliamocci, Cpaulf30, Lahi, 
Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, 
Volans, Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, Wikidata-bugs, 
aude, Mbch331, Krenair, akosiaris
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to