<b>Avertissement</b> : <b>Undefined variable $XrefNom</b> ligne 143 (/home/chdznra/www/site/listeEclair.php)<br/><b>Erreur fatale</b> : <b>count(): Argument #1 ($value) must be of type Countable|array, null given</b> ligne 143 (/home/chdznra/www/site/listeEclair.php)<br/>select 
        CodeNom, 
        NomUCD, Nom, 
        MIN(DateMin) as DateMin, 
        MAX(DateMax) as DateMax, 
        count(distinct(Individu)) as nbIndividu
        from
        (select
        Noms.CodeID as CodeNom,
        Noms.NomUCD,
        Noms.Nom,
        substr(Evenements.DateGed,-4) as DateMin,
        substr(Evenements.DateGed,-4) as DateMax,
        Individus.CodeID as Individu,
        Individus.Confidentiel as Confidentiel
        from Evenements
        join individus on Individus.CodeID = Evenements.XrefIndividuProprio
        join Noms on Noms.CodeID = Individus.XrefNom
        join Lieux on Lieux.CodeID = Evenements.XrefLieu
        where Evenements.XrefLieu = 258453
        and Evenements.EventType <> 94
        union
        select
        Noms.CodeID as CodeNom,
        Noms.NomUCD,
        Noms.Nom,
        substr(Evenements.DateGed,-4) as DateMin,
        substr(Evenements.DateGed,-4) as DateMax,
        Individus.CodeID as Individu,
        Individus.Confidentiel as Confidentiel
        from LienIndividuEvenement
        join individus on Individus.CodeID = LienIndividuEvenement.XrefIndividuOrig
        join Evenements on LienIndividuEvenement.XrefEvenement= Evenements.CodeID
        join Noms on Noms.CodeID = Individus.XrefNom
        join Lieux on Lieux.CodeID = Evenements.XrefLieu
        where Evenements.XrefLieu = 258453
        union
        select 
        Noms.CodeID as CodeNom,
        Noms.NomUCD,
        Noms.Nom,
        substr(Evenements.DateGed,-4) as DateMin,
        substr(Evenements.DateGed,-4) as DateMax,
        Individus.CodeID as Individu,
        Individus.Confidentiel as Confidentiel
        from Evenements
        join Unions on Unions.CodeID = Evenements.XrefUnionProprio
        join Lieux on Lieux.CodeID = Evenements.XrefLieu
        join Individus on (Individus.CodeID = Unions.XrefEpouse or Individus.CodeID = Unions.XrefEpoux)
        join Noms on Individus.XrefNom = Noms.CodeID
        where Evenements.XrefLieu = 258453
        and (Evenements.EventType = 61 or Evenements.EventType = 57 or Evenements.EventType = 59)
        ) where Confidentiel = 0 group by Nom<br/>