This story has been riffed in Doctor and Ditzy's science theatre by Rixizu. You can find it on his user page here

Spike has been missing for three years. Why he disappeared is a mystery to everypony. What caused him to leave in the first place, and why is he suddenly back now? He's acting cold towards his old friends and won't reveal why. He's lost his love for Rarity and is treating everypony he comes across the same way Gilda did.

Opening theme for this story is: Constellations - Sound of the Aviators

Rated: Teen for language and potential sexual outcomes.

Warning: Self-harm is described in this story. If you are prone to self-harm or know someone who is and feel uncomfortable reading about the subject, then I don't recommend reading the story.

Luna does her best to catch up on the events of the past thousand years and ends up reading even more than Twilight.

One day, an ancient tome slips into her pile of reading material and she reads it eagerly. What she finds there may very well be the discovery of the millennium: The location of the last refuge of the humans.

With the help of Twilight and her friends, the Lunar Princess sets out on an archaeological expedition to find the very last human on the planet of Equus.

And they found one, but why is he forged in a full body armor and claims to not being a human... Well he's not one anymore.

A man is transported to Equestria through some unknown means. Instead of becoming the life of the party in an instant, he is forced to survive using less than conventional means, hiding from the denizens of Ponyville in fear of how they would react to a human being. But such an existence cannot last forever.

As well, he must contend with the reality of an incomplete cartoon world. Things are not as easy to adjust to as they seem.

Applejack's life is turned upside-down after she suddenly inherits the full powers of a goddess. She insists that it isn't a big deal and that she's the same pony as always, just bigger. Meanwhile, everypony else starts making demands on her and placing expectations on the 'new princess'. When the constant stream of petitions and gawkers starts interfering with farm work, Applejack reacts a bit strongly. Luna, fearing the worst, is determined to rescue Applejack from corruption, further irritating the farm pony. Will Applejack accept her destiny, or is destiny what you make of it?

The day Big Mac came to Equestria, he was but a small colt. He told his story to passersby, but nopony believed him. Eventually, Applejack and Granny Smith found him, and brought him in. Except, they believed his story. They swore they would never tell anypony. But promises sometimes cannot be kept when you're the element of Honesty, and so the secret slips one night, and Applejack couldn't feel more guilty.

I'm a spiteful old man. I've spent my entire life trying to fulfill my wish. The same thing every one of us wants.

The year is 2070. I'm the last brony alive, 82 years old. But I did it. I created the portal. And I'm jumping through. No regrets.

I've actually finished writing this story! Can you believe it? It's also available in book form, Click Here to go to lulu.com

After a mishap with a falling star, Princess Luna crashes into Ponyville, only to be saved by Big Macintosh. Overly grateful, Luna calls upon an ancient contract which binds her to the draft pony as his personal servant. Can Big Macintosh co-exist with an overzealous moon goddess, her creepy assistant, and an army of evil looking guards long enough for Twilight to find a loophole to get him out of the pact?

Featured on 9/5/2012

The royal court of Canterlot welcomes its newest member with open forelegs: the human philosopher Voltaire, from Earth.

On Earth, Voltaire is known as the greatest enemy of tyranny in the history of literature, and a legend in his own mind.

On Equestria, the court betting pool is giving him a week before the Princess banishes him to the Moon.

Note: This story doesn't have sequels per se, but there are a couple of short follow-ups set in the present day ("Parade Coverage" and "Secret Histories"), and a prequel of sorts in "At the Inn of the Prancing Pony".

TV Tropes page.

Discord has given up. Defeated so easily? It's time to retire. But he can't just leave Equestria without chaos can he? So he selects a random human to take up his mantle and to create a new reign of chaos.

Can this human manage new powers? Will he go mad or he will he end up as a statue for foals to gawk at? Is there a third option? Not very likely but with this much power he's going to try his best to create chaos and harmony at the same time.

Link to the picture I used: http://karzahnii.deviantart.com/art/Discord-s-Game-322137800%0A

I do promise to try and keep this light hearted and relatively comedic. Oh right I wrote this in response to the 50 000 word pony story contest. I failed horribly but I thought I'd post what I've got up here. I do plan on finishing this and it being around 50 000 words in the end.

A little warning for you in that the prologue is written very differently then the rest of the story. Also it is mostly unnecessary if you want to skip it altogether. The other thing I promise is that the romance is between ponies only and ponies that appear in the show.

How will a Pony adjust to living in your human apartment? More importantly, how will you adjust to living with a pony? A mare pony no less. You should have known that someone with the name of Fluttershy would have been a pony. Equestrian Ponies are just so... foreign! You never know how to act around them. Will you be able to overcome this and cope with this pony invasion into your life?

In part inspired/influenced by The Roommate by totallynotabrony.