| 426,17 → 426,18 |
|---|
| |
| $requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS dob.id_observation, nom_sel, famille, ce_zone_geo, zone_geo, lieudit, station, milieu, date_observation, dob.mots_cles_texte, date_transmission, di.id_image, dob.ce_utilisateur, prenom, nom, courriel, nom_original, dob.commentaire as dob_commentaire, dob.nt, dob.nom_sel_nn '. |
| 'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob'). |
| 'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
| 'ON doi.id_observation = dob.id_observation '. |
| 'LEFT JOIN del_utilisateur du '. |
| 'ON du.id_utilisateur = dob.ce_utilisateur '. |
| 'INNER JOIN del_image di '. |
| 'LEFT JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
| 'ON doi.id_observation = dob.id_observation '. |
| 'LEFT JOIN del_image di '. |
| 'ON di.id_image = doi.id_image '; |
| |
| $requeteLiaisons .= $this->chargerClauseWhere(); |
| $requeteLiaisons .= ' GROUP BY doi.id_observation'; |
| $requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' '; |
| $requeteLiaisons .= $this->gestionBdd->getLimitSql(); |
| //echo $requeteLiaisons;exit; |
| |
| return $this->bdd->recupererTous($requeteLiaisons); |
| } |
| |