 | Base | ||||||
| Trees | Lists | Graphs | Sources | Medias | |||
 |  | Source list |
|
1146 : SELECT a.id_indi, a.date_evene, a.lieu_evene, a.dept_evene , b.sosa_dyn, b.nom, b.prenom1, b.prenom2, b.prenom3, b.sexe , c.nom, c.prenom1, c.prenom2, c.prenom3 , d.nom, d.prenom1, d.prenom2, d.prenom3 , a.type_evene , a.note_evene FROM (((got__individu b INNER JOIN got__evenement a ON a.id_indi = b.id_indi) LEFT OUTER JOIN got__individu c ON b.id_pere = c.id_indi) LEFT OUTER JOIN got__individu d ON b.id_mere = d.id_indi) WHERE a.type_evene like "BIRT%" AND b.nom like "%" AND b.prenom1 like "%" and b.sosa_dyn >= 0 AND c.nom like "%" AND d.nom like "%" AND a.anne_evene between "" and "9999" AND a.lieu_evene like "%" ORDER BY a.anne_evene,b.nom,b.prenom1 LIMIT 0,100
| Type | Name | Date | Places | Places | Father | Mother | Note |
1146 : SELECT id_indi FROM got__individu LIMIT 0,1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/_sql.inc.php on line 113
| Cousins | Default individual |
1064 : SELECT note_evene FROM got__evenement WHERE type_evene = "FILE" and id_indi =
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 77
1064 : SELECT * FROM got__individu WHERE id_indi =
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 87
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 102
1064 : SELECT a.type_evene,a.date_evene,a.lieu_evene,a.note_evene, b.id_sour, b.type_sourc,b.attr_sourc FROM (got__evenement a LEFT OUTER JOIN got__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) WHERE a.type_evene != "FILE" and a.id_indi = ORDER BY 1,2,3
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 121
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 122
FATHER
MOTHER
UNIONS
1064 : SELECT b.id_indi,b.nom,b.prenom1,b.prenom2,b.prenom3,b.sexe,b.profession, a.date_evene,a.lieu_evene,dept_evene,note_evene,b.sosa_dyn,b.sexe,a.id_husb,a.id_wife,a.type_evene FROM got__evenement a, got__individu b WHERE a.type_evene = "MARR" and (a.id_husb = b.id_indi) and a.id_wife =
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 245
Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 246
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 247
1064 : SELECT distinct b.id_indi,nom,prenom1,prenom2,prenom3,sexe,profession, date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces,note_indi,sosa_dyn FROM got__relation a, got__individu b WHERE (a.id_enfant = b.id_indi) and (a.id_parent = NULL or a.id_parent = NULL) and a.id_enfant != ORDER BY b.tri
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 268
BROTHERS AND SISTERS
1064 : SELECT b.id_indi,b.prenom1,b.prenom2,b.prenom3,b.nom,b.profession, b.date_naiss,b.lieu_naiss,b.dept_naiss,b.date_deces,b.lieu_deces,b.dept_deces,b.note_indi,b.sosa_dyn,b.sexe FROM got__relation a, got__individu b WHERE (a.id_enfant = b.id_indi) and a.id_parent = ORDER BY b.tri
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/fiche.php on line 297
CHILDREN