The sequel to this story: Sweetie Belle and the Quest for Knowledge is now available!

When Sweetie Belle finds a mysterious artifact of a now lost civilization, how will she come to terms with the wealth of knowledge it provides? It says it can be ignored, it says it will never try to influence her, but can an artifact of such power really be so harmless?

Book I of III

Prologue and Chapter 1: Thanks to TheOtherSideOfFluttershy for pre-reading and editing.
The whole story: Thanks to RaylanKrios for editing.
Chapter 4: Thanks to AuthorGenesis for editing.
Epilogue:
Thanks to Malefactory for editing.

I was just hoping to get this last job done, always getting sent to this dimension or that, always doing the interests of others. Unfortunately, everyone's luck eventually runs out, and it looks like mine has ran out as well. Now somehow I got stuck in this place, in a foreign body, and things just keeps getting worse for me. What did I do to deserve this?
Note: This is not a HiE story.
Editors: Discord Kantus (Chapters I-XLII), Hyari (Chapters XXXIV and onward), Fourpony
Art: AlicornParty

When Twilight visits Celestia's private hall of stained-glass windows, each bearing the image of a long-gone friend, one in particular catches her eye.

Who was this pony?

Why was she so important to Celestia?

And why does she look so familiar?

There is now a Spanish translation of this story, courtesy of Spaniard Kiwi

Daniel Habbuck, UN ambassador to Equestria, hates his job.

Sure it pays well, but it's hardly worth having to put up with flank-kissing politicians and the stomach twisting anxiety of knowing that he represents all of humanity.
One night, after a particularly tense meeting leaves him wound up, Daniel is desperate for somepony to talk to. With his friends either busy or too far away, he hires a batpony prostitute, just so he can have some company.

As he soon learns, there's much more to this streetwalker than meets the eye...

Rated T for sexual references, but no clop.

Special thanks to WingmanRed, Georg, and Kraken Hatchling for proofreading and editing

EDIT: Special, special thanks to Comrade Pony for the suggestions
EDIT: Deleted cover art.

Vinyl takes a walk after the wedding before returning home to her roommate, Octavia.

A lovely individual chose to translate this to Spanish! I can't read a lick of it myself, but if anyone would prefer that, the link is here: https://www.deviantart.com/spaniard-kiwi/art/No-es-como-si-estuviera-sorda-970424886

Celestia loves Twilight Sparkle. That is a fact, an indisputable constant of the universe. What that love means, however, is much less certain. The love of a teacher. The love of a friend. The love that Celestia dares not name. Every tick of the clock demands her answer, for while Celestia is timeless, Twilight is not.

Celestia has only a single lifetime to make her decision, but Twilight will wait. She always has, and she always will.

Tick. Tick. Tick.

Editing performed by the very talented Knight of Cerebus

Winner of the Seventh Bimonthly Twilestia Contest

You are Anon, and you managed to marry your love, Princess Celestia. However, fate conspires against you, and you end up bound to her sister as well.

Now if only you knew more about Luna than her name.

In response to threats of a griffon attack on Equestria, Twilight responds with a letter detailing just why such actions would prove unfavorable for them.

Mis-communication has started many a war, but in this case maybe calling it a war was too generous.

The "war" is over, Twilight has successfully orchestrated a bloodless end to the Griffons' aggression, but only now does she realize that there is more to winning than she had first assumed, especially against a nation that holds war as a central part of their culture...

Now Twilight must deal with the aftermath while facing a challenge she never anticipated: being seen as a conqueror.

This can be read alone, but I recommend reading the letter that started it all for a chuckle and a little exposition. This series of expositional one-shots can also give some additional world-building.

This story is a sequel to For the Hive

A few months after the events of Queen Twilight Sparkle's reveal that she and her hive can produce love, the changeling hives find themselves in an arms race. As Aegis Altair watches over her queens haggling with the minotaur emperor, she finds something that just might give Phoenix's Roost the edge it needs to come out on top.

This is a short interlude before hive book 3.