Project

General

Profile

Actions

task #10541

open

Incorrect orphaned synonyms

Added by Andreas Müller 2 months ago. Updated 2 months ago.

Status:
New
Priority:
New
Category:
data
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Severity:
normal
Tags:

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 #1

Updated by Andreas Müller 2 months ago

  • Tags set to cichorieae
Actions #2

Updated by Andreas Müller 2 months ago

Also check orphaned accepted taxa

Actions

Also available in: Atom PDF