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 ';LARU AND  c.region = id_region GROUP BY c.region ORDER BY regi