一、排查Amazon店铺异常提醒问题
SELECT os.ID AS OrderSourceID,
bt.ID AS BusinessTeamID,os.OrderSourceName
FROM RB_OrderSource os (nolock)
LEFT JOIN RB_Admin ra
ON ra.CustomerID = os.CustomerID
AND ra.ID = os.SaleAdminID
LEFT JOIN RB_BusinessTeam bt (nolock)
ON bt.CustomerID = os.CustomerID
AND bt.ID = ra.BusinessTeamID
WHERE os.OrderSourceType = 1
AND os.CustomerID=1
AND os.ID in(SELECT CONVERT(INT, item) FROM Charsplitforin('18574,18573,18567,18568,18563,18570', ','))
SELECT bt.ID AS BusinessTeamID,
ra.EmployeePhone,
ra.UserName,
ra.ID AS AdminID
FROM RB_Admin ra (NOLOCK)
INNER JOIN RB_BusinessTeam bt (NOLOCK)
ON bt.CustomerID = ra.CustomerID
AND bt.TeamLeaderID = ra.ID
WHERE ra.CustomerID = 1
AND bt.ID IN
(
SELECT CONVERT(INT, item)FROM CharSplitForIn(209, ',')
);
二、处理bug：ID 41674 【生产环境】速卖通平台批量复制listing选择渠道时未排序不好选择
