1146 : SELECT password,sosa_principal,consang,media,source,nb_noms,nb_lieux,nb_dept,nb_prenoms,volume FROM got__base WHERE base = "Baird_Family_Tree" GeneoTree v4.11
Base Baird_Family_Tree Individuals Language English French Hungarian Italian  Theme aqua ivory wiki wood 
 Last Name  Places  Statistics  Events

1064 : SELECT a.id_indi ,a.nom ,a.prenom1 ,a.prenom2 ,a.prenom3 ,a.sexe ,a.profession ,a.date_naiss ,a.lieu_naiss ,a.dept_naiss ,a.date_deces ,a.lieu_deces ,a.dept_deces ,b.date_evene ,b.lieu_evene ,b.dept_evene ,case when a.id_pere = 0 then 99999999 else a.id_pere end ,case when a.id_mere = 0 then 99999999 else a.id_mere end ,a.tri ,a.sosa_dyn FROM (got_Baird_Family_Tree_individu a LEFT OUTER JOIN got_Baird_Family_Tree_evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi =
1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces FROM got_Baird_Family_Tree_individu WHERE (id_pere = "" and id_mere = "") and id_indi != "" ORDER BY tri
1064 : SELECT a.id_indi ,a.nom ,a.prenom1 ,a.prenom2 ,a.prenom3 ,a.sexe ,a.profession ,a.date_naiss ,a.lieu_naiss ,a.dept_naiss ,a.date_deces ,a.lieu_deces ,a.dept_deces ,NULL ,a.sosa_dyn ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,a.tri FROM got_Baird_Family_Tree_individu a WHERE a.id_indi =























































1064 : SELECT * FROM got_Baird_Family_Tree_individu WHERE id_indi =
1064 : SELECT note_evene FROM got_Baird_Family_Tree_evenement WHERE type_evene = "FILE" and id_indi =
1064 : SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces FROM got_Baird_Family_Tree_individu a LEFT OUTER JOIN got_Baird_Family_Tree_individu b ON (a.id_pere = b.id_indi) WHERE a.id_indi = UNION ALL SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces FROM got_Baird_Family_Tree_individu a LEFT OUTER JOIN got_Baird_Family_Tree_individu b ON (a.id_mere = b.id_indi) WHERE a.id_indi =
1064 : SELECT c.id_indi, c.nom, c.prenom1, a.anne_evene, c.lieu_naiss, c.sosa_dyn, c.sexe, c.profession, b.date_naiss, a.date_evene, c.prenom2, c.prenom3,c.date_naiss,c.dept_naiss,c.date_deces,c.lieu_deces,c.dept_deces FROM got_Baird_Family_Tree_evenement a INNER JOIN got_Baird_Family_Tree_individu b ON (a.id_wife = b.id_indi) LEFT OUTER JOIN got_Baird_Family_Tree_individu c ON (a.id_husb = c.id_indi) WHERE a.type_evene IN ("MARR") AND a.id_wife = ORDER BY 4
1146 : SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,a.date_naiss,b.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces FROM got_Baird_Family_Tree_individu a INNER JOIN got_Baird_Family_Tree_individu b ON (a.id_indi = b.id_mere) WHERE a.id_indi = "" ORDER BY b.tri
1064 : SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces FROM got_Baird_Family_Tree_individu a INNER JOIN got_Baird_Family_Tree_individu b ON ( a.id_pere = b.id_pere AND a.id_indi != b.id_indi AND a.id_pere != 0) WHERE a.id_indi = UNION SELECT b.id_indi,b.nom,b.prenom1,b.TRI,b.lieu_naiss,b.sosa_dyn,b.sexe,b.profession,b.date_naiss,a.date_naiss,b.prenom2,b.prenom3,b.date_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces FROM got_Baird_Family_Tree_individu a INNER JOIN got_Baird_Family_Tree_individu b ON (a.id_mere = b.id_mere AND a.id_indi != b.id_indi AND a.id_mere != 0) WHERE a.id_indi = ORDER BY tri
1064 : SELECT a.type_evene,a.date_evene,a.lieu_evene,CONCAT(a.note_evene," ",IFNULL(c.note_source,"")), b.id_sour, b.type_sourc,b.attr_sourc FROM got_Baird_Family_Tree_evenement a LEFT OUTER JOIN got_Baird_Family_Tree_even_sour b ON (a.id_indi = b.id_indi and a.id_husb = b.id_husb and a.id_wife = b.id_wife and a.type_evene = b.type_evene and a.date_evene = b.date_evene /*and a.dept_evene = b.dept_evene and a.lieu_evene = b.lieu_evene*/) LEFT OUTER JOIN got_Baird_Family_Tree_source c ON (b.type_sourc = "SOUR" AND b.id_sour = c.id_sour) WHERE (a.id_indi = OR a.id_husb = OR a.id_wife = ) AND a.type_evene NOT IN ("FILE","OCCU","CHAN") ORDER BY a.anne_evene,a.type_evene,b.type_sourc DESC
Print a report Root personChange root person
 
 
Parents
 
     
Sources