clear codes join list update lost affiliates