Sunset Shimmer and Starlight Glimmer. Two ponies who are all too familiar with regret. Though they have just met, both can see a little of themselves in the other. After helping her friends stop the misguided rampage of Juniper Montage, Starlight is faced with another problem. Completely by accident, she uncovers Sunset's unrequited wish. To reunite with Princess Celestia.

With Sunset too enveloped in regret to undertake the journey alone, Starlight agrees to help. Pitted against their own doubts, will they be able to pull through or will Sunset's greatest wish go unanswered?

The fight against the Pony of Shadows didn’t go according to plan, and when Starlight comes to, she finds she’s been in a magically induced coma for two hundred years.

Nothing is as recognizable as the Equestria she knew, not even the landscape.

Lost in time, how will she cope?

Gift for Tilgoreth

Featured block 11-14-17

Twilight Sparkle never seemed to notice Lyra Heartstrings. She didn't even remember Lyra's name.

They were friends back in Canterlot and even went to school together. Yet Twilight didn't notice that Lyra just happened to move to Ponyville the same day she did. She didn't even notice when Lyra appeared at her welcoming party. Nor did she ever seem to spot her old classmate passing by in the background on any other day during her stay in Ponyville. Some days she could look right at Lyra and never realize that they knew each other.

Lyra isn't a very noticeable pony. She has put a lot of effort into that.

Set in late season 5, after Amending Fences.
Note: Lots of spoilers in the comments.

This story is a sequel to For Queen and Country

Twilight Sparkle always had a feeling that ponies were not alone in the universe. When he arrived in Equestria, she was proven right.

After he uncovered and subsequently overthrew a plot to kill the two princesses, they sent him back to his world. However, the curiosity of Princess Celestia was still unsatisfied. She had a glimpse of this other world through the mind of this one man, this agent of a service known as 'MI6', but wanted to know more. To this end, she resolved to send her former student there, in an effort to understand more of the human race and, perhaps, meet their mutual friend once again.

Who was this friend, you ask?

Bond. James Bond.

Commander James Bond was one of MI6's top operatives. Having succeeded in countless missions and bringing down international terrorists such as Le Chiffre and Dominic Greene, Bond is sent to Istanbul to retrieve a hard drive containing the names of every agent involved in undercover affairs. The hard drive in question has fallen into enemy hands, and it's his job to get it back.

After disastrous events in Istanbul during the mission, James finds himself in an unfamiliar land, and soon becomes entangled in a tale of international espionage.

Only one man can protect Equestria and its princesses in this new time of crisis, and his name's Bond.

James Bond.

A sequel has been published: An Equestrian Princess in London.