Complex sentence: Shore wrote the pilot with a vivid memory of a doctor's visit: he once had to wait two weeks to get a doctor's appointment for a sore hip, by which point his pain had disappeared.
Split into simpler sentences: Shore wrote the pilot with a memory of a doctor's visit in mind. When Shore had a sore hip once, he had to wait two weeks to get a doctor's appointment and by then, his pain had disappeared.