重现步骤

[步骤]

未添加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

历史记录  
  1. 2026-05-26 15:34:21, 由 袁慧斌 创建。
  2. 2026-05-26 15:34:47, 由 李乐同 指派给 何建宝。
    修改了 指派给，旧值为 "liletong"，新值为 "hejianbao"。
  3. 2026-05-26 15:39:26, 由 何建宝 指派给 李乐同。
    修改了 指派给，旧值为 "hejianbao"，新值为 "liletong"。
    来源渠道表查询的业务是程伟那边的
  4. 2026-05-26 15:39:56, 由 李乐同 指派给 程伟。
    修改了 指派给，旧值为 "liletong"，新值为 "chengwei"。
  5. 2026-05-26 17:02:37, 由 程伟 指派给 张明磊。
    修改了 指派给，旧值为 "chengwei"，新值为 "zhangminglei"。
    看下是不是来源渠道管理页面 
  6. 2026-05-26 21:58:32, 由 张明磊 解决，方案为 产品需求缺陷 。
    修改了 解决方案，旧值为 ""，新值为 "bypuduct"。
    修改了 解决日期，旧值为 ""，新值为 "2026-05-26 21:57:50"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "zhangminglei"。
    页面查询，需要实时性，可能得优化下批量查询数量
  7. 2026-05-27 09:54:11, 由 张明磊 指派给 黄凤。
    修改了 指派给，旧值为 "zhangminglei"，新值为 "huangfeng"。
  8. 2026-05-27 09:56:05, 由 张明磊 编辑。
    修改了 解决时效，旧值为 "0"，新值为 "6.39"。
    修改了 重现步骤，区别为：
    005-
    005+ 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
    006- 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
    005- <p></p>
    005+ <p>SELECT COUNT(1) FROM ( SELECT OS.*, EC.Country_cn, CASE WHEN OS.AddTime &gt;= 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%'&amp;nbs</p>
    006- <p>SELECT COUNT(1) FROM ( SELECT OS.*, EC.Country_cn, CASE WHEN OS.AddTime &gt;= 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
    有模糊查询先把订单的id找出来再过滤，页面查询暂不用nolock
  9. 2026-05-28 15:49:55, 由 曾倩 编辑。
    修改了 测试责任人，旧值为 ""，新值为 "yuanhuibin"。
  10. 2026-05-28 15:50:44, 由 曾倩 编辑。
    修改了 上线时间，旧值为 "0000-00-00 00:00:00"，新值为 "2026-05-27 09:00"。
    修改了 上线时效，旧值为 "-1"，新值为 "17.43"。
  11. 2026-05-28 15:50:47, 由 曾倩 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "huangfeng"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "zengqian"。
    修改了 关闭日期，旧值为 ""，新值为 "2026-05-28 15:50:47"。
  12. 2026-06-03 21:50:00, 由 张明磊 指派给 黄凤。
    修改了 指派给，旧值为 "closed"，新值为 "huangfeng"。
  13. 2026-06-03 21:56:38, 由 黄凤 激活。
    修改了 Bug状态 ，旧值为 "closed"，新值为 "active"。
    修改了 激活日期，旧值为 ""，新值为 "2026-06-03 21:56:38"。
    修改了 激活次数，旧值为 "0"，新值为 "1"。
    修改了 解决方案，旧值为 "bypuduct"，新值为 ""。
    修改了 解决日期，旧值为 "2026-05-26 21:57:50"，新值为 "0000-00-00"。
    修改了 解决者 ，旧值为 "zhangminglei"，新值为 ""。
    修改了 由谁关闭，旧值为 "zengqian"，新值为 ""。
    修改了 关闭日期，旧值为 "2026-05-28 15:50:47"，新值为 "0000-00-00"。
  14. 2026-06-03 21:58:47, 由 黄凤 转为 需求，编号为 #35722 OMS：性能优化-erp 渠道相关查询 。
  15. 2026-06-03 21:58:47, 由 黄凤 关闭。
返回
所属项目 技术中心-需求池
所属模块 供应链   产品采购   产品库
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门 技术研发中心
影响功能
开发责任人 张明磊
测试责任人 袁慧斌
解决时效 6.39
激活次数 1
激活日期 2026-06-03 21:56:38
是否确认 是
当前指派 Closed 于 2026-06-03 21:58:47
截止日期 0000-00-00
上线时间 2026-05-27 09:00:00
上线时效 17.43
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2026-05-26 15:34:21
影响环境 生产环境-业务反馈
由谁解决 黄凤 于 2026-06-03 21:58:47
解决版本
解决方案 tostory
由谁关闭 黄凤 于 2026-06-03 21:58:47
最后修改 黄凤 于 2026-06-03 21:56:38