已添加限制：

且改代码需要重构，否则维护会步入困难

多属性刊登逻辑新增代码

其他刊登新增代码

第一，请不要设置刊登时间限制！！！！

第二，多属性变体刊登逻辑参考了 EBay 平台，AliExpress 多属性刊登逻辑，就是从这两者抄的代码。

Ebay 平台中，优化了查询逻辑，按终审时间来切块查询，如果没有指定终审时间，则终审时间为截止今天的前两天的默认条件。

如果你需要知道这块的需求，找产品，作为开发者我也不清楚这里的需求。

这是生成的SQL

SELECT `t1`.`CustomerId` AS `CustomerId`,  `t1`.`Sku` AS `Sku`,  `t1`.`RealSku` AS `RealSku`,  `t1`.`CustomSku` AS `CustomSku`,  `t1`.`IsVariant` AS `IsVariant`,  `t1`.`IsMainVariant` AS `IsMainVariant`,  `t1`.`ParentId` AS `ParentId`,  `t1`.`Id` AS `Id`,  `t1`.`LogisticsAttribute` AS `LogisticsAttribute`,  `t1`.`FinalJudgmentStatus` AS `FinalJudgmentStatus`,  `t1`.`FinalJudgmentTime` AS `FinalJudgmentTime`,  `t1`.`AccurateKeywords` AS `AccurateKeywords`,  `t1`.`BrandId` AS `BrandId`,  `t1`.`BrandName` AS `BrandName`,  `t1`.`CartonPcsNum` AS `CartonPcsNum`,  `t1`.`CategoryId` AS `CategoryId`,  `t1`.`CategoryIds` AS `CategoryIds`,  `t1`.`FirstCategoryId` AS `FirstCategoryId`,  `t1`.`Color` AS `Color`,  `t1`.`DeclarationCode` AS `DeclarationCode`,  `t1`.`DeclarationLocalName` AS `DeclarationLocalName`,  `t1`.`DeclarationName` AS `DeclarationName`,  `t1`.`DeclarationPrice` AS `DeclarationPrice`,  `t1`.`DevelopmentType` AS `DevelopmentType`,  `t1`.`EditStatus` AS `EditStatus`,  `t1`.`GrossWeight` AS `GrossWeight`,  `t1`.`GroupSkuId` AS `GroupSkuId`,  `t1`.`Height` AS `Height`,  `t1`.`IsDelete` AS `IsDelete`,  `t1`.`IsGroup` AS `IsGroup`,  `t1`.`RiskInfringement` AS `RiskInfringement`,  `t1`.`Length` AS `Length`,  `t1`.`Material` AS `Material`,  `t1`.`MaxPurchasePrice` AS `MaxPurchasePrice`,  `t1`.`MinPurchasePrice` AS `MinPurchasePrice`,  `t1`.`Name` AS `Name`,  `t1`.`NameEn` AS `NameEn`,  `t1`.`NetWeight` AS `NetWeight`,  `t1`.`PackageHeight` AS `PackageHeight`,  `t1`.`PackageLength` AS `PackageLength`,  `t1`.`PackageWeight` AS `PackageWeight`,  `t1`.`PackageWidth` AS `PackageWidth`,  `t1`.`PurchasePrice` AS `PurchasePrice`,  `t1`.`StrongPlug` AS `StrongPlug`,  `t1`.`StrongPlugItem` AS `StrongPlugItem`,  `t1`.`Size` AS `Size`,  `t1`.`ShoeTightness` AS `ShoeTightness`,  `t1`.`StartBatch` AS `StartBatch`,  `t1`.`State` AS `State`,  `t1`.`SuitableforGender` AS `SuitableforGender`,  `t1`.`SupplyPrice` AS `SupplyPrice`,  `t1`.`Type` AS `Type`,  `t1`.`Width` AS `Width` FROM (SELECT `CustomerId`,  `Sku`,  `CustomSku`,  `IsVariant`,  `IsMainVariant`,  `ParentId`,  `Name`,  `NameEn`,  `BrandId`,  `BrandName`,  `Material`,  `FirstCategoryId`,  `CategoryId`,  `CategoryIds`,  `State`,  `StartBatch`,  `RiskInfringement`,  `Type`,  `LogisticsAttribute`,  `StrongPlug`,  `StrongPlugItem`,  `PurchasePrice`,  `MinPurchasePrice`,  `MaxPurchasePrice`,  `SupplyPrice`,  `Color`,  `Size`,  `PackageWeight`,  `GrossWeight`,  `NetWeight`,  `Length`,  `Width`,  `Height`,  `PackageLength`,  `PackageWidth`,  `PackageHeight`,  `DevelopmentType`,  `FinalJudgmentTime`,  `EditStatus`,  `DeclarationPrice`,  `AccurateKeywords`,  `FinalJudgmentStatus`,  `DeclarationName`,  `DeclarationCode`,  `SuitableforGender`,  `ShoeTightness`,  `CartonPcsNum`,  `IsGroup`,  `GroupSkuId`,  `DeclarationLocalName`,  `IsDelete`,  `RealSku`,  `LastModifierId`,  `LastModifier`,  `LastModificationTime`,  `CreatorId`,  `Creator`,  `CreationTime`,  `Id`  FROM `P_Product`) t1 Left JOIN (SELECT `CustomerId` AS `CustomerId`, `Sku` AS `Sku` FROM `Ap_AutoPublish_AliExpress_AllSku` WHERE ((((`CustomerId` = 1) AND (`MarketId` = 57)) AND  (`StrategyId` = 51132)) AND (`OrderSourceId` = 10956))) t2 ON ((`t1`.`CustomerId` = `t2`.`CustomerId`) AND (`t1`.`RealSku` = `t2`.`Sku`)) WHERE (((((((((((((((`t1`.`CustomerId` = 1) AND NOT (`t1`.`IsDelete` = 1)) AND  (`t1`.`FinalJudgmentStatus` = 1)) AND (((`t1`.`Sku` like concat('ZN', '%')) AND (CASE  WHEN (`t1`.`IsGroup` = TRUE) THEN TRUE  ELSE FALSE END) = 1) AND  (`t1`.`IsVariant` = 1))) AND  (`t2`.`Sku` = '' OR `t2`.`Sku` IS NULL)) AND (`t1`.`FinalJudgmentTime` >= ' 2022/9/17 0:00:00')
                   ) AND (`t1`.`FinalJudgmentTime` <= ' 2022/9/19 23:59:59')
                  ) AND (`t1`.`RiskInfringement` IN (1))) AND  (`t1`.`PackageLength` <= 65)) AND (`t1`.`PackageWidth` <= 65)) AND  (`t1`.`PackageHeight` <= 65)) AND  (((`t1`.`PackageLength` + `t1`.`PackageWidth`) + `t1`.`PackageHeight`) <= 90)) AND  ((CASE WHEN (`t1`.`PackageWeight` = 0) THEN `t1`.`GrossWeight` ELSE `t1`.`PackageWeight` END) <= 2000)) AND (NOT EXISTS(SELECT *  FROM `M_AliExpress_Listing` WHERE (((((`CustomerId` = `t1`.`CustomerId`) AND  (`OrderSourceId` = 10956)) AND (`Sku` = `t1`.`RealSku`)) AND  (`OnlineStatus` IN (1, 4))) AND (`Type` = 4))))) AND  (NOT EXISTS(SELECT *  FROM `M_AliExpress_Listing` WHERE (((((`CustomerId` = `t1`.`CustomerId`) AND (`OrderSourceId` = 10956)) AND  (`Sku` = `t1`.`RealSku`)) AND (`OnlineStatus` IN (1, 4))) AND (`Type` = 4))))) ORDER BY `t1`.`Id` DESC LIMIT 0,100 

请找产品

任务地址：[点击跳转]

需求地址：[点击跳转]

按SQL搜索有满足的数据。没有执行出数据