-- This script automatically generated by species dictionary extract routine on 7
-- Remove those items no longer in NAMESERVER
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000004642'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000135934'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000141944'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000144805'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000153998'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000163181'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000169667'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000171994'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000173056'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000173582'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000174925'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000174926'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000177911'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000178703'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000189458'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000189488'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000189489'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0000189519'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0100012986'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0100015265'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0100016421'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NBNSYS0200000108'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000066288'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000066352'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000066395'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068848'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068849'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068850'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068854'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000080170'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000332255'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000375915'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000375919'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000523226'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000532663'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000546016'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000560727'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000842136'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000875699'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001697303'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771789'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771790'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771791'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771792'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771793'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771794'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771795'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771796'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771797'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771798'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771799'
GO
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771801'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771802'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771803'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771804'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771805'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0001771806'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0020083176'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0020102984'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0020152111'
-- Remove those items from NAMESERVER where the INPUT_TAXON_VERSION no longer exists
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068848'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068849'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068850'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000068854'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000066288'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000066395'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000532663'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0000546016'
DELETE from NAMESERVER where INPUT_TAXON_VERSION_KEY = 'NHMSYS0020152111'
-- Remove those items no longer in TAXON_VERSION
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000068848'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000068849'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000068850'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000068854'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000066288'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000066395'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000532663'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0000546016'
DELETE from TAXON_VERSION where TAXON_VERSION_KEY = 'NHMSYS0020152111'
-- Remove those items no longer in TAXON
DELETE from TAXON where TAXON_KEY = 'NHMSYS0000066288'
DELETE from TAXON where TAXON_KEY = 'NHMSYS0000066395'
DELETE from TAXON where TAXON_KEY = 'NHMSYS0000068848'
DELETE from TAXON where TAXON_KEY = 'NHMSYS0000068849'
DELETE from TAXON where TAXON_KEY = 'NHMSYS0000068850'
DELETE from TAXON where TAXON_KEY = 'NHMSYS0000068854'
DELETE from TAXON where TAXON_KEY = 'NHMSYS0000546016'
DELETE from TAXON where TAXON_KEY = 'NHMSYS0020150195'

-- update to the BOU list to make it non-preferred --

UPDATE TAXON_LIST SET PREFERRED = 0 WHERE TAXON_LIST_KEY = 'NHMSYS0001688402'

UPDATE TAXON_LIST SET ITEM_NAME = 'British Ornithologists'' Union categories D and E' WHERE TAXON_LIST_KEY = 'NHMSYS0001688402'