原sql:
declare @CustomerID int= 1 ,@UserID int= 692 ,@InputTimeB datetime= '2022-05-01' ,@InputTimeE datetime= '2022-05-31' ,@UpAddAdminID varchar(2000)= '100070,327,100154,1900,3349,3659,3766,4514,4840,6315,6698,100155,692,1986,2512,3210,3660,4138,4139,6400,6927,100156,350,2160,2573,2858,3015,4036,6730,7136,7511,100188,1150,2810,2857,3174,3299,3521,4845,6049,6699,7545,100234,2952,3183,3226,3297,3341,4490,5062,5078,6719,6855,100235,2143,3054,3128,5288,5583,5688,6109,6367,6525,6541,6635,5214,6445,6316' ,@Count1 int ,@Count2 int ,@ThreeMonthSaleNum1 int= 1
if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#tb_Amazon_OrderSourceIDs') and type='U'))
drop table #tb_Amazon_OrderSourceIDs
create table #tb_Amazon_OrderSourceIDs (Id int primary key)
insert into #tb_Amazon_OrderSourceIDs
SELECT CONVERT(INT, item) as Id FROM Charsplitforin('13331,13330,13295,13267,13258,13257,13229,13228,13226,13225,13223,13222,13221,13220,13219,13218,13217,13216,13215,13201,13200,13199,13195,13194,13191,13188,13187,13174,13173,13172,13171,13170,13168,13167,13159,13155,13154,13153,13151,13149,13148,13147,13146,13145,13144,13142,13140,13138,13137,13136,13135,13134,13133,13132,13131,13124,13123,13120,13117,13116,13115,13114,13113,13105,13104,13103,13102,13101,13100,13099,13098,13091,13090,13087,13084,13083,13082,13081,13080,13076,13075,13074,13073,13072,13071,13070,13069,13046,13045,13044,13042,13038,13028,13027,13026,13025,13023,13020,13019,13018,13017,13016,12983,12982,12977,12972,12971,12925,12924,12921,12918,12917,12916,12915,12914,12815,12814,12813,12812,12810,12809,12808,12786,12785,12784,12782,12780,12779,12778,12777,12776,12775,12768,12766,12764,12763,12761,12749,12748,12747,12746,12745,12744,12742,12741,12740,12739,12738,12737,12721,12706,12705,12702,12699,12698,12697,12696,12695,12691,12690,12687,12685,12684,12683,12682,12681,12680,12639,12638,12637,12636,12635,12633,12632,12631,12629,12628,12627,12611,12610,12591,12566,12565,12561,12559,12558,12557,12556,12555,12554,12546,12545,12544,12530,12496,12495,12492,12490,12488,12487,12486,12485,12476,12475,12474,12473,12468,12467,12466,12465,12463,12014,12013,12012,12011,12010,12009,12003,12002,12001,11993,11992,11991,11975,11973,11972,11971,11970,11969,11966,11965,11964,11962,11961,11959,11952,11946,11944,11934,11903,11902,11899,11898,11897,11893,11892,11891,11890,11889,11888,11887,11886,11885,11884,11883,11881,11880,11877,11876,11875,11874,11873,11872,11871,11870,11869,11868,11867,11866,11865,11864,11862,11861,11860,11859,11858,11857,11856,11855,11854,11852,11851,11848,11841,11840,11839,11838,11837,11836,11835,11834,11833,11832,11831,11830,11828,11826,11825,11824,11823,11822,11821,11820,11818,11817,11800,11799,11798,11795,11794,11793,11792,11790,11789,11759,11758,11757,11756,11745,11742,11741,11738,11731,11727,11726,11725,11724,11723,11722,11721,11717,11715,11713,11712,11710,11709,11708,11706,11703,11702,11683,11682,11681,11680,11679,11678,11677,11676,11674,11672,11651,11650,11649,11648,11647,11646,11645,11644,11638,11637,11625,11624,11622,11621,11620,11616,11613,11612,11611,11610,11608,11607,11606,11605,11604,11603,11601,11597,11596,11595,11594,11584,11583,11582,11579,11576,11572,11571,11570,11569,11568,11567,11566,11565,11564,11558,11557,11556,11555,11552,11551,11550,11548,11544,11543,11541,11540,11537,11536,11532,11528,11526,11525,11524,11522,11521,11513,11512,11510,11509,11508,11507,11506,11505,11504,11499,11498,11497,11496,11495,11494,11493,11491,11490,11489,11488,11487,11486,11485,11484,11483,11482,11481,11480,11479,11478,11477,11476,11475,11474,11473,11472,11471,11470,11469,11468,11466,11464,11463,11462,11461,11450,11449,11441,11440,11439,11438,11437,11435,11434,11428,11427,11426,11425,11424,11423,11422,11421,11407,11406,11405,11404,11401,11400,11399,11398,11396,11394,11393,11392,11391,11390,11389,11388,11387,11365,11363,11362,11361,11359,11357,11351,11345,11344,11340,11338,11336,11335,11330,11329,11328,11327,11326,11325,11324,11323,11322,11318,11317,11316,11311,11307,11302,11301,11296,11292,11291,11289,11285,11284,11283,11282,11281,11280,11279,11278,11277,11276,11272,11267,11264,11263,11261,11259,11258,11257,11256,11255,11249,11248,11246,11245,11243,11242,11239,11234,11232,11231,11230,11229,11228,11227,11226,11213,11211,11210,11207,11206,11205,11204,11203,11202,11201,11199,11198,11194,11192,11191,11190,11188,11187,11186,11185,11184,11183,11181,11180,11179,11178,11176,11171,11170,11169,11168,11167,11166,11164,11163,11161,11160,11159,11158,11157,11156,11155,11154,11151,11147,11146,11143,11142,11141,11139,11138,11137,11136,11135,11134,11133,11132,11131,11130,11129,11128,11126,11124,11123,11122,11120,11118,11116,11115,11113,11112,11111,11110,11108,11102,11100,11098,11097,11096,11095,11094,11093,11092,11091,11090,11089,11088,11087,11086,11085,11084,11051,11034,11022,11021,11018,11016,11015,11010,10994,10992,10991,10990,10989,10988,10986,10981,10979,10978,10977,10976,10975,10972,10971,10970,10965,10960,10954,10953,10952,10929,10928,10927,10926,10923,10922,10921,10920,10919,10918,10917,10916,10914,10912,10911,10910,10909,10908,10905,10902,10901,10900,10899,10898,10897,10896,10895,10894,10893,10892,10891,10890,10889,10887,10884,10881,10879,10878,10876,10875,10874,10873,10871,10870,10869,10868,10867,10866,10865,10864,10863,10862,10861,10859,10858,10855,10854,10853,10851,10850,10849,10848,10847,10846,10845,10844,10837,10835,10827,10826,10818,10814,10812,10809,10804,10801,10800,10799,10773,10772,10771,10770,10769,10768,10767,10766,10765,10764,10763,10758,10757,10754,10753,10751,10749,10748,10746,10745,10744,10743,10742,10741,10740,10739,10738,10737,10717,10710,10709,10708,10567,10565,10560,10558,10556,10555,10554,10551,10550,10549,10548,10547,10543,10542,10541,10540,10539,10538,10537,10536,10535,10534,10533,10532,10531,10530,10529,10528,10527,10526,10525,10524,10496,10485,10467,10453,10450,10433,10431,10430,10429,10428,10427,10424,10420,10414,10398,10397,10395,10387,10386,10382,10381,10380,10378,10375,10374,10367,10366,10365,10364,10361,10360,10359,10358,10357,10356,10355,10353,10351,10350,10349,10348,10347,10346,10345,10344,10343,10336,10330,10329,10327,10320,10319,10318,10317,10316,10315,10313,10312,10311,10310,10309,10308,10292,10291,10290,10289,10288,10285,10284,10283,10281,10280,10278,10266,10265,10264,10263,10256,10254,10253,10252,10251,10247,10246,10245,10230,10187,10138,10137,10106,10095,10094,10089,10088,10087,10086,10084,10083,10082,10081,10080,10079,10075,10074,10073,10072,10071,10070,10069,10068,10067,10066,10065,10064,10063,10062,10061,10059,10058,10054,10053,10050,10049,10048,10047,10046,10045,10043,10038,10037,10036,10034,10033,10030,10029,10028,10027,10024,10023,10022,10008,10007,10006,10005,10004,10003,10002,10001,9968,9966,9965,9961,9959,9958,9957,9956,9952,9950,9949,9945,9928,9927,9924,9922,9921,9920,9919,9918,9917,9916,9915,9914,9913,9910,9908,9905,9903,9901,9900,9892,9891,9890,9889,9888,9887,9886,9885,9884,9882,9881,9877,9876,9875,9874,9873,9872,9871,9870,9869,9868,9867,9866,9865,9863,9862,9861,9860,9859,9858,9857,9855,9854,9853,9852,9851,9850,9839,9838,9837,9836,9835,9834,9833,9832,9831,9830,9829,9828,9827,9826,9825,9824,9823,9822,9821,9817,9816,9810,9807,9806,9805,9804,9801,9800,9799,9792,9789,9788,9787,9786,9785,9782,9781,9780,9777,9776,9775,9773,9772,9771,9770,9769,9768,9767,9766,9749,9748,9714,9713,9712,9711,9705,9704,9703,9702,9701,9700,9698,9697,9696,9695,9694,9693,9692,9691,9690,9679,9670,9669,9664,9663,9662,9661,9654,9653,9652,9651,9650,9649,9648,9647,9645,9643,9641,9640,9626,9624,9623,9622,9619,9618,9617,9616,9615,9614,9613,9612,9611,9610,9608,9606,9605,9604,9603,9602,9601,9600,9598,9597,9596,9595,9594,9593,9592,9589,9588,9587,9586,9585,9583,9582,9580,9579,9578,9577,9572,9568,9567,9566,9565,9562,9557,9556,9555,9554,9553,9551,9550,9548,9547,9546,9545,9544,9536,9535,9534,9533,9532,9531,9530,9529,9528,9526,9525,9524,9523,9522,9512,9511,9510,9509,9503,9496,9495,9494,9493,9492,9491,9490,9489,9488,9487,9486,9484,9483,9482,9481,9480,9479,9478,9477,9476,9475,9470,9469,9468,9467,9466,9460,9459,9458,9457,9456,9455,9454,9453,9452,9451,9450,9449,9448,9447,9440,9439,9438,9437,9436,9428,9426,9425,9423,9422,9421,9420,9419,9417,9416,9415,9414,9412,9407,9406,9380,9379,9364,9363,9362,9361,9303,9302,9301,9300,9298,9297,9296,9295,9294,9293,9292,9291,9290,9289,9288,9287,9286,9285,9284,9283,9272,9271,9263,9258,9257,9243,9242,9241,9240,9239,9237,9236,9235,9226,9225,9224,9223,9222,9219,9218,9217,9216,9215,9211,9210,9209,9208,9207,9206,9205,9176,9175,9174,9173,9172,9171,9170,9169,9168,9167,9165,9164,9163,9162,9161,9160,9159,9158,9157,9156,9155,9154,9153,9152,9150,9149,9148,9147,9146,9140,9139,9138,9137,9136,9130,9129,9128,9127,9126,9125,9124,9123,9121,9120,9119,9118,9117,9114,9113,9112,9108,9107,9099,9098,9097,9090,9089,9088,9087,9086,9085,9084,9083,9082,9080,9079,9078,9077,9074,9070,9069,9068,9067,9066,9061,9057,9047,9040,9039,9038,9037,9036,9034,9033,9032,9031,9030,9029,9028,9027,9025,9021,9014,9013,9012,9011,9010,8990,8989,8987,8959,8958,8957,8956,8955,8947,8930,8928,8927,8926,8925,8924,8862,8861,8860,8859,8858,8857,8856,8855,8854,8853,8852,8851,8841,8838,8696,8695,8694,8693,8692,8687,8679,8677,8676,8674,8640,8639,8637,8636,8621,8620,8619,8618,8616,8615,8614,8612,8611,8609,8606,8605,8570,8567,8565,8564,8563,8560,8559,8558,8557,8556,8553,8552,8549,8543,8541,8522,8519,8518,8517,8511,8505,8501,8499,8498,8496,8495,8494,8493,8492,8491,8490,8487,8485,8477,8476,8475,8474,8473,8472,8471,8465,8463,8462,8461,8460,8458,8457,8456,8455,8450,8449,8448,8446,8437,8428,8423,8414,8413,8412,8411,8410,8407,8405,8403,8393,8390,8382,8381,8380,8379,8378,8377,8376,8366,8362,8357,8353,8351,8350,8349,8348,8347,8346,8345,8339,8336,8260,8259,8258,8257,8256,8255,8254,8253,8252,8251,8250,8249,8248,8247,8246,8245,8244,8243,8242,8157,8155,8151,8149,8148,8147,8140,8137,8131,8126,8125,8124,8123,8122,8119,8118,8116,8114,8113,8112,8111,8101,8099,8098,8097,8096,8095,8094,8093,8092,8078,8077,8076,8075,8074,8073,8072,8071,8070,8068,8067,8066,8059,8058,8057,8056,8039,8037,8036,8034,8033,8031,8024,8023,8018,8017,8013,8012,8011,8010,8002,8001,8000,7999,7998,7997,7996,7995,7980,7979,7978,7977,7976,7956,7955,7954,7953,7950,7948,7946,7945,7944,7942,7936,7935,7934,7933,7932,7931,7930,7929,7928,7927,7926,7925,7924,7923,7922,7905,7904,7903,7902,7901,7900,7898,7897,7893,7892,7891,7890,7760,7759,7755,7754,7753,7752,7751,7749,7740,7739,7721,7720,7719,7716,7714,7713,7712,7711,7710,7708,7707,7706,7704,7702,7698,7527,7521,7519,7518,7517,7516,7515,7514,7513,7512,7511,7443,7442,7421,7398,7397,7396,7395,7394,7392,7391,7389,7388,7387,7386,7383,7382,7379,7378,7377,7376,7375,7369,7368,7367,7366,7364,7363,7362,7361,7360,7359,7357,7298,7297,7296,7289,7198,7192,7175,7170,7169,7168,7167,7166,7165,7164,7163,7162,7160,7159,7158,7157,7121,7119,7116,6964,6963,6961,6960,6959,6955,6954,6953,6952,6951,6950,6949,6943,6941,6940,6939,6938,6937,6936,6935,6934,6933,6932,6931,6930,6929,6928,6927,6926,6925,6924,6923,6922,6921,6919,6918,6917,6916,6915,6912,6911,6910,6909,6908,6907,6906,6904,6903,6902,6901,6899,6895,6891,6890,6888,6887,6886,6885,6884,6883,6882,6872,6871,6870,6869,6868,6867,6866,6837,6835,6809,6808,6807,6806,6777,6776,6756,6755,6754,6702,6701,6700,6698,6697,6696,6691,6690,6689,6688,6687,6675,6674,6673,6672,6671,6670,6669,6660,6659,6658,6652,6646,6645,6644,6643,6642,6641,6640,6639,6638,6625,6623,6622,6621,6620,6619,6618,6616,6615,6614,6613,6611,6609,6608,6607,6600,6599,6598,6596,6594,6593,6592,6591,6585,6574,6573,6572,6571,6570,6564,6563,6561,6559,6558,6556,6555,6554,6553,6552,6551,6550,6516,6515,6514,6513,6511,6510,6507,6499,6485,6484,6479,6464,6440,6439,6438,6437,6436,6433,6400,6399,6381,6275,6268,6267,6266,6265,6264,6263,6260,6238,6237,6236,6228,6173,6159,6158,6157,6156,6155,6154,6153,6151,6150,6149,6148,6146,6144,6143,6142,6141,6140,6139,6137,6123,6116,6115,6114,6113,6112,6111,6110,6109,6108,6107,6106,6105,6104,6103,6102,6101,6100,6099,6098,6097,6096,6095,6094,6093,6092,6090,6088,6087,6086,6085,6084,6083,6082,6081,6080,6079,6078,6077,6076,6075,6073,6072,6071,6070,6069,6068,6067,6066,6065,6064,6063,6062,6061,6060,6058,6057,6056,6055,6054,6051,6050,6049,6043,6042,6041,6040,6039,6038,6037,6036,6035,6033,6032,6031,6030,6029,6028,6027,6026,6025,6024,6023,5955,5954,5953,5952,5951,5949,5948,5946,5944,5813,5809,5783,5781,5780,5779,5777,5776,5774,5773,5771,5770,5769,5768,5767,5766,5764,5754,5753,5751,5750,5749,5748,5747,5746,5745,5744,5743,5742,5741,5740,5738,5734,5733,5716,5714,5712,5711,5706,5705,5691,5685,5684,5679,5676,5675,5673,5672,5671,5670,5669,5668,5666,5665,5664,5663,5661,5660,5657,5647,5645,5641,5640,5637,5636,5635,5634,5633,5632,5631,5628,5627,5626,5625,5610,5609,5608,5607,5606,5605,5604,5603,5587,5586,5585,5582,5581,5580,5579,5578,5577,5576,5575,5574,5573,5572,5571,5570,5568,5567,5566,5565,5564,5563,5556,5553,5552,5538,5537,5534,5533,5515,5514,5505,5504,5486,5485,5482,5481,5478,5477,5475,5473,5472,5471,5470,5469,5468,5467,5466,5465,5464,5463,5462,5461,5460,5457,5456,5454,5452,5451,5446,5444,5443,5442,5440,5439,5438,5437,5435,5408,5407,5406,5405,5397,5396,5395,5390,5389,5385,5377,5376,5374,5368,5367,5348,5341,5337,5334,5333,5332,5327,5326,5288,5277,5276,5256,5254,5251,5249,5248,5203,5202,5201,5200,5199,5194,5193,5192,5191,5189,5188,5187,5185,5183,5132,5125,5123,5117,5109,5105,5098,5095,5094,5093,5075,5073,5042,5018,5014,5007,5004,3000,12448,12447,12444,12440,12439,12438,12436,12435,12434,12433,12427,12426,12425,12424,12410,12408,12407,12406,12405,12404,12403,12398,12397,12395,12394,12393,12392,12391,12390,12370,12369,12366,12363,12362,12361,12360,12341,12334,12325,12323,12313,12287,12286,12285,12284,12283,12282,12271,12270,12269,12267,12266,12265,12262,12261,12260,12259,12248,12245,12244,12243,12240,12236,12229,12219,12218,12217,12216,12205,12204,12201,12200,12199,12197,12196,12195,12194,12187,12185,12177,12176,12155,12146,12145,12144,12141,12138,12133,12131,12129,12128,12124,12123,12121,12120,12119,12118,12117,12114,12113,12112,12111,12110,12109,12108,12107,12106,12100,12085,12082,12070,12069,12068,12060,12059,12058,12057,12052,12051,12049,12048,12047,12045,12044,12038,12021,8363,12811,10752,7703,5005,6612,6091,6089,12588,10747,11240,5059,6059,6549,9856,6942,10057,13332,5272,7921,5267,5765,9848,5266,5667,7197,7156,8832,9020,9299,6805,9166,9508,8030,7358,9979,10085,9971,9947,9946,8642,8599,8598,8597,8573,8572,8569,8568,8548,8525,8516,8515,8524,8540,8544,8689,8602,8595,8574,9980,9978,9975,8400,8310,7440,7290,8422,8409,8408,8406,8404,8402,8401,8399,8396,8395,8394,8392,8375,8373,8365,8364,8156,7878,7839,7837,7835,7832,7831,7830,7829,7828,7827,7826,7825,7824,7822,7821,7770,7769,7748,7726,7724,7723,7700,7293,8555,6048,12979,13271,9563,9564,9035,5383,6617,6948,8035,8065,11173,7899,8374,12230,10044,9607,8115,9081,11286,12727,12728,12729,12730,12731,12732,13224,12733,12734,7118,8613,12450,8032,12984,10883,10199,10198,10454,11459,9007,10924,10843,13157,8691,8038,7823,6407,6406,12783,13047,13169,11714,11220,11219,11218,11217,11216,11215,12462,7295,12980,11974,13022,13041,6486,10328,9055,12399,12401,12402,12400,12494,12497,12493,12491,12553,12551,12552,6781,7286,9747,12692,12689,12688,12686,12743,12136,12464,9864,11675,5782,11827,9621,12186,8386,9969,12234,13021,12803,12919,13040,11816,11609,11436,10277,12634,13156,11312,5375,11140,13150,10459,10735,13024,12781,12050,11397,11208,9429,8467,8466,8464,11175,12978,12132,13152,12461,12428,12442,12549,5483,5484,13268,11534,11531,9212,6657,13541,13540,13539,13520,13513,13512,13500,13468,13467,13466,13449,13447,13445,13443,13439,13432,13426,13424,13419,13418,13417,13415,13412,13411,13410,13409,13408,13407,13406,13405,13397,13396,13395,13376,13375,13374,13373,13372,13343,13342,13341,13340,13339,13338,13337,13336,13335,13334,12767,11801,11803,11805,11806,11807,11808,11810,11811,11813,12075,13516,12675,12674,12673,12672,12671,12670,12669,12668,12667,12666,12665,12664,12663,11502,11501,11500,11458,11457,11456,11455,11454,11109,8469,8453,11150,8451,13275,12272,12258,12257,12573,12572,12318,11664,11380,11379,11378,11377,11376,12071,8520,6446,11665,11148,10980,8468,8130,8129,8128,8127,9266,12249,11321,11225,9798,9434,9433,9432,9431,12073,10388,10275,11652,13515,11592,13477,12550,12787,13497,11802,13559,13272,13534,12137,12139,12140,11127,13431,8641,11332,11241,11976,11743,11739,11705,11523,11200,10564,12061,13446,13613,13612,13596,13615,13614,13594,13593,13617,8617,10026,10025,12126,13595,13629,13623,13622,12127,13398,11578,13377,8836,8835,8833,13107,11145,13414,11850,10886,11849,11842,11614,5701,5690,12016,11853,11845,11844,11707,9819,9591,8447,5702,9820,9818,11843,11615,9699,5707,13214,12765,12762,11847,11846,13444,11602,12104,12736,12105,7701,11511,11554,12053,12460,13511,12459,12458,13296,13448,13440,8834,13494,9435,9644,7287,9970,9912,6562,5517,5402,5401,5400,5399,13597,9953,9954,13702,13701,13700,13690,13663,13662,13624,13619,13610,13609,13605,13604,13603,13602,13601,13600,13599,13592,13590,13586,13585,13584,13580,13579,13578,13576,13575,13574,13573,13570,13569,13568,13567,13566,13565,13564,13560,13547,13519,13518,13517,8016,8015,8014,6152,8638,13628,13627,13626,13581,13582,13583,12756,13126,13093,13118,12385,13587,13588,13589,12926,12923,12922,12920,13097,13095,13096,13094,13130,13129,13127,13128,11671,13239,13495,10293,13469,13470,13471,13085,12134,11530,8554,13811,13809,13808,13807,12264,9561,9560,9559,9558,6655,6138,10736,13533,13476,13496,6405,11696,11690,11684,11685,11686,11687,11688,11689,11691,11692,11693,11694,12125,13475,13499,7161,11863,13290,13529,13528,13527,11791,11106,11105,11104,10462,12437,7117,12263,11287,11117,10490,10324,10323,10321,10322,10325,11882,13780,13709,13785,9911,11448,11349,5763,5775,11960,13563,13562,13561,5520,5164,11395,10417,10039,11878,11879,12268,13043,13667,13598,13425,11804,13810,11107,12015,11819,5739,5544,8523,10813,13577,12135,9977,10042,7750,9849,13799,10297,10296,10295,10294,5091,10040,8391,13661,13778,10041,5384,10060,6900,9549,13535,12469,13526,13525,13524,13416,6610,13784,13779,13394,13536,13782,12540,12537,10880,9571,12539,12538,9273,11319,9904,12191,12192,12193,13227,13420,13301,13300,13299,13297,11290,11212,11114,9507,9506,9505,10750,5403,13298,8139,6892,7949,7390,5643,14470,14469,14468,10032,7943,13478,9976,11262,11963,12630,11553,13671,13669,13668,13664,13616,13039,13037,13036,13035,9955,9951,6450,6451,11958,11957,11956,11955,11953,11951,5678,11954,11247,11341,14467,13781,13034,5051,11364,11125,10982,10416,8678,8562,6699,12017,9581,8566,11193,8988,14574,13591,13313,14593,13618,12232,12103,9234,9238,11403,11269,9504,7880,6656,6443,6442,12092,12091,12089,10078,10077,10076,10052,10051,9584,7385,7384,6595,13665,12389,12388,12387,12386,12371,12368,12367,12365,13158,13775,13774,13773,13768,14359,14358,14356,14355,14352,14348,14347,14346,14343,14342,14341,14340,14339,14338,14337,14336,14335,14334,14333,14332,14330,14327,14326,14325,14324,14323,14322,14321,14320,14319,14317,14316,14314,14313,14312,14311,14310,14309,14308,14307,14306,14305,14304,14303,14302,14301,14300,14295,14294,14293,14292,14291,14290,14289,14288,14287,14286,14285,14284,14283,14280,14278,14088,14087,14086,14076,14075,14074,14073,14071,14070,13926,13924,13923,13922,13921,13920,13919,13918,13916,13915,13913,13912,13911,13910,13908,13907,13905,13904,13903,13900,13898,13878,13872,13871,13870,13869,13868,13867,13866,13865,13864,13863,13862,13860,13859,13853,13852,13851,13850,13849,13848,13847,13846,13845,13844,13843,13842,13841,13840,13839,13838,13837,13836,13835,13834,13830,13829,13828,13827,13826,13825,13824,13823,13822,13821,13820,13819,13818,13817,13816,13815,13814,13813,13812,13798,13797,13786,14646,14645,14643,14642,14641,14636,14635,14634,14633,14617,14616,14615,14601,14600,14599,14592,14591,14590,14589,14583,14582,14581,14580,14579,14578,14577,14576,14573,14572,14571,14570,14569,14568,14567,14566,14565,14564,14563,14562,14561,14560,14559,14558,14557,14556,14555,14554,14553,14552,14551,14550,14546,14545,14544,14543,14542,14539,14538,14537,14536,14534,14533,14532,14531,14530,14527,14526,14525,14524,14523,14522,14521,14520,14518,14513,14512,14511,14510,14509,14508,14507,14506,14505,14504,14503,14502,14501,14500,14499,14498,14497,14496,14495,14494,14487,14486,14485,14484,14483,14482,14481,14480,14479,14478,14477,14476,14475,14474,14473,14472,14471,14462,14449,14448,14447,14441,14440,14439,14435,14433,14432,14431,14418,14417,14416,14413,14412,14409,14408,14407,14371,14370,14369,14368,14367,14366,14365,14364,14363,14362,14361,14360,14586,14596,14612,13902,14282,10987,13498,12457,13800,11797,11796,12760,12759,12758,12757,12807,12806,12805,12804,13125,13122,13121,13119,13092,13086,13088,13089,13243,13242,13241,13240,14690,14689,14688,14638,14682,14681,14679,14678,14677,14675,14691,14693,13858,14426,10031,13294,13293,13292,13291,14345,13861,13909,13917,14698,14697,14673,5167,5166,5165,14742,14741,14740,14739,14738,14737,14736,14734,14728,14726,14725,14724,14723,14722,14721,14720,14718,14717,13572,14402,14748,14749,14519,14753,5373,14777,14774,14773,14772,14771,14765,14764,14762,14761,14760,14759,14754,13887,14349,14415,14438,14787,10276,14644,7725,14676,10948,14819,14818,14817,14816,14815,14814,14807,14806,14805,14804,14799,14798,14797,14796,14795,14794,14788,14823,14822,14820,11740,5108,6557,10915,10872,10557,10363,5642,9151,9542,9543,9620,9625,9627,9628,9629,11695,14831,14830,14829,14843,14842,14841,14835,14834,14833,14832,14855,14854,14853,14849,14848,14847,14846,14845,14844,14851,9022,9024,9023,9446,10128,10249,10250,10282,10856,11009,11343,11549,5247,7894,7896,6147,6757,7510,9109,9110,11177,11981,14353,14867,14866,14865,14861,14859,14858,14857,14856,14887,14886,14879,14878,14877,14876,11533,11527,14894,5639,5730,5630,11988,14895,14727,14826,14838,14907,14906,14905,14903,14901,14899,14898,14896,14897,14891,14889,14888,5629,14733,13480,10415,14908,13666,13670,12180,12179,12178,11254,11253,11252,11251,14926,14925,14924,14923,14922,14921,14920,14915,14914,14913,14912,14911,14793,14790,14813,14931,14930,14929,14928,14752,14927,14692,14630,14719,13648,13654,11460,10984,13649,13479,12543,12542,13653,13652,13651,11939,9006,9005,13655,12541,12548,10354,14776,14775,14935,14934,14932,14943,14942,14941,14954,14953,14952,14072,14810,14973,14972,14970,14763,14756,14985,14983,14984,14974,14975,14976,14977,14978,14979,5677,9883,14902,14595,15003,15002,15001,15000,14997,14996,14995,14994,14993,14992,14991,13899,14279,14938,14988,8992,13772,13770,13769,14329,5522,15009,14933,15042,15041,15040,15039,15038,15037,15036,15035,15032,15031,15030,15028,15027,11331,11172,9667,6034,5252,14350,10888,10885,10314,10906,10561,6597,5704,14351,10396,7526,9599,7718,7717,7715,13650,14789,8625,8624,8623,8622,11433,11432,11431,11430,13660,13659,13658,13657,13892,5253,5255,9270,9570,9646,12536,10568,11320,11711,5713,5715,9003,9004,14611,13771,9008,9009,9902,10882,11529,10035,12202,15051,15050,15049,15017,15016,15015,15014,5269,5325,10852,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,14885,14882,14821,14850,14917,15060,15047,15044,15068,15067,15066,15065,11144,15081,15080,15079,15078,15074,15073,15072,15071,15070,11809,15034,15029,15046,15033,15099,15098,15097,15096,15091,15093,15092,15090,15089,15088,14614,14588,14598,14640,6052,14434,14411,14315,14069,14328,10379,15118,15119,15121,15122,15123,15124,15125,15126,15127,15129,15130,15131,15132,15133,15134,15135,15136,15137,12981,15076,6783,6782,15108,15111,15112,15113,15114,15115,15069,14680,14687,14685,13901,14281,15143,15145,15144,15141,15140,7705,5176,5177,5178,5250,14318,14344,14357,14331,15085,15084,15083,15082,14803,14802,14801,14800,14971,14437,14828,14840,14758,14770,15154,15153,15152,15151,15150,15147,15148,9259,9260,9261,9100,8452,8454,13501,7365,14767,14825,14837,11812,5674,7709,8561,14863,14862,15110,14535,14768,15095,14980,14981,11673,15077,8069,15149,15094,15120,15128,5305,5306,5307,5308,5086,15189,15188,15187,15186,15183,15182,15181,15180,15179,15178,15173,15174,15175,15168,15169,15171,15172,15201,15200,15199,15198,15197,15195,15194,15193,15192,15191,15190,15213,15212,15211,15210,15209,15208,15207,15206,15205,15203,15202,14694,15222,15221,15220,15219,15218,15216,15215,14881,14755,15230,15229,15228,15227,15226,15224,15223,9269,15238,15237,15236,15235,15234,15232,15231,15239,15240,15242,15243,15247,15245,15246,15248,15249,15250,14884,14792,15244,13611,13186,13185,13184,12484,12483,12482,12481,12480,12479,12478,12477,11968,11967,15185,11560,11542,11538,11358,11342,11539,11233,10000,9552,8571,8117,15184,14684,14632,14585,14637,14629,15170,15142,15167,15176,15177,15270,15269,15268,15267,15266,15264,15263,15262,15261,15260,15259,14809,15258,15257,15256,15255,15254,15252,15251,15233,15217,15280,15279,15278,15277,15276,15274,15273,10762,15265,11753,11752,11751,11750,11749,11748,11747,11746,15281,15285,15286,15204,15225,15196,15241,15275,14414,14672,15289,15287,15288,14987,15075,15045,11728,15253,15323,15322,15321,15320,15319,15318,15317,15316,15315,15314,15313,15312,15310,15309,15326,15327,15328,15329,15330,15331,15332,15333,15334,15335,15336,15337,15338,15339,15340,10877,8837,10055,10056,10229,10857,14919,14990,14940,15343,15345,15346,15347,15348,15352,15350,15351,15353,15354,15355,15356,5404,12359,12364,12472,15359,15349,14628,11429,14766,14354,14880,14836,14603,14604,14606,14607,14608,14609,13532,14602,14631,14605,14686,14769,14757,14791,14827,14883,14839,14639,14613,14587,14597,14406,14405,14404,14403,14430,14429,14428,14427,15311,15376,15375,15382,15384,11829,11503,11214,11250,11260,11375,12700,10326,12130,11492,13064,11788,13656,11720,12722,13189,13914,13906,5304,14989,15109,12090,6512,13413,9076,9096,9106,9116,14732,15402,15342,15417,15416,15415,15414,15413,15412,15411,15410,15409,15407,15408,15406,15157,15431,15430,15429,15428,15427,15433,15434,15403,15404,15443,15442,15441,15439,15437,15436,15440,15444,15458,15457,15456,15455,15454,15453,15452,15451,15450,15449,15448,15447,15446,15445,15459,15460,15461,15462,15463,15435,15383,5516,15341,14918,14939,15303,15465,15374,15373,15372,15371,15370,15369,15368,15367,15366,15365,15364,15363,15362,15361,15360,15468,15469,15470,15471,15473,15474,15475,15405,14436,15048,15476,15477,14824,14584,14731,14811,9842,15492,15491,15490,15488,15487,15486,15485,15484,15483,15482,15481,15479,15504,15503,15502,15501,15500,15499,15498,15497,15496,15494,15493,14860,5558,11101,10352,5611,15506,5562,5561,5560,15344,15478,15489,11563,11099,10959,9418,8482,8043,8042,8041,8040,15512,15513,15514,15515,15516,15517,15518,15519,15520,15521,15522,15523,15526,15525,15524,15438,15527,14946,14947,14951,14950,14949,14945,14944,14714,14713,14890,14750,14700,13895,13894,13893,13891,13890,13889,13888,13877,13876,13873,13874,13875,13514,13430,13429,13428,14715,14716,12072,7196,6449,6448,14936,14683,14610,14594,13068,13067,13066,13065,13193,13192,13190,13196,12726,12725,12724,12723,12704,12703,12701,12707,12432,12431,12430,12429,12446,12445,12443,12449,9199,9200,9201,9202,14916,14937,15540,15541,15542,15543,15544,15545,15547,15546,15548,15549,15550,15551,15552,15553,15554,15555,15556,10860,14808,14900,14735,14812,14852,14864,14904,14948,14982,15425,15426,15432,15480,15495,15557,15558,14699,13783,-1', ',')
select count(0) from [RB_Amazon_Product_Base] (nolock) vtb LEFT JOIN RB_StockClearDetailed scd (nolock) ON(vtb.OrderSourceSKUID=scd.ListId AND vtb.CustomerID=scd.CustomerID AND (clearType=1 OR clearType=3))
LEFT JOIN RB_StockClearStrategy scs (nolock) ON(scd.scsID=scs.ID AND scd.CustomerID=scs.CustomerID)
LEFT JOIN (SELECT sum(GoodNum) AS Inventory,WareHouseID,SKU,CustomerID FROM RB_WareHouse_Product (nolock) GROUP BY WareHouseID,SKU,CustomerID) AS tbWHN ON(vtb.WID=tbWHN.WareHouseID AND vtb.SKU=tbWHN.SKU AND vtb.CustomerID=tbWHN.CustomerID)
LEFT JOIN RB_WareHouse w (nolock) ON w.CustomerID=vtb.CustomerID and w.ID=vtb.DefaultWarehouseID
LEFT JOIN RB_OrderSource o (nolock) on vtb.CustomerID=o.CustomerID and vtb.OrderSourceID = o.ID
Left join RB_Product_Admin pa(nolock) on vtb.CustomerID=pa.CustomerID and vtb.SKU = pa.SKU
left join RB_Product p (nolock) on p.CustomerID=vtb.CustomerID and vtb.SKU = p.SKU
left join RB_WareHouse wh(nolock) on wh.CustomerID=p.CustomerID and wh.ID=p.DefaultLocalWarehouse
left join RB_WareHouse swh(nolock) on swh.CustomerID=vtb.CustomerID and swh.ID=vtb.TheWareHouseID
left join RB_Amazon_NotToFbaReason ntf (nolock) on vtb.CustomerID=ntf.CustomerID and vtb.NotToFbaReasonId=ntf.ID
INNER JOIN #tb_Amazon_OrderSourceIDs IDS on vtb.OrderSourceID=IDS.Id
WHERE vtb.CustomerID=@CustomerID AND vtb.IsDelete=0 AND DATEDIFF(day,@InputTimeB,vtb.AddTime)>=0 AND DATEDIFF(day,@InputTimeE,vtb.AddTime)<=0 and vtb.AddAdminID in(SELECT CONVERT(INT, item) FROM Charsplitforin(@UpAddAdminID, ',')) and ThreeMonthSaleNum>=@ThreeMonthSaleNum1 and isnull(IsOffShelf,0)<>3 and vtb.OrderSourceSKUID>0 option(maxdop 8)
建议优化为：
declare @CustomerID int= 1 ,@UserID int= 692 ,@InputTimeB datetime= '2022-05-01 00:00:00' ,@InputTimeE datetime= '2022-05-31 23:59:59' ,@UpAddAdminID varchar(2000)= '100070,327,100154,1900,3349,3659,3766,4514,4840,6315,6698,100155,692,1986,2512,3210,3660,4138,4139,6400,6927,100156,350,2160,2573,2858,3015,4036,6730,7136,7511,100188,1150,2810,2857,3174,3299,3521,4845,6049,6699,7545,100234,2952,3183,3226,3297,3341,4490,5062,5078,6719,6855,100235,2143,3054,3128,5288,5583,5688,6109,6367,6525,6541,6635,5214,6445,6316' ,@Count1 int ,@Count2 int ,@ThreeMonthSaleNum1 int= 1
if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#tb_Amazon_OrderSourceIDs') and type='U'))
drop table #tb_Amazon_OrderSourceIDs
create table #tb_Amazon_OrderSourceIDs (Id int primary key)
insert into #tb_Amazon_OrderSourceIDs
SELECT CONVERT(INT, item) as Id FROM Charsplitforin('13331,13330,13295,13267,13258,13257,13229,13228,13226,13225,13223,13222,13221,13220,13219,13218,13217,13216,13215,13201,13200,13199,13195,13194,13191,13188,13187,13174,13173,13172,13171,13170,13168,13167,13159,13155,13154,13153,13151,13149,13148,13147,13146,13145,13144,13142,13140,13138,13137,13136,13135,13134,13133,13132,13131,13124,13123,13120,13117,13116,13115,13114,13113,13105,13104,13103,13102,13101,13100,13099,13098,13091,13090,13087,13084,13083,13082,13081,13080,13076,13075,13074,13073,13072,13071,13070,13069,13046,13045,13044,13042,13038,13028,13027,13026,13025,13023,13020,13019,13018,13017,13016,12983,12982,12977,12972,12971,12925,12924,12921,12918,12917,12916,12915,12914,12815,12814,12813,12812,12810,12809,12808,12786,12785,12784,12782,12780,12779,12778,12777,12776,12775,12768,12766,12764,12763,12761,12749,12748,12747,12746,12745,12744,12742,12741,12740,12739,12738,12737,12721,12706,12705,12702,12699,12698,12697,12696,12695,12691,12690,12687,12685,12684,12683,12682,12681,12680,12639,12638,12637,12636,12635,12633,12632,12631,12629,12628,12627,12611,12610,12591,12566,12565,12561,12559,12558,12557,12556,12555,12554,12546,12545,12544,12530,12496,12495,12492,12490,12488,12487,12486,12485,12476,12475,12474,12473,12468,12467,12466,12465,12463,12014,12013,12012,12011,12010,12009,12003,12002,12001,11993,11992,11991,11975,11973,11972,11971,11970,11969,11966,11965,11964,11962,11961,11959,11952,11946,11944,11934,11903,11902,11899,11898,11897,11893,11892,11891,11890,11889,11888,11887,11886,11885,11884,11883,11881,11880,11877,11876,11875,11874,11873,11872,11871,11870,11869,11868,11867,11866,11865,11864,11862,11861,11860,11859,11858,11857,11856,11855,11854,11852,11851,11848,11841,11840,11839,11838,11837,11836,11835,11834,11833,11832,11831,11830,11828,11826,11825,11824,11823,11822,11821,11820,11818,11817,11800,11799,11798,11795,11794,11793,11792,11790,11789,11759,11758,11757,11756,11745,11742,11741,11738,11731,11727,11726,11725,11724,11723,11722,11721,11717,11715,11713,11712,11710,11709,11708,11706,11703,11702,11683,11682,11681,11680,11679,11678,11677,11676,11674,11672,11651,11650,11649,11648,11647,11646,11645,11644,11638,11637,11625,11624,11622,11621,11620,11616,11613,11612,11611,11610,11608,11607,11606,11605,11604,11603,11601,11597,11596,11595,11594,11584,11583,11582,11579,11576,11572,11571,11570,11569,11568,11567,11566,11565,11564,11558,11557,11556,11555,11552,11551,11550,11548,11544,11543,11541,11540,11537,11536,11532,11528,11526,11525,11524,11522,11521,11513,11512,11510,11509,11508,11507,11506,11505,11504,11499,11498,11497,11496,11495,11494,11493,11491,11490,11489,11488,11487,11486,11485,11484,11483,11482,11481,11480,11479,11478,11477,11476,11475,11474,11473,11472,11471,11470,11469,11468,11466,11464,11463,11462,11461,11450,11449,11441,11440,11439,11438,11437,11435,11434,11428,11427,11426,11425,11424,11423,11422,11421,11407,11406,11405,11404,11401,11400,11399,11398,11396,11394,11393,11392,11391,11390,11389,11388,11387,11365,11363,11362,11361,11359,11357,11351,11345,11344,11340,11338,11336,11335,11330,11329,11328,11327,11326,11325,11324,11323,11322,11318,11317,11316,11311,11307,11302,11301,11296,11292,11291,11289,11285,11284,11283,11282,11281,11280,11279,11278,11277,11276,11272,11267,11264,11263,11261,11259,11258,11257,11256,11255,11249,11248,11246,11245,11243,11242,11239,11234,11232,11231,11230,11229,11228,11227,11226,11213,11211,11210,11207,11206,11205,11204,11203,11202,11201,11199,11198,11194,11192,11191,11190,11188,11187,11186,11185,11184,11183,11181,11180,11179,11178,11176,11171,11170,11169,11168,11167,11166,11164,11163,11161,11160,11159,11158,11157,11156,11155,11154,11151,11147,11146,11143,11142,11141,11139,11138,11137,11136,11135,11134,11133,11132,11131,11130,11129,11128,11126,11124,11123,11122,11120,11118,11116,11115,11113,11112,11111,11110,11108,11102,11100,11098,11097,11096,11095,11094,11093,11092,11091,11090,11089,11088,11087,11086,11085,11084,11051,11034,11022,11021,11018,11016,11015,11010,10994,10992,10991,10990,10989,10988,10986,10981,10979,10978,10977,10976,10975,10972,10971,10970,10965,10960,10954,10953,10952,10929,10928,10927,10926,10923,10922,10921,10920,10919,10918,10917,10916,10914,10912,10911,10910,10909,10908,10905,10902,10901,10900,10899,10898,10897,10896,10895,10894,10893,10892,10891,10890,10889,10887,10884,10881,10879,10878,10876,10875,10874,10873,10871,10870,10869,10868,10867,10866,10865,10864,10863,10862,10861,10859,10858,10855,10854,10853,10851,10850,10849,10848,10847,10846,10845,10844,10837,10835,10827,10826,10818,10814,10812,10809,10804,10801,10800,10799,10773,10772,10771,10770,10769,10768,10767,10766,10765,10764,10763,10758,10757,10754,10753,10751,10749,10748,10746,10745,10744,10743,10742,10741,10740,10739,10738,10737,10717,10710,10709,10708,10567,10565,10560,10558,10556,10555,10554,10551,10550,10549,10548,10547,10543,10542,10541,10540,10539,10538,10537,10536,10535,10534,10533,10532,10531,10530,10529,10528,10527,10526,10525,10524,10496,10485,10467,10453,10450,10433,10431,10430,10429,10428,10427,10424,10420,10414,10398,10397,10395,10387,10386,10382,10381,10380,10378,10375,10374,10367,10366,10365,10364,10361,10360,10359,10358,10357,10356,10355,10353,10351,10350,10349,10348,10347,10346,10345,10344,10343,10336,10330,10329,10327,10320,10319,10318,10317,10316,10315,10313,10312,10311,10310,10309,10308,10292,10291,10290,10289,10288,10285,10284,10283,10281,10280,10278,10266,10265,10264,10263,10256,10254,10253,10252,10251,10247,10246,10245,10230,10187,10138,10137,10106,10095,10094,10089,10088,10087,10086,10084,10083,10082,10081,10080,10079,10075,10074,10073,10072,10071,10070,10069,10068,10067,10066,10065,10064,10063,10062,10061,10059,10058,10054,10053,10050,10049,10048,10047,10046,10045,10043,10038,10037,10036,10034,10033,10030,10029,10028,10027,10024,10023,10022,10008,10007,10006,10005,10004,10003,10002,10001,9968,9966,9965,9961,9959,9958,9957,9956,9952,9950,9949,9945,9928,9927,9924,9922,9921,9920,9919,9918,9917,9916,9915,9914,9913,9910,9908,9905,9903,9901,9900,9892,9891,9890,9889,9888,9887,9886,9885,9884,9882,9881,9877,9876,9875,9874,9873,9872,9871,9870,9869,9868,9867,9866,9865,9863,9862,9861,9860,9859,9858,9857,9855,9854,9853,9852,9851,9850,9839,9838,9837,9836,9835,9834,9833,9832,9831,9830,9829,9828,9827,9826,9825,9824,9823,9822,9821,9817,9816,9810,9807,9806,9805,9804,9801,9800,9799,9792,9789,9788,9787,9786,9785,9782,9781,9780,9777,9776,9775,9773,9772,9771,9770,9769,9768,9767,9766,9749,9748,9714,9713,9712,9711,9705,9704,9703,9702,9701,9700,9698,9697,9696,9695,9694,9693,9692,9691,9690,9679,9670,9669,9664,9663,9662,9661,9654,9653,9652,9651,9650,9649,9648,9647,9645,9643,9641,9640,9626,9624,9623,9622,9619,9618,9617,9616,9615,9614,9613,9612,9611,9610,9608,9606,9605,9604,9603,9602,9601,9600,9598,9597,9596,9595,9594,9593,9592,9589,9588,9587,9586,9585,9583,9582,9580,9579,9578,9577,9572,9568,9567,9566,9565,9562,9557,9556,9555,9554,9553,9551,9550,9548,9547,9546,9545,9544,9536,9535,9534,9533,9532,9531,9530,9529,9528,9526,9525,9524,9523,9522,9512,9511,9510,9509,9503,9496,9495,9494,9493,9492,9491,9490,9489,9488,9487,9486,9484,9483,9482,9481,9480,9479,9478,9477,9476,9475,9470,9469,9468,9467,9466,9460,9459,9458,9457,9456,9455,9454,9453,9452,9451,9450,9449,9448,9447,9440,9439,9438,9437,9436,9428,9426,9425,9423,9422,9421,9420,9419,9417,9416,9415,9414,9412,9407,9406,9380,9379,9364,9363,9362,9361,9303,9302,9301,9300,9298,9297,9296,9295,9294,9293,9292,9291,9290,9289,9288,9287,9286,9285,9284,9283,9272,9271,9263,9258,9257,9243,9242,9241,9240,9239,9237,9236,9235,9226,9225,9224,9223,9222,9219,9218,9217,9216,9215,9211,9210,9209,9208,9207,9206,9205,9176,9175,9174,9173,9172,9171,9170,9169,9168,9167,9165,9164,9163,9162,9161,9160,9159,9158,9157,9156,9155,9154,9153,9152,9150,9149,9148,9147,9146,9140,9139,9138,9137,9136,9130,9129,9128,9127,9126,9125,9124,9123,9121,9120,9119,9118,9117,9114,9113,9112,9108,9107,9099,9098,9097,9090,9089,9088,9087,9086,9085,9084,9083,9082,9080,9079,9078,9077,9074,9070,9069,9068,9067,9066,9061,9057,9047,9040,9039,9038,9037,9036,9034,9033,9032,9031,9030,9029,9028,9027,9025,9021,9014,9013,9012,9011,9010,8990,8989,8987,8959,8958,8957,8956,8955,8947,8930,8928,8927,8926,8925,8924,8862,8861,8860,8859,8858,8857,8856,8855,8854,8853,8852,8851,8841,8838,8696,8695,8694,8693,8692,8687,8679,8677,8676,8674,8640,8639,8637,8636,8621,8620,8619,8618,8616,8615,8614,8612,8611,8609,8606,8605,8570,8567,8565,8564,8563,8560,8559,8558,8557,8556,8553,8552,8549,8543,8541,8522,8519,8518,8517,8511,8505,8501,8499,8498,8496,8495,8494,8493,8492,8491,8490,8487,8485,8477,8476,8475,8474,8473,8472,8471,8465,8463,8462,8461,8460,8458,8457,8456,8455,8450,8449,8448,8446,8437,8428,8423,8414,8413,8412,8411,8410,8407,8405,8403,8393,8390,8382,8381,8380,8379,8378,8377,8376,8366,8362,8357,8353,8351,8350,8349,8348,8347,8346,8345,8339,8336,8260,8259,8258,8257,8256,8255,8254,8253,8252,8251,8250,8249,8248,8247,8246,8245,8244,8243,8242,8157,8155,8151,8149,8148,8147,8140,8137,8131,8126,8125,8124,8123,8122,8119,8118,8116,8114,8113,8112,8111,8101,8099,8098,8097,8096,8095,8094,8093,8092,8078,8077,8076,8075,8074,8073,8072,8071,8070,8068,8067,8066,8059,8058,8057,8056,8039,8037,8036,8034,8033,8031,8024,8023,8018,8017,8013,8012,8011,8010,8002,8001,8000,7999,7998,7997,7996,7995,7980,7979,7978,7977,7976,7956,7955,7954,7953,7950,7948,7946,7945,7944,7942,7936,7935,7934,7933,7932,7931,7930,7929,7928,7927,7926,7925,7924,7923,7922,7905,7904,7903,7902,7901,7900,7898,7897,7893,7892,7891,7890,7760,7759,7755,7754,7753,7752,7751,7749,7740,7739,7721,7720,7719,7716,7714,7713,7712,7711,7710,7708,7707,7706,7704,7702,7698,7527,7521,7519,7518,7517,7516,7515,7514,7513,7512,7511,7443,7442,7421,7398,7397,7396,7395,7394,7392,7391,7389,7388,7387,7386,7383,7382,7379,7378,7377,7376,7375,7369,7368,7367,7366,7364,7363,7362,7361,7360,7359,7357,7298,7297,7296,7289,7198,7192,7175,7170,7169,7168,7167,7166,7165,7164,7163,7162,7160,7159,7158,7157,7121,7119,7116,6964,6963,6961,6960,6959,6955,6954,6953,6952,6951,6950,6949,6943,6941,6940,6939,6938,6937,6936,6935,6934,6933,6932,6931,6930,6929,6928,6927,6926,6925,6924,6923,6922,6921,6919,6918,6917,6916,6915,6912,6911,6910,6909,6908,6907,6906,6904,6903,6902,6901,6899,6895,6891,6890,6888,6887,6886,6885,6884,6883,6882,6872,6871,6870,6869,6868,6867,6866,6837,6835,6809,6808,6807,6806,6777,6776,6756,6755,6754,6702,6701,6700,6698,6697,6696,6691,6690,6689,6688,6687,6675,6674,6673,6672,6671,6670,6669,6660,6659,6658,6652,6646,6645,6644,6643,6642,6641,6640,6639,6638,6625,6623,6622,6621,6620,6619,6618,6616,6615,6614,6613,6611,6609,6608,6607,6600,6599,6598,6596,6594,6593,6592,6591,6585,6574,6573,6572,6571,6570,6564,6563,6561,6559,6558,6556,6555,6554,6553,6552,6551,6550,6516,6515,6514,6513,6511,6510,6507,6499,6485,6484,6479,6464,6440,6439,6438,6437,6436,6433,6400,6399,6381,6275,6268,6267,6266,6265,6264,6263,6260,6238,6237,6236,6228,6173,6159,6158,6157,6156,6155,6154,6153,6151,6150,6149,6148,6146,6144,6143,6142,6141,6140,6139,6137,6123,6116,6115,6114,6113,6112,6111,6110,6109,6108,6107,6106,6105,6104,6103,6102,6101,6100,6099,6098,6097,6096,6095,6094,6093,6092,6090,6088,6087,6086,6085,6084,6083,6082,6081,6080,6079,6078,6077,6076,6075,6073,6072,6071,6070,6069,6068,6067,6066,6065,6064,6063,6062,6061,6060,6058,6057,6056,6055,6054,6051,6050,6049,6043,6042,6041,6040,6039,6038,6037,6036,6035,6033,6032,6031,6030,6029,6028,6027,6026,6025,6024,6023,5955,5954,5953,5952,5951,5949,5948,5946,5944,5813,5809,5783,5781,5780,5779,5777,5776,5774,5773,5771,5770,5769,5768,5767,5766,5764,5754,5753,5751,5750,5749,5748,5747,5746,5745,5744,5743,5742,5741,5740,5738,5734,5733,5716,5714,5712,5711,5706,5705,5691,5685,5684,5679,5676,5675,5673,5672,5671,5670,5669,5668,5666,5665,5664,5663,5661,5660,5657,5647,5645,5641,5640,5637,5636,5635,5634,5633,5632,5631,5628,5627,5626,5625,5610,5609,5608,5607,5606,5605,5604,5603,5587,5586,5585,5582,5581,5580,5579,5578,5577,5576,5575,5574,5573,5572,5571,5570,5568,5567,5566,5565,5564,5563,5556,5553,5552,5538,5537,5534,5533,5515,5514,5505,5504,5486,5485,5482,5481,5478,5477,5475,5473,5472,5471,5470,5469,5468,5467,5466,5465,5464,5463,5462,5461,5460,5457,5456,5454,5452,5451,5446,5444,5443,5442,5440,5439,5438,5437,5435,5408,5407,5406,5405,5397,5396,5395,5390,5389,5385,5377,5376,5374,5368,5367,5348,5341,5337,5334,5333,5332,5327,5326,5288,5277,5276,5256,5254,5251,5249,5248,5203,5202,5201,5200,5199,5194,5193,5192,5191,5189,5188,5187,5185,5183,5132,5125,5123,5117,5109,5105,5098,5095,5094,5093,5075,5073,5042,5018,5014,5007,5004,3000,12448,12447,12444,12440,12439,12438,12436,12435,12434,12433,12427,12426,12425,12424,12410,12408,12407,12406,12405,12404,12403,12398,12397,12395,12394,12393,12392,12391,12390,12370,12369,12366,12363,12362,12361,12360,12341,12334,12325,12323,12313,12287,12286,12285,12284,12283,12282,12271,12270,12269,12267,12266,12265,12262,12261,12260,12259,12248,12245,12244,12243,12240,12236,12229,12219,12218,12217,12216,12205,12204,12201,12200,12199,12197,12196,12195,12194,12187,12185,12177,12176,12155,12146,12145,12144,12141,12138,12133,12131,12129,12128,12124,12123,12121,12120,12119,12118,12117,12114,12113,12112,12111,12110,12109,12108,12107,12106,12100,12085,12082,12070,12069,12068,12060,12059,12058,12057,12052,12051,12049,12048,12047,12045,12044,12038,12021,8363,12811,10752,7703,5005,6612,6091,6089,12588,10747,11240,5059,6059,6549,9856,6942,10057,13332,5272,7921,5267,5765,9848,5266,5667,7197,7156,8832,9020,9299,6805,9166,9508,8030,7358,9979,10085,9971,9947,9946,8642,8599,8598,8597,8573,8572,8569,8568,8548,8525,8516,8515,8524,8540,8544,8689,8602,8595,8574,9980,9978,9975,8400,8310,7440,7290,8422,8409,8408,8406,8404,8402,8401,8399,8396,8395,8394,8392,8375,8373,8365,8364,8156,7878,7839,7837,7835,7832,7831,7830,7829,7828,7827,7826,7825,7824,7822,7821,7770,7769,7748,7726,7724,7723,7700,7293,8555,6048,12979,13271,9563,9564,9035,5383,6617,6948,8035,8065,11173,7899,8374,12230,10044,9607,8115,9081,11286,12727,12728,12729,12730,12731,12732,13224,12733,12734,7118,8613,12450,8032,12984,10883,10199,10198,10454,11459,9007,10924,10843,13157,8691,8038,7823,6407,6406,12783,13047,13169,11714,11220,11219,11218,11217,11216,11215,12462,7295,12980,11974,13022,13041,6486,10328,9055,12399,12401,12402,12400,12494,12497,12493,12491,12553,12551,12552,6781,7286,9747,12692,12689,12688,12686,12743,12136,12464,9864,11675,5782,11827,9621,12186,8386,9969,12234,13021,12803,12919,13040,11816,11609,11436,10277,12634,13156,11312,5375,11140,13150,10459,10735,13024,12781,12050,11397,11208,9429,8467,8466,8464,11175,12978,12132,13152,12461,12428,12442,12549,5483,5484,13268,11534,11531,9212,6657,13541,13540,13539,13520,13513,13512,13500,13468,13467,13466,13449,13447,13445,13443,13439,13432,13426,13424,13419,13418,13417,13415,13412,13411,13410,13409,13408,13407,13406,13405,13397,13396,13395,13376,13375,13374,13373,13372,13343,13342,13341,13340,13339,13338,13337,13336,13335,13334,12767,11801,11803,11805,11806,11807,11808,11810,11811,11813,12075,13516,12675,12674,12673,12672,12671,12670,12669,12668,12667,12666,12665,12664,12663,11502,11501,11500,11458,11457,11456,11455,11454,11109,8469,8453,11150,8451,13275,12272,12258,12257,12573,12572,12318,11664,11380,11379,11378,11377,11376,12071,8520,6446,11665,11148,10980,8468,8130,8129,8128,8127,9266,12249,11321,11225,9798,9434,9433,9432,9431,12073,10388,10275,11652,13515,11592,13477,12550,12787,13497,11802,13559,13272,13534,12137,12139,12140,11127,13431,8641,11332,11241,11976,11743,11739,11705,11523,11200,10564,12061,13446,13613,13612,13596,13615,13614,13594,13593,13617,8617,10026,10025,12126,13595,13629,13623,13622,12127,13398,11578,13377,8836,8835,8833,13107,11145,13414,11850,10886,11849,11842,11614,5701,5690,12016,11853,11845,11844,11707,9819,9591,8447,5702,9820,9818,11843,11615,9699,5707,13214,12765,12762,11847,11846,13444,11602,12104,12736,12105,7701,11511,11554,12053,12460,13511,12459,12458,13296,13448,13440,8834,13494,9435,9644,7287,9970,9912,6562,5517,5402,5401,5400,5399,13597,9953,9954,13702,13701,13700,13690,13663,13662,13624,13619,13610,13609,13605,13604,13603,13602,13601,13600,13599,13592,13590,13586,13585,13584,13580,13579,13578,13576,13575,13574,13573,13570,13569,13568,13567,13566,13565,13564,13560,13547,13519,13518,13517,8016,8015,8014,6152,8638,13628,13627,13626,13581,13582,13583,12756,13126,13093,13118,12385,13587,13588,13589,12926,12923,12922,12920,13097,13095,13096,13094,13130,13129,13127,13128,11671,13239,13495,10293,13469,13470,13471,13085,12134,11530,8554,13811,13809,13808,13807,12264,9561,9560,9559,9558,6655,6138,10736,13533,13476,13496,6405,11696,11690,11684,11685,11686,11687,11688,11689,11691,11692,11693,11694,12125,13475,13499,7161,11863,13290,13529,13528,13527,11791,11106,11105,11104,10462,12437,7117,12263,11287,11117,10490,10324,10323,10321,10322,10325,11882,13780,13709,13785,9911,11448,11349,5763,5775,11960,13563,13562,13561,5520,5164,11395,10417,10039,11878,11879,12268,13043,13667,13598,13425,11804,13810,11107,12015,11819,5739,5544,8523,10813,13577,12135,9977,10042,7750,9849,13799,10297,10296,10295,10294,5091,10040,8391,13661,13778,10041,5384,10060,6900,9549,13535,12469,13526,13525,13524,13416,6610,13784,13779,13394,13536,13782,12540,12537,10880,9571,12539,12538,9273,11319,9904,12191,12192,12193,13227,13420,13301,13300,13299,13297,11290,11212,11114,9507,9506,9505,10750,5403,13298,8139,6892,7949,7390,5643,14470,14469,14468,10032,7943,13478,9976,11262,11963,12630,11553,13671,13669,13668,13664,13616,13039,13037,13036,13035,9955,9951,6450,6451,11958,11957,11956,11955,11953,11951,5678,11954,11247,11341,14467,13781,13034,5051,11364,11125,10982,10416,8678,8562,6699,12017,9581,8566,11193,8988,14574,13591,13313,14593,13618,12232,12103,9234,9238,11403,11269,9504,7880,6656,6443,6442,12092,12091,12089,10078,10077,10076,10052,10051,9584,7385,7384,6595,13665,12389,12388,12387,12386,12371,12368,12367,12365,13158,13775,13774,13773,13768,14359,14358,14356,14355,14352,14348,14347,14346,14343,14342,14341,14340,14339,14338,14337,14336,14335,14334,14333,14332,14330,14327,14326,14325,14324,14323,14322,14321,14320,14319,14317,14316,14314,14313,14312,14311,14310,14309,14308,14307,14306,14305,14304,14303,14302,14301,14300,14295,14294,14293,14292,14291,14290,14289,14288,14287,14286,14285,14284,14283,14280,14278,14088,14087,14086,14076,14075,14074,14073,14071,14070,13926,13924,13923,13922,13921,13920,13919,13918,13916,13915,13913,13912,13911,13910,13908,13907,13905,13904,13903,13900,13898,13878,13872,13871,13870,13869,13868,13867,13866,13865,13864,13863,13862,13860,13859,13853,13852,13851,13850,13849,13848,13847,13846,13845,13844,13843,13842,13841,13840,13839,13838,13837,13836,13835,13834,13830,13829,13828,13827,13826,13825,13824,13823,13822,13821,13820,13819,13818,13817,13816,13815,13814,13813,13812,13798,13797,13786,14646,14645,14643,14642,14641,14636,14635,14634,14633,14617,14616,14615,14601,14600,14599,14592,14591,14590,14589,14583,14582,14581,14580,14579,14578,14577,14576,14573,14572,14571,14570,14569,14568,14567,14566,14565,14564,14563,14562,14561,14560,14559,14558,14557,14556,14555,14554,14553,14552,14551,14550,14546,14545,14544,14543,14542,14539,14538,14537,14536,14534,14533,14532,14531,14530,14527,14526,14525,14524,14523,14522,14521,14520,14518,14513,14512,14511,14510,14509,14508,14507,14506,14505,14504,14503,14502,14501,14500,14499,14498,14497,14496,14495,14494,14487,14486,14485,14484,14483,14482,14481,14480,14479,14478,14477,14476,14475,14474,14473,14472,14471,14462,14449,14448,14447,14441,14440,14439,14435,14433,14432,14431,14418,14417,14416,14413,14412,14409,14408,14407,14371,14370,14369,14368,14367,14366,14365,14364,14363,14362,14361,14360,14586,14596,14612,13902,14282,10987,13498,12457,13800,11797,11796,12760,12759,12758,12757,12807,12806,12805,12804,13125,13122,13121,13119,13092,13086,13088,13089,13243,13242,13241,13240,14690,14689,14688,14638,14682,14681,14679,14678,14677,14675,14691,14693,13858,14426,10031,13294,13293,13292,13291,14345,13861,13909,13917,14698,14697,14673,5167,5166,5165,14742,14741,14740,14739,14738,14737,14736,14734,14728,14726,14725,14724,14723,14722,14721,14720,14718,14717,13572,14402,14748,14749,14519,14753,5373,14777,14774,14773,14772,14771,14765,14764,14762,14761,14760,14759,14754,13887,14349,14415,14438,14787,10276,14644,7725,14676,10948,14819,14818,14817,14816,14815,14814,14807,14806,14805,14804,14799,14798,14797,14796,14795,14794,14788,14823,14822,14820,11740,5108,6557,10915,10872,10557,10363,5642,9151,9542,9543,9620,9625,9627,9628,9629,11695,14831,14830,14829,14843,14842,14841,14835,14834,14833,14832,14855,14854,14853,14849,14848,14847,14846,14845,14844,14851,9022,9024,9023,9446,10128,10249,10250,10282,10856,11009,11343,11549,5247,7894,7896,6147,6757,7510,9109,9110,11177,11981,14353,14867,14866,14865,14861,14859,14858,14857,14856,14887,14886,14879,14878,14877,14876,11533,11527,14894,5639,5730,5630,11988,14895,14727,14826,14838,14907,14906,14905,14903,14901,14899,14898,14896,14897,14891,14889,14888,5629,14733,13480,10415,14908,13666,13670,12180,12179,12178,11254,11253,11252,11251,14926,14925,14924,14923,14922,14921,14920,14915,14914,14913,14912,14911,14793,14790,14813,14931,14930,14929,14928,14752,14927,14692,14630,14719,13648,13654,11460,10984,13649,13479,12543,12542,13653,13652,13651,11939,9006,9005,13655,12541,12548,10354,14776,14775,14935,14934,14932,14943,14942,14941,14954,14953,14952,14072,14810,14973,14972,14970,14763,14756,14985,14983,14984,14974,14975,14976,14977,14978,14979,5677,9883,14902,14595,15003,15002,15001,15000,14997,14996,14995,14994,14993,14992,14991,13899,14279,14938,14988,8992,13772,13770,13769,14329,5522,15009,14933,15042,15041,15040,15039,15038,15037,15036,15035,15032,15031,15030,15028,15027,11331,11172,9667,6034,5252,14350,10888,10885,10314,10906,10561,6597,5704,14351,10396,7526,9599,7718,7717,7715,13650,14789,8625,8624,8623,8622,11433,11432,11431,11430,13660,13659,13658,13657,13892,5253,5255,9270,9570,9646,12536,10568,11320,11711,5713,5715,9003,9004,14611,13771,9008,9009,9902,10882,11529,10035,12202,15051,15050,15049,15017,15016,15015,15014,5269,5325,10852,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,14885,14882,14821,14850,14917,15060,15047,15044,15068,15067,15066,15065,11144,15081,15080,15079,15078,15074,15073,15072,15071,15070,11809,15034,15029,15046,15033,15099,15098,15097,15096,15091,15093,15092,15090,15089,15088,14614,14588,14598,14640,6052,14434,14411,14315,14069,14328,10379,15118,15119,15121,15122,15123,15124,15125,15126,15127,15129,15130,15131,15132,15133,15134,15135,15136,15137,12981,15076,6783,6782,15108,15111,15112,15113,15114,15115,15069,14680,14687,14685,13901,14281,15143,15145,15144,15141,15140,7705,5176,5177,5178,5250,14318,14344,14357,14331,15085,15084,15083,15082,14803,14802,14801,14800,14971,14437,14828,14840,14758,14770,15154,15153,15152,15151,15150,15147,15148,9259,9260,9261,9100,8452,8454,13501,7365,14767,14825,14837,11812,5674,7709,8561,14863,14862,15110,14535,14768,15095,14980,14981,11673,15077,8069,15149,15094,15120,15128,5305,5306,5307,5308,5086,15189,15188,15187,15186,15183,15182,15181,15180,15179,15178,15173,15174,15175,15168,15169,15171,15172,15201,15200,15199,15198,15197,15195,15194,15193,15192,15191,15190,15213,15212,15211,15210,15209,15208,15207,15206,15205,15203,15202,14694,15222,15221,15220,15219,15218,15216,15215,14881,14755,15230,15229,15228,15227,15226,15224,15223,9269,15238,15237,15236,15235,15234,15232,15231,15239,15240,15242,15243,15247,15245,15246,15248,15249,15250,14884,14792,15244,13611,13186,13185,13184,12484,12483,12482,12481,12480,12479,12478,12477,11968,11967,15185,11560,11542,11538,11358,11342,11539,11233,10000,9552,8571,8117,15184,14684,14632,14585,14637,14629,15170,15142,15167,15176,15177,15270,15269,15268,15267,15266,15264,15263,15262,15261,15260,15259,14809,15258,15257,15256,15255,15254,15252,15251,15233,15217,15280,15279,15278,15277,15276,15274,15273,10762,15265,11753,11752,11751,11750,11749,11748,11747,11746,15281,15285,15286,15204,15225,15196,15241,15275,14414,14672,15289,15287,15288,14987,15075,15045,11728,15253,15323,15322,15321,15320,15319,15318,15317,15316,15315,15314,15313,15312,15310,15309,15326,15327,15328,15329,15330,15331,15332,15333,15334,15335,15336,15337,15338,15339,15340,10877,8837,10055,10056,10229,10857,14919,14990,14940,15343,15345,15346,15347,15348,15352,15350,15351,15353,15354,15355,15356,5404,12359,12364,12472,15359,15349,14628,11429,14766,14354,14880,14836,14603,14604,14606,14607,14608,14609,13532,14602,14631,14605,14686,14769,14757,14791,14827,14883,14839,14639,14613,14587,14597,14406,14405,14404,14403,14430,14429,14428,14427,15311,15376,15375,15382,15384,11829,11503,11214,11250,11260,11375,12700,10326,12130,11492,13064,11788,13656,11720,12722,13189,13914,13906,5304,14989,15109,12090,6512,13413,9076,9096,9106,9116,14732,15402,15342,15417,15416,15415,15414,15413,15412,15411,15410,15409,15407,15408,15406,15157,15431,15430,15429,15428,15427,15433,15434,15403,15404,15443,15442,15441,15439,15437,15436,15440,15444,15458,15457,15456,15455,15454,15453,15452,15451,15450,15449,15448,15447,15446,15445,15459,15460,15461,15462,15463,15435,15383,5516,15341,14918,14939,15303,15465,15374,15373,15372,15371,15370,15369,15368,15367,15366,15365,15364,15363,15362,15361,15360,15468,15469,15470,15471,15473,15474,15475,15405,14436,15048,15476,15477,14824,14584,14731,14811,9842,15492,15491,15490,15488,15487,15486,15485,15484,15483,15482,15481,15479,15504,15503,15502,15501,15500,15499,15498,15497,15496,15494,15493,14860,5558,11101,10352,5611,15506,5562,5561,5560,15344,15478,15489,11563,11099,10959,9418,8482,8043,8042,8041,8040,15512,15513,15514,15515,15516,15517,15518,15519,15520,15521,15522,15523,15526,15525,15524,15438,15527,14946,14947,14951,14950,14949,14945,14944,14714,14713,14890,14750,14700,13895,13894,13893,13891,13890,13889,13888,13877,13876,13873,13874,13875,13514,13430,13429,13428,14715,14716,12072,7196,6449,6448,14936,14683,14610,14594,13068,13067,13066,13065,13193,13192,13190,13196,12726,12725,12724,12723,12704,12703,12701,12707,12432,12431,12430,12429,12446,12445,12443,12449,9199,9200,9201,9202,14916,14937,15540,15541,15542,15543,15544,15545,15547,15546,15548,15549,15550,15551,15552,15553,15554,15555,15556,10860,14808,14900,14735,14812,14852,14864,14904,14948,14982,15425,15426,15432,15480,15495,15557,15558,14699,13783,-1', ',')
SELECT CONVERT(INT, item) AddAdminID into #tmpAddminID FROM Charsplitforin(@UpAddAdminID, ',');
select count(0) from [RB_Amazon_Product_Base] (nolock) vtb
INNER JOIN #tb_Amazon_OrderSourceIDs IDS on vtb.OrderSourceID=IDS.Id
inner join #tmpAddminID addID on addID.AddAdminID=vtb.AddAdminID
WHERE vtb.CustomerID=@CustomerID AND vtb.IsDelete=0
and vtb.AddTime between @InputTimeB and @InputTimeE
and ThreeMonthSaleNum>=@ThreeMonthSaleNum1 and isnull(IsOffShelf,0)<>3 and vtb.OrderSourceSKUID>0 option(maxdop 8);
drop table #tmpAddminID;
