Duplicates in UK Master List

Indicia-Team / warehouse

GNU General Public License v3.0

5 stars 3 forks source link

Duplicates in UK Master List #83

Open JimBacon opened 8 years ago

JimBacon commented 8 years ago

The UK Master List contains some duplicate entries, i.e. the same taxon_id is referred to multiple times in the one list. This seems wrong to me. The following query lists such entries on warehouse1.

select taxon_id, count(*) from
taxa_taxon_lists ttl 
where taxon_list_id = 15
and deleted = false
group by taxon_id
having count(*) > 1
order by count(*)
desc

johnvanbreda commented 8 years ago

Agreed, I can't see a good reason for this. It's possibly a bug in the UKSI import script, which is pretty complex so hardly surprising.