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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
