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 '' at line 6

SELECT cs.crimeid, l.locationid, l.lat, l.lng, l.location, ct.title AS crimetype, cy.crimemonth, cy.crimeyear FROM crime_s cs INNER JOIN location l ON (l.locationid = cs.locationid) INNER JOIN crimeyear cy ON (cy.ID = cs.crimeyearid) INNER JOIN crimetype ct ON (ct.typeid = cs.crimetypeid) INNER JOIN location_n ln on l.locationid = ln.locationid and ln.neighbourhoodid = 1247 WHERE 1 AND cs.crimeyearid=