|
|
| 1064 :
SELECT *
FROM got__individu
WHERE id_indi =
|
1064 : SELECT note_evene
FROM got__evenement
WHERE type_evene = "FILE"
and id_indi =
|
|
| 1064 :
SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces
FROM got__individu a
LEFT OUTER JOIN got__individu b ON (a.id_pere = b.id_indi)
WHERE a.id_indi =
UNION ALL
SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces
FROM got__individu a
LEFT OUTER JOIN got__individu b ON (a.id_mere = b.id_indi)
WHERE a.id_indi =
|
Parents |
1064 :
SELECT c.id_indi, c.nom, c.prenom1, a.anne_evene, c.lieu_naiss, c.sosa_dyn, c.sexe, c.profession, b.date_naiss, a.date_evene, c.prenom2, c.prenom3,c.date_naiss,c.dept_naiss,c.date_deces,c.lieu_deces,c.dept_deces
FROM got__evenement a
INNER JOIN got__individu b ON (a.id_wife
= b.id_indi)
LEFT OUTER JOIN got__individu c ON (a.id_husb = c.id_indi)
WHERE a.type_evene IN ("MARR")
AND a.id_wife =
ORDER BY 4
1146 :
SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,a.date_naiss,b.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces
FROM got__individu a
INNER JOIN got__individu b ON (a.id_indi = b.id_mere) WHERE a.id_indi = ""
ORDER BY b.tri 1064 : SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces
FROM got__individu a
INNER JOIN got__individu b ON ( a.id_pere = b.id_pere AND a.id_indi != b.id_indi AND a.id_pere != 0)
WHERE a.id_indi =
UNION
SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces
FROM got__individu a
INNER JOIN got__individu b ON (a.id_mere = b.id_mere AND a.id_indi != b.id_indi AND a.id_mere != 0)
WHERE a.id_indi =
ORDER BY tri
|
|
Cousins | 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,NULL
,a.sosa_dyn
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,a.tri
FROM got__individu a
WHERE a.id_indi = 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,NULL
,a.sosa_dyn
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,a.tri
FROM got__individu a
WHERE a.id_indi = 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri 1064 : SELECT
a.id_indi
,a.nom
,a.prenom1
,a.prenom2
,a.prenom3
,a.sexe
,a.profession
,a.date_naiss
,a.lieu_naiss
,a.dept_naiss
,a.date_deces
,a.lieu_deces
,a.dept_deces
,b.date_evene
,b.lieu_evene
,b.dept_evene
,case when a.id_pere = 0 then 99999999 else a.id_pere end
,case when a.id_mere = 0 then 99999999 else a.id_mere end
,a.tri
,a.sosa_dyn
FROM (got__individu a
LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = 1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
FROM got__individu
WHERE (id_pere = "" and id_mere = "")
and id_indi != ""
ORDER BY tri
|