optimise join request retrieval