Subversion Repositories eFlore/Applications.del

Rev

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

Rev 787 Rev 820
Line 124... Line 124...
124 
		$requeteLiaisons = 'SELECT * '.
 124 
		$requeteLiaisons = 'SELECT * '.
125 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
 125 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
126 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
 126 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
127 
						   'ON doi.id_observation = dob.id_observation '.
 127 
						   'ON doi.id_observation = dob.id_observation '.
128 
						   'INNER JOIN del_utilisateur du '.
 128 
						   'INNER JOIN del_utilisateur du '.
129 
						   'ON du.id_utilisateur = doi.id_utilisateur '.
 129 
						   'ON du.id_utilisateur = dob.ce_utilisateur '.
130 
						   'WHERE doi.id_observation = '.$this->id_observation;
 130 
						   'WHERE doi.id_observation = '.$this->id_observation;
131 
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
 131 
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
132 
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';
 132 
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';
133 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
 133 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();