附属类目没说不做，也不可能说只做主类目的，标识都是有的，都是同一套逻辑。

不能说因为是附属类目，有标识反而还不打标识。

肖玉的需求就是奇奇怪怪的。

1、erp代码改IsAI和IsAC字段的语句已取消。

3、服务EProductAmazonBrowseTreeCron

3、智能选品服务改为增量

SELECT TOP
	100 [a].[ID] AS [Id],
	[a].[SKU] AS [Sku],
	[a].[PreCheckTime] AS [PreCheckTime],
	[a].[PreCheckStatus] AS [PreCheckStatus],
	[a].[BrowsePathByID] AS [BrowsePathByID],
	[b].[ProductNameCN] AS [ProductNameCN],
	[b].[ImageUrl] AS [ImageUrl],
	[c].[BrowseNodeName] AS [BrowsePathByName],
	[c].[IsMain] AS [IsMain],
	[c].[Id] AS [Pab_Id] 
FROM
	[E_Product_Amazon_BrowseTree_Check] [a] WITH ( NOLOCK )
	INNER JOIN [RB_Product] [b] WITH ( NOLOCK ) ON [a].[SKU] = [b].[SKU]
	INNER JOIN [E_Product_Amazon_BrowseTree] [c] WITH ( NOLOCK ) ON [a].[SKU] = [c].[SKU] AND [a].[BrowsePathByID] = [c].[BrowsePathByID] 
WHERE
	[a].[ID] > 0 
	AND [a].[PreCheckStatus] = 3 
	AND [a].[PreCheckTime] >= '2023-11-11 07:00:00.000' 
	AND [a].[PreCheckTime] < '2023-11-11 08:00:00.000' 
	AND [b].[IsGroup] = 0 
	AND [c].[IsMain] = [c].[IsMain] 
ORDER BY
	[a].[ID] ASC

SELECT *, 0 AS _NAV_ORDER_F_ FROM [dbo].[E_Product_Amazon_BrowseTree] WHERE [ID] = N'9212297'