The Great and Powerful Trixie is finally the successful stage magician she always dreamed of becoming. However, she can't stop thinking about Ponyville and went wrong for her there. When she brings her new show to town to try and repair her image, the only pony that will accept her is Twilight Sparkle. A conversation leads to a bet, and the bet leads to attempting a mind-swapping spell that fails and traps both Trixie and Twilight in the former's body. Can the two magically gifted ponies get along, and can they keep the mishap a secret from Twilight's friends until a solution can be found?
Comments are appreciated.
[This story takes place in the same continuity as the Order-naries saga. Reading those stories is recommended but not required to enjoy this one]

Twilight Sparkle has a lot of difficulty getting a good night's sleep. She has to keep it a secret from the ponies who care about her, because they might disown her. Worse, they might try to help...

WARNING: The first five or so chapters are, on reflection, properly grimdark. If this makes you run away like a puppy that just laid a brown egg on the new carpet, that's your prerogative entirely. Please don't tell me that I'm objectionable for having written it, though, because that's not very nice. Or accurate. At all.

The shiny new art is a commission by this lovely person, so do feel free to check her out for all your creepy-pony needs.

Because sometimes, just because you're immortal doesn't make you invulnerable. Sometimes, the one you're more proud of than anything else is the one that respects you the most, and sometimes respect goes deeper than either of you had ever realised.

Additionally, because sometimes an author wants to try and write something that doesn't end in horse sex, but instead adorable hugging and stuff. If this doesn't work out I'll probably go on and add some horse sex later, because people always like to see that, but I hope people enjoy it. My first foray into a full sized shipping fic, so please tell me what I screwed up.

EDIT: Updated with grammar improvements/education courtesy of the incredibly helpful kits.

The earth spun through space. Basking in the light of the sun on one side, and of the moon on the other. The eternal dance playing out as it had for untold years. The sun roaring and bright, the moon cold and aloof, while the earth sat in between, bustling with life and growth. Below on the expansive surface of the world, in a country, in a village, in a house by the forest a yellow pegasus walked out the door to check on her animals. She was not particularly brash, nor brave, or all that strong of will. And the day was not of particular importance. Still, on that unimportant day, the unassuming pony would uncover a long held secret.

Comments and stars appreciated.

It is the longest day of the year, and something has gone wrong. Canterlot is in ruins, Celestia is an out-of-control god flying west, and it's up to Twilight Sparkle and her friends to save Equestria. But with the Great and Powerful Trixie playing a reckless wild card, do the girls have what it takes to set things right?

Throughout all of history, one concept has kept both the written and spoken word from becoming an unintelligible mess. That concept is that most holy of grounds known by some as "grammar." It sets down rules for language to follow, and keeps it free of distortion.

Yet something is wrong. The rules are failing. And only one pony so much as suspects that something is wrong. Something that goes deeper than a simple appearance of errors. Something that could be an attack on the very root of language itself.

One by one, Twilight and her friends must come to terms with the consequences of being the Elements of Harmony.

These stories take place in the intervening time between Season One and Season Two,
with the exception of Ditzy Doo: Muffins, which takes place early in Season One.

The series continues in the sequel, Secrets and Lies.

Pony Psychology has a TV Tropes Page.

After a summoning mishap, six champions from Runeterra's League of Legends arrive in Equestria. At first, they are focused entirely on getting home, but soon find out that it might be more complicated than they thought when Discord decides that he can use them for his own ends. Continued in The Redemption of Jericho Swain

It's no mere coincidence that the possessors of the Elements of Harmony all wound up in Ponyville. With careful planning, convincing, and a bit of luck Princess Celestia led six mares along the right path that would forever make them the best of friends.

But first she had to find them.

[In the process of being rewritten]