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_lx group by id) as temp where cnt>0 order by cnt desc,id desc limit 10
