_getSingleJoin() optimization