Subversion Repositories eFlore/Applications.del

Compare Revisions

Ignore whitespace Rev 1977 → Rev 1978

/trunk/services/modules/0.1/observations/ListeObservations.php
115,8 → 115,7
*/
private function getInfosObs() {
$idsObsConcat = implode(',', $this->idsObsOrdonnees);
// TODO : bizarement MYSQL 5.6 retourne plusieurs fois les mêmes enregistrements d'où le DISTINCT (normalement inutile)
$requete = "SELECT DISTINCT id_observation, nom_sel AS `determination.ns`, nt AS `determination.nt`, ".
$requete = "SELECT id_observation, nom_sel AS `determination.ns`, nt AS `determination.nt`, ".
'nom_sel_nn AS `determination.nn`, famille AS `determination.famille`, '.
'nom_referentiel AS `determination.referentiel`, ce_zone_geo AS id_zone_geo, '.
'zone_geo, lieudit, station, milieu, date_observation, do.mots_cles_texte, '.