涉及项目：erp

检测程序已完成，针对检测品牌词日本或非日本站点，未启用erp自带检测敏感词方法，已将目前新的过滤敏感词保持一致，目前所有在线listing：7000多万，已在检测

涉及项目：erp

数据已跑完，导出数据sql如下：

select a.ID,a.OrderSourceName
,a.OrderSourceSKU,
a.SKU,
b.SaleAdminName as '销售人员',
d.DepartmentName as '部门',
 CASE
    isnull(abt2.BusinessTeamName, '')
    WHEN '' then (
      case
        ISNULL(abt1.BusinessTeamName, '')
        when '' then abt.BusinessTeamName
        else abt1.BusinessTeamName
      end
    )
    ELSE abt2.BusinessTeamName
  END as '一级销售小组',
  CASE
    isnull(abt2.BusinessTeamName, '')
    WHEN '' then (
      case
        ISNULL(abt1.BusinessTeamName, '')
        when '' then ''
        else abt.BusinessTeamName
      end
    )
    ELSE abt1.BusinessTeamName
  END as '二级销售小组',
  CASE
    isnull(abt2.BusinessTeamName, '')
    WHEN '' then ''
    ELSE abt.BusinessTeamName
  END as '三级销售小组',
  ISNULL(a.TitleContainBand,'') as '标题对应品牌词',
  ISNULL(a.GenericKeywordContainBand,'') as '关键词对应品牌词',
  ISNULL(a.BulletPointContainBand,'') as '亮点对应品牌词',
  ISNULL(a.ProductDescriptionContainBand,'') as '描述对应品牌词'
from  
A_AmazonListing_BnadDetails a(nolock) 
inner join
RB_OrderSource b(nolock)
on a.OrderSourceID=b.ID
left join RB_Admin c (nolock)
on b.CustomerID=c.CustomerID
and b.SaleAdminID=c.ID
left join
RB_Department d(nolock)
on c.CustomerID=d.CustomerID
and c.DepartmentID=d.ID
left join RB_BusinessTeam abt(nolock) on abt.Id = c.BusinessTeamID
  and abt.CustomerID = a.CustomerID
  left join RB_BusinessTeam abt1(nolock) on abt1.id = abt.BusinessTeamParentID
  and abt1.CustomerID = a.CustomerID
  left join RB_BusinessTeam abt2(nolock) on abt2.id = abt1.BusinessTeamParentID
  and abt2.CustomerID = a.CustomerID
  and abt1.BusinessTeamName <> ''
where a.Status=1  and 
(ISNULL(a.TitleContainBand,'')<>'' OR  
ISNULL(a.GenericKeywordContainBand,'')<>'' OR
ISNULL(a.BulletPointContainBand,'')<>'' OR
ISNULL(a.ProductDescriptionContainBand,'')<>'')