Andy's Earth 2 Fan-fiction Archive :: We bring you new version of your favorite E2 FanFic Archive

$field_title"; if($list == "beta") { $countquery = "SELECT COUNT(DISTINCT ai.uid) FROM ".TABLEPREFIX."fanfiction_authorinfo as ai, "._AUTHORTABLE." WHERE ai.field = '$field_id' AND ai.info = '"._YES."' AND "._UIDFIELD." = ai.uid".(isset($letter) ? " AND $letter" : ""); $authorquery = "SELECT COUNT( stories.sid ) as stories, "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid FROM ".TABLEPREFIX."fanfiction_authorinfo as ai, "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs AS ap ON "._UIDFIELD." = ap.uid LEFT JOIN ".TABLEPREFIX."fanfiction_stories AS stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.") WHERE ai.field = '$field_id' AND ai.info = '"._YES."' AND "._UIDFIELD." = ai.uid ".(isset($letter) ? " AND $letter" : "")." GROUP BY "._UIDFIELD; $pagetitle .= $field_title; } ?>

Authors

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Other

Maggie C [9]
Mary Brick [2]
mosylu [6]
Natalie GirlPoet [1]
Nicole Mayer [18]
Nora [1]
Oonagh [1]
Paige Daro [1]
pal fow [5]
Paula Sanders [9]
Raven [1]
Rebecca Jane Yoo [2]
Rhonda Hallstrom [2]
Robin Carter [1]
Rosa Moran [5]
Sabrina Sestito [5]
SecondGuess [6]
Sharon Bailey [1]
Shelley Ann Rossell [2]
Shireen Lau [1]
Simon Kattenhorn [3]
sparky_elf [1]
Stephanie Ladd [1]
Tara OShea [9]
TesubCalle [2]

[Previous] 1 2 3 4 [Next]

Andy's Earth 2 Fan-fiction Archive

Skin modified for this site by Andy, original skin 'simple_machine' created by Kali - Icons by Mark James - Based on Default SMF Skin