This story is a sequel to Sunset Shimmer's Unpleasant Discovery

Twilight Sparkle returns to the human world intending to take a short vacation from her princessly duties, and to catch up with her non-Equestrian friends. One sleepover at Pinkie Pie’s house later, Twilight comes to learn something fascinating—and horrifying—about her very human body.

This story now has a spiritual prequel: Sunset Shimmer's Unpleasant Discovery, by Bootsy Slickmane, rated [mature]. While mine pokes fun at the characters, his offers the more serious take.

Preread by Stiggerzz and Majin Syeekoh.

Rated Teen for sexual references.

Featured on:
Fimfiction.net Feature Box (11/01/2014)

When Cadence told Celestia she was having twins, the princess of the sun wanted to be happy for her. She tried very hard to be happy for her, but she couldn’t. Celestia knew that it was inevitable, but hearing that Cadence was having foals drove a dagger of jealousy through her heart, for she is able to have something that Celestia can never have: foals.

Edited by Rated Ponystar
Proofread by Neko Majin C
Pre-read by RainbowBob

YouTube reading!

This story is a sequel to Aegis of the Hive

Natural selection. It is the byword of every changeling queen who has ever lived. The chief resource that has always curbed the hives' growth used to be love. Now though, with Queen Twilight Sparkle's bloodline capable of producing love on their own, the old guard of changeling morality has seen fit to acquire this ability for the next generation before removing all of their future royal daughters' competitors.

Some queens are far closer to this goal than others.

Editor in Chief: A Bitter Pill, and Boldish42

Luna has Loved Twilight since that first nightmare night, even if the feeling wasn't mutual.
She decides to visit Twilight and reveal her true feelings towards the younger Alicorn.
Who could stop the true feelings of love?

Luna x Twilight

Credit to Midnight the Umbreon for the image

Princess Luna has helped thousands of Equestria's children through their dreams. But is this done out of love or are her motives more complex? When Luna finds a filly that can't wake up, they both discover a lot about each other.

This story is approved by Twilight's Library!

Now that Discord's reformed and friends with a princess and her entourage, he's decided it's time to assimilate himself into pony culture. With Nightmare Night coming up, Discord decides to get into the spirit of things by opening a costume shop in Ponyville. His amazing costumes soon become the talk of the town, and Nightmare Night fever is stronger than ever...

...but is Discord about to play the ultimate Nightmare Night prank on an unsuspecting Ponyville?

Nightmare Night, the one evening where all your worst dreams come true, is almost over...or is it? With Luna's moon still glimmering over Ponyville, the Apple family gathers together in their storm cellar to exchange scary stories before turning in for the night.

Some comments contain spoilers!

Entry for HONORABLE MENTION in the Poniverse Nightmare Night Contest

Don't Sit Near the Apple Tree (with Anypony Else but Me) - told by Granny Smith: A young Granny Smith finds a dying apple tree in the orchard. Anypony who goes to chop it down is never seen again.
I See Dead Ponies - told by Apple Bloom: Scootaloo and Sweetie Belle spend the night in a haunted cottage but when their stay becomes miserable, they receive unlikely help.
Fiddlin' Amok - told by Applejack: Fiddlesticks auditions for the Canterlot Chamber Orchestra which soon becomes cursed when she doesn't get in. Contains gore.

Octavia and Vinyl have been dating for months, but neither has had a chance to introduce their significant other to their families. Vinyl always dodges the issue, but when Octavia is insistent, they have a fight. This leaves Vinyl with no other option than to have Octavia over to meet her parents.

Maybe she should have told Octavia who she really was?

Dramatic reading by Goombasa available here.

Now in Russian, translated by Hopeless.

When Applejack goes to a strip club, she finds some pony that manages to catch her eye. Who would guess that the pony she falls for is her exact opposite!

Ever since she was a filly, Applejack has lived in Manehattan. And ever since Nightmare Moon took over, she’s had plenty of work as a private eye. When a tall stallion walks into her office and asks her to find his missing fiancé, it seems like just another case. But when a trail of clues and bodies leads her deeper into the darkened heart of the city, Applejack may find herself in over her fedora, and quite literally gambling for her life.