select arc.id,arc.typeid,arc.senddate,arc.flag,arc.ismake,arc.channel,arc.arcrank,
arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.mid,tp.typename, ch.typename as channelname,nt.*
from `#@__archives` arc
left join `#@__arctype` tp on tp.id=arc.typeid
left join `#@__channeltype` ch on ch.id=arc.channel
left join `#@__addon17` nt on nt.aid=arc.id
$whereSql order by arc.senddate desc
试试吧,没有MYSQL环境,不知道是否有错误
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024