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 'WHERE 1 AND cs.crimeyearid=88' at line 6<br><br>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 =  WHERE 1 AND cs.crimeyearid=88