Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 539 Rev 626
Line 253... Line 253...
253 
					'		ON (coi.id_image = ci.id_image) '.
 253 
					'		ON (coi.id_image = ci.id_image) '.
254 
					'	LEFT JOIN cel_obs AS co '.
 254 
					'	LEFT JOIN cel_obs AS co '.
255 
					'		ON (coi.id_observation = co.id_observation) '.
 255 
					'		ON (coi.id_observation = co.id_observation) '.
256 
					'WHERE co.transmission = 1 '.
 256 
					'WHERE co.transmission = 1 '.
257 
					"	AND co.nom_ret_nn IN ($numNom) ".
 257 
					"	AND co.nom_ret_nn IN ($numNom) ".
258 
					'	AND ci.date_prise_de_vue != "0000-00-00" ORDER BY ci.date_prise_de_vue ASC';
 258 
					'	AND ci.date_prise_de_vue != "0000-00-00" ORDER BY ci.date_prise_de_vue ASC '.
- 
 
 259 
					'LIMIT 1';
Line 259... Line 260...
259 
 
 260 
 
Line 260... Line 261...
260 
		$resultat = $this->Bdd->recupererTous($requete);
 261 
		$resultat = $this->Bdd->recupererTous($requete);
261 
 
 262