Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1025 Rev 1180
Line 138... Line 138...
138
138
139 
		$requeteLiaisons = 'SELECT *, dob.commentaire as dob_commentaire '.
 139 
		$requeteLiaisons = 'SELECT *, dob.commentaire as dob_commentaire '.
140 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
 140 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
141 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
 141 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
142 
						   'ON doi.id_observation = dob.id_observation '.
 142 
						   'ON doi.id_observation = dob.id_observation '.
143 
						   'INNER JOIN del_utilisateur du '.
 143 
						   'LEFT JOIN del_utilisateur du '.
144 
						   'ON du.id_utilisateur = dob.ce_utilisateur '.
 144 
						   'ON du.id_utilisateur = dob.ce_utilisateur '.
145 
						   'WHERE doi.id_observation = '.$this->id_observation;
 145 
						   'WHERE doi.id_observation = '.$this->id_observation;
146 
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
 146 
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
147 
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';
 147 
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';