相关集锦

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