Wrong update limits mysql

Wrong update limits mysql

From this question: update multiple rows using limit in mysql? I made this
code up for a MySQL query:
UPDATE clientes SET telemarketer =1
WHERE telemarketer IN (
SELECT telemarketer FROM (
SELECT telemarketer FROM clientes
WHERE telemarketer=0
ORDER BY telemarketer DESC
LIMIT 0, 10
) temporal
);
But It's returning a SELECT telemarketer FROM clientes.
Looking around I found out that the ORDER BY is needed in the case or it
would return random rows.
Why isn't the LIMIT working?.
Already tryed using LIMIT 10 instead of LIMIT 0, 10 and got the same result.