[!--title--]
[!--newstext--]
上一条:[!--info.pre--]
下一条:[!--info.next--]
相关录像
Server shutdown in progress
select * from(select id,title,titleurl,sum((case when instr(title,'高拉特')>0 then 1 else 0 end)+(case when instr(title,'国足')>0 then 1 else 0 end)+(case when instr(title,'中超')>0 then 1 else 0 end)+(case when instr(title,'广州队热门')>0 then 1 else 0 end)) as cnt from ***_ecms_lx group by id) as temp where cnt>0 order by cnt desc,id desc limit 10