Cparle added a comment.
Something else I don't understand about this - if I take the ids from that
query that fails and run this:
select page_title,page_id from page where page_id in
(92967652,234494,24559020,960551,3007520,76398273,6972234,363488,2257260,4157420,89319925,84920900,41797907,61421859,92055128,9221880,14562,26762776,33298380,65449552,3795363,66235719,42442426,89319828,27708617,2563533,66701920,22548996,108484,25232065,6846286,43665564,2257433,8811984,84203487,3837544,5324927,8645978,805218,1078394,81978764,391851)
order by page_title;
I get this
+------------------------------------------------------------------------------------+----------+
| page_title
| page_id |
+------------------------------------------------------------------------------------+----------+
| 1865_births
| 234494 |
| Am_Südpark_(Köln)
| 24559020 |
| Artists_from_Germany
| 960551 |
| Association_football_clubs_in_the_Czech_Republic
| 3007520 |
| Association_football_in_Benešov_District
| 76398273 |
| Badges_of_rank_of_the_Schutzstaffel
| 6972234 |
| Breweries
| 363488 |
| Brick_walls
| 2257260 |
| Broken_category_redirects
| 4157420 |
| Cemeteries_in_Berezivka_Raion
| 89319925 |
| Cemeteries_in_Odesa_Oblast_by_raion
| 84920900 |
| Cold_soups
| 41797907 |
| Cold_soups_of_Turkey
| 61421859 |
| Collective_works_of_Suriname
| 92055128 |
| Creator_template_home_categories
| 9221880 |
| Culture
| 14562 |
| Enrico_Ruggeri
| 26762776 |
| Files_reused_by_external_parties_out_of_compliance_with_licensing_terms
| 33298380 |
| Fomes_fomentarius_in_the_Netherlands
| 65449552 |
| Gate_of_Salutation_(Topkapı_Palace)
| 3795363 |
| Gomphaceae_by_country
| 66235719 |
| Gomphales_by_country
| 42442426 |
| Graves_in_Berezivka_Raion
| 89319828 |
| Graves_in_Odessa_Oblast
| 27708617 |
| Hees
| 2563533 |
| Hees_(Nijmegen)
| 66701920 |
| Hotels_in_Taichung
| 22548996 |
| Interior_decoration
| 108484 |
| Language_templates_with_no_text_displayed
| 25232065 |
| Members_of_the_Communist_Party_of_the_Russian_Federation
| 6846286 |
|
Members_of_the_Communist_Party_of_the_Russian_Soviet_Federative_Socialist_Republic
| 43665564 |
| Mud_walls
| 2257433 |
| Newspaper_clippings
| 8811984 |
| Organizations_of_Benešov_District
| 84203487 |
| PD_text
| 3837544 |
| Porte_Sante_cemetery
| 5324927 |
| Screenshots_of_free_software
| 8645978 |
| Sogndal
| 805218 |
| Sorbus_alnifrons
| 92967652 |
| Stone_walls
| 1078394 |
| Syndicalists
| 81978764 |
| Trujillo_(Peru)
| 391851 |
+------------------------------------------------------------------------------------+----------+
Why do I have such a big range of page_title strings, if the original query
selecting the ids is ordered by page_title?
TASK DETAIL
https://phabricator.wikimedia.org/T260232
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Cparle
Cc: ArielGlenn, CBogen, Cparle, Umherirrender, DannyS712, Naike, WDoranWMF,
Krinkle, aaron, Reedy, Ladsgroup, Aklapper, Marostegui, XeroS_SkalibuR,
jannee_e, Akuckartz, Adidsone1, darthmon_wmde, holger.knust, EvanProdromou,
Nandana, Namenlos314, Phukettaxigroup, Lahi, Gq86, Darkminds3113,
Lucas_Werkmeister_WMDE, GoranSMilovanovic, Jayprakash12345, Lunewa, QZanden,
EBjune, merbst, LawExplorer, Vali.matei, _jensen, rosalieper, Agabi10,
Scott_WUaS, Pchelolo, Jonas, Xmlizer, Volker_E, gnosygnu, jkroll,
Wikidata-bugs, Jdouglas, aude, Tobias1984, GWicke, Dcljr, Dinoguy1000,
Manybubbles, Mbch331, Rxy, Jay8g
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
