Subversion Repositories eFlore/Applications.del

Rev

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

Rev 733 Rev 734
Line 35... Line 35...
35 
		i.commentaire, i.nom_original, i.date_modification, i.date_creation, i.publiable_eflore
35 
		i.commentaire, i.nom_original, i.date_modification, i.date_creation, i.publiable_eflore
36 
	FROM tb_cel.cel_images AS i
36 
	FROM tb_cel.cel_images AS i
37 
		INNER JOIN tb_cel.cel_obs_images AS oi ON (i.id_image = oi.id_image)
37 
		INNER JOIN tb_cel.cel_obs_images AS oi ON (i.id_image = oi.id_image)
38 
		INNER JOIN tb_cel.cel_obs AS o ON (oi.id_observation = o.id_observation)
 38 
		INNER JOIN tb_cel.cel_obs AS o ON (oi.id_observation = o.id_observation)
39 
	WHERE o.transmission = '1'
39 
	WHERE o.transmission = '1'
40 
		AND i.id_utilisateur REGEXP '^[[:digit:]]+$';
 - 
 
41 

            40
            
		AND i.ce_utilisateur REGEXP '^[[:digit:]]+$';

          

          

            -
            
 

            41
            

          

          

            42
            

            42