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 |