业务需求
需求描述

https://alidocs.dingtalk.com/i/nodes/r1R7q3QmWe7BrgLahZMNMepwJxkXOEP2?utm_scene=team_space


[步骤]

未添加nolock 查询慢 容易造成阻塞

SELECT Count(1)
FROM   (SELECT OS.*,
EC.Country_cn,
CASE
WHEN OS.AddTime >= Dateadd(MONTH, -3, Getdate()) THEN '新'
ELSE '旧'
END                                      NewOldSign,
API.IsActive                             AS APIIsActive,
EabyAPI.IsActive                         AS APIIsActiveNew,
EMAIL.IsActive                           AS EmailSetIsActive,
ADS.IsActive                             AS ReturnAddressIsActive,
HOUSE.WareHouseName,
BT.BusinessTeamName,
API.MerchantToken,
dp.DepartmentName                        AS DepartmentName,
( CPM.Name + '-' + CPM.CorporateNameCN ) AS NameCorporateNameCN,
ADA.IsActive                             AS AmazonAdertismentIsActive,
RBA.UserName,
API.CertIDAccessKeyId,
EabyAPI.CertIDAccessKeyId                AS CertIDAccessKeyIdNew,
API.ServerUrl,
API.TokenDeadline,
API.EUBAPIPassword,
LTPE.AuthAddtime,
CASE
WHEN LTPE.AuthAddtime IS NULL
AND API.TokenDeadline IS NULL THEN 0
ELSE 1
END                                      AS TokenLineStatus
FROM   RB_OrderSource OS WITH(nolock)
LEFT JOIN E_Country EC
ON EC.Shorthand = OS.OrderSourceCountry
LEFT JOIN RB_Admin RBA
ON RBA.CustomerID = OS.CustomerID
AND RBA.ID = OS.SaleAdminID
LEFT JOIN RB_BusinessTeam BT
ON BT.CustomerID = OS.CustomerID
AND BT.ID = RBA.BusinessTeamID
LEFT JOIN RB_Admin RBAS
ON RBAS.CustomerID = OS.CustomerID
AND RBAS.ID = OS.ServiceAdminID
LEFT JOIN RB_Department dp
ON dp.CustomerID = RBAS.CustomerID
AND dp.ID = RBAS.DepartmentID
LEFT JOIN RB_OrderSource_EbayAmazonAPI API
ON API.CustomerID = OS.CustomerID
AND API.OrderSourceID = OS.ID
LEFT JOIN RB_OrderSource_EmailSet EMAIL
ON EMAIL.CustomerID = OS.CustomerID
AND EMAIL.OrderSourceID = OS.ID
LEFT JOIN RB_OrderSource_ReturnAddress ADS
ON ADS.CustomerID = OS.CustomerID
AND ADS.OrderSourceID = OS.ID
LEFT JOIN RB_WareHouse HOUSE
ON HOUSE.CustomerID = OS.CustomerID
AND HOUSE.ID = OS.DefaultWareHouseID
LEFT JOIN RB_CustomsPeopleManage CPM
ON CPM.CustomerID = OS.CustomerID
AND CPM.ID = OS.CustomsPeopleManageID
LEFT JOIN RB_Amazon_AdvertisementAuthorization ADA
ON ADA.CustomerID = OS.CustomerID
AND ADA.OrderSourceID = OS.ID
LEFT JOIN RB_OrderSource_API AS EabyAPI
ON EabyAPI.CustomerID = OS.CustomerID
AND EabyAPI.OrderSourceID = OS.ID
LEFT JOIN RB_OrderSource_FinancialExt AS FIN
ON FIN.CustomerID = OS.CustomerID
AND FIN.OrderSourceID = OS.ID
LEFT JOIN RB_Amazon_AdvertisementAuthorization AS CPC
ON CPC.CustomerID = OS.CustomerID
AND CPC.OrderSourceID = OS.ID
LEFT JOIN (SELECT LogType,
Max(Addtime) AuthAddtime
FROM   RB_OrderSource_Log
WHERE  1 = 1
AND LogTableName = 'RB_OrderSource_EbayAmazonAPI'
AND LogType != 'undefined'
GROUP  BY LogType) LTPE
ON LTPE.LogType = OS.ID
WHERE  OS.CustomerID = 1
AND Isnull(OS.IsDelete, 0) = 0
AND OS.IsActive = 1
AND ( OS.OrderSourceName LIKE '%Ozon-Z26140-QWYN%'
OR OS.OrderSourceName LIKE '%Ozon-Z26141-VYLK%'
OR OS.OrderSourceName LIKE '%Ozon-Z26142-JAXO%'
OR OS.OrderSourceName LIKE '%Ozon-Z26143-ZYNE%'
OR OS.OrderSourceName LIKE '%Ozon-Z26144-KRYZ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26145-VOXE%'
OR OS.OrderSourceName LIKE '%Ozon-Z26146-XYPH%'
OR OS.OrderSourceName LIKE '%Ozon-Z26147-GLOW%'
OR OS.OrderSourceName LIKE '%Ozon-Z26148-FRYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26149-BLYN%'
OR OS.OrderSourceName LIKE '%Ozon-Z26150-CYXA%'
OR OS.OrderSourceName LIKE '%Ozon-Z26151-TRYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26152-WYVE%'
OR OS.OrderSourceName LIKE '%Ozon-Z26153-JYXE%'
OR OS.OrderSourceName LIKE '%Ozon-Z26154-KLOQ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26155-ZAVY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26156-NYXI%'
OR OS.OrderSourceName LIKE '%Ozon-Z26157-PYRI%'
OR OS.OrderSourceName LIKE '%Ozon-Z26158-QXOR%'
OR OS.OrderSourceName LIKE '%Ozon-Z26159-VYJU%'
OR OS.OrderSourceName LIKE '%Ozon-Z26160-ZYWA%'
OR OS.OrderSourceName LIKE '%Ozon-Z26161-KLYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26162-JORV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26163-FEXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26166-CRYN%'
OR OS.OrderSourceName LIKE '%Ozon-Z26167-PLYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26168-BROX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26169-DRYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26170-FLYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26171-GLYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26172-QWER%'
OR OS.OrderSourceName LIKE '%Ozon-Z26173-ZYLV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26174-VEXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26175-JYTH%'
OR OS.OrderSourceName LIKE '%Ozon-Z26176-KRYP%'
OR OS.OrderSourceName LIKE '%Ozon-Z26177-FLYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26178-GRYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26179-BLYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26180-CYZO%'
OR OS.OrderSourceName LIKE '%Ozon-Z26181-DRYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26182-FRYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26183-GLYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26184-HYXP%'
OR OS.OrderSourceName LIKE '%Ozon-Z26185-JYXV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26186-KLYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26187-MRYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26188-NYXO%'
OR OS.OrderSourceName LIKE '%Ozon-Z26189-PRYF%'
OR OS.OrderSourceName LIKE '%Ozon-Z26189-biblab%'
OR OS.OrderSourceName LIKE '%Ozon-Z26190-audience%'
OR OS.OrderSourceName LIKE '%Ozon-Z26191-patientive%'
OR OS.OrderSourceName LIKE '%Ozon-Z26192-skilluous%'
OR OS.OrderSourceName LIKE '%Ozon-Z26193-unihood%'
OR OS.OrderSourceName LIKE '%Ozon-Z26194-roleling%'
OR OS.OrderSourceName LIKE '%Ozon-Z26195-fightular%'
OR OS.OrderSourceName LIKE '%Ozon-Z26196-tostfication%'
OR OS.OrderSourceName LIKE '%Ozon-Z26197-describe%'
OR OS.OrderSourceName LIKE '%Ozon-Z26198-ornithoeast%'
OR OS.OrderSourceName LIKE '%Ozon-Z26199-bullietic%'
OR OS.OrderSourceName LIKE '%Ozon-Z26200-airivity%'
OR OS.OrderSourceName LIKE '%Ozon-Z26201-syattack%'
OR OS.OrderSourceName LIKE '%Ozon-Z26202-futilesque%'
OR OS.OrderSourceName LIKE '%Ozon-Z26203-claimety%'
OR OS.OrderSourceName LIKE '%Ozon-Z26204-omation%'
OR OS.OrderSourceName LIKE '%Ozon-Z26205-quiteor%'
OR OS.OrderSourceName LIKE '%Ozon-Z26206-vivatory%'
OR OS.OrderSourceName LIKE '%Ozon-Z26231-pinness%'
OR OS.OrderSourceName LIKE '%Ozon-Z26232-plaint%'
OR OS.OrderSourceName LIKE '%Ozon-Z26233-palinsion%'
OR OS.OrderSourceName LIKE '%Ozon-Z26234-hotelier%'
OR OS.OrderSourceName LIKE '%Ozon-Z26235-drivesive%'
OR OS.OrderSourceName LIKE '%Ozon-Z26236-holdarian%'
OR OS.OrderSourceName LIKE '%Ozon-Z26237-keysome%'
OR OS.OrderSourceName LIKE '%Ozon-Z26238-raceaire%'
OR OS.OrderSourceName LIKE '%Ozon-Z26239-crimeular%'
OR OS.OrderSourceName LIKE '%Ozon-Z26240-wouldic%'
OR OS.OrderSourceName LIKE '%Ozon-Z26241-thustion%'
OR OS.OrderSourceName LIKE '%Ozon-Z26242-hotfic%'
OR OS.OrderSourceName LIKE '%Ozon-Z26243-partyress%'
OR OS.OrderSourceName LIKE '%Ozon-Z26244-seiee%'
OR OS.OrderSourceName LIKE '%Ozon-Z26245-pteryair%'
OR OS.OrderSourceName LIKE '%Ozon-Z26246-whomous%'
OR OS.OrderSourceName LIKE '%Ozon-Z26247-claustro%'
OR OS.OrderSourceName LIKE '%Ozon-Z26248-hormer%'
OR OS.OrderSourceName LIKE '%Ozon-Z26249-bloodon%'
OR OS.OrderSourceName LIKE '%Ozon-Z26250-epianeous%'
OR OS.OrderSourceName LIKE '%Ozon-Z26251-semiie%'
OR OS.OrderSourceName LIKE '%Ozon-Z26252-piproof%'
OR OS.OrderSourceName LIKE '%Ozon-Z26253-seaality%'
OR OS.OrderSourceName LIKE '%Ozon-Z26254-flyism%'
OR OS.OrderSourceName LIKE '%Ozon-Z26261-perhapser%'
OR OS.OrderSourceName LIKE '%Ozon-Z26262-memory%'
OR OS.OrderSourceName LIKE '%Ozon-Z26263-capsture%'
OR OS.OrderSourceName LIKE '%Ozon-Z26264-flaccade%'
OR OS.OrderSourceName LIKE '%Ozon-Z26265-centuryade%'
OR OS.OrderSourceName LIKE '%Ozon-Z26266-vermair%'
OR OS.OrderSourceName LIKE '%Ozon-Z26219-GRYM%'
OR OS.OrderSourceName LIKE '%Ozon-Z26220-BLZX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26221-CYJA%'
OR OS.OrderSourceName LIKE '%Ozon-Z26222-FRYM%'
OR OS.OrderSourceName LIKE '%Ozon-Z26223-GLYC%'
OR OS.OrderSourceName LIKE '%Ozon-Z26224-HYKL%'
OR OS.OrderSourceName LIKE '%Ozon-Z26225-JYPL%'
OR OS.OrderSourceName LIKE '%Ozon-Z26226-KRYN%'
OR OS.OrderSourceName LIKE '%Ozon-Z26227-MRYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26228-NYXT%'
OR OS.OrderSourceName LIKE '%Ozon-Z26229-PRYW%'
OR OS.OrderSourceName LIKE '%Ozon-Z26230-QLYF%'
OR OS.OrderSourceName LIKE '%Ozon-Z26207-QLYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26208-SRYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26209-TRYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26210-VYXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26211-WRYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26212-ZYXR%'
OR OS.OrderSourceName LIKE '%Ozon-Z26213-QWYN%'
OR OS.OrderSourceName LIKE '%Ozon-Z26214-ZYMP%'
OR OS.OrderSourceName LIKE '%Ozon-Z26215-VOXL%'
OR OS.OrderSourceName LIKE '%Ozon-Z26216-JYRS%'
OR OS.OrderSourceName LIKE '%Ozon-Z26217-KXLY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26218-FLYC%'
OR OS.OrderSourceName LIKE '%Ozon-Z26267-tetro%'
OR OS.OrderSourceName LIKE '%Ozon-Z26268-philory%'
OR OS.OrderSourceName LIKE '%Ozon-Z26269-cuspidion%'
OR OS.OrderSourceName LIKE '%Ozon-Z26270-ravency%'
OR OS.OrderSourceName LIKE '%Ozon-Z26271-noroon%'
OR OS.OrderSourceName LIKE '%Ozon-Z26272-uniten%'
OR OS.OrderSourceName LIKE '%Ozon-Z26279-WindR%'
OR OS.OrderSourceName LIKE '%Ozon-Z26280-SkyP%'
OR OS.OrderSourceName LIKE '%Ozon-Z26281-Rock%'
OR OS.OrderSourceName LIKE '%Ozon-Z26282-HillR%'
OR OS.OrderSourceName LIKE '%Ozon-Z26283-Cloud%'
OR OS.OrderSourceName LIKE '%Ozon-Z26284-Frost%'
OR OS.OrderSourceName LIKE '%Ozon-Z26285-Nova%'
OR OS.OrderSourceName LIKE '%Ozon-Z26286-Lite%'
OR OS.OrderSourceName LIKE '%Ozon-Z26287-SkyD%'
OR OS.OrderSourceName LIKE '%Ozon-Z26288-Vibe%'
OR OS.OrderSourceName LIKE '%Ozon-Z26289-Prime%'
OR OS.OrderSourceName LIKE '%Ozon-Z26290-Mega%'
OR OS.OrderSourceName LIKE '%Ozon-Z26291-Luvio%'
OR OS.OrderSourceName LIKE '%Ozon-Z26292-Nexin%'
OR OS.OrderSourceName LIKE '%Ozon-Z26293-Zevora%'
OR OS.OrderSourceName LIKE '%Ozon-Z26294-Mirolo%'
OR OS.OrderSourceName LIKE '%Ozon-Z26295-Vesaro%'
OR OS.OrderSourceName LIKE '%Ozon-Z26296-Elanor%'
OR OS.OrderSourceName LIKE '%Ozon-Z26297-AXQY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26298-VJZU%'
OR OS.OrderSourceName LIKE '%Ozon-Z26299-WYFK%'
OR OS.OrderSourceName LIKE '%Ozon-Z26300-ZXQO%'
OR OS.OrderSourceName LIKE '%Ozon-Z26301-KYVJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26302-QRYZ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26303-LYXW%'
OR OS.OrderSourceName LIKE '%Ozon-Z26304-MVXQ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26305-NYJK%'
OR OS.OrderSourceName LIKE '%Ozon-Z26307-RVZY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26306-PXYQ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26308-SXKJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26309-Luna%'
OR OS.OrderSourceName LIKE '%Ozon-Z26310-Vello%'
OR OS.OrderSourceName LIKE '%Ozon-Z26311-Mirol%'
OR OS.OrderSourceName LIKE '%Ozon-Z26312-Silva%'
OR OS.OrderSourceName LIKE '%Ozon-Z26313-Neva%'
OR OS.OrderSourceName LIKE '%Ozon-Z26314-Zorvi%'
OR OS.OrderSourceName LIKE '%Ozon-Z26315-Calen%'
OR OS.OrderSourceName LIKE '%Ozon-Z26316-Briel%'
OR OS.OrderSourceName LIKE '%Ozon-Z26317-Novel%'
OR OS.OrderSourceName LIKE '%Ozon-Z26318-Fiora%'
OR OS.OrderSourceName LIKE '%Ozon-Z26319-Kaeli%'
OR OS.OrderSourceName LIKE '%Ozon-Z26320-Sera%'
OR OS.OrderSourceName LIKE '%Ozon-Z26345-Auror%'
OR OS.OrderSourceName LIKE '%Ozon-Z26346-Celes%'
OR OS.OrderSourceName LIKE '%Ozon-Z26347-Valeri%'
OR OS.OrderSourceName LIKE '%Ozon-Z26348-Lunari%'
OR OS.OrderSourceName LIKE '%Ozon-Z26350-Elari%'
OR OS.OrderSourceName LIKE '%Ozon-Z26351-Novel%'
OR OS.OrderSourceName LIKE '%Ozon-Z26352-Veral%'
OR OS.OrderSourceName LIKE '%Ozon-Z26353-Aethe%'
OR OS.OrderSourceName LIKE '%Ozon-Z26354-Pures%'
OR OS.OrderSourceName LIKE '%Ozon-Z26355-Grayv%'
OR OS.OrderSourceName LIKE '%Ozon-Z26356-Clare%'
OR OS.OrderSourceName LIKE '%Ozon-Z26349-Mirab%'
OR OS.OrderSourceName LIKE '%Ozon-Z26321-Zonix%'
OR OS.OrderSourceName LIKE '%Ozon-Z26322-NexGen%'
OR OS.OrderSourceName LIKE '%Ozon-Z26323-Volta%'
OR OS.OrderSourceName LIKE '%Ozon-Z26324-Apex%'
OR OS.OrderSourceName LIKE '%Ozon-Z26325-Optix%'
OR OS.OrderSourceName LIKE '%Ozon-Z26326-Forge%'
OR OS.OrderSourceName LIKE '%Ozon-Z26327-Velos%'
OR OS.OrderSourceName LIKE '%Ozon-Z26328-Cirro%'
OR OS.OrderSourceName LIKE '%Ozon-Z26329-Lumen%'
OR OS.OrderSourceName LIKE '%Ozon-Z26330-Solis%'
OR OS.OrderSourceName LIKE '%Ozon-Z26331-Vivid%'
OR OS.OrderSourceName LIKE '%Ozon-Z26332-Zephy%'
OR OS.OrderSourceName LIKE '%Ozon-Z26333-Quark%'
OR OS.OrderSourceName LIKE '%Ozon-Z26334-Spark%'
OR OS.OrderSourceName LIKE '%Ozon-Z26335-Nexus%'
OR OS.OrderSourceName LIKE '%Ozon-Z26336-Pulse%'
OR OS.OrderSourceName LIKE '%Ozon-Z26337-Flux%'
OR OS.OrderSourceName LIKE '%Ozon-Z26338-Echo%'
OR OS.OrderSourceName LIKE '%Ozon-Z26339-TYQZ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26340-UVYW%'
OR OS.OrderSourceName LIKE '%Ozon-Z26341-VXZJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26342-WYQX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26343-XZVK%'
OR OS.OrderSourceName LIKE '%Ozon-Z26344-YJVX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26357-Flore%'
OR OS.OrderSourceName LIKE '%Ozon-Z26358-Soravi%'
OR OS.OrderSourceName LIKE '%Ozon-Z26359-Mavie%'
OR OS.OrderSourceName LIKE '%Ozon-Z26360-Jovie%'
OR OS.OrderSourceName LIKE '%Ozon-Z26361-Calen%'
OR OS.OrderSourceName LIKE '%Ozon-Z26362-Renov%'
OR OS.OrderSourceName LIKE '%Ozon-Z26363-Prime%'
OR OS.OrderSourceName LIKE '%Ozon-Z26364-Eclat%'
OR OS.OrderSourceName LIKE '%Ozon-Z26365-Arkha%'
OR OS.OrderSourceName LIKE '%Ozon-Z26366-Talor%'
OR OS.OrderSourceName LIKE '%Ozon-Z26367-Haven%'
OR OS.OrderSourceName LIKE '%Ozon-Z26368-Nobl%'
OR OS.OrderSourceName LIKE '%Ozon-Z26387-Velori%'
OR OS.OrderSourceName LIKE '%Ozon-Z26388-Lumer%'
OR OS.OrderSourceName LIKE '%Ozon-Z26389-Aurel%'
OR OS.OrderSourceName LIKE '%Ozon-Z26390-Seren%'
OR OS.OrderSourceName LIKE '%Ozon-Z26391-Novel%'
OR OS.OrderSourceName LIKE '%Ozon-Z26392-Elvan%'
OR OS.OrderSourceName LIKE '%Ozon-Z26393-Nord%'
OR OS.OrderSourceName LIKE '%Ozon-Z26394-Roya%'
OR OS.OrderSourceName LIKE '%Ozon-Z26395-Luxp%'
OR OS.OrderSourceName LIKE '%Ozon-Z26396-Elitu%'
OR OS.OrderSourceName LIKE '%Ozon-Z26397-Muse%'
OR OS.OrderSourceName LIKE '%Ozon-Z26369-ZKXV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26370-QVYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26371-KZVX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26372-JYXQ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26373-PYXJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26374-VQYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26375-BYXJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26376-CQYZ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26377-FZXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26378-GYXJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26379-HVXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26380-JWYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26381-KXQY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26382-LVYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26383-MXVY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26384-NXYQ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26385-PVXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26386-QVYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26399-Glow%'
OR OS.OrderSourceName LIKE '%Ozon-Z26400-Dawn%'
OR OS.OrderSourceName LIKE '%Ozon-Z26401-Silva%'
OR OS.OrderSourceName LIKE '%Ozon-Z26402-Calmo%'
OR OS.OrderSourceName LIKE '%Ozon-Z26403-Petra%'
OR OS.OrderSourceName LIKE '%Ozon-Z26404-Glob%'
OR OS.OrderSourceName LIKE '%Ozon-Z26405-Prim%'
OR OS.OrderSourceName LIKE '%Ozon-Z26406-Skyv%'
OR OS.OrderSourceName LIKE '%Ozon-Z26407-Everl%'
OR OS.OrderSourceName LIKE '%Ozon-Z26408-Eleno%'
OR OS.OrderSourceName LIKE '%Ozon-Z26409-Luxno%'
OR OS.OrderSourceName LIKE '%Ozon-Z26471-StarV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26472-RoyalP%'
OR OS.OrderSourceName LIKE '%Ozon-Z26473-Globa%'
OR OS.OrderSourceName LIKE '%Ozon-Z26474-PeakH%'
OR OS.OrderSourceName LIKE '%Ozon-Z26475-Noble%'
OR OS.OrderSourceName LIKE '%Ozon-Z26476-SkyF%'
OR OS.OrderSourceName LIKE '%Ozon-Z26477-Ocea%'
OR OS.OrderSourceName LIKE '%Ozon-Z26478-Elite%'
OR OS.OrderSourceName LIKE '%Ozon-Z26479-Grand%'
OR OS.OrderSourceName LIKE '%Ozon-Z26480-Vista%'
OR OS.OrderSourceName LIKE '%Ozon-Z26481-PureA%'
OR OS.OrderSourceName LIKE '%Ozon-Z26482-Prim%'
OR OS.OrderSourceName LIKE '%Ozon-Z26489-Outvi%'
OR OS.OrderSourceName LIKE '%Ozon-Z26490-Treko%'
OR OS.OrderSourceName LIKE '%Ozon-Z26491-Campl%'
OR OS.OrderSourceName LIKE '%Ozon-Z26492-Travo%'
OR OS.OrderSourceName LIKE '%Ozon-Z26493-Wind%'
OR OS.OrderSourceName LIKE '%Ozon-Z26494-Natu%'
OR OS.OrderSourceName LIKE '%Ozon-Z26495-Firsk%'
OR OS.OrderSourceName LIKE '%Ozon-Z26496-Vent%'
OR OS.OrderSourceName LIKE '%Ozon-Z26497-Sylva%'
OR OS.OrderSourceName LIKE '%Ozon-Z26498-Clim%'
OR OS.OrderSourceName LIKE '%Ozon-Z26499-Shor%'
OR OS.OrderSourceName LIKE '%Ozon-Z26500-bree%'
OR OS.OrderSourceName LIKE '%Ozon-Z26429-RXYK%'
OR OS.OrderSourceName LIKE '%Ozon-Z26430-SXVY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26431-TVXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26432-UVYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26433-VXQY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26434-WXYK%'
OR OS.OrderSourceName LIKE '%Ozon-Z26435-XVYJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26436-YXVQ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26437-ZVYJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26438-QYXJ%'
OR OS.OrderSourceName LIKE '%Ozon-Z26439-JVXY%'
OR OS.OrderSourceName LIKE '%Ozon-Z26440-AQYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26441-BXYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26442-CVYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26443-DXYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26444-EYVX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26445-FVYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26446-GYVX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26447-HXYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26448-IYVX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26449-JVYX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26450-KXYV%'
OR OS.OrderSourceName LIKE '%Ozon-Z26451-LYVX%'
OR OS.OrderSourceName LIKE '%Ozon-Z26452-MXYV%' )) AS PagerTable

