1050 :
CREATE TABLE gene_2167321723_desc_cles (
id_indi int NOT NULL default 0,
id_conj int NULL,
date_maria varchar(32),
lieu_maria varchar(32),
dept_maria varchar(32),
id_parent int,
c char(1) NULL,
d int NULL) engine = myisam default character set utf8 collate utf8_general_ci
1146 : SELECT
a.id_indi
,b.nom
,b.prenom1
,b.prenom2
,b.prenom3
,b.sexe
,b.profession
,b.date_naiss
,b.lieu_naiss
,b.dept_naiss
,b.date_deces
,b.lieu_deces
,b.dept_deces
,a.id_parent
,b.sosa_dyn
,a.id_conj
,a.date_maria
,a.lieu_maria
,a.dept_maria
,c.nom
,c.prenom1
,c.prenom2
,c.prenom3
,c.sexe
,c.sosa_dyn
,b.tri
,b.nickname
,b.titre
,b.etiquette
FROM gene_2167321723_desc_cles a
INNER JOIN `gene_sds-full_individu` b ON (a.id_indi = b.id_indi)
LEFT OUTER JOIN `gene_sds-full_individu` c ON (a.id_conj = c.id_indi)
ORDER BY a.id_parent, b.tri
