Adding join within sub query breaks query

Is this the same issue as here?