<b>Remarque</b> : <b>Undefined offset: 63</b> ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)<br/><b>Remarque</b> : <b>Undefined offset: 63</b> ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)<br/><b>Erreur fatale</b> : <b>SQLSTATE[HY000]: General error: 1 near "=": syntax error</b> ligne 33 (/home/chdznra/www/site/app/connexion.php)<br/>select 
            E.DateGed,
            E.TriTypeUCD as Evenement,
            E.Titre as TitreEvenement,
            "individu" as Relation,
            I.Prenoms as Prenoms,
            NS.Nom as Nom,
            I.Sexe as Sexe,
            L.Ville,
            E.XrefLieu,
            SB.Titre as Subdivision,
            L.Departement,
            L.Pays,
            case
            when (E.NombreSources > 0) Then E.CodeID
            end Source,
            case
            when (E.NombreSources > 1) Then E.NombreSources
            end nbSources,
            case
            when (E.XrefNote is not Null) Then E.XrefNote
            end Note,
            Null as NoteUnion,
            E.RechercheActe,
            E.Cause,
            E.XrefIndividuProprio as CodeID,
            E.EventType,
            case
            when (E.EventType = 8 or E.EventType = 6) then (E.DateTri+0.1)
            else E.DateTri
            end DateTri
            from Evenements E 
            left join Lieux L on L.CodeID = E.XrefLieu
            left join Subdivisions SB on E.XrefSubdivision = SB.CodeID 
            left join Individus I on I.CodeID = E.XrefIndividuProprio
            left join Noms NS on I.XrefNom = NS.CodeID
            where E.XrefIndividuProprio = 5483
            and E.EventType <> 7 union 
            select 
            E.DateGed,
            E.TriTypeUCD as Evenement,
            E.Titre as TitreEvenement,
            "individu" as Relation,
            I.Prenoms as Prenoms,
            NS.Nom as Nom,
            I.Sexe as Sexe,
            L.Ville,
            E.XrefLieu,
            SB.Titre as Subdivision,
            L.Departement,
            L.Pays,
            case
            when (E.NombreSources > 0) Then E.CodeID
            end Source,
            case
            when (E.NombreSources > 1) Then E.NombreSources
            end nbSources,
            case
            when (E.XrefNote is not Null) Then E.XrefNote
            end Note,
            U.XrefNote as NoteUnion,
            E.RechercheActe,
            E.Cause,
            I.CodeID as CodeID,
            E.EventType,
            E.DateTri as DateTri
            from Evenements E 
            left join Unions U on E.XrefUnionProprio = U.CodeID 
            left join Lieux L on L.CodeID = E.XrefLieu
            left join Subdivisions SB on E.XrefSubdivision = SB.CodeID left join Individus I on I.CodeID = U. 
                left join Noms NS on I.XrefNom = NS.CodeID
                where U. = 5483 union 
            select 
            E.DateGed,
            E.TriTypeUCD as Evenement,
            E.Titre as TitreEvenement,
            "individu" as Relation,
            I.Prenoms as Prenoms,
            Ns.Nom as Nom,
            I.Sexe as Sexe,
            L.Ville,
            E.XrefLieu,
            SB.Titre as Subdivision,
            L.Departement,
            L.Pays,
            case
            when (E.NombreSources > 0) Then E.CodeID
            end Source,
            case
            when (E.NombreSources > 1) Then E.NombreSources
            end nbSources,
            case
            when (E.XrefNote is not Null) Then E.XrefNote
            end Note,
            NULL as NoteUnion,
            E.RechercheActe,
            E.Cause,
            LIE.XrefIndividuOrig as CodeID,
            E.EventType,
            E.DateTri as DateTri
            from LienIndividuEvenement LIE
            left join Evenements E on E.CodeID = LIE.XrefEvenement
            left join Lieux L on L.CodeID = E.XrefLieu
            left join Subdivisions SB on E.XrefSubdivision = SB.CodeID 
            left join Individus I on I.CodeID = LIE.XrefIndividuOrig 
            left join Noms NS on I.XrefNom = NS.CodeID
            where LIE.XrefIndividuOrig = 5483 union select 
            E.DateGed,
            E.TriTypeUCD as Evenement,
            E.Titre as TitreEvenement,
            "parents" as Relation,
            I.Prenoms as Prenoms,
            NS.Nom as Nom,
            I.Sexe as Sexe,
            L.Ville,
            E.XrefLieu,
            SB.Titre as Subdivision,
            L.Departement,
            L.Pays,
            case
            when (E.NombreSources > 0) Then E.CodeID
            end Source,
            case
            when (E.NombreSources > 1) Then E.NombreSources
            end nbSources,
            case
            when (E.XrefNote is not Null) Then E.XrefNote
            end Note,
            Null as NoteUnion,
            E.RechercheActe,
            E.Cause,
            E.XrefIndividuProprio as CodeID,
            E.EventType,
            case
            when (E.EventType = 8 or E.EventType = 6) then (E.DateTri+0.1)
            else E.DateTri
            end DateTri
            from Evenements E 
            left join Lieux L on L.CodeID = E.XrefLieu
            left join Subdivisions SB on E.XrefSubdivision = SB.CodeID 
            left join Individus I on I.CodeID = E.XrefIndividuProprio
            left join Noms NS on I.XrefNom = NS.CodeID
            where E.XrefIndividuProprio = 4980
            and E.EventType <> 7 and (E.EventType = 6 or E.EventType = 12)  union select 
            E.DateGed,
            E.TriTypeUCD as Evenement,
            E.Titre as TitreEvenement,
            "parents" as Relation,
            I.Prenoms as Prenoms,
            NS.Nom as Nom,
            I.Sexe as Sexe,
            L.Ville,
            E.XrefLieu,
            SB.Titre as Subdivision,
            L.Departement,
            L.Pays,
            case
            when (E.NombreSources > 0) Then E.CodeID
            end Source,
            case
            when (E.NombreSources > 1) Then E.NombreSources
            end nbSources,
            case
            when (E.XrefNote is not Null) Then E.XrefNote
            end Note,
            Null as NoteUnion,
            E.RechercheActe,
            E.Cause,
            E.XrefIndividuProprio as CodeID,
            E.EventType,
            case
            when (E.EventType = 8 or E.EventType = 6) then (E.DateTri+0.1)
            else E.DateTri
            end DateTri
            from Evenements E 
            left join Lieux L on L.CodeID = E.XrefLieu
            left join Subdivisions SB on E.XrefSubdivision = SB.CodeID 
            left join Individus I on I.CodeID = E.XrefIndividuProprio
            left join Noms NS on I.XrefNom = NS.CodeID
            where E.XrefIndividuProprio = 4997
            and E.EventType <> 7 and (E.EventType = 6 or E.EventType = 12)  order by DateTri, E.EventType<br/>