[CHECK] Handle Bibliography Name Facts correctly
There are 13568 name facts of type "Bibliography" (Cat=3).
These are currently attached to the according names as TaxonNameDescription with feature "Citation".
The citations seem to come from ILDIS but the names are also used in 7600000 so they often appear twice.
The Citations currently do not show up in the BM data portal. In CDM they show up behind the name formatted same as second nomenclatural references.
Decisions to take:
- Should they show up in the data portal => probably not (see #7796#note-8)
- Depending on this, keep them as TaxonName Citations or make them TaxonName extensions. The later may not show up in the portal by default.
If keeping them as TaxonNameDescriptions make these available by TaxEditor again
- If extensions, implement extension import (with own feature)
Decisition: we keep them as citations
#3 Updated by Andreas Müller over 2 years ago
SELECT n.NameCache, n.FullNameCache, n.NomRefFk, pt.PTRefFk, fact.NameFactId, fact.PTNameFk, fact.NameFact, n.notes, pt.Notes, fact.NameFactCategoryFk, fact.NameFactRefFk, fact.DoubtfulFlag, fact.PublishFlag, fact.Created_When, fact.Updated_When, fact.Created_Who, fact.Updated_Who, fact.Notes, fact.NameFactRefDetail, pt.PublishFlag FROM NameFact fact INNER JOIN Name AS n ON fact.PTNameFk = n.NameId LEFT OUTER JOIN PTaxon pt ON pt.PTNameFk = fact.PTNameFk AND pt.PTRefFK NOT IN (500000) WHERE (fact.NameFactCategoryFk = 3) ORDER BY pt.PTRefFk, n.FullNameCache;
SELECT DISTINCT fact.NameFactId FROM NameFact fact WHERE (fact.NameFactCategoryFk = 3)