|
关注：1
2013-05-23 12:21
求翻译：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,mb.uname as adminname from `dede_archives` arc left join `dede_arctype` tp on tp.id=arc.typeid left join `dede_channeltype` ch on ch.id=arc.channel left join `dede_member` mb on mb.mid=arc.mid where arc.channel = '1' And arc.arcrank > -2 order by arc.id desc limit 0,30是什么意思？ 待解决
 悬赏分：1
- 离问题结束还有
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,mb.uname as adminname from `dede_archives` arc left join `dede_arctype` tp on tp.id=arc.typeid left join `dede_channeltype` ch on ch.id=arc.channel left join `dede_member` mb on mb.mid=arc.mid where arc.channel = '1' And arc.arcrank > -2 order by arc.id desc limit 0,30
问题补充： |
|
2013-05-23 12:26:38
选择 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，作为从 'dede_archives' 弧左的连接 'dede_arctype' tp 上 mb.mid=arc.mid ch.id=arc.channel 左的连接 'dede_member' mb tp.id=arc.typeid 左的连接 'dede_channeltype' ch adminname channelname,mb.uname，arc.channel = ' 1' 和 arc.arcrank 〉 按照 arc.id desc 限制 0,30-2
|
湖北省互联网违法和不良信息举报平台 | 网上有害信息举报专区 | 电信诈骗举报专区 | 涉历史虚无主义有害信息举报专区 | 涉企侵权举报专区
