[!--title--]
比赛时间:[!--newstime--]
相关录像
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)+(case when instr(title,'五洲')>0 then 1 else 0 end)+(case when instr(title,'足球')>0 then 1 else 0 end)+(case when instr(title,'Z原创')>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