| 25,6 → 25,7 |
|---|
| eflore_vernaculaire_attribution AS attribution, |
| eflore_taxon AS taxon, |
| eflore_selection_nom AS selection, |
| eflore_selection_nom_statut AS statut, |
| eflore_nom AS nom, |
| eflore_nom_intitule AS intitule |
| |
| 32,9 → 33,19 |
|---|
| intitule.eni_id_categorie_format = 3 |
| AND intitule.eni_id_valeur_format = 4 |
| AND intitule.eni_id_nom = nom.en_id_nom |
| AND nom.en_id_nom NOT IN |
| ( |
| SELECT nom_relation.enr_id_nom_1 |
| FROM eflore_nom_relation AS nom_relation |
| WHERE nom_relation.enr_id_nom_1 = nom_relation.enr_id_nom_2 |
| AND nom_relation.enr_id_categorie_relation = 10 |
| AND nom_relation.enr_id_valeur_relation = 3 |
| ) |
| AND nom.en_id_nom = selection.esn_id_nom |
| AND selection.esn_id_taxon = taxon.et_id_taxon |
| AND selection.esn_id_version_projet_taxon = taxon.et_id_version_projet_taxon |
| AND selection.esn_ce_statut = statut.esns_id_statut |
| AND statut.esns_id_statut = 3 |
| AND taxon.et_id_version_projet_taxon = attribution.eva_id_version_projet_taxon_ref |
| AND taxon.et_id_taxon = attribution.eva_id_taxon_ref |
| AND attribution.eva_id_nom_vernaculaire = vernaculaire.ev_id_nom_vernaculaire |