Hi @Everton1878,
Curious, because that is pretty much the resulting SQL.
Are you sure you are not running with -dryrun? And how are you checking whether the asset still exists? If one leaves the browser open on the particular asset's details page, then a refresh (Ctrl-F5) will likely be required in order for the browser to know the asset doesn't exist anymore.
Assuming you are affirmative on the above, could you please ensure the query results in at least TWO items...(*)
(*) there's a very old edge-case which I am suspecting here. IF I have time this afternoon, I will run through this edge-case myself, but no promises.