SELECT COUNT(1) FROM ( SELECT                                       OS.*, EC.Country_cn,                                          CASE                                               WHEN OS.AddTime >= DATEADD(MONTH,-3,GETDATE()) THEN '新'                                              ELSE '旧'                                          END NewOldSign,                                       API.IsActive AS APIIsActive,                                          EabyAPI.IsActive AS APIIsActiveNew,                                       EMAIL.IsActive AS EmailSetIsActive,                                       ADS.IsActive AS ReturnAddressIsActive,                                       HOUSE.WareHouseName,                                       BT.BusinessTeamName,                                       API.MerchantToken,                                          dp.DepartmentName AS DepartmentName,                                          (CPM.Name+'-'+CPM.CorporateNameCN)   AS  NameCorporateNameCN,                                          ADA.IsActive as AmazonAdertismentIsActive,                                          RBA.UserName,                                          API.CertIDAccessKeyId,                                          EabyAPI.CertIDAccessKeyId AS CertIDAccessKeyIdNew,                                          API.ServerUrl,                                          API.TokenDeadline,                                          API.EUBAPIPassword,                                          LTPE.AuthAddtime,                                          case when LTPE.AuthAddtime is null and API.TokenDeadline is null THEN 0                                          else 1 end as TokenLineStatus                                       FROM                                       RB_OrderSource OS with(nolock)                                      LEFT JOIN E_Country EC                                           ON EC.Shorthand = OS.OrderSourceCountry                                      LEFT JOIN RB_Admin RBA                                           ON RBA.CustomerID = OS.CustomerID AND RBA.ID = OS.SaleAdminID                                      LEFT JOIN RB_BusinessTeam BT                                           ON BT.CustomerID = OS.CustomerID AND BT.ID = RBA.BusinessTeamID                                      LEFT JOIN RB_Admin RBAS                                           ON RBAS.CustomerID = OS.CustomerID AND RBAS.ID = OS.ServiceAdminID                                      LEFT JOIN RB_Department dp                                          ON dp.CustomerID = RBAS.CustomerID AND dp.ID = RBAS.DepartmentID                                       LEFT JOIN RB_OrderSource_EbayAmazonAPI API                                           ON API.CustomerID = OS.CustomerID AND API.OrderSourceID = OS.ID                                      LEFT JOIN RB_OrderSource_EmailSet EMAIL                                           ON EMAIL.CustomerID = OS.CustomerID AND EMAIL.OrderSourceID = OS.ID                                      LEFT JOIN RB_OrderSource_ReturnAddress ADS                                           ON ADS.CustomerID = OS.CustomerID AND ADS.OrderSourceID = OS.ID                                      LEFT JOIN RB_WareHouse HOUSE                                           ON HOUSE.CustomerID = OS.CustomerID AND HOUSE.ID = OS.DefaultWareHouseID                                      LEFT JOIN RB_CustomsPeopleManage CPM                                           ON CPM.CustomerID = OS.CustomerID AND CPM.ID = OS.CustomsPeopleManageID                                      LEFT JOIN RB_Amazon_AdvertisementAuthorization ADA                                          ON ADA.CustomerID = OS.CustomerID and ADA.OrderSourceID = OS.ID                                      LEFT JOIN RB_OrderSource_API  as EabyAPI                                          ON EabyAPI.CustomerID = OS.CustomerID                                           and EabyAPI.OrderSourceID = OS.ID                                      LEFT JOIN RB_OrderSource_FinancialExt  as FIN                                          ON FIN.CustomerID = OS.CustomerID                                           and FIN.OrderSourceID = OS.ID                                      LEFT JOIN RB_Amazon_AdvertisementAuthorization  as CPC                                          ON CPC.CustomerID = OS.CustomerID                                           and CPC.OrderSourceID = OS.ID                                      left join (select LogType,max(Addtime) AuthAddtime from RB_OrderSource_Log where 1=1  and LogTableName = 'RB_OrderSource_EbayAmazonAPI' and LogType != 'undefined'                        GROUP BY LogType) LTPE on LTPE.LogType = OS.ID                                                                                                                    WHERE                                       OS.CustomerID = 1 AND ISNULL(OS.IsDelete,0)=0                                        AND OS.IsActive=1  AND (  OS.OrderSourceName LIKE '%Ozon-Z26140-QWYN%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26141-VYLK%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26142-JAXO%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26143-ZYNE%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26144-KRYZ%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26145-VOXE%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26146-XYPH%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26147-GLOW%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26148-FRYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26149-BLYN%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26150-CYXA%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26151-TRYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26152-WYVE%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26153-JYXE%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26154-KLOQ%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26155-ZAVY%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26156-NYXI%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26157-PYRI%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26158-QXOR%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26159-VYJU%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26160-ZYWA%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26161-KLYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26162-JORV%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26163-FEXY%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26166-CRYN%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26167-PLYV%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26168-BROX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26169-DRYV%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26170-FLYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26171-GLYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26172-QWER%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26173-ZYLV%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26174-VEXY%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26175-JYTH%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26176-KRYP%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26177-FLYV%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26178-GRYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26179-BLYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26180-CYZO%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26181-DRYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26182-FRYV%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26183-GLYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26184-HYXP%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26185-JYXV%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26186-KLYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26187-MRYX%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26188-NYXO%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26189-PRYF%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26189-biblab%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26190-audience%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26191-patientive%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26192-skilluous%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26193-unihood%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26194-roleling%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26195-fightular%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26196-tostfication%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26197-describe%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26198-ornithoeast%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26199-bullietic%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26200-airivity%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26201-syattack%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26202-futilesque%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26203-claimety%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26204-omation%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26205-quiteor%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26206-vivatory%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26231-pinness%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26232-plaint%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26233-palinsion%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26234-hotelier%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26235-drivesive%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26236-holdarian%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26237-keysome%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26238-raceaire%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26239-crimeular%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26240-wouldic%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26241-thustion%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26242-hotfic%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26243-partyress%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26244-seiee%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26245-pteryair%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26246-whomous%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26247-claustro%'  OR  OS.OrderSourceName LIKE '%Ozon-Z26248-hormer%'&nbs

验收标准
价值描述
10000
历史记录  
  1. 2026-06-03 21:58:47, 由 黄凤 Bug转化而来，Bug编号为 63521 。
  2. 2026-06-03 21:59:06, 由 黄凤 编辑。
    修改了 所属计划，旧值为 ""，新值为 "2643"。
    修改了 所处阶段，旧值为 "wait"，新值为 "planned"。
  3. 2026-06-04 13:57:59, 由 张明磊 编辑。
    修改了 预计工时，旧值为 "8"，新值为 "4"。
    修改了 成本 ，旧值为 "4000"，新值为 "2000"。
    修改了 ROI ，旧值为 "15.00"，新值为 "30.00"。
  4. 2026-06-04 14:00:04, 由 张明磊 记录评审结果，结果为 确认通过。
  5. 2026-06-04 14:01:10, 由 周杰 关联到迭代 主干_6月V3版本_20260616 。
  6. 2026-06-05 15:23:52, 由 周杰 编辑。
    修改了 计划验收时间，旧值为 "0000-00-00"，新值为 "2026-06-19"。
  7. 2026-06-05 15:52:34, 由 曾倩 编辑。
    修改了 测试人员，旧值为 ""，新值为 "zengqian"。
  8. 2026-06-15 13:49:13, 由 周杰 编辑。
    修改了 所处阶段 ，旧值为 "tested"，新值为 "bepending"。
    修改了 设置阶段者，旧值为 ""，新值为 "zhoujie"。
  9. 2026-06-23 10:07:11, 由 周杰 关闭，原因为 已完成 。
    修改了 由谁关闭，旧值为 ""，新值为 "zhoujie"。
    修改了 关闭日期，旧值为 "0000-00-00 00:00:00"，新值为 "2026-06-23 10:07:10"。
    修改了 指派给 ，旧值为 "zhangminglei"，新值为 "closed"。
    修改了 当前状态，旧值为 "active"，新值为 "closed"。
    修改了 所处阶段，旧值为 "bepending"，新值为 "closed"。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
返回
迭代版本
提报业务部门 技术研发中心
提报人员 黄凤
需求来源 bug转需求
所属项目 技术中心-需求池
所属模块 财务   客户订单
所属计划
业务价值
开发组 财务开发组
受益业务部门 技术研发中心
验收人员 许瑞丰
业务目标类型
中心业务目标
业务价值 控制风险
每月价值量 10000
每月节省人数 0
优先级 P2
价值类型 长期价值
预计工时 4
成本 2000
ROI 30.00
操作手册 否
高价值 -
主被动 被动接收
复杂度 一般性
工作流ID
工作流创建时间 0000-00-00 00:00:00
更新点
是否高危 否
评分
当前状态 已关闭
所处阶段 已关闭
关键词
评审次数 一次
计划上线 0000-00-00
上线时间 2026-06-16
计划验收时间 2026-06-19
业务验收时间
满意度
价值验收
满意度分值
业务回填价值
验收达成价值
验收达成ROI
抄送给 袁慧斌  
由谁创建 黄凤 于 2026-06-03 21:58:47
指派给 Closed 于 2026-06-23 10:07:10
由谁评审 张明磊
评审时间 2026-06-04
由谁关闭 周杰 于 2026-06-23 10:07:10
关闭原因 已完成
最后修改 周杰 于 2026-06-23 10:07:10
来源Bug
相关Bug
相关用例
相关需求
细分需求