La Généalogie de Quentin & Clément

9198 Individus

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 (3458,4046,4512,4894,5491,3623,5236,6018 ) 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 (3458,4046,4512,4894,5491,3623,5236,6018 ) 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

Arbre d'ascendance Arbre mixte

Aperçu de l'arbre

		DE MERCIE Cenwulf en 740 en 821
			DE KENT Cénelm en 760 en 821
				DE KENT Céonwulf en 790 en 849
					DE KENT Ealswyth en 848
						DE BERNICIE Elfleda en 874 en 927
			DE MERCIE Aetheired en 820 en 866
				DE GUINES Ethelbrite en 852 en 905 à Winchester
					DE WESSEX Elstrude en 874 à Wessex en 929
						DE FLANDRE Arnould en 900 en 964 à Gand
							DE FLANDRE Baudouin en 926 en 962
							DE FLANDRE Hildegarde en 934 en 990 à Meulan (77)
							DE FLANDRE Elstrude en 945
					D'ANGLETERRE Edouard en 871 en 924 à Farndon on Dee
						D'ANGLETERRE Edmond en 922 en 946
							D'ANGLETERRE Edgard en 944 en 975 à Winchester
						D'ANGLETERRE Hedwige en 904 en 951
							DE FRANCE Louis en 921 en 954 à Reims (54)
							DE VERMANDOIS Ne... en 935
						D'ANGLETERRE Edith en 910 en 946 à ALLEMAGNE
							DE SAXE Richilde en 940 en 1020
						D'ANGLETERRE Aelfgifu en 915
							DE BOHÊME Boleslav en 999