Clever optimization engines are IMO no excuse for blindly throwing queries at it and not knowing what's going on. Every optimizer has some corner cases in which it fails and I'd argue that as a good developer you should know when they can happen.
Additionally, in this example, the rewritten query is easier to read and maintain.
No comments yet.