Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1028 Rev 1030
Line 45... Line 45...
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 
	INNER JOIN tb_cel.cel_obs_images AS coi ON o.id_observation = doi.id_observation
50 
    WHERE transmission = '1' AND
 50 
    WHERE transmission = '1'
51 
$$
 51 
$$
52 
DELIMITER ;
 52 
DELIMITER ;
Line 53... Line 53...
53 
 
 53