Geographic location of our actions with "Votre entreprise" in Indonesia

  • 4 928 trees planted

SELECT DISTINCT(CONCAT(Geoloc_parcelle.pays, Geoloc_parcelle.identreprise)) as idcompose, Geoloc_parcelle.pays, Geoloc_parcelle.identreprise, Geoloc_parcelle.id_parcelle, Geoloc_entreprise.nom AS nomentreprise, Geoloc_parcelle.GPSdegN, Geoloc_parcelle.GPSdegW FROM Geoloc_parcelle LEFT OUTER JOIN Geoloc_entreprise ON CONCAT(Geoloc_entreprise.pays, Geoloc_entreprise.identreprise) = CONCAT(Geoloc_parcelle.pays, Geoloc_parcelle.identreprise) WHERE Geoloc_parcelle.GPSdegN != 0 AND Geoloc_parcelle.GPSdegW != 0 AND Geoloc_parcelle.pays LIKE 'indonesie' AND Geoloc_parcelle.identreprise = '65' GROUP BY CONCAT(Geoloc_parcelle.pays, Geoloc_parcelle.identreprise)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND Geoloc_parcelle.GPSdegN != 0 AND Geoloc_parcelle.GPSdegW != 0' at line 1