[!--title--]
比赛时间：[!--newstime--]
相关录像
MySQL server has gone away
select * from(select id,title,titleurl,sum((case when instr(title,'CBA')>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
