相关集锦

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