需求内容：之前导出的数据没有分类名称，需要把分类名称加上，其他字段的导出逻辑无修改

之前导出数据的SQL，如下：

select 
OrderSourceName '来源渠道',
SKU '系统SKU',
OrderSourceSKU '渠道SKU',
RecommendedBrowseNodeName '上架类目路径',
LastRecommendedBrowseNodeName '推荐类目路径',   （要分类名称，不需要分类ID）
BusinessTeamName '销售小组',
BusinessUserName '销售人员',
AddAdminName '上架人员',
offBusinessTeamName '上架小组',
PublishTime '刊登时间',
msaleNum '近30天销量',
case when OnShelfMode=1  then '一键上架' 
when OnShelfMode=2  then '草稿上架'
when OnShelfMode=3  then '表格上架'
when OnShelfMode=4  then '关联导入'
when OnShelfMode=5  then '批量跟卖'
when OnShelfMode=6  then '凤凰重刊'
when OnShelfMode=7  then '复制上架'
when OnShelfMode=8  then '智能刊登'
else '' end  as '上架方式',
 CASE
    WHEN IsOffShelf = 0 THEN '在线'
    WHEN IsOffShelf = 1 THEN '下架'
    WHEN IsOffShelf = 2 THEN '售完'
    WHEN IsOffShelf = 3 THEN '草稿'
    WHEN IsOffShelf = 4 THEN '刊登中'
    WHEN IsOffShelf = 5 THEN '刊登失败'
    ELSE ''
  END '在线状态'
from(
SELECT
ROW_NUMBER() OVER (ORDER BY ID asc) AS [PageIndex] ,* FROM (
select a.OrderSourceName 
,a.SKU 
,a.OrderSourceSKU
,a.RecommendedBrowseNodeName 
,(select top 1 d.PathName from RB_Amazon_Product_KeyClassResult d (nolock) where d.CustomerID=a.CustomerID and d.SKU= a.SKU order by d.SerialNo asc ) as LastRecommendedBrowseNodeName
,a.BusinessTeamName 
,a.BusinessUserName  
,a.AddAdminName 
,c.BusinessTeamName as offBusinessTeamName
,a.PublishTime 
,a.msaleNum 
,a.OnShelfMode
,a.IsOffShelf
,a.ID
from RB_Amazon_Product_Base a (nolock)
inner join  RB_OrderSource d(nolock)
on a.CustomerID=d.CustomerID
and a.OrderSourceID=d.ID
left join RB_Admin b (nolock) on a.CustomerID=b.CustomerID and a.AddAdminID = b.ID
left join RB_BusinessTeam c (nolock) on c.CustomerID = b.CustomerID and c.id = b.BusinessTeamID
where a.CustomerID=1  and a.OrderSourceSKUID >0 and a.OnShelfMode in(1,2,7,8)
and  d.OrderSourceCountry='US'
and a.PublishTime >='2022-01-01' and a.PublishTime <'2022-05-01'
 ) AS TempTable ) AS  PagerTable
WHERE PagerTable.[PageIndex] BETWEEN 1 AND 600000