问题描述：
Ebay：凤凰计划，符合条件的数据未进入到调价队列表中
)
004-
004+ SELECT * from m_ebay_listing where OnlineStatus =1
005-SELECT * from m_ebay_listing where OnlineStatus =1 and PublishTime > '2016-10-01' and PublishTime < '2025-09-01' and QuantitySold =0 and IsAutoPublish = 0 and OrderSourceId in (select OrderSourceId from pp_phoenixplan_strategy_ordersource where StrategyId = 100457)and ProductId not in (select ItemId from pp_phoenixplan_ebay_autoadjustprice_queue where StrategyId=100457 and `Status` = 'success')
005+ and PublishTime > '2016-10-01' and PublishTime < '2025-09-01'and Country = 'CN' and (WarehouseIds LIKE '%333%' or WarehouseIds LIKE '%5312%' )and QuantitySold =0and IsAutoPublish = 0and OrderSourceId in (select OrderSourceId from pp_phoenixplan_strategy_ordersource where StrategyId = 100457)and ProductId not in (select ItemId from pp_phoenixplan_ebay_autoadjustprice_queue where StrategyId=100457 and `Status` = 'success')
007-
007+
004-<p><br /></p>
004+ SELECT * from m_ebay_listing where OnlineStatus =1<br />
005-<p>SELECT * from m_ebay_listing where OnlineStatus =1 and PublishTime > '2016-10-01' and PublishTime < '2025-09-01' and QuantitySold =0 and IsAutoPublish = 0 and OrderSourceId in (<br />select OrderSourceId from pp_phoenixplan_strategy_ordersource where StrategyId = 100457<br />)<br />and ProductId not in (<br />select ItemId from pp_phoenixplan_ebay_autoadjustprice_queue where StrategyId=100457 and `Status` = 'success'<br />)</p>
005+ and PublishTime > '2016-10-01' and PublishTime < '2025-09-01'<br />and Country = 'CN' and (WarehouseIds LIKE '%333%' or WarehouseIds LIKE '%5312%' )<br />and QuantitySold =0<br />and IsAutoPublish = 0<br />and OrderSourceId in (<br />select OrderSourceId from pp_phoenixplan_strategy_ordersource where StrategyId = 100457<br />)<br />and ProductId not in (<br />select ItemId from pp_phoenixplan_ebay_autoadjustprice_queue where StrategyId=100457 and `Status` = 'success'<br /><p>)</p>
007-<p><img src="{520945.png}" alt="" /></p>
007+ <p><img src="{521081.png}" alt="" /></p>
使用SellerSku查询，调价队列表缺少17722条Listing，详细数据见附件
测试数据：
场景1：
被价格计算器过滤
```
返回：{
```
场景2： 店铺没有授权
| 由谁创建 | 王超 于 2025-12-22 15:35:42 |
|---|---|
| 影响环境 |
生产环境-线上测试 |
| 由谁解决 | 刘朋飞 于 2025-12-25 09:38:09 |
| 解决版本 | 主干 |
| 解决方案 | 历史bug（180天以上） |
| 由谁关闭 | 王超 于 2025-12-25 09:42:13 |
| 最后修改 | 汤翊 于 2025-12-26 10:27:36 |
| 相关Bug |
|---|
历史垃圾数据：
select * from m_ebay_listing where ProductId in ('156941424799','156941585784')
过滤：SELECT `CustomerId` AS `CustomerId` , `OrderSourceId` AS `OrderSourceId` , `SellerSku` AS `SellerSku` , `Time` AS `Time` FROM `Pp_PhoenixPlan_Ebay_AutoAdjustPrice_Queue` WHERE ((((( `CustomerId` = 1 ) AND ( `MarketId` = 2 )) AND ( `OrderSourceId` = 5081 )) AND ( `StrategyId` = 100457 )) AND (`SellerSku` IN ('W1224256SHVC5081','R122528HL3PK5081','W12280126OY25081','9122259I482U5081','Y122523OWO6D5081','8122419X0MEH5081','B122802BX8WY5081','31225242J74H5081','A122522B8GYT5081','T1226327VKD75081','Y1224018IAVI5081','U12240170C3E5081','4122521WL00Q5081','X122631FGFJA5081','2122516QNHW65081','I1226125GMWW5081','N122422SOSZP5081','2122515FJSJ75081','5122358S7XXN5081','E122433OQCF95081','N12251451OZX5081','V122352X9NRB5081','O122512482HX5081','11226101IKNM5081','X122351KQW0V5081','Q1224272A52Y5081','B122427F5JX45081','H122758XKFGH5081','D1225570870C5081','S125345WKCD45081','O122801O9UL25081','X122806N57855081','N12251920WL95081','X1227059TLFI5081','L122812MISBV5081','E122346WGPJH5081','K122754W57625081','I094612445BB5081','5122419O3KXQ5081','51232152PJCW5081','D123308H7IZ35081','8125348GC9XJ5081','Y123419OUPF55081','H123346M0ZA95081','2123236VVMH65081','5184050PDBA55081','4184013QIX6G5081','4184008DK3QN5081','0183929N2JU25081','11837261LDQO5081','K1832174MFJ45081','3183216P19HF5081','2183214ZM5HT5081','X18321319I6B5081','518320768G9J5081','7183144NW4GL5081','C1226366VGM85081','5122424XEU4A5081','J122730IWIZT5081','K122635SXLS75081','X122726PLUFG5081','0122253KB7N65081','R122400P73AZ5081','Q1227549D85W5081','4122630RWU625081','Z122517I3Z8C5081','P1224541D1WH5081','E122452C3ILB5081','4122433D9NGF5081','0122509DX9EF5081','E122609UHWY95081','J122430Q2UQA5081','B122603HGY5B5081','K122601NNRHT5081','J122558PQ64X5081','Z125210NG6ZE5081','1123409FGJCV5081','H122804MFGVU5081','O122348NGLET5081','B122654YS8275081','F122658EKGEF5081','0094559WPSP65081','Q094557W62CE5081','Q0946132J3DF5081','80946090J8HR5081','W183221CAXJQ5081','Y184107WVMVZ5081','61840534PZ0M5081','C184054CI8UR5081','1184007YVGT45081','P184005PAI7D5081','L1838077S5WK5081','U183217IWTVT5081','C1832168XT915081','T18321067NSP5081','S183205E4H655081','61831597FMMK5081','T183151T8IWB5081','11831500UMR85081','51831374LYWP5081')) )