Join optimizer + Concat optimizations [ci skip]