 | Base | ||||||
| Trees | Lists | Graphs | Sources | Medias | |||
1146 : SELECT nom,count(*) FROM got__individu WHERE nom != "" GROUP BY nom ORDER BY nom
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/_stat.inc.php on line 51
 |  | Lists Last Name AA - ZZ |
1146 : SELECT CASE concat(a.type_evene,e.couple) WHEN "BIRT1" THEN d.nom WHEN "DEAT1" THEN d.nom WHEN "BIRT2" THEN d.nom WHEN "DEAT2" THEN d.nom WHEN "MARR1" THEN b.nom WHEN "MARR2" THEN c.nom END as col ,lieu_evene ,count( distinct CASE concat(a.type_evene,e.couple) WHEN "BIRT1" THEN d.id_indi WHEN "DEAT1" THEN d.id_indi WHEN "BIRT2" THEN d.id_indi WHEN "DEAT2" THEN d.id_indi WHEN "MARR1" THEN b.id_indi WHEN "MARR2" THEN c.id_indi END) ,max(a.dept_evene) ,MIN(a.anne_evene) ,MAX(a.anne_evene) FROM ((((got__evenement a LEFT OUTER JOIN got__individu b ON a.id_husb = b.id_indi) LEFT OUTER JOIN got__individu c ON a.id_wife = c.id_indi) LEFT OUTER JOIN got__individu d ON a.id_indi = d.id_indi) LEFT OUTER JOIN got_t_couple e ON 1=1) WHERE a.type_evene in ("MARR","BIRT","DEAT") and ( (b.nom >= " AA" and b.nom < "ZZ") or (c.nom >= " AA" and c.nom < "ZZ") or (d.nom >= " AA" and d.nom < "ZZ") ) GROUP BY col,lieu_evene
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/154/sdb/b/5/mamitree/listes.php on line 129 |
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