Hey Anna, there have never been any photos of Sophie at the opening ceremony for London 2012, only the paralympic's. She and Edward did attend a long with many other members of the family, but they were not sitting with the Queen etc. in the IOC so they were never photographed.
"I am yours, you are mine, of that be sure. You are locked in my heart, the little key is lost and now you must stay there forever."
Written by Princess Alix of Hesse and by Rhine in the diary of her fiance, Tsarevich Nicholas.