Addshore added a comment.
Now generating a list for up to Q20 million based on SQL for a rebuild...
addshore@stat1007:~$ analytics-mysql wikidatawiki -e "SELECT DISTINCT
wbit_item_id as id FROM wbt_item_terms LEFT JOIN wbt_term_in_lang ON
wbit_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 AND wbit_item_id < 20000000 AND
wbit_item_id > 10000000 ORDER
BY wbit_item_id ASC;" -N -B > 10to20holes-24feb1345
TASK DETAIL
https://phabricator.wikimedia.org/T219123
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup, Addshore
Cc: Ladsgroup, Addshore, Jdforrester-WMF, ArielGlenn, Aklapper, alaa_wmde,
Hazizibinmahdi, Beast1978, Un1tY, Hook696, Daryl-TTMG, RomaAmorRoma,
0010318400, E.S.A-Sheild, Iflorez, darthmon_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
