task #9364
closedCleanup authors with multiple & and protected names and teams
100%
Description
(high priority only to first issue as it is related to #2200)
In context of #2200 I already checked names with >1 "&" in nameCache. These are cleanedup.
But there are open issues with TeamOrPerson.nomenclaturalTitle:
Campanula: 43
Diptera: 77
FdAC: 92
Palmae: 266 !
Guianas: 3(?) => unparsed collectors with 2 collectors having the same family name
FM: 59(?) => remaining issues are all MAN with some second author team with unclear semantics needs to be fixed during next import
SELECT ab.DTYPE, ab.id, ab.titleCache, ab.nomenclaturaltitle, ab.protectedtitlecache, ab.protectednomenclaturaltitlecache FROM AgentBase ab WHERE ab.nomenclaturaltitle LIKE '%&%&%' OR ab.titleCache LIKE '%&%&%';
In some databases there are many names with protected caches which may lead to problems when searching for names.
SELECT tn.id, tn.titleCache, tn.nameCache, tn.protectedTitleCache, tn.protectedNameCache, tn.protectedFullTitleCache, tn.protectedAuthorshipCache , tn.* FROM TaxonName tn WHERE tn.protectednamecache = 1 OR tn.protectedtitlecache = 1 OR tn.protectedFullTitleCache = 1 OR tn.protectedAuthorshipCache ;
Especially interesting might be those having an "&" in the protected nameCache which indicates that there is authorship in the nameCache which should not happen.
Also many Teams have a protected nomenclatural title which is in most cases not necessary.
SELECT ab.id, ab.DTYPE, ab.titleCache, ab.nomenclaturaltitle, ab.protectedtitlecache, ab.protectednomenclaturaltitlecache, ab.* FROM AgentBase ab WHERE -- ab.protectedtitlecache = 1 OR ab.protectednomenclaturaltitlecache = 1 ORDER BY ab.nomenclaturaltitle
However, in most cases this is not critical.
Related issues