Copying Account relationship to Contact relationship

-- Copy all of the data, using account_id for contact_id even though it's wrong
insert into contacts_contr_contributions_1_c
(id,
contacts_contr_contributions_1contacts_ida,
contacts_contr_contributions_1contr_contributions_idb)
select
accounts_contr_contributions_3_c.id,
accounts_contr_contributions_3_c.accounts_contr_contributions_3accounts_ida,
accounts_contr_contributions_3_c.accounts_contr_contributions_3contr_contributions_idb
from accounts_contr_contributions_3_c where accounts_contr_contributions_3_c.deleted = 0;

-- Replace the account_id with contact_id
update contacts_contr_contributions_1_c
join accounts_contacts on contacts_contr_contributions_1_c.contacts_contr_contributions_1contacts_ida = accounts_contacts.account_id
join contacts on accounts_contacts.contact_id = contacts.id
set contacts_contr_contributions_1_c.contacts_contr_contributions_1contacts_ida
  = contacts.id
where contacts.id in (
  select contacts.id
  from contacts
  join accounts_contacts on contacts.id = accounts_contacts.contact_id
);

-- see what was left over...
delete from contacts_contr_contributions_1_c
where contacts_contr_contributions_1_c.contacts_contr_contributions_1contacts_ida in
(select accounts.id from accounts);