Subversion Repositories eFlore/Applications.cel

Rev

Rev 1325 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1325 Rev 1327
Line 94... Line 94...
94
94
Line 95... Line 95...
95 
	private function fabriquerRequeteJointureObs() {
 95 
	private function fabriquerRequeteJointureObs() {
96
96
97 
		$requete_jointure_observations = 'FROM cel_obs_images coi '.
 97 
		$requete_jointure_observations = 'FROM cel_obs_images coi '.
98 
			'INNER JOIN cel_obs co '.
 98 
			'INNER JOIN cel_obs co '.
99 
				'ON coi.id_observation = co.id_observation AND coi.id_utilisateur = co.ce_utilisateur '.
 99 
				'ON coi.id_observation = co.id_observation '.
100 
			'INNER JOIN cel_images ci '.
 100 
			'INNER JOIN cel_images ci '.
Line 101... Line 101...
101 
				'ON coi.id_image = ci.id_image AND coi.id_utilisateur = ci.ce_utilisateur '.
101 
				'ON coi.id_image = ci.id_image '.
102 
			'WHERE co.ce_utilisateur = ci.ce_utilisateur ';
 102 
			'WHERE co.ce_utilisateur = ci.ce_utilisateur ';