[步骤]
exec sp_executesql N'SELECT DISTINCT [a].[Id] AS [OrderSourceId] , [a].[OrderSourceName] AS [OrderSourceName] , [a].[OrderSourceCountry] AS [OrderSourceCountry] , [b].[DevIDSellerId] AS [DevIDSellerId] , [b].[AppIDMarketplaceId] AS [AppIDMarketplaceId] , [a].[IsActive] AS [IsActive] , [a].[SaleAdminID] AS [SaleAdminID] , [a].[RealShopName] AS [RealShopName] , [a].[AddTime] AS [AddTime] FROM [RB_OrderSource] [a] WITH(NOLOCK) Inner JOIN [RB_OrderSource_EbayAmazonAPI] [b] WITH(NOLOCK) ON (((((((((( [a].[CustomerID] = [b].[CustomerID] ) AND ( [a].[Id] = [b].[OrderSourceID] )) AND ( [a].[IsActive]=1 ) ) AND ( [b].[IsActive]=1 ) ) AND (ISNULL([a].[ChannelPlatformStatus],@MethodConst0) = @Const1 )) AND ([a].[Id] IN (5516,5517,5614,5615,6397,6398,6448,6449,6459,6460,6461,6462,6463,6648,6649,6650,6651,6694,6695,6958,7196,8124,8493,9578,10275,10276,10388,10929,10937,10941,10942,10944,10945,10946,10947,10948,11008,11059,11192,11375,11376,11377,11378,11379,11380,11592,11664,12573,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,13606,13607,13608,13873,13874,13875,13876,14476,14477,14478,14479,14712,14888,15326,15327,15328,15329,15330,15331,15332,15333,15334,15335,15336,15337,15338,15339,15340,15384,15528,15529,15530,15531,15532,15533,15534,15535,15536,15537,15538,15539,15592,15593,15594,15595,15597,15605,15606,15607,15608,15609,15610,15611,15612,15613,15614,15615,15616,15617,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16231,16354,16355,16399,16457,16487,16488,16489,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16615,16616,16617,16618,16619,16620,16621,16622,16623,16624,16625,16626,16627,16628,16696,16697,16698,16699,16700,16701,16702,16703,16704,16705,16706,16707,16708,16709,16797,16800,16802,16803,16804,16805,16806,16807,16808,16809,16810,16811,16812,16813,16814,16815,16816,16817,16818,16819,16820,16821,16822,16823,16824,16825,16826,16827,16828,16852,16853,16854,16855,16856,16857,16858,16859,16860,16861,16862,16863,16864,16865,16866,16867,16868,16869,16870,16871,16872,16873,16874,16875,16876,16877,16878,16879,16894,16895,16896,16897,16898,16899,16900,16901,16902,16903,16904,16905,16906,16907,16908,16909,16910,16911,16912,16913,16914,16915,16916,16917,16918,16919,16920,16944,16945,16946,16949,16950,16951,16952,16953,16954,16955,16956,16957,16958,16959,16960,16961,16962,16984,16985,16986,16987,16988,16989,16990,16991,16992,16993,16994,16995,16996,16997,16998,16999,17000,17001,17002,17003,17004,17005,17006,17007,17008,17009,17010,17011,17012,17013,17014,17015,17016,17017,17018,17019,17020,17021,17022,17023,17024,17025,17027,17028,17029,17030,17031,17032,17033,17034,17035,17036,17037,17038,17039,17040,17041,17042,17043,17044,17045,17046,17047,17048,17049,17050,17051,17052,17053,17054,17055,17056,17057,17058,17059,17060,17061,17062,17063,17064,17065,17066,17067,17082,17083,17084,17085,17086,17087,17088,17089,17090,17091,17092,17093,17094,17095,17115,17116,17117,17118,17119,17120,17121,17122,17123,17124,17125,17126,17127,17128,17135,17136,17137,17138,17139,17140,17141,17142,17143,17144,17145,17146,17147,17148,17162,17163,17164,17165,17166,17167,17168,17169,17170,17171,17172,17173,17174,17175,17196,17200,17201,17202,17230,17231,17232,17233,17234,17235,17236,17237,17238,17239,17240,17241,17242,17243,17244,17246,17247,17250,17281,17288,17367,17368,17369,17370,17371,17372,17373,17374,17375,17376,17377,17378,17379,17380,17401,17410,17413,17415,17416,17417,17418,17419,17420,17421,17422,17423,17424,17425,17426,17427,17428,17429,17431,17432,17433,17434,17435,17436,17437,17438,17439,17440,17441,17442,17443,17444,17446,17447,17448,17449,17450,17451,17452,17453,17454,17455,17456,17457,17458,17459,17468,17495,17499,17500,17501,17502,17504,17506,17513,17531,17532,17533,17534,17535,17536,17537,17538,17539,17540,17541,17542,17543,17544,17566,17567,17568,17570,17571,17572,17573,17574,17575,17576,17577,17578,17579,17580,17581,17582,17583,17584,17585,17586,17587,17588,17641,17642,17643,17644,17645,17646,17647,17648,17649,17650,17651,17652,17653,17654,17679,17680,17681,17756,17757,17759,17763,17764,17765,17766,17767,17768,17769,17770,17771,17772,17773,17774,17775,17776,17847,17848,17849,17850,17851,17852,17853,17854,17855,17856,17857,17858,17859,17860,17861,17862,17863,17864,17865,17866,17867,17868,17869,17870,17871,17872,17873,17874,17877,17923,17927,17928,17929,17930,17931,17932,17933,17934,17935,17936,17937,17938,17939,17940,17941,17942,17968,17969,17980,18005,18006,18007,18037,18091,18111,18125,18200,18201,18202,18209,18210,18211,18212,18213,18214,18215,18216,18217,18218,18219,18220,18221,18222,18240,18241,18242,18243,18244,18245,18246,18247,18248,18249,18250,18251,18252,18253,18319,18320,18321,18322,18323,18324,18325,18326,18327,18328,18329,18330,18331,18332,18374,18375,18376,18377,18378,18379,18380,18381,18382,18383,18384,18385,18386,18387,18496,18497,18498,18500,18501,18502,18503,18504,18505,18506,18507,18508,18509,18510,18511,18512,18513,19014,19015,19016,19017,19018,19019,19020,19021,19022,19023,19024,19025,19026,19027,19179,19180,19181,19182,19183,19221,19227,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19328,19329,19330,19331,19332,19333,19334,19335,19336,19337,19338,19339,19340,19341,19356,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19451,19452,19453,19454,19455,19456,19457,19458,19459,19460,19461,19462,19463,19464,19481,19482,19483,19484,19485,19486,19487,19488,19489,19490,19491,19492,19493,19494,19548,19549,19550,19561,19562,19563,19564,19565,19566,19567,19568,19569,19570,19571,19572,19573,19574,19575,19618,19619,19620,19621,19622,19738,19787,19788,19789,19790,19791,19792,19793,19794,19795,19796,19797,19798,19799,19800,19887,19888,19889,19897,19916,20001,20012,20013,20016,20019,20024,20027,20039,20041,20043,20044,20216,20217,20232,20233,20234,20235,20236,20237,20238,20239,20240,20241,20242,20243,20244,20245,20299,20300,20301,20302,20303,20304,20305,20306,20307,20308,20309,20310,20311,20312,20313,20314,20315,20316,20336,20337,20338,20339,20340,20351,20352,20353,20354,20535,20544,20628,20629,20630,20631,20632,20633,20634,20635,20636,20637,20638,20639,20640,20641,20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20712,20713,20714,20715,20716,20717,20718,20719,20720,20721,20722,20723,20724,20725,20726,20727,20728,20729,20750,20770,20771,20772,20773,20774,20775,20776,20777,20778,20779,20780,20781,20783,20789,20790,20791,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20804,20805,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20923,20962,20963,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21058,21067,21309,21310,21311,21312,21313,21314,21315,21316,21317,21318,21319,21320,21321,21322,21326,21327,21328,21329,21330,21331,21332,21333,21334,21335,21336,21337,21338,21339,21390,21391,21393,21394,21402,21403,21415,21416,21417,21418,21419,21420,21421,21422,21423,21424,21425,21426,21427,21428,21501,21612,21613,21614,21624,21625,21627,21628,21629,21639,21640,21723,21886,21887,21888,21889,21891,21892,21893,21894,21895,21896,21897,21898,21899,21947,21948,21949,21950,21951,21952,21953,21954,21955,21956,21957,21958,21959,21960,21966,21967,21968,21969,21970,21971,21972,21973,21974,21975,21976,21977,21978,21979,21980,21981,21982,21983,21984,21985,21986,21987,21988,21989,21990,21991,21992,21993,22090,22092,22093,22094,22095,22096,22097,22098,22099,22100,22101,22102,22103,22104,22105,22112,22113,22114,22124,22125,22162,22163,22164,22165,22166,22167,22168,22169,22170,22171,22172,22173,22174,22175,22176,22177,22178,22179,22180,22181,22182,22183,22184,22185,22186,22187,22188,22189,22190,22191,22192,22193,22194,22195,22196,22197,22198,22199,22200,22278,22279,22280,22290,22291,22292,22293,22294,22295,22296,22297,22298,22299,22300,22301,22302,22303,22304,22305,22383,22384,22385,22386,22387,22388,22389,22390,22391,22392,22393,22394,22395,22396,22415,22416,22417,22418,22419,22420,22421,22422,22423,22424,22425,22426,22428,22452,22453,22454,22455,22456,22457,22458,22459,22460,22461,22462,22463,22464,22465,22477,22478,22479,22480,22481,22482,22483,22484,22485,22486,22487,22488,22490,22507,22508,22530,22531,22532,22533,22534,22535,22536,22537,22538,22539,22540,22541,22542,22546,22547,22548,22549,22550,22551,22552,22553,22554,22555,22556,22557,22568,22598,22599,22600,22610,22611,22624,22625,22678,22679,22680,22690,22691,22700,22701,22714,22716,22717,22719,22731,22750,22752,22753,22778,22779,22780,22781,22782,22783,22784,22785,22786,22787,22941,23006,23007,23008,23009,23010,23011,23012,23013,23014,23015,23016,23017,23018,23019,23058,23059,23060,23070,23071,23089,23090,23091,23092,23093,23094,23095,23096,23097,23098,23099,23100,23101,23102,23125,23126,23128,23187,23241,23242,23243,23253,23254,23330,23331,23332,23333,23334,23335,23336,23337,23338,23339,23340,23341,23342,23343,23344,23345,23346,23347,23348,23349,23350,23351,23352,23353,23354,23355,23356,23357,23374,23375,23376,23386,23387,23388,23389,23390,23400,23401,23409,23410,23411,23421,23422,23536,23537,23538,23539,23540,23541,23542,23543,23544,23545,23546,23547,23548,23549,23550,23551,23552,23553,23554,23555,23556,23557,23558,23559,23560,23561,23562,23563,23589,23641,23642,23643,23653,23654,23711,23712,23713,23714,23727,23728,23729,23739,23740,23854,23856,23858,23874,23875,23876,23877,23878,23879,23880,23881,23882,23883,23884,23885,23886,23887,23950,23951,23952,23962,23963,24007,24008,24009,24010,24011,24012,24013,24014,24015,24016,24017,24018,24019,24020,24022,24023,24024,24025,24026,24027,24028,24029,24030,24031,24032,24033,24034,24035,24072,24073,24074,24075,24085,24086,24087,24088,24089,24099,24100,24101,24102,24103,24113,24114,24115,24116,24117,24127,24128,24129,24130,24131,24132,24133,24134,24135,24136,24137,24138,24139,24140,24141,24142,24150,24151,24152,24153,24154,24155,24156,24157,24158,24159,24160,24161,24162,24163,24191,24192,24193,24194,24195,24196,24197,24198,24199,24200,24201,24202,24203,24204,24205,24206,24207,24208,24209,24210,24211,24212,24213,24214,24215,24216,24217,24218,24219,24220,24221,24222,24223,24224,24225,24226,24227,24228,24229,24230,24231,24232,24269,24289,24290,24291,24292,24293,24294,24295,24296,24297,24298,24299,24300,24301,24302,24303,24304,24305,24306,24307,24308,24309,24310,24311,24312,24313,24314,24315,24316,24319,24320,24321,24322,24323,24324,24325,24326,24327,24328,24329,24330,24331,24332,24338,24339,24340,24341,24342,24343,24344,24345,24346,24347,24348,24349,24350,24351,24353,24354,24355,24356,24357,24358,24359,24360,24361,24362,24363,24364,24365,24366,24380,24381,24385,24386,24387,24388,24389,24390,24391,24392,24393,24394,24395,24411,24412,24413,24414,24415,24416,24417,24418,24419,24420,24421,24422,24423,24424,24504,24505,24506,24507,24508,24509,24510,24511,24512,24513,24514,24515,24516,24517,24531,24532,24533,24534,24535,24536,24537,24538,24539,24540,24541,24542,24543,24544,24545,24546,24547,24548,24549,24550,24551,24552,24553,24554,24555,24556,24558,24635,24636,24637,24638,24639,24640,24641,24642,24643,24644,24645,24646,24647,24648,24692,24693,24694,24695,24696,24697,24698,24699,24700,24701,24702,24703,24704,24705,24706,24707,24708,24709,24710,24711,24712,24713,24714,24715,24716,24717,24718,24719,24724,24725,24726,24727,24728,24729,24730,24731,24732,24733,24734,24735,24736,24737,24738,24739,24740,24741,24742,24743,24744,24745,24746,24747,24748,24749,24750,24751,24755,24756,24757,24758,24759,24760,24761,24762,24763,24764,24765,24766,24767,24768,24797,24798,24799,24800,24801,24802,24803,24804,24805,24806,24807,24808,24809,24810,24811,24812,24813,24814,24815,24816,24817,24818,24819,24820,24821,24822,24823,24824,24825,24826,24827,24828,24830,24831,24832,24833,24834,24835,24836,24837,24838,24839,24840,24841,24842,24843,24844,24845,24846,24847,24848,24849,24850,24851,24852,24853,24854,24855,24856,24857,24858,24859,24860,24861,24862,24863,24864,24865,24866,24867,24876,24877,24878,24879,24880,24881,24882,24883,24884,24885,24886,24887,24888,24889,24953,24954,24955,24956,24957,24958,24959,24960,24961,24962,24963,24964,24965,25015,25016,25017,25018,25019,25020,25021,25022,25023,25024,25025,25026,25027,25028,25125,25126,25127,25137,25138,25140,25141,25142,25143,25144,25145,25146,25147,25148,25149,25150,25151,25152,25153,25155,25156,25157,25158,25159,25160,25161,25162,25163,25164,25165,25166,25167,25168,25169,25170,25171,25172,25173,25174,25175,25176,25177,25178,25179,25180,25181,25182,25183,25184,25185,25186,25187,25188,25189,25190,25191,25192,25193,25194,25195,25196,25212,25213,25214,25215,25216,25217,25218,25219,25220,25221,25222,25223,25224,25225,25254,25255,25256,25257,25258,25259,25260,25261,25262,25263,25264,25265,25266,25267,25282,25283,25284,25285,25286,25287,25288,25289,25290,25291,25292,25293,25294,25295,25297,25299,25314,25315,25316,25317,25318,25319,25320,25321,25322,25323,25324,25325,25326,25327,25342,25343,25344,25345,25346,25347,25348,25349,25350,25351,25352,25353,25354,25355,25356,25357,25358,25359,25360,25361,25362,25363,25364,25365,25366,25367,25368,25369,25370,25371,25372,25373,25374,25375,25376,25377,25378,25379,25380,25381,25382,25383,25384,25385,25386,25387,25388,25389,25390,25391,25392,25393,25394,25395,25396,25397,25398,25399,25400,25401,25402,25403,25404,25405,25406,25407,25408,25409,25410,25411,25415,25416,25417,25418,25419,25420,25421,25422,25423,25424,25425,25427,25428,25429,25430,25431,25432,25433,25434,25435,25436,25437,25438,25439,25440,25441,25442,25443,25444,25445,25446,25447,25448,25449,25450,25451,25452,25453,25454,25455,25456,25457,25458,25459,25460,25461,25462,25463,25464,25465,25466,25467,25468,25484,25485,25486,25487,25488,25489,25490,25491,25492,25493,25494,25495,25496,25497,25515,25516,25517,25518,25519,25520,25521,25522,25523,25524,25525,25526,25527,25528,25578,25579,25580,25581,25582,25583,25584,25585,25586,25587,25588,25589,25591,25732,25733,25734,25735,25736,25737,25738,25739,25740,25741,25742,25743,25744,25745,25854,25855,25856,25857,25858,25859,25860,25861,25862,25863,25864,25865,25866,25867,25896,25975,25976,25977,25978,25979,25980,25981,25982,25983,25984,25985,25986,25987,25988,25993,25994,25995,25996,25997,25998,25999,26000,26001,26002,26003,26004,26005,26006,26183,26184,26185,26186,26187,26188,26189,26190,26191,26192,26193,26194,26196,26303,26304,26305,26306,26307,26308,26309,26310,26311,26312,26313,26378,26379,26380,26381,26382,26383,26384,26385,26386,26387,26388,26389,26390,26391,26424,26425,26426,26427,26428,26429,26430,26431,26432,26433,26434,26435,26436,26437,26667,26668,26669,26670,26671,26672,26673,26674,26675,26676,26677,26678,26679,26680,26746,26747,26748,26749,26750,26751,26752,26753,26754,26755,26756,26757,26758,26759,27149,27551,27552,27553,27554,27555,27556,27557,27558,27559,27560,27561,27562,27563,27564,27765,27766,27767,27768,27769,27770,27771,27772,27773,27774,27775,27776,27777,27778,27914,27915,27916,27917,27918,27919,27920,27921,27922,27923,27924,27925,27927,27928,27950,27951,27952,27953,27954,27956,27957,27958,27959,27960,27961,27962,27963,27964,27965,27966,27967,27968,27969,27971,27972,27973,27974,27975,27976,27977,27978,27979,28012,28013,28014,28015,28016,28017,28018,28019,28020,28021,28022,28023,28025,28026,28027,28028,28029,28030,28031,28033,28034,28035,28036,28037,28038,28039,28040,28041,28196,28197,28198,28199,28200,28202,28203,28204,28205,28206,28207,28208,28209,28210,28211,28212,28213,28214,28215,28217,28218,28219,28220,28221,28222,28223,28224,28225,28226,28227,28228,28229,28230,28232,28233,28234,28235,28236,28237,28238,28239,28240,28242,28243,28244,28245,28246,28247,28248,28249,28250,28251,28252,28253,28255,28256,28257,28258,28259,28260,28261,28262,28263,28264,28265,28266,28267,28268,28270,28271,28273,28274,28275,28276,28277,28279,28280,28281,28282,28283,28284,28285,28286,28287,28291,28292,28293,28294,28295,28297,28298,28299,28300,28301,28302,28303,28304,28305,28321,28322,28323,28324,28325,28327,28328,28329,28330,28331,28332,28333,28334,28335,28336,28337,28338,28339,28340,28341,28342,28343,28344,28345,28346,28347,28349,28350,28351,28352,28353,28354,28355,28357,28358,28359,28360,28361,28362,28363,28364,28365,28366,28367,28368,28369,28370,28371,28372,28373,28374,28375,28376,28377,28379,28380,28381,28382,28383,28384,28385,28387,28388,28389,28390,28391,28392,28393,28394,28395,28427,28428,28429,28430,28431,28433,28434,28435,28436,28437,28438,28439,28440,28441,28442,28443,28444,28445,28446,28448,28449,28450,28451,28452,28453,28454,28455,28456,28457,28458,28459,28460,28461,28463,28464,28465,28466,28467,28468,28469,28470,28471,28472,28473,28474,28475,28476,28478,28479,28480,28481,28482,28483,28484,28485,28486,28487,28488,28489,28490,28491,28493,28494,28495,28496,28497,28498,28499,28500,28501,28502,28503,28504,28505,28506,28508,28509,28510,28511,28512,28513,28514,28515,28516,28532,28533,28534,28535,28536,28538,28539,28540,28541,28542,28543,28544,28545,28546,28547,28548,28549,28550,28551,28553,28554,28555,28556,28557,28558,28559,28560,28561,28562,28563,28564,28565,28566,28568,28569,28570,28571,28572,28573,28574,28575,28576,28577,28578,28579,28580,28581,28582,28583,28584,28585,28586,28587,28588,28590,28591,28595,28596,28597,28598,28599,28601,28602,28603,28604,28605,28606,28607,28608,28609,28610,28611,28612,28613,28614,28616,28617,28618,28619,28620,28621,28622,28623,28624,28666,28667,28668,28669,28670,28672,28673,28674,28675,28676,28677,28678,28679,28680,28684,28685,28686,28687,28688,28690,28691,28692,28693,28694,28695,28696,28697,28698,28699,28700,28701,28702,28703,28705,28706,28707,28708,28709,28710,28711,28712,28713,28729,28730,28731,28732,28733,28735,28736,28737,28738,28739,28740,28741,28742,28743,28763,28764,28765,28766,28767,28769,28770,28771,28772,28773,28774,28775,28776,28777,28795,28796,28797,28798,28799,28801,28802,28803,28804,28805,28806,28807,28808,28809,28829,28830,28831,28832,28833,28835,28836,28837,28838,28839,28840,28841,28842,28843,28850,28851,28852,28853,28854,28856,28857,28858,28859,28860,28861,28862,28863,28864,28881,28882,28883,28884,28885,28887,28888,28889,28890,28891,28892,28893,28894,28895,28898,28899,28900,28901,28902,28904,28905,28906,28907,28908,28909,28910,28911,28912,28917,28918,28919,28920,28921,28923,28924,28925,28926,28927,28928,28929,28930,28931,28947,28948,28949,28950,28951,28953,28954,28955,28956,28957,28958,28959,28960,28961,28982,28983,28984,28985,28986,28988,28989,28990,28991,28992,28993,28994,28995,28996,29046,29047,29048,29049,29050,29052,29053,29054,29055,29056,29057,29058,29059,29060,29061,29062,29063,29065,29066,29067,29068,29069,29070,29071,29072,29073,29074,29075,29078,29079,29080,29081,29082,29084,29085,29086,29087,29088,29089,29090,29091,29092,29093,29094,29095,29096,29097,29099,29100,29101,29102,29103,29104,29105,29106,29107,29108,29109,29110,29111,29112,29114,29115,29116,29117,29118,29119,29120,29121,29122,29306,29307,29308,29309,29310,29311,29312,29313,29314,29316,29317,29811,29812,29813,29814,29815,29817,29818,29819,29820,29821,29822,29823,29824,29825,29850,29851,29852,29853,29854,29856,29857,29858,29859,29860,29861,29862,29863,29864,29965,29966,29968,29969,29970,29971,29972,29973,29974,29975,29976,30087,30088,30089,30090,30091,30093,30094,30095,30096,30097,30098,30099,30100,30101,30112,30113,30114,30115,30116,30118,30119,30120,30121,30122,30123,30124,30125,30126,30289,30290,30291,30292,30293,30295,30296,30297,30298,30299,30300,30301,30302,30303,30319,30320,30321,30322,30323,30324,30325,30326,30327,30328,30329,30330,30332,30333,30379,30380,30381,30382,30383,30384,30385,30386,30387,30388,30389,30390,30391,30393,30394,30395,30396,30397,30398,30399,30401,30402,30403,30404,30405,30406,30407,30408,30409,30457,30458,30459,30460,30461,30463,30464,30465,30466,30467,30468,30469,30470,30471,30472,30473,30475,30476,30477,30478,30479,30480,30481,30654,30655,30656,30657,30658,30660,30661,30662,30663,30664,30665,30666,30667,30668,30708,30709,30710,30711,30712,30714,30715,30716,30717,30718,30719,30720,30721,30722,30762,30763,30764,30765,30766,30768,30769,30770,30771,30772,30773,30774,30775,30776,30780,30781,30783,30784,30785,30786,30787,30788,30789,30790,30791,30910,30911,30912,30913,30914,30916,30917,30918,30919,30920,30921,30922,30923,30924,30940,30941,30942,30943,30944,30946,30947,30948,30949,30950,30951,30952,30953,30954,30968,30969,31052,31053,31054,31055,31056,31058,31059,31060,31061,31062,31063,31064,31065,31066,31067,31068,31069,31070,31071,31073,31074,31075,31076,31077,31078,31079,31080,31081,31084,31085,31086,31087,31088,31090,31091,31092,31093,31094,31095,31096,31097,31098,31103,31104,31105,31106,31107,31108,31109,31110,31111,31113,31128,31129,31130,31131,31132,31134,31135,31136,31137,31138,31139,31140,31141,31142,31182,31183,31184,31185,31186,31188,31189,31190,31191,31192,31193,31194,31195,31196,31247,31248,31249,31250,31251,31253,31254,31255,31256,31257,31258,31259,31260,31261,31287,31288,31289,31300,31301,31304,31305,31306,31307,31308,31310,31311,31312,31313,31314,31315,31316,31317,31318,31371,31372,31373,31374,31375,31377,31378,31379,31380,31381,31382,31383,31384,31385,31445,31446,31447,31458,31459,31471,31472,31473,31484,31485,31495,31496,31497,31498,31499,31501,31502,31503,31504,31505,31506,31507,31508,31509,31542,31543,31544,31545,31546,31547,31548,31549,31550,31551,31552,31553,31555,31556,31568,31569,31570,31571,31572,31574,31575,31576,31577,31578,31579,31580,31581,31582,31630,31631,31632,31633,31634,31635,31636,31637,31638,31639,31640,31641,31643,31644,31654,31655,31656,31668,31669,31670,31671,31672,31673,31674,31675,31676,31677,31678,31679,31680,31682,31683,31729,31730,31731,31733,31734,31735,31736,31737,31738,31739,31740,31741,31742,31743,31744,31745,31746,31757,31758,31759,31760,31761,31762,31763,31764,31765,31766,31767,31768,31769,31770,31772,31773,31822,31823,31824,31825,31826,31828,31829,31830,31831,31832,31833,31834,31835,31836,31837,31838,31839,31840,31841,31843,31844,31845,31846,31847,31848,31849,31850,31851,31852,31853,31855,31856,31857,31858,31859,31860,31861,31862,31863,31864,31865,31866,31867,31868,31869,31870,31871,31872,31873,31875,31876,31937,31938,31939,31940,31941,31943,31944,31945,31946,31947,31948,31949,31950,31951,31952,31953,31954,31956,31957,31958,31959,31960,31961,31962,31963,31964,31965,31966,31967,31968,31969,31971,31972,31973,31974,31975,31976,31977,31978,31979,31980,31981,31982,31983,31984,31985,31986,31987,31988,31989,31990,31991,31992,31993,31995,31996,31997,31998,31999,32000,32001,32002,32003,32004,32005,32006,32007,32008,32010,32011,32017,32018,32019,32020,32021,32023,32024,32025,32026,32027,32028,32029,32030,32031,32032,32033,32034,32036,32037,32038,32039,32040,32041,32042,32043,32044,32045,32046,32047,32048,32049,32051,32052,32053,32054,32055,32056,32057,32058,32059,32060,32061,32069,32070,32071,32072,32073,32074,32075,32076,32077,32078,32079,32080,32082,32083,32084,32085,32086,32087,32088,32090,32091,32092,32093,32094,32095,32096,32097,32098,32130,32131,32132,32133,32134,32136,32137,32138,32139,32140,32141,32142,32143,32144,32238,32239,32240,32241,32242,32243,32244,32245,32247,32248,32249,32250,32251,32252,32253,32254,32255,32271,32272,32273,32274,32275,32277,32278,32279,32280,32281,32282,32283,32284,32285,32317,32318,32319,32321,32322,32323,32324,32325,32326,32327,32328,32329,32330,32331,32397,32398,32399,32400,32401,32403,32404,32405,32406,32407,32408,32409,32410,32411,32490,32491,32492,32493,32494,32496,32497,32498,32499,32500,32501,32502,32503,32504,32506,32507,32508,32509,32510,32511,32512,32513,32514,32515,32516,32517,32519,32520,32521,32522,32523,32524,32525,32527,32528,32529,32530,32531,32532,32533,32534,32535,32597,32598,32599,32601,32602,32603,32604,32605,32606,32607,32608,32609,32610,32611,32627,32628,32629,32630,32631,32633,32634,32635,32636,32637,32638,32639,32640,32641,32642,32643,32644,32645,32646,32648,32649,32650,32651,32652,32653,32654,32655,32656,32785,32786,32787,32788,32789,32791,32792,32793,32794,32795,32796,32797,32798,32799,32801,32802,32803,32805,32806,32807,32808,32809,32810,32811,32812,32813,32814,32815,32825,32826,32827,32828,32829,32830,32831,32832,32833,32834,32835,32893,32894,32895,32896,32897,32899,32900,32901,32902,32903,32904,32905,32906,32907,32911,32912,32914,32915,32916,32917,32918,32919,32920,32921,32922,32932,32933,32934,32935,32936,32938,32939,32940,32941,32942,32943,32944,32945,32946,33112,33113,33114,33115,33116,33118,33119,33120,33121,33122,33123,33124,33125,33126,34248,34249,34250,34251,34252,34253,34254,34255,34256,34258,34259,34365,34366,34367,34368,34369,34370,34372,34373,34374,34375,34376,34377,34378,34379,34380,34395,34396,34397,34399,34400,34401,34402,34403,34404,34405,34406,34407,34408,34409,34487,34488,34489,34490,34491,34492,34493,34494,34495,34497,34498,34509,34511,34512,34513,34514,34515,34516,34517,34518,34519,34520,34521,34523,34524,34613,34614,34616,34617,34618,34619,34620,34621,34622,34623,34624,35111,35549,35550,35551,35553,35554,35555,35556,35557,35558,35559,35560,35561,35562,35563,36169,36170,36171,36173,36174,36175,36176,36177,36178,36179,36180,36181,36183,36184,36373,36374,36375,36377,36378,36379,36380,36381,36382,36383,36384,36385,36387,36388,36389,36390,36391,36393,36394,36396,36397,36399,36400,36401,36402,36403,36404,36405,36532,36534,36535,36536,36537,36539,36540,36541,36542,36543,36544,36545,36546,36547,36577,36578,36579,36581,36582,36583,36584,36585,36586,36587,36588,36589,36591,36592,36594,36595,36596,36597,36598,36600,36601,36602,36603,36604,36605,36606,36607,36608,36619,36620,36621,36623,36624,36626,36627,36628,36629,36630,36631,36632,36633,36634,36643,36644,36645,36646,36647,36648,36649,36650,36651,36652,36653,36654,36656,36657,36753,36754,36755,36756,36757,36758,36759,36760,36761,36763,36764,36765,36766,36767,36843,36844,36845,36846,36847,36848,36849,36850,36851,36853,36854,36855,36857,36858,36884,36885,36886,36887,36888,36889,36890,36891,36892,36893,36894,36895,36897,36898,36944,36945,36947,36948,36949,36950,36951,36952,36953,36954,36955,36956,36958,36959,37027,37028,37029,37031,37032,37034,37035,37036,37037,37038,37039,37040,37041,37042,37044,37046,37047,37048,37049,37051,37052,37053,37054,37055,37056,37057,37058,37059,37070,37071,37073,37075,37076,37077,37078,37079,37080,37081,37082,37083,37084,37085,37093,37094,37095,37097,37098,37099,37100,37101,37102,37103,37104,37105,37107,37108,37238,37239,37241,37243,37244,37245,37246,37247,37248,37249,37250,37251,37252,37253,37329,37330,37331,37333,37334,37336,37337,37338,37339,37340,37341,37342,37343,37344,37413,37414,37415,37417,37418,37420,37421,37422,37423,37424,37425,37426,37427,37428,37430,37431,37432,37434,37435,37436,37437,37438,37439,37440,37441,37442,37444,37445,37474,37475,37476,37478,37479,37480,37481,37482,37483,37484,37485,37486,37488,37489,37491,37492,37493,37495,37496,37497,37498,37499,37500,37501,37502,37503,37505,37506,37509,37511,37512,37513,37514,37516,37517,37518,37519,37520,37521,37522,37523,37524,37526,37527,37528,37530,37531,37533,37534,37535,37536,37537,37538,37539,37540,37541,37591,37592,37593,37595,37596,37597,37598,37599,37600,37601,37602,37603,37605,37606,37608,37609,37610,37612,37613,37614,37615,37616,37617,37618,37619,37620,37622,37623,37722,37723,37725,37726,37727,37728,37729,37730,37731,37732,37733,37765,37766,37767,37769,37770,37771,37772,37773,37774,37775,37776,37777,37779,37780,37788,37790,37791,37792,37793,37795,37796,37797,37798,37799,37800,37801,37802,37803,37873,37874,37875,37877,37878,37879,37880,37881,37882,37883,37884,37885,37887,37888,37907,37909,37910,37911,37912,37914,37915,37916,37917,37918,37919,37920,37921,37922,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38024,38025,38028,38029,38030,38032,38033,38034,38035,38036,38037,38038,38039,38040,38042,38043,38045,38046,38047,38049,38050,38051,38052,38053,38054,38055,38056,38057,38059,38060,38085,38086,38087,38089,38090,38092,38093,38094,38095,38096,38097,38098,38099,38100,38106,38107,38108,38109,38110,38111,38112,38113,38114,38116,38117,38145,38147,38148,38149,38150,38152,38153,38154,38155,38156,38157,38158,38159,38160,38163,38165,38166,38167,38168,38170,38171,38172,38173,38174,38175,38176,38177,38178,38280,38281,38282,38284,38285,38287,38288,38289,38290,38291,38292,38293,38294,38295,38322,38323,38324,38326,38327,38329,38330,38331,38332,38333,38334,38335,38336,38337,38427,38428,38429,38431,38432,38433,38434,38435,38436,38437,38438,38439,38441,38442,38444,38446,38447,38448,38449,38451,38452,38453,38454,38455,38456,38457,38458,38459,38485,38486,38487,38549,38551,38552,38553,38554,38556,38557,38558,38559,38560,38561,38562,38563,38564,38584,38585,38586,38588,38589,38591,38592,38593,38594,38595,38596,38597,38598,38599,38652,38653,38654,38656,38657,38658,38659,38660,38661,38662,38663,38664,38666,38667,38763,38764,38765,38767,38768,38769,38770,38771,38772,38773,38774,38775,38777,38778,38842,38843,38844,38846,38847,38849,38850,38852,38853,38854,38855,38856,38857,38858,38859,38860,38861,38863,38864,38865,38866,38867,38868,38869,38870,38872,38873,38875,38876,38877,38878,38880,38881,38883,38884,38885,38886,38887,38888,38889,38890,38891,39102,39103,39104,39106,39107,39108,39109,39110,39111,39112,39113,39114,39116,39117,39209,39210,39212,39213,39214,39215,39216,39217,39218,39219,39220,39221,39223,39224,39262,39264,39265,39266,39267,39269,39270,39271,39272,39273,39274,39275,39276,39277,39280,39281,39282,39284,39285,39287,39288,39289,39290,39291,39292,39293,39294,39295,39340,39341,39342,39343,39345,39346,39347,39349,39350,39352,39353,39354,39355,39356,39357,39358,39359,39360,39448,39449,39450,39452,39453,39454,39455,39456,39457,39458,39459,39460,39462,39463,39481,39483,39484,39485,39486,39488,39489,39490,39491,39492,39493,39494,39495,39496,39502,39504,39505,39506,39507,39509,39510,39511,39512,39513,39514,39515,39516,39517,39519,39520,39521,39523,39524,39526,39527,39528,39529,39530,39531,39532,39533,39534,39871,39872,39873,39875,39876,39878,39879,39880,39881,39882,39883,39884,39885,39886,40175,40176,40177,40179,40180,40181,40182,40183,40184,40185,40186,40187,40189,40190,40330,40331,40332,40334,40335,40337,40338,40339,40340,40341,40342,40343,40344,40345,40365,40366,40367,40368,40369,40371,40372,40373,40374,40375,40376,40377,40378,40379,40386,40387,40388,40390,40391,40393,40394,40395,40396,40397,40398,40399,40400,40401,40403,40404,40405,40417,40418,40480,40481,40482,40484,40485,40487,40488,40489,40490,40491,40492,40493,40494,40495,40507,40508,40509,40511,40512,40514,40515,40516,40521,40522,40552,40553,40554,40556,40557,40559,40560,40562,40563,40568,40586,40587,40588,40590,40591,40593,40594,40595,40596,40597,40598,40599,40600,40601,40670,40671,40672,40674,40675,40677,40678,40679,40684,40685,40708,40709,40710,40712,40713,40715,40716,40717,40718,40719,40720,40721,40722,40723,40725,40726,40727,40729,40730,40732,40733,40734,40735,40736,40737,40738,40739,40740,40742,40743,40744,40746,40747,40749,40750,40751,40756,40757,40759,40760,40761,40763,40764,40766,40767,40768,40769,40770,40771,40772,40773,40774,40793,40794,40795,40796,40797,40799,40800,40801,40802,40803,40804,40805,40806,40807,40839,40840,40841,40843,40844,40846,40847,40848,40849,40850,40851,40852,40853,40854,40876,40877,40878,40879,40880,40882,40883,40884,40889,40890,40939,40940,40941,40943,40944,40945,40946,40947,40953,40954,40979,40980,40982,40983,40985,40986,40987,40992,40993,40995,41066,41067,41068,41070,41071,41073,41074,41075,41080,41081,41204,41205,41206,41207,41208,41210,41211,41212,41217,41218,41278,41279,41280,41282,41283,41285,41286,41287,41292,41293,41380,41381,41382,41383,41384,41386,41387,41388,41393,41394,41396,41397,41398,41399,41400,41401,41403,41404,41405,41410,41411,41514,41515,41516,41517,41518,41520,41521,41522,41527,41528)) ) AND ( [a].[SourceStatus] = @SourceStatus3 )) AND ( [a].[CustomerID] = @CustomerID4 )) AND ( [a].[OrderSourceCountry] <> @OrderSourceCountry5 )) AND ( [a].[OrderSourceType] = @OrderSourceType6 )) ',N'@MethodConst0 int,@Const1 int,@SourceStatus3 int,@CustomerID4 int,@OrderSourceCountry5 nvarchar(4000),@OrderSourceType6 int',@MethodConst0=0,@Const1=0,@SourceStatus3=0,@CustomerID4=1,@OrderSourceCountry5=N'IN',@OrderSourceType6=1
[结果]
[期望]
这些表 数据量不大 ，建议同步到独立数据库，采用统一缓存管理，减少ERP 读库压力。