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