存储过程和查询执行之间的结果不同

I'm trying to execute a stored procedure with mysql with Navicat and when I execute this stored procedure I got 0 rows but when I execute the part of the stored procedure which I want I get 1 row which is what I want. The stored procedure is this:I'm trying to execute a stored procedure with m