Twilight Sparkle is a bit underwhelmed with her ascension to alicornhood and, after a disastrous coronation ceremony, it becomes clear that something is missing.

It'd be a shame if somepony else got to it before she did.

This story is a sequel to Sharing the Night

Twilight Sparkle is the alicorn of the stars, and after a period of self-discovery, ancient-goddess-discovery and a minor case of malmanifestation madness, she has finally come to share the night, a city, her ex-villain status and a bed with Luna, the alicorn of the moon.

Things are looking pretty good for her.

The five demigoddesses she created out of spite? Not so much. Celestia and Celestia are a little lost too, and for some unknown, completely mysterious reason, dragons are flooding into Equestria—and they're not acclimating. Someone probably should do something about that.

It never gets dull in Ponyville, does it?

TV Tropes

A prequel to Luna Eclipsed. It seems like a dream come true when Lodestar finds herself working directly for Her Royal Highness Princess Luna, but she soon learns that a thousand years of exile have left Luna dangerously out of touch. This makes for a poor combination with Luna's limitless power and terrible pride. Now Lodestar has to deal with both her own failings and Princess Luna's disruptive struggles to find herself, not to mention the threat of being accidentally asphyxiated by a careless goddess.

This is a fic based on the Time Loop Files, the format of which was first codified by Innortal on fanfiction.net.
Here's a brief guide.
The basic idea is, one character (the Anchor, usually the main character of a fictional setting) is looping back to the very first moments of their parent series every time either they die or some kind of time limit expires. They of course end up monumentally stir crazy given enough time.
Eventually others start to loop as well.
The reset is not always perfect. Sometimes a loop's history will be different to the "prime" loop, or canonical plot.
"Crossover" or "Fusion" loops also occur, randomly. These can involve the home loopers having a guest, or the anchor for one universe spending time in another, or replacements of one character by another.
Vacation Loops are where the Anchor (or others) decide/s "buck it" and lets off steam by doing whatever comes to mind. There's little or no attempt to maintain the original timeline.

In addition, and particularly more recently, it should be known that this story has a collaborative element to it - people may submit loop ideas or loops, ideally at the Spacebattles thread (a link to the current version of which is on the Trope page), and they may become included.

There's two page image options, thanks to Filraen - the current page image has been edited by the original creator from this work of theirs.. The other one is here:
http://hourglass-vectors.deviantart.com/art/MLP-Loops-466030169

Being an alicorn is wonderful... except when it isn't. There are plenty of things that put a damper on limitless vistas of possibility afforded by such a long life: Court, mortal needs and expectations, the occasional decade of ennui.

And the dreams, of course. Agelessness comes with its own special kind of dreaming. Celestia finds that her own "Inner Court" is a bit too literal, and it--and she--are troubled at the prospect of a near-immortal Twilight Sparkle.

If only she could articulate exactly why that was.

art by spectralunicorn

Part of the Monophysite Quartet, which also includes Celestia Isn't Real, Have You Considered My Servant, Twilight?, and The Esoteric Rites of Darkness. All four stories have a common origin point in an old story idea I called "Monophysite" and touch on who or what Celestia really is in some way. They are otherwise unrelated.

Luna's return and Twilight's ascension to rulership of Equestria helped usher in an age of scientific and magical innovation. She and her slow-aging and long-lived friends lived through tumultous times of discovery and progress, and now Equestria is beginning its first true forays into deep space.

But someone has to be out there, representing Twilight and speaking on her behalf. She can't go herself--FTL travel is still primitive and time consuming. She needs someone out there trekking the stars, keeping up with the growing network of colonies. Someone with diplomatic chops, a vivid imagination, impeccable manners, and a lot of charisma. Rarity is eager to help her wife out in a once in a lifetime opportunity to see the worlds, literally.

When Twilight is awake, Celestia is her teacher, and she a faithful student. But when Twilight shuts her eyes, another mare approaches, who teaches her a very different lesson.

An experimental fic, written to play around with alternative perspectives. Be warned, ye who enter here.