SELECT a.`Status`,count(*) FROM ap_autopublish_allegro_queue a
LEFT JOIN pp_phoenixplan_allegro_queue b ON a.CustomerId=b.CustomerId AND a.MarketId=b.MarketId AND a.OrderSourceId=b.OrderSourceId AND a.SellerSku=b.RePublishSellerSku
WHERE a.CustomerId=1 AND a.MarketId=67 AND a.PublishType=3 AND a.IsAgainPublish=1 AND b.StrategyId IN(7341,7348) AND a.Time >= '2023-02-21'
GROUP BY a.`Status`

主干分支代码不一样,已更新,执行如下