MYSQL: weird bug with nested stored procedure
Beware when using the same name:

WHERE  `language_code` = language_code


Suggest you precede any arguments or locally DECLAREd variables with a _.

You can probably combine both procedures into a single SQL statement.