383,7 → 383,7 |
* */ |
private function chargerLiaisons() { |
|
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte '. |
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte, dob.commentaire as dob_commentaire '. |
'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob'). |
'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
'ON doi.id_observation = dob.id_observation '. |
396,7 → 396,6 |
$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' '; |
$requeteLiaisons .= $this->gestionBdd->getLimitSql(); |
|
|
return $this->bdd->recupererTous($requeteLiaisons); |
} |
|