PhycoBank

use nomenclatural reference as sec. references for all taxa which have the IAPT as sec reference

this can be done using the following sql script:

update TaxonBase t set t.sec_id =
    ( select r.id from TaxonNameBase n
      join Reference r on  n.nomenclaturalReference_id = r.id
      where n.id = t.name_id
    )
  where sec_id = 14 and ( select r.id from TaxonNameBase n
      join Reference r on  n.nomenclaturalReference_id = r.id
      where n.id = t.name_id
    ) is not null;


update TaxonBase t set t.titleCache = null
where t.protectedTitleCache = 0 and t.sec_id is not null;