UPDATE in SQL
UPDATE wp_postmeta AS a JOIN wp_term_relationships AS b ON a.post_id=b.object_id SET meta_value=0 WHERE term_taxonomy_id = 9 AND meta_key = 'issue_id' AND meta_value != 0;