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 : 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 (2777,6667 )
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 (2777,6667 )
and if (a.id_indi != @old, 'O', 'N') = 'O'
