3.0 fix translate

Fixes #4726 and remove the magic left join removal for the subquery strategy.

The joins were being removed previously as a way to generate smaller queries under the assumption that they would not affect the final result, but @AD7six  figured out that would not always be the case.