Are you sure that this query looks like this?

For me such query use indexes in both cases left and inner.

Show full example with plans

Regards,

Karol Bieniaszewski