Actions
task #10541
openIncorrect orphaned synonyms
Start date:
Due date:
% Done:
0%
Estimated time:
Severity:
normal
Description
1700 incorrect orphaned synonyms observed in Cichorieae.
SELECT tb.id, tb.uuid, tn.id, tn.titleCache, tn.namecache FROM TaxonBase tb LEFT JOIN TaxonName tn ON tn.id = tb.name_id WHERE tb.DTYPE = 'Synonym' AND tb.acceptedTaxon_id IS NULL ORDER BY tn.titleCache
We need to
- clean the data
- check, why this happened (I could reproduce this a couple of days ago, but don't remember how)
Actions