/trunk/jrest/services/CelWidgetMap.php |
---|
252,7 → 252,7 |
$projet_sql = $this->getSqlWhereProjet($projet); |
} |
$requete = 'SELECT nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille '. |
$requete = 'SELECT DISTINCT nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille '. |
'FROM cel_inventory AS i '. |
' LEFT JOIN locations AS l '. |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ". |