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)+(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)+(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
