Pinkie Pie is visited by a strange customer whilst working at Sugarcube Corner. Hilarity ensues.

This story is a sequel to Justice

Worker's dreams have taken a turn for the worse. Feeling trapped, unable to talk about his experiences and unable to stop the near-nightly terrors, he wonders if he should reach out to the Princesses. It never occurs to him that these nightmares might be something more.
This is the final story of a trilogy. The first part is Order from Chaos, and the second is called Justice.

An English knight married a kindly woman, touched in the head, who thought she was an alicorn. She was right.

Then one day Cecilia disappeared.

He knew that Cecilia vanished into the side of the statue, the same place she lamented the 'mirror closing' two and a half years ago. He threw a rock at it... and it vanished. It was true. He had to find her.

He didn't care about Cecilia's madness, about this 'Equestria' or her obsession with ponies. He loved her. He loved her enough to walk into Hell itself. He would bring her back, no matter what.

TV Tropes page

Non-canon chapters 8-12

Edited by: John Hood, OkemosBrony, Legion222 & Katherine Kerensky (Chapters 1-12)
Guest Editor: refferree

It is the year 2038, and the Earth is slowly being consumed by a space-borne monstrosity dubbed the Black Tide, which is using nanotechnology to remake the planet into something hideously alien.

Erin Olsen works for Project Harmonics, humanity's last-ditch effort to find a new world before the Tide can wipe them out. But when that world is found, and it turns out to be occupied, Erin will need to find the courage to face the unknown in order to save the inhabitants of both worlds.

(Many thanks to Easteu for the fantastic cover image for this story!)

Now with its own TV Tropes page

There is now a follow-up to this story: Sunflower - Side Projects
Sequel: Project Sunflower: Harmony

The Medallion of Light and the Medallion of Shadow are some of the most powerful yet obscure artifacts of antiquity. Created by a now-vanished cult of assassins, the two devices together give their bearer the incredible power to walk the worlds with but a single step.

Nefarious forces are closing in on both artifacts, and very little stands in their way. Heinrich Himmler's agents covet the medallions for the greater glory of the Third Reich. Ahuizotl's simply want their master to get what's coming to him: the world, and everything in it.

With the fate of all good people and ponies in doubt, one thing's for certain: saving two worlds would be one hell of an adventure. And if adventure has a name, it must be Daring Do… or is that Indiana Jones?

Will our heroes win the day? Find out in... Daring Do and the Medallion of Shadow! Or, Indiana Jones and the Medallion of Light!

NOTE: there will be some violence in this story, but nothing more than you would expect to see in an Indiana Jones movie-- so I didn't check the "gore" content box.

Artwork by Tzelly-el.

Special thanks to SapphireStarlightPony & Rated Ponystar for helping with the brainstorming on this one.

Thanks to this stupid thing I've had the Indiana Jones theme song stuck in my head for like the past four days and I am about to claw my eyes out AAAAAAAHHHHH @_@

Isolated from her friends and taken prisoner in the middle of a war, Twilight must deal with the very real dangers of being percieved as an enemy as well as the nightmares of her arrival on 'Earth'. Can she overcome her own fears and the fears of her captors? Will the wayward unicorn's assistance be a boon or a curse to the 'humans?' Most importantly, will she ever find her way home?

"In short, it's a story of friendship and plasma rifles, with the emphasis on the friendship. The characters are well written, the XCOM setting is fleshed out very well, and the story is compelling. If you love XCOM, you'll love the story, but even if you've never heard of it, it's more than worth giving the first 3 chapters a read.

There's excellent action later on, but the real strength lies in the collision between the friendly and naive world of Twilight Sparkle and the desperate world of humans fighting a losing war for survival and willing to do anything to turn the tide."

--Arzoo

(XCOM/FiM crossover)
(Cover art commissioned by a friend and created by the magnificent FoxInShadow!)
(Original cover art by the amazing Carnelian can be viewed here!)
(Gore tag for blood and some violence)
(Many thanks to the studius OminousTen, Arzoo, xXFluttershyForeverXx and finally Setokaiva for giving my rambles a once-over)
(Now with it's own TV Tropes page! Get to tropin' folks!)