Erreur fatale : SQLSTATE[HY000]: General error: 1 incomplete input ligne 30 (/home/chdznra/www/site/app/connexion.php)
select
I.CodeID as CodeID,
I.Sexe as Sexe,
I.NombreUnions as NombreUnions,
I.NombreEnfants as NombreEnfants,
CASE
WHEN E.DateTri is Null THEN 9223372036854775808
ELSE E.DateTri
END as DateTri
from Individus I
left join Evenements E on E.CodeID = I.XrefMainEventNaissance
where (XrefPere = 37840 or XrefMere =37842) and I.CodeID !=37834 and I.Confidentiel < 1 union select
I.CodeID as CodeID,
I.Sexe as Sexe,
I.NombreUnions as NombreUnions,
I.NombreEnfants as NombreEnfants,
CASE
WHEN E.DateTri is Null THEN 9223372036854775808
ELSE E.DateTri
END as DateTri
from Individus I
left join Evenements E on E.CodeID = I.XrefMainEventNaissance
where (XrefPere = 37847) and I.CodeID !=37836 and I.Confidentiel < 1 order by DateTri