[步骤]
CBT1663258490
CBT1663245356

[结果]
listing管理数据重复显示[期望]
listing管理数据显示正常[步骤]
CBT1663258490
CBT1663245356

[结果]
listing管理数据重复显示[期望]
listing管理数据显示正常002-CBT1663258490CBT1663245356
002+ CBT1663258490CBT1663245356
002-<p>CBT1663258490<br />CBT1663245356<br /></p>
002+ <p>CBT1663258490<br />CBT1663245356</p>
1.查询关联了M_Mercadolibre_Listing_Site表 站点表有两笔 所以显示两笔
SELECT m.* FROM (SELECT * FROM (SELECT `Id` AS `Id` ,`CustomerId` AS `CustomerId` ,`OrderSourceId` AS `OrderSourceId` ,`SiteId` AS `SiteId` ,`ProductId` AS `ProductId` ,`SellerId` AS `SellerId` ,`OfficialStoreId` AS `OfficialStoreId` ,`Type` AS `Type` ,`ParentSku` AS `ParentSku` ,`Name` AS `Name` ,`SubName` AS `SubName` ,`Tags` AS `Tags` ,`MainImage` AS `MainImage` ,`CategoryId` AS `CategoryId` ,`Price` AS `Price` ,`BasePrice` AS `BasePrice` ,`OriginalPrice` AS `OriginalPrice` ,`Currency` AS `Currency` ,`InitialQuantity` AS `InitialQuantity` ,`Quantity` AS `Quantity` ,`SoldQuantity` AS `SoldQuantity` ,`BuyingMode` AS `BuyingMode` ,`ListingTypeId` AS `ListingTypeId` ,`StartTime` AS `StartTime` ,`StopTime` AS `StopTime` ,`Condition` AS `Condition` ,`PermaLink` AS `PermaLink` ,`AcceptsMercadopago` AS `AcceptsMercadopago` ,`VideoId` AS `VideoId` ,`DescriptionId` AS `DescriptionId` ,`CatalogProductId` AS `CatalogProductId` ,`DomainId` AS `DomainId` ,`DateCreated` AS `DateCreated` ,`LastUpdate` AS `LastUpdate` ,`Health` AS `Health` ,`CatalogListing` AS `CatalogListing` ,`AutomaticRelist` AS `AutomaticRelist` ,`Warranty` AS `Warranty` ,`Status` AS `Status` ,`SubStatus` AS `SubStatus` ,`SellerSku` AS `SellerSku` ,`Inventory` AS `Inventory` ,`Color` AS `Color` ,`Size` AS `Size` ,`Length` AS `Length` ,`Height` AS `Height` ,`Width` AS `Width` ,`Weight` AS `Weight` ,`Sku` AS `Sku` ,`CustomSku` AS `CustomSku` ,`PublishTime` AS `PublishTime` ,`UnPublishTime` AS `UnPublishTime` ,`AutoPublishStrategyId` AS `AutoPublishStrategyId` ,`AutoPublishTime` AS `AutoPublishTime` ,`IsAutoPublish` AS `IsAutoPublish` ,`RePublishStrategyId` AS `RePublishStrategyId` ,`RePublishTime` AS `RePublishTime` ,`AutoUnPublishStrategyId` AS `AutoUnPublishStrategyId` ,`AutoUnPublishTime` AS `AutoUnPublishTime` ,`AutoAdjustPriceStrategyId` AS `AutoAdjustPriceStrategyId` ,`AutoAdjustPriceTime` AS `AutoAdjustPriceTime` ,`AutoPromotionStrategyId` AS `AutoPromotionStrategyId` ,`AutoPromotionTime` AS `AutoPromotionTime` ,`LastPhoenixPlanStrategyType` AS `LastPhoenixPlanStrategyType` ,`OnlineStatus` AS `OnlineStatus` ,`SyncStep` AS `SyncStep` ,`SyncTime` AS `SyncTime` ,`LastModifierId` AS `LastModifierId` ,`LastModifier` AS `LastModifier` ,`LastModificationTime` AS `LastModificationTime` ,`CreatorId` AS `CreatorId` ,`Creator` AS `Creator` ,`CreationTime` AS `CreationTime` FROM `M_Mercadolibre_Listing` WHERE (((((( `CustomerId` = 1 ) AND NOT( `Sku` IS NULL OR `Sku`='')) AND (`OnlineStatus` IN (1)) ) AND ( `PublishTime` >= '2023-04-13 00:00:00' )) AND ( `PublishTime` <= '2023-04-13 23:59:59' )) AND (`ProductId` IN ('CBT1663258490')) ) ) MergeTable ) m Left JOIN `M_Mercadolibre_Listing_Site` site ON (((( `site`.`CustomerId` = `m`.`CustomerId` ) AND ( `site`.`OrderSourceId` = `m`.`OrderSourceId` )) AND ( `site`.`ProductId` = `m`.`ProductId` )) AND (`site`.`Status` IN ('active')) )
确认下要怎么修改
1.将重复结果汇总

| 由谁创建 | 李乐同 于 2023-04-13 12:00:25 |
|---|---|
| 影响环境 |
668 |
| 由谁解决 | 朱思文 于 2023-04-14 09:50:00 |
| 解决版本 | |
| 解决方案 | 程序BUG |
| 由谁关闭 | 李乐同 于 2023-04-14 14:43:24 |
| 最后修改 | 刘超 于 2023-11-17 09:46:10 |
| 相关Bug |
|---|