select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4140,4142,4141,4143,3810,3812,3820,4146,4421,4442,4442,4496,4506) and a.image is not null and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 4 + 6
LG手机评测查询：
LG手机最新新闻更新
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4140,4142,4141,4143,3810,3812,3820,4146,4421,4442,4442,4496,4506) and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 12 + 6
售后电话：8008105659
最
新
手
机
产
品
秀
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4140,4141,4142,4143) and a.logo is not null and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 5 + 6
LG手机推荐评测
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4140,4142,4141,4143) and a.logo is not null and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 3 + 6
LG手机特别推荐
LG手机新闻
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4496,4146) and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 8 + 6
LG手机评测
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4140,4141,4142,4143) and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 8 + 6
LG手机行情
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4447,4448,4449,4450,4451,4452,4453,4454,4455,4456,4457,4458,4459,4500,4564) and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 8 + 6
LG手机导购
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(4502,4503,4504,4505) and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 8 + 6
LG手机资讯
select rownum ,v.* from (select id from article a,categoryarticleassign c where a.releasetime/1000000<1338063 and a.id=c.articleid and c.categoryid in(3810,4443) and lower(a.keyword) like '%LG%' order by a.releasetime desc) v where rownum < 8 + 6
