$articlelist = DB::fetch_all("SELECT t1.aid,t1.catid,t3.catname,t1.uid,t1.username,t1.title,t1.summary,t1.dateline,t2.viewnum,t2.commentnum,t1.pic FROM " . DB::table('portal_article_title')." t1 LEFT OUTER JOIN " . DB::table('portal_article_count')." t2 ON t1.aid = t2.aid LEFT OUTER JOIN " . DB::table('portal_category')." t3 ON t1.catid = t3.catid ORDER BY t1.dateline DESC" . DB::limit($startlimit, $pagesize));