Addshore added a comment.
mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT wbpt_property_id as id, wby_name as type, wbxl_language as language, wbx_text as text 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 JOIN 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; +------+-------+----------+------+ | id | type | language | text | +------+-------+----------+------+ | 7850 | alias | NULL | NULL | | 7786 | alias | NULL | NULL | | 7884 | alias | NULL | NULL | | 7885 | alias | NULL | NULL | | 1416 | alias | NULL | NULL | | 932 | alias | NULL | NULL | | 846 | alias | NULL | NULL | | 2326 | alias | NULL | NULL | | 590 | alias | NULL | NULL | | 1566 | alias | NULL | NULL | | 356 | alias | NULL | NULL | +------+-------+----------+------+ 11 rows in set (6.33 sec) Checking this again today it appears there might still be one situation that is causing issue that we should investigate. TASK DETAIL https://phabricator.wikimedia.org/T219301 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Jdforrester-WMF, ArielGlenn, Addshore, Ladsgroup, Aklapper, alaa_wmde, Iflorez, darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs