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 < 1000000 AND wbit_item_id > 0000000;" -N -B
> 0to1holes-postfill
addshore@stat1007:~$ wc -l 0to1holes-postfill
23 0to1holes-postfill
addshore@stat1007:~$
addshore@stat1007:~$
addshore@stat1007:~$ cat 0to1holes-postfill
4006
15105
24354
47988
60110
90317
114416
143888
149912
188467
217812
219718
254435
310751
386905
506052
581768
692160
739279
774383
852302
940886
946865
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 < 1000000 AND wbit_item_id > 0000000;" -N -B