MySQL Query : select links.*,sites.qp from ve123_links links left join ve123_sites sites on links.site_id=sites.site_id where links.title<>'' and CONCAT(links.title,' ',links.url,' ',links.fulltxt) like '%北京市%' OR CONCAT(links.title,' ',links.url,' ',links.fulltxt) like '%医院%' order by links.tuiguang desc,((case when links.title like '%北京市%' then 1 else 0 end)+(case when links.title like '%海%' then 1 else 0 end)+(case when links.title like '%淀%' then 1 else 0 end)+(case when links.title like '%医院%' then 1 else 0 end)+(case when links.title like '%北京市海淀医院%' then 8 else 0 end)) desc
MySQL Error : Table 've123_links' is marked as crashed and should be repaired
MySQL Errno : 1194
Message : MySQL Query Error