updated joins