Ladsgroup moved this task from Doing to Peer Review on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Ladsgroup added a comment.
Last but not least: mysql -h s8-analytics-replica.eqiad.wmnet -P 3318 -A -e "select * from wikidatawiki.wbt_item_terms right join wikidatawiki.wbt_term_in_lang on wbit_term_in_lang_id = wbtl_id where wbit_id is null and wbtl_id not in (select wbpt_term_in_lang_id from wikidatawiki.wbt_property_terms);" > T241212-4.results Gives 5K rows, I think we are good to go with this. Probably the cleaner bit fixed every part. TASK DETAIL https://phabricator.wikimedia.org/T241212 WORKBOARD https://phabricator.wikimedia.org/project/board/3539/ EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Ladsgroup, Addshore, Aklapper, Iflorez, darthmon_wmde, alaa_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