56,679
社区成员
发帖
与我相关
我的任务
分享
$Sql = "select SQL_CALC_FOUND_ROWS a.*, b.Language as BLanguage, b.ClassId as BClassId, b.OLState as BState from ".$bodyTable." a, ".$mainTable." b
where 1=1 and b.AuthorId='$getAuthorId'".$searchSql.$SqlLan.$SqlCls." and a.Pass='Y' and a.TowerId = b.Id limit ".$startpage.",$psize";
$Sql = "select SQL_CALC_FOUND_ROWS a.*, b.Language as BLanguage, b.ClassId as BClassId, b.OLState as BState from ".$bodyTable." a, ".$mainTable." b where 1=1 and b.AuthorId='$getAuthorId'".$searchSql.$SqlLan.$SqlCls." and a.Pass='Y' and a.TowerId = b.Id limit ".$startpage.",$psize";