$query = "Select arc.ID,arc.title,arc.iscommend,arc.color,arc.typeid,
arc.ismake,arc.description,arc.pubdate,arc.senddate,arc.arcrank,arc.click,
arc.money,arc.litpic,arc.writer,arc.shorttitle,arc.memberid,arc.vote,arc.postnum,arc.lastpost,arc.keywords,
tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,
tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,st.softrank
$addField
from dede_archives arc
left join dede_arctype tp on arc.typeid=tp.ID
left join dede_addonsoft st on arc.ID=st.aid
$addJoin
where $orwhere $ordersql $limitsql";

$row['info'] = $row['description'];

$row['keyword'] = $row['keywords'];

$row['info'] = $row['description'];

$row[softrank] = $row[softrank];