Subversion Repositories eFlore/Applications.del

Rev

Rev 806 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 806 Rev 819
Line 373... Line 373...
373 
		$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte '.
 373 
		$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte '.
374 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
 374 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
375 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
 375 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
376 
						   'ON doi.id_observation = dob.id_observation '.
 376 
						   'ON doi.id_observation = dob.id_observation '.
377 
						   'INNER JOIN del_utilisateur du '.
 377 
						   'INNER JOIN del_utilisateur du '.
378 
						   'ON du.id_utilisateur = doi.id_utilisateur '.
 378 
						   'ON du.id_utilisateur = dob.ce_utilisateur '.
379 
						   'INNER JOIN del_image di '.
 379 
						   'INNER JOIN del_image di '.
380 
						   'ON di.id_image = doi.id_image ';
 380 
						   'ON di.id_image = doi.id_image ';
381 
		$requeteLiaisons .= $this->chargerClauseWhere();
 381 
		$requeteLiaisons .= $this->chargerClauseWhere();
382 
		$requeteLiaisons .= ' GROUP BY doi.id_observation';
 382 
		$requeteLiaisons .= ' GROUP BY doi.id_observation';
383 
		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';
 383 
		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';