Subversion Repositories eFlore/Applications.del

Rev

Rev 809 | Rev 1030 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 809 Rev 1028
Line 44... Line 44...
44 
        ce_zone_geo, zone_geo, lieudit, station, milieu,
44 
        ce_zone_geo, zone_geo, lieudit, station, milieu,
45 
        date_observation, mots_cles_texte, commentaire,
45 
        date_observation, mots_cles_texte, commentaire,
46 
        date_creation, date_modification, date_transmission
46 
        date_creation, date_modification, date_transmission
47 
    FROM tb_cel.cel_obs AS o
 47 
    FROM tb_cel.cel_obs AS o
48 
        INNER JOIN tb_cel.cel_utilisateurs_infos AS u ON (o.ce_utilisateur = u.id_utilisateur)
 48 
        INNER JOIN tb_cel.cel_utilisateurs_infos AS u ON (o.ce_utilisateur = u.id_utilisateur)
- 
 
 49 
	INNER JOIN tb_cel.cel_obs_images AS coi ON o.id_observation = doi.id_observation
49 
    WHERE transmission = '1'
50 
    WHERE transmission = '1' AND
50 
$$
 51 
$$
51 
DELIMITER ;
 52 
DELIMITER ;
Line 52... Line 53...
52 
 
 53