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 (4783,6399,4198,4811,6645 ) 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 (4783,6399,4198,4811,6645 ) 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

 Aperçu de l'arbre

DE VERMANDOIS Herbert
en 945
en 967
DE VERMANDOIS Adèle
en 967
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 LA ROCHE-GUYON Hélissende
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 MAYENNE Gervaise
DE MAYENNE Marguerite
en 1208
en 1248
DE CRAON Amaury
en 1170
en 1226 à La Roë (53)
DE CRAON Maurice
en 1213
en 1250
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
DE RIEUX Guillaume
en 1125
en 1180