Remarque : Undefined offset: 63 ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Undefined offset: 63 ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Erreur fatale : SQLSTATE[HY000]: General error: 1 near "=": syntax error ligne 33 (/home/chdznra/www/site/app/connexion.php)
select
E.DateGed,
E.TriTitreUCD as Evenement,
"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,
I.XrefNoteRecherche as NoteRecherche,
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.TriTitreUCD as Evenement,
"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 NoteRecherche,
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.TriTitreUCD as Evenement,
"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 NoteRecherche,
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.TriTitreUCD as Evenement,
"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,
I.XrefNoteRecherche as NoteRecherche,
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.TriTitreUCD as Evenement,
"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,
I.XrefNoteRecherche as NoteRecherche,
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