This, this is why I spend so much time in the archives, Twilight thought, holding a dusty old book close in her magic. Inside the book were a number of advanced spells, each one more interesting than the last in some sort of circular logic that Twilight could only assume went to infinity

Twilight galloped through the doors to her tower and leaped onto her favorite reading pillow on the balcony. She opened the book to the table of contents.

Oh my gosh! They’re all so interesting! Ooh, an age spell! That…might be a bit beyond me. But here right below it – a duplication spell!

Previous Episode: The Brief Reign of Princess Twily
Current Episode: Season Zero – Episode Two
Next Episode: Works Every Time

SG-1 is sent through the Stargate as a forward scouting team for an extended scientific mission to P3X-597. Arriving in a long abandoned castle, the team heads out for the nearest village. As they approach, it becomes clear that the locals aren't exactly human. Their contact with the pony-like aliens goes well, conveniently timed alongside a celebration of the sun, until an over-the-top, hammy, evil pony appears to ruin the festivities.

A Stargate SG-1 crossover.

Since her return and rescue, Princess Luna has been looking for some way to properly honor the six mares who saved her from herself, but nothing she has been able to think of has seemed meaningful enough to repay her saviors.

Nothing, at least, until she spends Nightmare Night in Ponyville, and gets to actually know the six ponies to whom she owes such a great debt. She realizes she enjoys their company, and wishes for them to spend more time with her, that she might grow closer to them.

So, in accordance with many fine and ancient traditions, and after thinking it over for a good...couple of hours, easy, she proclaims that she shall marry all six of them. Oh, and that Twilight will be marrying Celestia, too.

Now would be the appropriate time for everypony to panic.

--Cover Art Courtesy of Zemious--
--Editing Graciously Provided By BronyWriter--

NB - The sex tag is in place for sexual situations and suggestions; the story is, and shall remain, free of explicit sex.

On the day of the thousandth Summer Sun Celebration, Twilight Sparkle finds out about the return of Nightmare moon and begins to worry about it. however, Princess Celestia dismisses Twilight's worries and sends her to Ponyville to oversee the preparations for the celebration and to make some friends. Once there, Twilight meets five ponies whose destinies are inexplicably tied with her own. Those ponies? Derpy Hooves, Lyra Heartstrings, Bon-Bon, Pinkie Pie, and Cloudkicker.

...

What? Were you expecting someone else?

Twilight Sparkle, prized student of Princess Celestia, has always been very good at magic. Too good.

This is the story of how she solves every problem all by herself, because she is the best pony and my favorite.

My name is Twilight Sparkle.
I am three hundred and seventy five years old.
Except for Spike, all my friends are dead...But not for long

Betrayed by Celestia, and isolated in her castle with only Spike for support, Twilight Sparkle enacts a powerful spell to reincarnate the element bearers through her own body.
Her friends will be reborn, and, with the trials of being a mother to her friends ahead of her, an unraveling secret from the past following her at every turn, and the possibility of a brand new life so close in reach, Twilight just might be reborn too.

Credit for both the inspiration for this story and cover picture go to
Crystal Leviathan

In the aftermath of her battle against Tirek, Twilight Sparkle is unwell. She wants more. She needs more. And she is afraid of what others might think of her.

But even in the midst of her growing despair that she has betrayed everything she stood for, she learns something about friendship and what it means to be an alicorn.

This story is a sequel to What Have You Done?

Chrysalis, the Changeling Queen, has taken her prize, unhindered by Equestria's precious heroes. Celestia is little more than another prisoner of war now. The Bearers of the Elements of Harmony are lost, and the Elements themselves have turned away from Equestria's plight. As the world they once knew begins to crumble, a single question is asked among the people as they look up at their fallen heroes.

There is no such thing as "miserably ever after," for someone will always be fighting for things to change. Hope doesn't die just because someone's turned off the lights. Truth doesn't vanish when deceit begins its reign, and Harmony can only shine brighter among chaos.
Even as this world falls, we'll work to build it up again.
Even as you lose yourself, you can find greater things within you.
Even as fear rises up like a tidal wave, we'll forge a sanctuary to stand against it.
Even as you break, someone will always be standing there next to you to carry you through it.

Cover art is by Odin-odin.
Story theme (Equestria in Grey) is by Omnipony.
Main Characters are Twilight, Velvet, Discord, Nightlight, Luna, and Chrysalis, in that order.
See you in the comments, my dear readers.

It is the thousandth year since Nightmare Moon's banishment and she has returned. When the battle with Nightmare Moon goes awry, Twilight's friends and family must cope with the destruction left in Nightmare's wake.

Note: This story is based off of the picture giuliabeck's You Are Mine and Sparkle No More.

SPOILERS IN DESCRIPTION!!!!!!

Twilight was close, so close to getting the spell right... Why did this have to happen again.... -Celestia

Celestia was sure Twilight would be the one to solve it. She was so promising and so bright. It turns out Twilight didn't get the spell right. The outcome was not what Twilight was expecting. But will she ever figure out that it went wrong or will she forever live the lie Celestia wove to protect her? If she does will she find a way back? And if she does can it ever be the same...

EVEN MORE SPOILERS BELOW!
Inspired by
Oh What A Beautiful Mourning

This is also my first fanfic so please point out any errors you notice.