Table '***_ecms_lx' is marked as crashed and should be repaired 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_lx group by id) as temp where cnt>0 order by cnt desc,id desc limit 10
