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 (3494,4194,4852,6647 ) 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 (3494,4194,4852,6647 ) and if (a.id_indi != @old, 'O', 'N') = 'O'

Arbre d'ascendance Arbre mixte

Aperçu de l'arbre

DE VALOIS Gauthier en 920 en 992
	DE VALOIS Gauthier en 966 en 1023
		DE VALOIS Alix
			DE MEULAN Galeran en 1005 en 1069
				DE MEULAN Adeline en 1023 en 1081
					DE BEAUMONT-LE-ROGER Robert en 1050 à Pont Audemer (27) en 1118 à Leicestershire
						DE MEULAN Galerand en 1103 à Leicester en 1166 à Préaux (76)
							DE MEULAN Robert en 1204
								DE MEULAN Agnès en 1222
							DE BEAUMONT-LE-ROGER DE MEULAN Isabelle en 1147 à Meulan (78) en 1220 à Savigny sur Orge (91)
								DE MAYENNE Juhel en 1166 en 1220 à Tunis
								DE CRAON Amaury en 1170 en 1226 à La Roë (53)
				DE MEULAN Marie en 1025
					DE TALBOT DE CLEUVILLE Jeanne en 1045 en 1107
						D'ESTOUTEVILLE Mauricette en 1063
							DE RIEUX Gaucelin en 1080 en 1111
								DE RIEUX Guéhénoc en 1106 en 1149