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