[Albert_Camus]

Author here, you are indeed correct that Query #2's final join can be an INNER join. However, I just tested it against our test data set and it makes no impact on the performance.

[tech2]

Ah well, thanks for humouring me. Good thing those query optimisers do the right thing on occasion.