leftJoin and rightJoin for inlining with a conditional; not much performance benefit, unfortunately