MySQL server has gone away 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,'JR')>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
