| 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); |
| } |
| |