$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; } ?>


Site Info
Members: 2924
Series: 16
Stories: 163
Chapters: 519
Word count: 2378465
Authors: 83
Reviews: 2826
Reviewers: 138
Newest Member: Sustaita70546
Challenges: 2
Challengers: 2
Recommendations: 6
Recommenders: 4
 



Login
Register
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
tgfiction.net Webutation