-- update the list type of the Trichoptera list to allow data entry --

Update taxon_list set taxon_list_type_key = 'NBNSYS0000000005' where taxon_list_key = 'NBNSYS0000000088'

-- update European Topic Centre lists to avoid data entry --

Update taxon_list set taxon_list_type_key = 'NBNSYS0000000002' where taxon_list_key = 'NBNSYS0000000113'
Update taxon_list set taxon_list_type_key = 'NBNSYS0000000002' where taxon_list_key = 'NBNSYS0000000114'

-- Update “ACULEATES Checklist of British Hymenoptera Aculeata” to preferred list --

Update taxon_list set preferred = '1' where taxon_list_key = 'NHMSYS0000871304'

-- Update “ICHNEUMONIDAE Checklist of British and Irish Ichneumonidae” to preferred list --

Update taxon_list set preferred = '1' where taxon_list_key = 'NHMSYS0000886770'

-- Update “TICKS Checklist of British Ixodida (ticks)” to preferred list --

Update taxon_list set preferred = '1' where taxon_list_key = 'NHMSYS0000884893'