Married The youngest | | Married The oldest |
1146 :
select
b.id_indi
,b.sosa_dyn
,b.nom
,b.prenom1
,b.tri
,DATEDIFF(STR_TO_DATE(date_evene,'%d %M %Y'), STR_TO_DATE(b.date_naiss,'%d %M %Y')) as calcul
,b.sexe
FROM (got__evenement a
LEFT OUTER JOIN got__individu b ON a.id_husb = b.id_indi)
WHERE a.type_evene = 'MARR'
and b.tri >= '' and b.tri < 2024
and b.sosa_dyn >= 0
and date_evene != ''
and date_evene not like 'ABT%'
and date_evene not like 'BEF%'
and date_evene not like 'AFT%'
and date_evene not like 'BET%'
and length(date_evene) >= 10
and date_naiss != ''
and date_naiss not like 'ABT%'
and date_naiss not like 'BEF%'
and date_naiss not like 'AFT%'
and date_naiss not like 'BET%'
and length(date_naiss) >= 10
UNION ALL
select
b.id_indi
,b.sosa_dyn
,b.nom
,b.prenom1
,b.tri
,DATEDIFF(STR_TO_DATE(date_evene,'%d %M %Y'), STR_TO_DATE(b.date_naiss,'%d %M %Y')) as calcul
,b.sexe
FROM (got__evenement a
LEFT OUTER JOIN got__individu b ON a.id_wife = b.id_indi)
WHERE a.type_evene = 'MARR'
and b.tri >= '' and b.tri < 2024
and b.sosa_dyn >= 0
and date_evene != ''
and date_evene not like 'ABT%'
and date_evene not like 'BEF%'
and date_evene not like 'AFT%'
and date_evene not like 'BET%'
and length(date_evene) >= 10
and date_naiss != ''
and date_naiss not like 'ABT%'
and date_naiss not like 'BEF%'
and date_naiss not like 'AFT%'
and date_naiss not like 'BET%'
and length(date_naiss) >= 10
ORDER BY calcul asc LIMIT 0,30 |
| 1146 :
select
b.id_indi
,b.sosa_dyn
,b.nom
,b.prenom1
,b.tri
,DATEDIFF(STR_TO_DATE(date_evene,'%d %M %Y'), STR_TO_DATE(b.date_naiss,'%d %M %Y')) as calcul
,b.sexe
FROM (got__evenement a
LEFT OUTER JOIN got__individu b ON a.id_husb = b.id_indi)
WHERE a.type_evene = 'MARR'
and b.tri >= '' and b.tri < 2024
and b.sosa_dyn >= 0
and date_evene != ''
and date_evene not like 'ABT%'
and date_evene not like 'BEF%'
and date_evene not like 'AFT%'
and date_evene not like 'BET%'
and length(date_evene) >= 10
and date_naiss != ''
and date_naiss not like 'ABT%'
and date_naiss not like 'BEF%'
and date_naiss not like 'AFT%'
and date_naiss not like 'BET%'
and length(date_naiss) >= 10
UNION ALL
select
b.id_indi
,b.sosa_dyn
,b.nom
,b.prenom1
,b.tri
,DATEDIFF(STR_TO_DATE(date_evene,'%d %M %Y'), STR_TO_DATE(b.date_naiss,'%d %M %Y')) as calcul
,b.sexe
FROM (got__evenement a
LEFT OUTER JOIN got__individu b ON a.id_wife = b.id_indi)
WHERE a.type_evene = 'MARR'
and b.tri >= '' and b.tri < 2024
and b.sosa_dyn >= 0
and date_evene != ''
and date_evene not like 'ABT%'
and date_evene not like 'BEF%'
and date_evene not like 'AFT%'
and date_evene not like 'BET%'
and length(date_evene) >= 10
and date_naiss != ''
and date_naiss not like 'ABT%'
and date_naiss not like 'BEF%'
and date_naiss not like 'AFT%'
and date_naiss not like 'BET%'
and length(date_naiss) >= 10
ORDER BY calcul desc LIMIT 0,30 |
|
Married Shortest |
|
Married Longest |
1146 : SELECT b.id_indi
,max(b.sosa_dyn)
,max(b.nom)
,max(b.prenom1)
,max(b.tri),min(CASE WHEN STR_TO_DATE(b.date_deces,'%d %M %Y') < STR_TO_DATE(c.date_deces,'%d %M %Y')
THEN DATEDIFF(STR_TO_DATE(b.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
ELSE DATEDIFF(STR_TO_DATE(c.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
END) as calcul,'M' 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)
WHERE a.type_evene = 'MARR'
and a.date_evene != ''
and a.date_evene not like 'ABT%'
and a.date_evene not like 'BEF%'
and a.date_evene not like 'AFT%'
and a.date_evene not like 'BET%'
and length(a.date_evene) >= 10
and b.date_deces != ''
and b.date_deces not like 'ABT%'
and b.date_deces not like 'BEF%'
and b.date_deces not like 'AFT%'
and b.date_deces not like 'BET%'
and length(b.date_deces) >= 10
and c.date_deces != ''
and c.date_deces not like 'ABT%'
and c.date_deces not like 'BEF%'
and c.date_deces not like 'AFT%'
and c.date_deces not like 'BET%'
and length(c.date_deces) >= 10 GROUP BY b.id_indi
HAVING max(b.tri) >= '' and max(b.tri) < 2024 AND MAX(b.sosa_dyn) >= 0 UNION ALL SELECT c.id_indi
,max(c.sosa_dyn)
,max(c.nom)
,max(c.prenom1)
,max(c.tri),min(CASE WHEN STR_TO_DATE(b.date_deces,'%d %M %Y') < STR_TO_DATE(c.date_deces,'%d %M %Y')
THEN DATEDIFF(STR_TO_DATE(b.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
ELSE DATEDIFF(STR_TO_DATE(c.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
END) as calcul,'F' 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)
WHERE a.type_evene = 'MARR'
and a.date_evene != ''
and a.date_evene not like 'ABT%'
and a.date_evene not like 'BEF%'
and a.date_evene not like 'AFT%'
and a.date_evene not like 'BET%'
and length(a.date_evene) >= 10
and b.date_deces != ''
and b.date_deces not like 'ABT%'
and b.date_deces not like 'BEF%'
and b.date_deces not like 'AFT%'
and b.date_deces not like 'BET%'
and length(b.date_deces) >= 10
and c.date_deces != ''
and c.date_deces not like 'ABT%'
and c.date_deces not like 'BEF%'
and c.date_deces not like 'AFT%'
and c.date_deces not like 'BET%'
and length(c.date_deces) >= 10 GROUP BY c.id_indi
HAVING max(c.tri) >= '' and max(c.tri) < 2024 AND MAX(c.sosa_dyn) >= 0 ORDER BY calcul asc
LIMIT 0,30 |
| 1146 : SELECT b.id_indi
,max(b.sosa_dyn)
,max(b.nom)
,max(b.prenom1)
,max(b.tri),max(CASE WHEN STR_TO_DATE(b.date_deces,'%d %M %Y') < STR_TO_DATE(c.date_deces,'%d %M %Y')
THEN DATEDIFF(STR_TO_DATE(b.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
ELSE DATEDIFF(STR_TO_DATE(c.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
END) as calcul,'M' 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)
WHERE a.type_evene = 'MARR'
and a.date_evene != ''
and a.date_evene not like 'ABT%'
and a.date_evene not like 'BEF%'
and a.date_evene not like 'AFT%'
and a.date_evene not like 'BET%'
and length(a.date_evene) >= 10
and b.date_deces != ''
and b.date_deces not like 'ABT%'
and b.date_deces not like 'BEF%'
and b.date_deces not like 'AFT%'
and b.date_deces not like 'BET%'
and length(b.date_deces) >= 10
and c.date_deces != ''
and c.date_deces not like 'ABT%'
and c.date_deces not like 'BEF%'
and c.date_deces not like 'AFT%'
and c.date_deces not like 'BET%'
and length(c.date_deces) >= 10 GROUP BY b.id_indi
HAVING max(b.tri) >= '' and max(b.tri) < 2024 AND MAX(b.sosa_dyn) >= 0 UNION ALL SELECT c.id_indi
,max(c.sosa_dyn)
,max(c.nom)
,max(c.prenom1)
,max(c.tri),max(CASE WHEN STR_TO_DATE(b.date_deces,'%d %M %Y') < STR_TO_DATE(c.date_deces,'%d %M %Y')
THEN DATEDIFF(STR_TO_DATE(b.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
ELSE DATEDIFF(STR_TO_DATE(c.date_deces,'%d %M %Y'), STR_TO_DATE(a.date_evene,'%d %M %Y'))
END) as calcul,'F' 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)
WHERE a.type_evene = 'MARR'
and a.date_evene != ''
and a.date_evene not like 'ABT%'
and a.date_evene not like 'BEF%'
and a.date_evene not like 'AFT%'
and a.date_evene not like 'BET%'
and length(a.date_evene) >= 10
and b.date_deces != ''
and b.date_deces not like 'ABT%'
and b.date_deces not like 'BEF%'
and b.date_deces not like 'AFT%'
and b.date_deces not like 'BET%'
and length(b.date_deces) >= 10
and c.date_deces != ''
and c.date_deces not like 'ABT%'
and c.date_deces not like 'BEF%'
and c.date_deces not like 'AFT%'
and c.date_deces not like 'BET%'
and length(c.date_deces) >= 10 GROUP BY c.id_indi
HAVING max(c.tri) >= '' and max(c.tri) < 2024 AND MAX(c.sosa_dyn) >= 0 ORDER BY calcul desc
LIMIT 0,30 |
|
|
| 1064 :
SELECT *
FROM got__individu
WHERE id_indi =
|
1064 : SELECT note_evene
FROM got__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__individu a
LEFT OUTER JOIN got__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__individu a
LEFT OUTER JOIN got__individu b ON (a.id_mere = b.id_indi)
WHERE a.id_indi =
|
Parents |
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__evenement a
INNER JOIN got__individu b ON (a.id_wife
= b.id_indi)
LEFT OUTER JOIN got__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__individu a
INNER JOIN got__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__individu a
INNER JOIN got__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__individu a
INNER JOIN got__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__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*/)
LEFT OUTER JOIN got__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 DESCSources |
|