The issue is that they’re not the same when you have a left join with an additional condition in the on clause.