相关集锦

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