 | 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 |
 | Geography |
cujd
1146 : INSERT INTO got_t_temp SELECT b.id_indi, b.nom, b.prenom1, a.date_evene, a.lieu_evene, b.sosa_dyn,b.sexe FROM (got__evenement a INNER JOIN got__individu b ON a.id_indi = b.id_indi) WHERE a.type_evene in ("BIRT","DEAT") AND nom = "cujd" UNION ALL SELECT b.id_indi, b.nom, b.prenom1, a.date_evene, a.lieu_evene, b.sosa_dyn,b.sexe FROM (got__evenement a INNER JOIN got__individu b ON a.id_husb = b.id_indi) WHERE a.type_evene in ("MARR") AND nom = "cujd" UNION ALL SELECT b.id_indi, b.nom, b.prenom1, a.date_evene, a.lieu_evene, b.sosa_dyn,b.sexe FROM (got__evenement a INNER JOIN got__individu b ON a.id_wife = b.id_indi) WHERE a.type_evene in ("MARR") AND nom = "cujd"
1064 : SELECT nom,prenom1,date_naiss,lieu_naiss,sexe 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/_sql.inc.php on line 123
The following individual will becoming the default individual