/trunk/services/modules/0.1/observations/ListeObservations.php |
---|
383,7 → 383,7 |
* */ |
private function chargerLiaisons() { |
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte, dob.commentaire as dob_commentaire '. |
$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, id_utilisateur, 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 '. |