Addshore added a comment.
So, an update from T244115#5889790 <https://phabricator.wikimedia.org/T244115#5889790> which listed 15 item holes for aliases on the 17th Feb. Running the query again now shows 21 holes, again all for aliases. mysql:[email protected] [wikidatawiki]> SELECT * FROM wbt_property_terms LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_id = wby_id LEFT JO IN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wbx_text IS NULL; +---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+---------+---------------+--------------+--------+----------+ | wbpt_id | wbpt_property_id | wbpt_term_in_lang_id | wbtl_id | wbtl_type_id | wbtl_text_in_lang_id | wby_id | wby_name | wbxl_id | wbxl_language | wbxl_text_id | wbx_id | wbx_text | +---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+---------+---------------+--------------+--------+----------+ | 332730 | 7850 | 411848038 | 411848038 | 3 | 407983555 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 332732 | 7786 | 411848054 | 411848054 | 3 | 406931806 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 332734 | 7884 | 411848132 | 411848132 | 3 | 409421152 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 332736 | 7885 | 411848158 | 411848158 | 3 | 409421166 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 332926 | 932 | 412045499 | 412045499 | 3 | 88258 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 332933 | 846 | 412045592 | 412045592 | 3 | 82909 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 332937 | 590 | 412045617 | 412045617 | 3 | 63613 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 334720 | 1440 | 413008330 | 413008330 | 3 | 123055 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 334722 | 1665 | 413010089 | 413010089 | 3 | 135377 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 334883 | 3417 | 413099852 | 413099852 | 3 | 212096 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 335048 | 4474 | 413348559 | 413348559 | 3 | 240023 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 335149 | 1017 | 413511952 | 413511952 | 3 | 411294102 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 335196 | 6365 | 413582295 | 413582295 | 3 | 274837 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 335576 | 949 | 415036560 | 415036560 | 3 | 288784 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 335589 | 2033 | 415066824 | 415066824 | 3 | 152756 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 335854 | 667 | 415923987 | 415923987 | 3 | 69305 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 336949 | 477 | 417006412 | 417006412 | 3 | 51848 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 337230 | 1755 | 417689972 | 417689972 | 3 | 415460553 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 337269 | 190 | 417808950 | 417808950 | 3 | 26783 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 337367 | 3916 | 418041210 | 418041210 | 3 | 225590 | 3 | alias | NULL | NULL | NULL | NULL | NULL | | 337371 | 508 | 418041355 | 418041355 | 3 | 54642 | 3 | alias | NULL | NULL | NULL | NULL | NULL | +---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+---------+---------------+--------------+--------+----------+ 21 rows in set (10.27 sec) All patches in this ticket are still to be deployed or merged. TASK DETAIL https://phabricator.wikimedia.org/T244115 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Tarrow, Addshore Cc: Lucas_Werkmeister_WMDE, Tarrow, Ladsgroup, Addshore, Aklapper, Hazizibinmahdi, Beast1978, Un1tY, Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, Iflorez, darthmon_wmde, alaa_wmde, Meekrab2012, joker88john, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
