alaa_wmde added a comment.
a quick snippet on clean up sql script DELETE FROM wbt_term_in_lang WHERE wbtl_id IS NOT IN (SELECT wbpt_term_in_lang_id FROM wbt_item_terms) AND wbtl_id IS NOT IN (SELECT wbpt_term_in_lang_id FROM wbt_property_terms) ; DELETE FROM wbt_text_in_lang WHERE wbxl_id IS NOT IN (SELECT wbtl_text_in_lang_id from wbt_term_in_lang) ; DELETE FROM wbt_text WHERE wbx_id IS NOT IN (SELECT wbxl_text_id from wbt_text_in_lang) ; @Ladsgroup @Addshore any concerns re indexes or sub-queries here TASK DETAIL https://phabricator.wikimedia.org/T220150 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: alaa_wmde Cc: Ladsgroup, Addshore, alaa_wmde, Aklapper, JeroenDeDauw, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs