I've sorted out a workaround, but not all all certain why it works.

The left side of the outer join was itself a nested query, and flattening this query hierarchy has...