Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 666 Rev 726
Line 284... Line 284...
284
				'FROM cel_images AS ci'.
284
				'FROM cel_images AS ci'.
285
				'	LEFT JOIN cel_obs_images AS coi  '.
285
				'	LEFT JOIN cel_obs_images AS coi  '.
286
				'		ON (coi.id_image = ci.id_image) '.
286
				'		ON (coi.id_image = ci.id_image) '.
287
				'	LEFT JOIN cel_obs AS co '.
287
				'	LEFT JOIN cel_obs AS co '.
288
				'		ON (coi.id_observation = co.id_observation) '.
288
				'		ON (coi.id_observation = co.id_observation) '.
289
				'WHERE ci.id_image = '.$this->ressources[0];
289
				'WHERE ci.id_image = '.$this->ressources[0].
-
 
290
				' AND co.id_observation IS NOT NULL';
Line 290... Line 291...
290
 
291
 
291
		$this->infosImages = $this->Bdd->recupererTous($requete);
292
		$this->infosImages = $this->Bdd->recupererTous($requete);
Line 292... Line 293...
292
	}
293
	}