Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 536 Rev 568
Line 294... Line 294...
294
		if (isset($this->parametres[0])) {
294
		if (isset($this->parametres[0])) {
295
			$this->format_image = $this->parametres[0];
295
			$this->format_image = $this->parametres[0];
296
		}
296
		}
Line 297... Line 297...
297
		
297
		
298
		// Construction de la requête
298
		// Construction de la requête
-
 
299
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, '.
299
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, ci_id_image, ci_nom_original '.
300
			'	ci_id_image, ci_nom_original, ci_meta_date_ajout, ci_meta_mots_cles, ci_meta_comment, ci_note_image  '.
300
			'FROM cel_obs_images AS coi '.
301
			'FROM cel_obs_images AS coi '.
301
			'LEFT JOIN cel_inventory AS ci '.
302
			'LEFT JOIN cel_inventory AS ci '.
302
				'ON (coi.coi_ce_observation = ci.ordre AND coi.coi_ce_utilisateur = ci.identifiant) '.
303
				'ON (coi.coi_ce_observation = ci.ordre AND coi.coi_ce_utilisateur = ci.identifiant) '.
303
			'LEFT JOIN cel_images AS cim '.
304
			'LEFT JOIN cel_images AS cim '.