mysql - Error in SQL syntax MySQLSyntaxErrorException in Grails -

i request mysql database, searches data in table criteria:

def tableacounting(){     def user = person.findbyusername(springsecurityservice.currentuser.username)     def cafee = user.cafee     def tablesquery = tableplacesinfo.createcriteria()     def tables = tablesquery.list {            //an error show on string         'in'("hall", hallszones.findallbycafee(cafee))     }     def halls = cafee.halls 

but such error:

class:com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception message:you have error in sql syntax;  check manual corresponds mysql server version right syntax use near ')' @ line 1 

this happends if in search using empty set. means, need check size of hallszones.findallbycafee(cafee) because set empty.