Allow more subselect partitioned queries to join locally