Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 532 → Rev 533

/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)) ".