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 `sucai_分隔符archives` arc
left join `sucai_分隔符arctype` tp on tp.id=arc.typeid
left join `sucai_分隔符channeltype` ch on ch.id=arc.channel
left join `sucai_分隔符addon17` nt on nt.aid=arc.id
$whereSql order by arc.senddate desc
|