   tc.id,
   NULL AS parent_id,
   taxonomies.name,
-  CASE WHEN taxonomies.name = 'CITES' THEN TRUE ELSE FALSE END AS taxonomy_is_cites_eu,
+  CASE WHEN taxonomies.name = 'CITES_EU' THEN TRUE ELSE FALSE END AS taxonomy_is_cites_eu,
   tc.full_name,
   tc.author_year,
   'S' AS name_status,

  created_at,
  FALSE AS active -- deleted taxa
  FROM taxon_concept_versions
  WHERE event = 'destroy'
;
  taxon_concept_id,
  NULL AS parent_id,
  taxonomy_name,
  CASE WHEN taxonomy_name = 'CITES_EU' THEN TRUE ELSE FALSE END AS taxonomy_is_cites_eu,
  full_name,
  author_year,
  name_status,
