Inner Join returning empty

Question

I have a SELECT to return a list of products, but I want them to be differentiated by input and output, contains and does not contain...

Obs: I WANT TO TAKE THE LAST MOVEMENT OF EACH PRODUCT

Select that I have so far

SELECT DISTINCT * 
FROM EstoqueGeral e
LEFT OUTER JOIN (

SELECT  * 
FROM produto_movimento 
GROUP BY codigoproduto
) AS mvp ON mvp.codigoproduto = e.codigo2

LEFT OUTER JOIN (
SELECT DISTINCT * 
FROM estoque_movimentacao
GROUP BY idmov
) AS em ON mvp.idmov = em.idmov

LEFT OUTER JOIN (

SELECT DISTINCT * 
FROM clientes2
GROUP BY ID_cliente
) AS c ON c.cpf = em.cliente

ORDER BY `mvp`.`id_pm`  DESC
LIMIT 15

RETURN

MOVING TABLE 2

TABLE OF PRODUCTS 3

TABLE PRODUCTS MOVED 4

SCHEDULE 5

Answer 1

should not be appearing because the INNER JOIN switches to LEFT JOIN so to see if it returns or tries it more will get heavy or something like that

 SELECT * FROM EstoqueGeral e
    LEFT JOIN produto_movimento mvp 
        ON 
            mvp.codigoproduto = e.codigo2 AND 
            mvp.codigoproduto  = ( SELECT mvp2.codigoproduto FROM produto_movimento ORDER BY mvp2.codigoproduto DESC LIMIT 1 )