博客   建站   招商   医药   
到要搜首页    
   
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.keywords) like '%/163c/out-4.asp%' OR CONCAT(links.title,' ',links.url,' ',links.keywords) like '%wd%' OR CONCAT(links.title,' ',links.url,' ',links.keywords) like '%/163c/out-4.asp%' OR CONCAT(links.title,' ',links.url,' ',links.keywords) like '%wd%' OR CONCAT(links.title,' ',links.url,' ',links.keywords) like '%医药%' order by links.tuiguang desc,((case when links.title like '%/163c/out-4.asp%' then 1 else 0 end)+(case when links.title like '%?%' then 1 else 0 end)+(case when links.title like '%wd%' then 1 else 0 end)+(case when links.title like '%=%' then 1 else 0 end)+(case when links.title like '%/163c/out-4.asp%' then 1 else 0 end)+(case when links.title like '%?%' then 1 else 0 end)+(case when links.title like '%wd%' 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 '%/163c/out-4.asp?wd=/163c/out-4.asp?wd=医药%' then 8 else 0 end)) desc
MySQL Error :
MySQL Errno : 0
Message : MySQL Query Error