浏览 1788 次
该帖已经被评为隐藏帖
|
|
---|---|
作者 | 正文 |
发表时间:2008-03-31
categories4_.ARTICLE_ID as ARTICLE1_, cs1_.id as CATEGORY2_, cs1_.id as id2_0_, cs1_.CREATE_TIME as CREATE2_2_0_, cs1_.descn as descn2_0_, cs1_.name as name2_0_, cs1_.PARENT_ID as PARENT5_2_0_, cs1_.uuid as uuid2_0_, keywords6_.ARTICLE_ID as ARTICLE1_, kw2_.id as KEYWORD2_, kw2_.id as id5_1_, kw2_.CREATE_TIME as CREATE2_5_1_, kw2_.name as name5_1_ from ARTICLES this_ inner join ARTICLE_CATEGORY categories4_ on this_.id=categories4_.ARTICLE_ID inner join CATEGORYS cs1_ on categories4_.CATEGORY_ID=cs1_.id inner join ARTICLE_KEYWORD keywords6_ on this_.id=keywords6_.ARTICLE_ID inner join KEYWORDS kw2_ on keywords6_.KEYWORD_ID=kw2_.id where cs1_.id=3 and kw2_.name in ('西班牙') order by this_.id desc ) where rownum <= 20
select * from ( select this_.id as id0_2_, this_.ABSTRACT as ABSTRACT0_2_, this_.author as author0_2_, this_.CREATE_TIME as CREATE4_0_2_, this_.PUB_TIME as PUB5_0_2_, this_.source as source0_2_, this_.title as title0_2_, this_.uuid as uuid0_2_, 为什么会给取两个一样的别名? 声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |