<BR>1064 : 
	SELECT id_indi,nom,prenom1,TRI,lieu_naiss,sosa_dyn,sexe,profession,date_naiss,date_naiss,prenom2,prenom3,date_naiss,dept_naiss,date_deces,lieu_deces,dept_deces,note_indi
	FROM got__individu WHERE id_indi = <BR>1064 : SELECT note_evene
        FROM got__evenement
        WHERE type_evene = "FILE"
        and id_indi = <BR>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 = <BR>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
    <BR>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<BR>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
    <BR>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 DESC<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,NULL
        ,a.sosa_dyn
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,a.tri
        FROM got__individu a
        WHERE a.id_indi = <BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,NULL
        ,a.sosa_dyn
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,NULL
        ,a.tri
        FROM got__individu a
        WHERE a.id_indi = <BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri<BR>1064 : SELECT 
        a.id_indi
        ,a.nom
        ,a.prenom1
        ,a.prenom2
        ,a.prenom3
        ,a.sexe
        ,a.profession
        ,a.date_naiss
        ,a.lieu_naiss
        ,a.dept_naiss
        ,a.date_deces
        ,a.lieu_deces
        ,a.dept_deces
        ,b.date_evene
        ,b.lieu_evene
        ,b.dept_evene
        ,case when a.id_pere = 0 then 99999999 else a.id_pere end
        ,case when a.id_mere = 0 then 99999999 else a.id_mere end
        ,a.tri
        ,a.sosa_dyn
         FROM (got__individu a 
           LEFT OUTER JOIN got__evenement b ON (a.id_indi = b.id_husb or a.id_indi = b.id_wife) and b.type_evene = 'MARR') WHERE a.id_indi = <BR>1146 : SELECT id_indi,nom,prenom1,sosa_dyn,sexe,tri,profession,date_naiss,lieu_naiss,dept_naiss,date_deces,lieu_deces,dept_deces
            FROM got__individu 
            WHERE (id_pere = "" and id_mere = "")
                and id_indi != ""
            ORDER BY tri