1146 :
SELECT SQL_CALC_FOUND_ROWS a.date_evene, a.lieu_evene, a.dept_evene
,b.id_indi, b.sosa_dyn, b.nom, b.prenom1, b.prenom2, b.prenom3, b.sexe
,c.id_indi, c.sosa_dyn, c.nom, c.prenom1, c.prenom2, c.prenom3, c.sexe
,d.nom, d.prenom1, d.prenom2, d.prenom3
,a.type_evene, a.anne_evene
,a.note_evene, e.id_sour
,long_evene
,lati_evene
,xpix_evene
,ypix_evene
FROM got__evenement a
INNER JOIN got__individu b 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
LEFT OUTER JOIN got__even_sour e ON a.id_indi = e.id_indi and a.type_evene = e.type_evene AND e.type_sourc = "SOUR"
WHERE a.type_evene NOT IN ("NOTE","FILE","OCCU","CHAN","RFN","RIN")
AND a.type_evene like "%"
AND b.sexe LIKE "_"
AND b.sosa_dyn >= 0
AND CONCAT(IFNULL(LOWER(b.nom),""),IFNULL(LOWER(a.anne_evene),""),IFNULL(LOWER(a.lieu_evene),""),IFNULL(LOWER(a.dept_evene),""),IFNULL(LOWER(c.nom),""),IFNULL(LOWER(d.nom),""),IFNULL(LOWER(a.note_evene),"")) LIKE "%%"
UNION ALL
SELECT a.date_evene, max(a.lieu_evene), max(a.dept_evene)
,a.id_husb, max(b.sosa_dyn), max(b.nom), max(b.prenom1), max(b.prenom2), max(b.prenom3), max(b.sexe)
,a.id_wife, max(c.sosa_dyn), max(c.nom), max(c.prenom1), max(c.prenom2), max(c.prenom3), max(c.sexe)
,"", "", "", ""
,max(a.type_evene), max(a.anne_evene), max(a.note_evene)
,max(ifnull(e.id_sour,0))
,MAX(long_evene)
,MAX(lati_evene)
,MAX(xpix_evene)
,MAX(ypix_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__even_sour e ON (a.id_husb = e.id_husb AND a.id_wife = e.id_wife and a.type_evene = e.type_evene)
WHERE a.type_evene in ("MARR","MARZ","MARC","MARB","MARL","MARS","DIV","ENGA","ORDI","EVEN")
AND a.type_evene like "%"
AND CONCAT(IFNULL(LOWER(b.nom),""),IFNULL(LOWER(c.nom),""),IFNULL(LOWER(a.anne_evene),""),IFNULL(LOWER(a.lieu_evene),""),IFNULL(LOWER(a.dept_evene),""),IFNULL(LOWER(a.note_evene),"")) LIKE "%%"
AND (b.sosa_dyn >= 0 OR c.sosa_dyn >= 0)
GROUP BY a.date_evene, a.id_husb, a.id_wife
ORDER BY 6, 6
LIMIT 0,50 1146 :
SELECT SQL_CALC_FOUND_ROWS DISTINCT a.lieu_evene, a.dept_evene,xpix_evene,ypix_evene,long_evene,lati_evene
FROM got__evenement a
INNER JOIN got__individu b 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 NOT IN ("NOTE","FILE","OCCU","CHAN","RFN","RIN")
AND a.type_evene like "%"
AND b.sexe LIKE "_"
AND b.sosa_dyn >= 0
AND CONCAT(IFNULL(LOWER(b.nom),""),IFNULL(LOWER(a.anne_evene),""),IFNULL(LOWER(a.lieu_evene),""),IFNULL(LOWER(a.dept_evene),""),IFNULL(LOWER(c.nom),""),IFNULL(LOWER(d.nom),""),IFNULL(LOWER(a.note_evene),"")) LIKE "%%"
AND xpix_evene != 0
UNION
SELECT DISTINCT a.lieu_evene, a.dept_evene, xpix_evene, ypix_evene,long_evene,lati_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)
WHERE a.type_evene in ("MARR","MARZ","MARC","MARB","MARL","MARS","DIV","ENGA","ORDI")
AND a.type_evene like "%"
AND CONCAT(IFNULL(LOWER(b.nom),""),IFNULL(LOWER(c.nom),""),IFNULL(LOWER(a.anne_evene),""),IFNULL(LOWER(a.lieu_evene),""),IFNULL(LOWER(a.dept_evene),""),IFNULL(LOWER(a.note_evene),"")) LIKE "%%"
AND (b.sosa_dyn >= 0 OR c.sosa_dyn >= 0)
AND xpix_evene != 0
ORDER BY 2,1
|
|
|
| 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 |
|