1146 : INSERT INTO gene_2167321723_desc_cles
SELECT
a.id_indi
, case when b.id_wife is not NULL then b.id_wife when c.id_husb is not NULL then c.id_husb end
, case when b.id_wife is not NULL then b.date_evene when c.id_husb is not NULL then c.date_evene end
, case when b.id_wife is not NULL then b.lieu_evene when c.id_husb is not NULL then c.lieu_evene end
, case when b.id_wife is not NULL then b.dept_evene when c.id_husb is not NULL then c.dept_evene end
, a.id_pere
,if (a.id_indi != @old, 'O', 'N')
,@old := a.id_indi
FROM `gene_sds-full_individu` a
LEFT OUTER JOIN `gene_sds-full_evenement` b ON (a.id_indi = b.id_husb and b.type_evene = 'MARR')
LEFT OUTER JOIN `gene_sds-full_evenement` c ON (a.id_indi = c.id_wife and c.type_evene = 'MARR')
where a.id_pere IN (3717,3394,5658,3432,3715,6428,3779,3387,4709,4264,3712,5351,3516,5202,4061,5203,3845,4299,3850,3910,4209,3865,4172,4542,5578,3659,3886,4500,3592,4835,6552,4043,3435,4866,5144,4325,6569,4223,4571,3588,6006,4298,6237,5036,6502,6593 )
and if (a.id_indi != @old, 'O', 'N') = 'O'
UNION ALL
SELECT
a.id_indi
, case when b.id_wife is not NULL then b.id_wife when c.id_husb is not NULL then c.id_husb end
, case when b.id_wife is not NULL then b.date_evene when c.id_husb is not NULL then c.date_evene end
, case when b.id_wife is not NULL then b.lieu_evene when c.id_husb is not NULL then c.lieu_evene end
, case when b.id_wife is not NULL then b.dept_evene when c.id_husb is not NULL then c.dept_evene end
, a.id_mere
,if (a.id_indi != @old, 'O', 'N')
,@old := a.id_indi
FROM `gene_sds-full_individu` a
LEFT OUTER JOIN `gene_sds-full_evenement` b ON (a.id_indi = b.id_husb and b.type_evene = 'MARR')
LEFT OUTER JOIN `gene_sds-full_evenement` c ON (a.id_indi = c.id_wife and c.type_evene = 'MARR')
where a.id_mere IN (3717,3394,5658,3432,3715,6428,3779,3387,4709,4264,3712,5351,3516,5202,4061,5203,3845,4299,3850,3910,4209,3865,4172,4542,5578,3659,3886,4500,3592,4835,6552,4043,3435,4866,5144,4325,6569,4223,4571,3588,6006,4298,6237,5036,6502,6593 )
and if (a.id_indi != @old, 'O', 'N') = 'O'
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