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 a.address_id = lm.address_id AND c.state_id = s.state_id GROUP BY a.addre' at line 9