improved explicit joins test