Celestia and Cadance have shared many a night together, but memories of the past return to put a halt to their fun