Server shutdown in progress select * from(select id,title,titleurl,sum((case when instr(title,'nba比赛')>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)+(case when instr(title,'cba')>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_jj group by id) as temp where cnt>0 order by cnt desc,id desc limit 10
