| 75,7 → 75,8 |
|---|
| $requete = |
| "SELECT nom_sel AS taxon, ce_zone_geo, zone_geo, station, 'floradata' AS source, ". |
| "IF({$condition}, wgs84_latitude, latitude) AS latitude, IF({$condition}, wgs84_longitude, longitude) ". |
| "AS longitude, IF({$condition}, 'COMMUNE', 'STATION') AS type_site ". |
| "AS longitude, IF({$condition}, 'commune', 'station') AS type_site, ". |
| "CONCAT(prenom_utilisateur, ' ', nom_utilisateur) AS auteur ". |
| "FROM cel_obs LEFT JOIN cel_zones_geo cz ON ce_zone_geo=id_zone_geo ". |
| "WHERE transmission=1 ". |
| $this->construireWhereCoordonneesBbox().' '. |