PhycoBank

sql to test

select * from AgentBase a 
    where DTYPE = 'Person'
        and a.lastname is null AND a.firstname is null AND a.initials is NULL 
        AND (a.protectedTitleCache = 0 OR a.protectedCollectorTitleCache  = 0 OR a.protectedNomenclaturalTitleCache = 0)

select * from AgentBase a left join AgentBase_AgentBase a_a on a_a.Team_id = a.id
    where DTYPE = 'Team'
        and a_a.Team_id is null
        AND (a.protectedTitleCache = 0 OR a.protectedCollectorTitleCache  = 0 OR a.protectedNomenclaturalTitleCache = 0)

and the query to fix the data:

UPDATE AgentBase a left join AgentBase_AgentBase a_a on a_a.Team_id = a.id
    SET a.protectedTitleCache = 1, a.protectedCollectorTitleCache  = 1, a.protectedNomenclaturalTitleCache = 1
 WHERE 
    DTYPE = 'Team'
    AND a_a.Team_id is null
    AND (a.protectedTitleCache = 0 OR a.protectedCollectorTitleCache  = 0 OR a.protectedNomenclaturalTitleCache = 0)

UPDATE AgentBase a left join AgentBase_AgentBase a_a on a_a.Team_id = a.id
    SET a.protectedTitleCache = 1, a.protectedCollectorTitleCache  = 1, a.protectedNomenclaturalTitleCache = 1
 WHERE 
    DTYPE = 'Person'
    and a.lastname is null AND a.firstname is null AND a.initials is NULL 
    AND (a.protectedTitleCache = 0 OR a.protectedCollectorTitleCache  = 0 OR a.protectedNomenclaturalTitleCache = 0)

applied to all databases!