相关集锦

Server shutdown in progress
select * from(select id,title,titleurl,sum((case when instr(title,'NBA')>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,'76人')>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