(
select dd.*,t.RANK
from crm_CustomerAnalyzeDetails dd
inner join containstable(crm_CustomerAnalyzeDetails,KeyWords,'IsAbout(双子 weight(.5),string weight(.4), 认识 weight(.1) , 字符 weight(.3))',50) as t
on dd.ID = t.[key]
)
union all
(
select dd.*,t.RANK
from crm_CustomerAnalyzeDetails dd
inner join containstable(crm_CustomerAnalyzeDetails,AnalyzeContent,'IsAbout(双子 weight(.5),string weight(.4), 认识 weight(.1) , 字符 weight(.3))',50) as t
on dd.ID = t.[key]
)
union all
(
select dd.*,t.RANK
from crm_CustomerAnalyzeDetails dd
inner join containstable(crm_CustomerAnalyzeDetails,Strategy,'IsAbout(双子 weight(.5),string weight(.4), 认识 weight(.1) , 字符 weight(.3))',50) as t
on dd.ID = t.[key]
)
ORDER BY t.RANK DESC
