1.问题分析
魏鹏军反馈，亚马逊listing查询慢sql
查询有230列，12个表联接查询,
1.分析了我们的erp 亚马逊listing 查询，最大展示70列，这里为什么查询输出230列，已让开发核实业务情况
2. where 负向查询and isnull(IsOffShelf,0)<>3 ，可以改为 and IsOffShelf in(0,1,2,4,5) 走索引 --看表里IsOffShelf 值为0，1，2，3，4，5，需和业务确认
备注：这是一个典型的多列，大表，多表联查的例子，等开发确认后再进行第2次优化
2.SQL
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('5100,5657,5538,5537,5347,5344,5343,5638,5153,5152,5052,5039,5037,5019,5311,5309,5552,5514,5394,5393,5173,5172,5171,5168,5074,5430,5151,5298,5296,5295,5132,5783,6111,6139,5215,5214,5213,5083,5360,5359,5358,5357,5356,5260,5220,5219,5218,5948,5949,5110,5133,5181,5111,5076,5197,5112,6381,6723,6722,6721,6720,6719,6891,6928,6927,5754,5753,5572,5571,5568,5567,5566,5565,5564,5563,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,5390,5389,5385,5348,5341,5337,5334,5333,5332,5194,5193,5192,5191,5189,5188,5187,5185,5183,6716,6715,5734,5733,5570,6867,5668,5148,6611,5198,5312,5297,5216,6775,6499,6485,6484,5691,6267,6045,6766,5920,5661,5660,5647,5429,5326,5294,5288,5710,5708,7357,6717,6714,6555,6906,6907,5764,5781,5094,5040,5346,5313,5217,6718,5352,5354,7389,7364,7363,7443,5042,6263,5679,5322,6433,5766,7198,5327,7967,7948,7893,5310,8017,7952,7951,6943,7421,6767,6765,6764,6763,5098,6556,5075,6866,7774,5515,7983,8155,6554,6925,6173,6104,5741,5740,8053,8052,8044,6733,6732,6731,6730,6729,6728,6727,6726,6725,6724,5073,8366,5490,5489,5488,6237,5351,5424,5751,5428,5666,5777,5665,5776,6934,5521,8063,8062,8061,8060,8428,6487,7776,7984,5093,6923,5505,5504,5582,5581,5604,5603,5609,5608,5944,6137,6607,6510,6511,7201,7704,8114,8113,8112,8111,7936,7922,7905,8242,6899,8120,8121,5426,5664,5749,8397,8477,8486,5750,8476,5425,8498,8496,8495,8494,8552,8553,6835,7904,6123,8499,5955,6088,6100,6116,6144,6159,6645,6675,6809,7514,5953,6098,6114,6142,6150,6157,6514,6614,6673,6807,5954,6099,6115,6143,6151,6158,6615,6644,6674,6808,7159,8343,8319,6616,5779,5780,8497,8321,8320,8501,8463,8462,8461,8460,6033,6032,6936,6935,8029,8028,8027,8025,7764,8522,8260,8259,8045,8046,8054,8692,8913,8928,8924,8925,8926,8927,8857,5533,8987,6658,8861,8862,6083,5586,6087,6646,5099,6854,8947,9047,8959,8958,8957,8956,8955,8855,8854,8853,8852,8851,8838,8670,8669,8668,8667,8666,8665,8664,8663,8662,8661,8660,8659,8658,8657,8656,8630,8629,8628,8627,8626,8488,8484,8483,8458,8457,8456,8455,7760,9483,9482,5587,9533,9521,9520,9519,9518,9517,9534,9535,6941,8930,7765,6660,6563,9114,7387,9113,9112,9624,8411,6922,6702,7935,9655,9652,9650,9649,9647,9645,9643,9642,6659,8634,9379,9789,6564,9653,8633,6050,6068,6066,6042,6043,6041,9070,7927,8564,9712,9692,8594,6400,6399,5543,7714,7712,7710,9137,9810,6593,9209,9208,9207,9886,9884,9885,6265,9662,9690,9691,9704,9705,9748,9792,9711,9663,9572,9074,9244,9827,9826,9825,9824,9823,9822,8827,8830,6106,6869,7157,7359,7376,7395,7706,7900,7711,7924,9067,6916,6806,6938,6592,6513,6437,6065,6049,6040,5952,5774,8674,8693,7762,7763,9210,9669,9919,9914,8570,8047,8055,8322,9922,9920,9918,9915,10069,10068,10067,10066,10065,10064,10063,10062,10061,9906,9907,9176,8632,8635,9452,5487,7367,7925,9068,9469,7158,7761,6060,6061,6062,6063,6613,6642,6672,6930,6931,6932,6933,6901,6902,6903,6904,6909,6910,6911,6912,7163,7164,7165,7366,7368,7369,7511,7719,7720,7721,8556,8557,8558,9245,6070,6055,8828,6919,8565,6918,8475,7362,7398,6058,7903,7379,9080,9248,5585,8474,6071,6056,7377,7707,7901,7396,9246,8473,7397,6057,9247,9302,8472,9494,9493,9492,7891,6754,6690,6689,6652,6640,6625,5745,5744,5743,5738,6691,6301,10187,10230,9449,8606,5610,5117,9927,9928,5684,10307,10306,10304,10278,10188,6964,6960,6963,5716,6238,8859,6236,6266,6275,8989,6268,9781,10303,10263,10246,10137,10138,10355,9546,9548,9966,9140,9138,9364,9363,9362,5631,5632,6561,10397,8013,6573,7902,6067,6051,9547,8098,8097,8096,5769,5770,5768,9425,8024,8092,8147,8118,8491,8243,8244,8246,8247,8248,8249,8339,8490,9026,9027,9028,9029,9030,9031,9032,9484,9550,9551,9553,9588,9589,6515,9608,9610,9612,9613,9614,9713,9800,9838,9839,10256,10319,10320,8377,8381,9147,9148,9149,9150,9219,10071,9286,9287,9288,10070,9766,9767,9292,9768,9769,10075,10072,9582,9604,9605,9670,9961,10088,9696,7993,9695,8018,8251,8254,8255,8256,9616,9077,9078,9079,9085,9084,9083,9082,9090,9087,10347,9804,9129,9128,9127,9126,9125,9124,9243,9295,9296,9297,9298,9615,9770,9771,10247,10351,9416,10348,9417,9476,10346,9890,9477,10349,9478,10350,9479,9480,9965,9526,9525,9524,9523,9555,9557,9562,9876,10049,10050,10281,10033,10087,10038,10086,10288,10289,10290,10291,10292,8026,8078,8077,8076,8074,8073,8149,9697,9531,9529,9821,9972,9910,9654,9600,10344,10089,10030,10024,10023,10265,10054,10053,10364,10313,9578,9703,9422,9157,9158,9159,9160,10043,9773,9772,9300,9301,9303,9406,9407,9651,9421,9777,9440,9439,9438,9437,9467,9468,9470,10424,9799,9580,9585,9586,9593,9587,9619,9701,9626,9702,9595,10036,10084,10345,10315,10316,10365,9426,8614,10356,9481,8990,9921,9648,9448,9949,10095,9841,9847,9854,9855,10283,9862,9863,10058,10284,10398,10298,10317,10318,8100,9428,9805,8070,8348,10386,10253,10254,5109,9806,9807,5276,5367,7297,7759,10382,10450,7378,10427,10375,9241,9958,9852,9836,9831,9837,9853,9104,10359,10366,10387,10430,10431,10414,10429,10395,9817,10467,9950,10255,10234,9929,6516,5771,9205,9170,9169,9168,9167,9959,9957,7926,10526,10527,10529,10530,10531,10532,10533,10534,10535,10536,10537,10538,10525,10524,9089,10550,6622,6620,9488,10558,10555,6698,10541,10343,7708,7945,9069,9861,10381,9283,8560,6700,10428,10252,10251,10106,9872,9866,9865,10245,10008,10007,9460,9459,9458,10709,10710,9414,9583,9913,9891,5580,9454,10420,10565,10528,9706,9240,9851,10771,10770,10772,10380,9795,10748,10800,10827,10548,10717,10818,10799,9606,9622,10551,10453,9216,10046,9871,10083,9869,9217,9844,9860,10047,10081,10027,9218,10048,7361,7360,10873,10874,10876,10878,10879,10844,10846,10847,10848,10849,10850,10851,10853,10854,10855,10858,10864,10869,10870,10871,10865,10866,10867,10868,10863,9496,10921,10910,10929,10928,10927,10917,10914,10912,10909,9475,9870,5481,10902,10899,10897,10975,10918,10989,10988,10953,10952,10916,10920,10923,10919,10922,10960,10972,10976,11010,10978,10977,10971,10485,9859,9835,8064,8631,10837,10965,10981,10983,10991,10992,10954,10908,9412,10737,10757,10758,10547,7170,7169,7168,10567,10560,10556,10360,9877,10034,9577,6154,10037,9554,8541,11051,11100,11097,11095,11092,11088,11087,11086,11085,11016,10549,11131,11128,11126,11124,11151,11149,11136,11133,11159,11158,11156,11155,11166,11165,11164,11171,11192,11191,11187,11186,11184,11180,11178,11147,11138,11142,11146,8351,8350,8349,8345,10743,11120,11113,11022,11210,11213,11118,10080,11116,10745,11018,11108,11021,11206,11230,11226,11227,11228,11229,11231,11234,11292,11291,11289,11285,11283,11282,11280,11279,9457,10310,11316,11329,11239,8126,11328,11327,11345,11276,8382,8380,7729,11207,9415,11123,8037,8413,11307,8410,7755,7754,7753,7749,11335,9618,6924,10861,5251,7995,10862,5125,9887,5007,7192,6090,6094,6095,10766,5249,9924,5123,6093,9487,9617,9873,10900,10374,9785,9172,10767,9495,6585,6574,6756,10543,9882,8687,5946,5746,5248,5534,10029,10028,6029,10765,9486,6028,6027,9173,10367,9603,5637,5636,5635,5634,8412,11388,11390,11391,11393,9923,11396,11398,11399,11400,11401,11404,11405,11407,9888,11392,7515,7518,10901,9868,9491,7519,7892,9832,9830,9829,7512,7298,11084,11135,11157,11091,5475,5200,5482,11340,10312,11098,11169,11163,11094,11093,5478,5477,11202,5397,5396,5395,5254,5203,5202,5201,11261,11323,11359,11201,9152,9153,9154,9155,11183,9130,10911,10801,11160,11435,11434,11389,11449,7739,10896,7740,8414,10059,10094,9623,9361,9881,11423,11426,11427,11428,9174,9175,9490,7980,7976,8346,9057,10892,11362,5018,9224,9223,9226,9225,11139,10764,7979,7978,7977,9641,6479,5640,10875,9237,9236,9235,11462,11090,11296,11301,11302,11361,8505,6621,10895,6954,8357,10763,8511,7521,6949,11137,11513,10539,11491,11490,11489,11487,11485,11484,11483,11482,11481,11480,11477,11476,11475,11474,11473,11472,11471,11470,11488,11469,11468,11486,5556,6102,6101,10845,8549,9098,9545,9447,5685,11536,10769,10336,8071,9833,10826,11537,11540,11541,11543,11154,10994,9679,9258,11550,11558,11557,11556,11552,9455,9453,9021,9427,10804,11565,11572,11576,11571,11570,11568,11567,11566,6572,10542,9892,6755,6688,7752,11569,9775,11466,10708,10353,11497,11498,11499,11441,10887,9594,6598,6599,7296,6609,6608,9801,10891,10540,9489,7890,7516,6953,6619,11584,10990,11464,11555,11594,11596,11597,7121,5095,5014,5374,5376,5377,11620,11622,11621,10814,9040,10003,9787,9780,10746,6264,11526,11522,11525,11524,6950,6952,10744,11311,11624,11625,10302,10299,10300,10301,6623,6618,9329,5368,9640,6670,8679,11199,11606,11607,11608,9380,8841,5712,9419,5714,9597,7527,11406,11181,7386,9420,8694,8519,8518,8696,11637,8695,9903,10926,9592,8437,8010,8011,9905,8858,8605,10264,9263,9036,11176,11034,9108,9107,9700,10986,9272,9271,11324,9596,9598,5705,8059,8101,9601,8379,8376,8253,8250,8131,8095,6085,6092,6141,6146,6149,6153,6097,6103,8148,6156,6113,10881,10889,6669,10073,10006,10005,10002,9579,9694,8257,8258,8676,9117,9118,9120,11644,10884,9916,9602,9698,11582,10022,11532,9857,10859,10285,11645,11646,11648,11650,11651,9290,9291,9293,10074,11112,10979,11278,9714,8093,10280,6777,6638,6643,11344,6594,10754,11703,11709,11712,11713,7167,11272,9119,11683,9661,9782,10773,9450,11494,11505,11603,11611,11478,11357,11725,11726,11727,9242,11638,5124,5057,5056,5055,5036,5035,5034,5033,5011,11102,11185,11365,11745,11317,9776,9139,10554,10305,11394,6026,11110,11111,11015,11708,7713,11822,11821,11852,11838,11835,11834,11836,11837,11839,11840,11823,11682,11681,11680,11674,11676,11677,11678,11679,11647,11799,11841,11828,8640,9033,11387,5813,9788,9037,9038,9039,9211,9908,10361,11132,11277,10768,11717,11141,10893,10358,9749,11893,11891,11890,11889,11888,11887,11886,11961,11959,11595,11129,11203,11450,11544,11463,11461,11992,11793,11795,11794,11798,11800,11579,11211,10812,11899,11898,11897,11903,8563,5485,6890,8677,6507,5004,11758,11759,12013,12012,12011,12010,12009,11330,11851,11892,11246,11880,11877,11875,11874,11873,11867,11866,11865,11864,11862,11861,11860,11859,11856,11855,11182,10993,10925,9095,9094,9093,9092,9091,7716,11616,11857,11870,11883,11831,11818,9097,9099,11848,11854,11946,9664,7931,7929,8445,5607,9611,5606,8441,8443,8444,8442,9105,9103,9102,9101,11790,12049,12051,11189,12045,12044,9609,12068,12069,12070,12059,12057,12058,6885,11521,8125,11973,11972,11970,11267,12014,12085,12082,9693,10004,11741,12038,10309,12109,12110,12111,12112,12120,12121,12123,12124,9786,12119,12128,12141,12156,12001,7160,9536,12003,12108,12114,12155,12100,12177,12176,8023,12185,10890,12002,12195,11824,11826,11825,11993,11934,12205,5303,5299,5302,5301,8493,8124,11263,11248,11264,12113,9530,12052,12060,12048,12218,12219,11884,5809,12204,12200,12199,6110,8116,8618,11832,11715,9285,11738,11194,10905,11702,10835,11710,11731,11564,11548,11167,11170,11242,11757,11205,11706,11351,11583,11168,11742,11198,10809,11336,11243,11756,11902,8514,6559,9968,12240,8119,8123,5405,5406,5407,5408,9136,11161,8122,8034,8615,8620,5628,5627,5626,5673,5672,5671,5670,10751,6951,9088,8056,8621,8636,9206,11338,5748,11232,11134,6697,7383,7953,11122,11143,11944,11326,8099,11439,11612,11325,11604,11479,9874,11858,8465,8058,11440,12261,12265,12270,12248,12217,12282,12285,12229,8039,8517,11551,11043,10727,10726,8831,7699,12304,11975,11508,11510,11509,10894,9121,6024,6023,8609,8485,8567,6639,5553,7834,12323,12325,7956,7955,7954,12216,12313,12243,12021,9917,11249,11885,12334,12236,10496,12047,11507,11115,9424,12370,12369,12366,12361,12362,10970,12284,11506,11495,12262,12267,7392,7391,12397,12394,12392,12391,12390,12410,12407,12405,12403,12423,12420,12418,12417,12416,12244,12384,12383,12382,12380,12379,12378,12377,12375,12374,12373,12448,12447,12444,12439,12440,12372,12376,12422,12269,12271,12287,12381,11179,11204,10001,12245,12404,5641,6558,6439,6440,6438,10433,6837,10082,6464,12266,11991,12286,12436,12435,12434,12433,12426,12425,12424,12466,12467,12468,12474,12487,12475,12496,12495,12492,12488,6107,6108,6109,5663,11089,5162,12201,12555,12557,12558,12554,12561,12556,12559,12393,12395,12406,12408,12411,12412,12413,12414,12415,12419,12421,12565,12146,12145,12144,11259,11258,11257,11256,11255,12587,12585,12584,12583,12582,12579,12575,12591,11425,11424,11422,11421,9875,12363,12603,12595,12594,12602,12599,12596,12604,12600,12598,12597,12592,12593,12187,12107,12106,12117,12118,12260,12259,12360,12438,12473,12485,12486,5277,6039,5747,5633,5625,5605,6084,6096,6105,12610,6155,6591,6641,6895,6915,6929,7166,7923,7942,8245,8378,9066,9123,9146,9239,9284,9289,9294,9522,9556,9834,10045,11245,11438,11966,10738,10378,10311,10308,10079,9858,9850,9816,9528,9466,9257,9222,9161,9156,9010,8616,8471,8446,8094,8072,8012,7950,7394,7375,6908,6671,6596,6436,6148,6140,6112,12624,6064,6054,5951,12623,12622,12621,5773,5711,5669,9867,9828,5256,5199,9451,9171,9061,8347,7751,7517,6687,6570,6025,5742,5486,12620,12619,8829,12618,12617,8611,5767,12612,12613,12614,12615,12616,12639,12638,12637,12636,12635,12632,12631,12629,12628,12627,11820,11872,12463,11605,8639,12691,12690,12687,12683,12682,12681,12680,12708,12709,12711,12712,12714,12715,12716,12717,12718,12720,12713,12721,11722,11723,11724,8151,11130,8487,11528,12768,12766,12764,12763,12761,12808,12809,12812,12813,12815,12810,12283,3000,12786,12785,12782,12779,12778,12777,12776,12775,11962,12847,12719,12748,12747,12745,12742,12740,12738,12737,12848,12851,12852,12706,12854,12705,12855,12857,12858,12702,12859,12698,12856,12850,12853,11613,11792,11971,8033,12925,12924,12917,12916,12915,12914,12921,12684,12699,12749,12744,12739,12741,12814,9532,11096,12849,12784,12918,12129,12972,12971,11969,12341,12530,12982,12977,13028,13027,13023,13020,13019,13018,13016,13017,13026,12194,12197,12566,12746,12586,12577,12578,12580,12581,12601,5645,12633,12710,6961,8075,7513,5706,11318,13091,13090,13087,13083,13082,13080,13076,13074,13073,13072,13071,13070,13069,11493,13075,13084,11504,12427,12476,13124,13123,13120,13116,13115,13114,13113,9565,9566,9567,9568,13140,11188,10357,9423,13142,13155,13154,13151,13149,13147,13146,13145,13144,5675,13174,13173,13172,13171,13170,13168,13167,13117,13148,10898,9889,11512,9901,6940,6939,6937,10266,9945,9900,13187,11610,8637,11672,11869,11437,11830,11789,13200,13199,8057,11871,11649,11833,13188,11190,13201,12576,11601,11881,12695,12696,12697,13195,13194,13191,13153,12611,6571,13230,13228,13225,13226,13215,13216,13217,13218,13219,13220,13221,13223,13229,5579,5578,5577,5576,5575,5574,5573,7702,6228,6926,6955,6959,7116,7698,7119,7175,6075,6076,6077,6078,6079,6080,6081,12196,6888,6887,6886,6884,6883,6882,7934,7933,7932,7930,7928,7996,7997,7998,7999,8000,8001,8002,11284,9952,11876,9145,9144,9143,9142,9141,13025,13046,13045,13044,13042,13038,11721,11817,13138,13137,13136,13135,13134,13133,13132,13131,13257,8612,13258,8036,13267,7775,12246,5656,9668,6395,6396,8354,9982,9974,5474,5662,5476,9774,6274,9544,8860,11964,11965,11868,11952,6031,6072,11363,11281,8543,6086,6073,12133,6260,10327,10330,10329,12983,8619,13295,8492,8031,13159,12398,6921,10749,8559,6082,8856,7442,5105,9215,9956,9436,8403,8390,7898,8336,8157,8140,7289,8423,8353,8393,8362,8137,7897,8405,13105,13104,13098,13099,13100,13101,13102,13103,13222,10753,6917,6069,6696,7382,6030,6701,8252,9086,11322,6776,7162,11496,12490,12780,12685,12544,12545,12546,6600,5345,12465,9503,12131,9456,13331,13330,12138,8363,12811,10752,13336,13335,13339,13338,13342,13341,7703,5005,6612,6091,6089,12588,10747,11240,13337,13340,5059,6059,6549,9856,6942,10057,13332,13343,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,8387,7440,6508,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,13372,13397,13396,13271,13376,13374,9563,9564,13373,9035,5383,6617,6948,13405,13419,13418,13415,13411,13410,13409,13408,8035,8065,13412,11173,7899,8374,10728,10734,10733,10732,10731,10730,10729,12230,10044,9607,8115,9081,11286,12727,12728,12729,12730,12731,12732,13224,12733,12734,13426,13424,7118,8613,12450,13375,8032,13432,12984,10883,10199,10198,10454,11459,9007,10924,10843,13157,8691,8038,7823,5012,6407,6406,12783,13047,13169,11714,11220,11219,11218,11217,11216,11215,12462,7295,5719,12980,11974,6044,13022,13041,6486,5268,5355,5300,8368,5427,5703,13334,6273,13439,11174,9973,9784,6447,9981,8682,10328,9796,9055,13443,13445,12399,12401,12402,12400,12494,12497,12493,12491,12553,12551,12552,13447,5650,6560,6781,7286,13449,9747,12692,12689,12688,12686,12743,9265,12136,13465,13464,13463,13462,13461,13460,13459,13458,13457,13456,13455,13454,13453,12464,9864,12767,13467,13466,11675,13417,5782,11827,9621,13395,12186,8386,9969,12234,13021,12803,12919,13040,11816,11609,11436,10277,12634,13156,11312,5375,11140,13150,10459,10735,13500,13468,13512,13513,13024,12781,12050,11397,11208,9429,8467,8466,8464,8601,13520,11175,12978,12132,13152,12461,12428,12442,12549,5483,5484,13407,13406,13268,11534,11531,13540,13539,9212,6657,13541,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,13564,13565,13568,13547,13497,13567,13560,13566,13569,9960,13559,11802,13272,13574,13573,13575,13576,13578,13579,13534,13584,13585,13586,12137,12139,12140,11127,13594,13593,13431,8641,13605,13603,13602,11332,11241,11976,11743,11739,11705,11523,11200,10564,13519,13518,13517,13600,13599,13609,12061,13580,13610,13617,13619,13446,13613,13612,13596,13615,13614,8617,10026,10025,12126,13592,13590,13629,13623,13622,13595,13604,13601,12127,6277,13398,11578,13662,13663,11209,13377,8836,8835,8833,13624,13107,11145,13414,11850,10886,11849,11842,11614,5701,5690,12016,11853,11845,11844,11707,9819,9591,5702,9820,9818,11843,11615,9699,5707,13214,12765,12762,11847,11846,13444,11602,12104,12736,12105,7701,11511,11554,12053,13570,12460,13511,12459,12458,13296,13448,13440,13690,8834,13494,13702,13701,13700,13708,13707,13706,9435,9644,7287,9970,9912,6562,5517,5402,5401,5400,5399,13597,9953,9954,8016,8015,8014,6152,8638,13773,13774,13775,13786,13628,13627,13626,13581,13582,13583,13797,12756,13126,13093,13118,12385,13587,13588,13589,12926,12923,12922,12920,13097,13095,13096,13094,13130,13129,13127,13128,11671,13495,10293,13469,13470,13471,5353,13085,12134,11530,13811,13809,13807,13808,8554,13814,13813,13812,13821,13818,13817,11575,11023,7738,7737,7736,7735,7734,7733,7732,6637,5935,5934,12264,9561,9560,9559,9558,6655,13827,13824,6138,13822,13823,13829,13828,10736,13533,13476,13496,13830,6405,11696,11690,11684,11685,11686,11687,11688,11689,11691,11692,11693,11694,12125,13475,13499,13838,13836,13835,13834,13843,13840,13839,13848,13845,13853,13850,13849,7161,11863,11990,11028,13865,13864,13290,13529,13528,13527,13871,13869,11791,12437,7117,9845,10107,12263,13905,13904,11287,11117,10490,10324,10323,10321,10322,10325,13913,13912,13921,13920,13923,13922,11882,13898,13780,13709,13926,13878,13785,9911,13911,11448,11349,5763,5775,11960,13798,13563,13562,13561,5520,14076,14075,14074,13816,5164,11395,10417,10039,11878,11879,12268,13043,13667,13598,13425,11804,14086,14088,13815,13867,13866,13908,13852,13851,13847,13846,13863,13810,13860,13820,13819,13903,13837,13842,13841,13919,13825,13916,13924,12015,11819,5739,5544,8523,10813,13868,13872,13577,12135,9977,7750,9849,13799,10297,10296,10295,10294,5091,10040,14290,14289,14288,14287,14286,14284,14285,14278,8391,14295,14294,14293,14292,14291,14304,14301,14300,14309,14306,14307,14308,14283,13661,14303,14302,14321,14322,14323,14324,14325,14326,14327,13778,10041,5384,10060,14314,14313,14312,14310,14311,14340,14338,14337,14336,14335,14334,14367,14368,14371,14348,14347,14346,14341,14071,6900,9549,13768,13535,14317,14320,14087,12469,13526,13525,13524,14409,14408,13416,13859,6610,13784,13779,13900,14280,14418,14417,14369,14433,14432,14431,14416,14330,14333,14343,14407,14441,14440,14439,13907,13915,14413,13394,13536,13782,13862,13910,13918,12409,12547,12560,14370,14339,14352,12540,12537,10880,9571,12539,12538,9273,11319,9904,12191,12192,12193,13227,13420,14470,14469,14468,14474,14473,14471,13826,5785,14483,14481,14480,14479,14477,14476,14487,14485,14484,13301,13300,13299,13297,11290,11212,11114,9507,9506,9505,10750,5403,13298,8139,6892,7949,7390,5643,14475,14472,14478,14482,14486,10032,13478,14366,14365,14364,14363,14362,14361,14360,14359,14356,14449,9976,11262,14497,14496,14494,11963,14502,14500,14499,14504,14505,14507,12630,14512,14510,14509,14518,11553,14522,14524,14523,14526,13671,13669,13668,13664,13616,13039,13037,13036,13035,9955,9951,6450,6451,14538,14537,14533,14532,14530,14447,14498,14495,14508,14506,14513,14511,11958,11957,11956,11955,11953,11951,5678,11954,11247,14503,14501,11341,14467,14550,14551,14552,14553,14554,14555,14448,14520,14521,14462,14542,14543,14545,11573,11574,14559,14557,14556,13781,13034,14560,14561,14562,14563,14564,14565,14073,14332,14358,14319,14571,14570,14568,5051,14572,11364,11125,10982,10416,8678,8562,6699,12017,9581,8566,11193,14527,14525,14539,14536,14534,14531,14546,14544,14567,14558,14569,8988,14574,14573,14566,13591,14070,14355,14342,14316,14435,14576,14577,14579,14580,14581,14583,13313,14582,14592,14601,14600,14599,14593,13618,14589,14590,14591,12232,14578,12103,9234,9238,14617,14616,14615,11403,11269,9504,7880,6656,6443,6442,14635,14634,14633,12489,12441,8138,7393,9840,14412,14643,14642,14641,14636,12092,12091,12089,10078,10077,10076,10052,10051,9584,7385,7384,6595,13665,12389,12388,12387,12386,12371,12368,12367,12365,14305,13158,13870,14645,14646,14586,14596,14612,13902,14282,10987,13498,12457,13800,5431,5432,5433,14663,14662,14661,14671,14670,14664,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,11348,14693,13858,14426,10031,13294,13293,13292,13291,14345,14724,14723,14722,14721,14728,14726,14725,13861,13909,13917,14742,14741,14740,14739,14738,14737,14736,14669,14666,14698,14697,14673,5167,5166,5165,13572,14402,14748,14749,14648,14519,14753,5373,14765,14764,14762,14761,14760,14759,14754,14773,14772,14771,14777,14774,13887,14349,14415,14438,14787,10276,14799,14798,14797,14796,14795,14794,14788,14644,7725,14807,14806,14805,14804,14676,14819,14818,14817,14816,14815,14814,10948,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,14848,14847,14846,14845,14844,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,14859,14858,14857,14856,14874,14873,14868,14887,14886,14879,14878,14877,14876,11533,11527,14894,5639,5730,5630,11988,14895,14875,14727,14826,14838,14907,14906,14905,14899,14898,14896,14897,14891,14889,14888,5629,13480,14914,14913,14912,14911,10415,14908,13666,13670,12180,12179,12178,11254,11253,11252,11251,14926,14925,14924,14923,14922,14921,14920,14793,14790,14813,14931,14930,14929,14928,14943,14942,14941,14752,14927,14692,14630,13648,13654,11460,10984,13649,13479,12543,12542,13653,13652,13651,11939,9006,9005,13655,12541,12548,10354,14776,14775,14658,14935,14934,14932,14954,14953,14952,14072,14961,14963,14964,14965,14966,14967,14962,14973,14972,14970,7520,14763,14756,14985,14983,14984,14974,14975,14976,14977,14978,5677,9883,14986,14991,14992,14993,14994,14995,14996,14997,14902,14657,14595,15003,15002,15001,15000,13899,14279,14938,14988,8992,13772,13770,13769,14329,5522,15013,15012,15011,15010,15017,15016,15015,15014,15025,15024,15023,15026,15030,15028,15027,15009,14933,15035,15036,15037,15038,15042,15041,15040,15039,15031,11331,11172,9667,6034,5252,14350,10888,10885,10314,10906,10561,6597,5704,14351,10396,9599,7718,7717,7715,13650,14789,8625,8624,8623,8622,11433,11432,11431,11430,13660,13659,13658,13657,13892,15051,15050,15049,15021,15059,15058,15057,15052,5253,5255,9270,9570,9646,12536,10568,11320,11711,5713,5715,9003,9004,14611,13771,9008,9009,9902,10882,11529,10035,12202,14720,14719,14718,14717,5269,5325,10852,12789,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,14885,14882,14998,15006,15008,14999,14821,15004,14850,15005,14917,15060,15044,15068,15067,15066,15065,11144,15081,15080,15079,15078,15074,15073,15072,15071,15070,11809,15007,15029,15046,15054,15033,15099,15098,15097,15096,15091,15093,15092,15090,15089,15088,14614,14588,14598,14640,14668,14660,6052,14434,14411,14315,14069,14328,10379,15118,15121,15123,15124,15125,15126,15129,15131,15132,15133,15134,15135,15136,15137,12981,15076,5174,5175,6783,6782,15108,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,14958,14959,14971,14437,14828,14840,14758,14770,15154,15153,15152,15151,15147,9259,9260,9261,9100,8452,8454,13501,7365,14767,14825,14837,14870,14869,11812,5674,7709,8561,14862,15110,14535,14768,15095,14980,11673,15149,15094,15120,15128,5305,5306,5307,5308,5086,15189,15188,15187,15186,15182,15181,15180,15179,15178,15173,15174,15175,15168,15171,15172,15201,15200,15199,15198,15197,15195,15194,15193,15192,15191,15190,15213,15212,15211,15210,15209,15208,15207,15206,15205,15202,14694,15222,15221,15220,15219,15218,15215,14881,14755,15230,15229,15228,15227,15226,15224,15223,9269,15238,15237,15236,15235,15234,15231,15239,15242,15243,15247,15245,15246,15248,15249,15250,14884,14792,14872,15244,13611,13186,13185,13184,12484,12483,12482,12481,12480,12479,12478,12477,11968,11967,11560,11542,11538,11358,11342,11539,11339,11233,10000,9552,8571,8338,8117,7200,15184,14665,14684,14632,14585,14637,14629,15170,15142,15167,15176,15177,15270,15269,15268,15267,15263,15262,15261,15260,15259,15258,15257,15256,15255,15254,15252,15251,15233,15217,15280,15279,15278,15277,15276,15273,10762,15265,11753,11752,11751,11750,11749,11748,11747,11746,15281,15285,15286,15204,15225,15196,15241,15275,15287,14414,14672,15288,15289,12396,14987,15075,15019,15045,11728,15253,15323,15322,15321,15320,15319,15318,15317,15316,15315,15314,15313,15310,15309,15326,15327,15329,15330,15331,15332,15333,15334,15335,15336,15337,15338,15339,15340,10877,8837,10055,10056,10229,10857,14919,14990,14940,15343,15346,15347,15348,15352,15350,15351,15353,15354,15355,15356,5404,12359,12364,12472,15359,15349,14628,14656,11429,14766,14354,14880,14836,14603,14604,14606,14607,14608,14609,13532,14602,14631,14605,14667,14659,14686,14769,14757,14791,14827,14883,14871,14839,14639,14613,14587,14597,14406,14405,14404,14403,14430,14429,14428,14427,15311,15376,15375,15381,15380,15379,15378,15377,15382,15384,11829,11503,11214,11250,11260,11375,12700,10326,12130,11492,13064,11788,13656,11720,12722,13189,13914,13906,5273,5304,14989,15109,15053,12090,6512,13413,9076,9096,9106,9116,15402,15342,15417,15415,15414,15413,15412,15411,15410,15409,15407,15408,15157,15431,15430,15429,15428,15427,15433,15434,15403,15404,15443,15442,15441,15022,15056,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,15361,15360,15468,15469,15470,15471,15473,15474,15475,15405,14436,15048,15476,15477,14824,14584,14731,9842,9843,9846,15492,15490,15488,15487,15486,15485,15484,15483,15482,15479,15504,15503,15502,15500,15499,15498,15497,15494,15493,14860,5558,11101,10352,5611,15506,5562,5561,5560,5559,15344,15478,15489,11563,11099,10959,9418,8482,8043,8042,8041,8040,15512,15513,15515,15516,15517,15518,15519,15520,15521,15522,15523,15526,15525,15524,14946,14951,14950,14949,14944,14714,14713,14890,14750,14700,13895,13894,13893,13891,13890,13889,13877,13876,13873,13874,13875,13514,13430,13429,13428,14715,14716,12072,7196,6449,6448,14936,14956,14683,14610,15018,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,14852,14864,14904,14948,14960,14982,15425,15426,15480,15495,15557,15558,14699,13783,14915,14735,14733,14732,14812,14811,14810,14809,15559,15514,13239,9025,7388,9034,13081,10042,15560,8407,5676,15328,15432,15362,15562,15563,15561,15564,15565,15566,15567,14808,14900,13888,14691,15169,15274,15232,15312,15266,15185,15150,15111,15077,15020,15047,15055,9590,8154,8153,8152,8150,13844,15436,15437,15438,15439,15440,7526,14861,14945,15119,15127,14979,15032,14957,14901,14849,15491,15416,15583,15582,15581,15580,15579,15578,15577,15576,15575,15574,15573,15572,15571,15570,15569,15527,15584,15585,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15602,15603,15604,14734,14903,14851,14863,15034,14947,14981,15122,15130,15626,15625,15624,15623,15622,15620,15619,15568,15627,15501,15642,15641,15639,15638,15637,15636,15635,15634,15633,15632,15631,15629,15628,15645,15646,15647,15648,15649,15650,15651,15652,15653,15654,15655,15656,15657,15658,15148,15183,15216,15264,15640,15662,15664,15666,15669,15667,15668,15670,15671,15672,15673,15674,15676,15675,15665,15679,15678,15677,15240,15203,15345,15406,15481,15496,15621,15586,15630,6038,6037,6036,6035,6550,6552,6551,6553,6872,6871,6870,6868,7946,7944,7943,8068,8069,8067,8066,8450,8449,8448,8447,15681,15682,15683,15684,9011,15685,9014,9013,15686,15687,9012,15688,9165,9164,9163,9162,9512,9511,9510,9509,15703,15702,15701,15700,15699,15698,15697,15696,15694,15693,15692,15691,15689,10742,10741,10740,10739,11027,11026,11025,11024,15695,15690,15711,15710,15709,15708,15707,15706,15705,15704,15663,15712,15713,15714,15715,15716,15717,15718,15719,15680,-1', ',')
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY todaysaleNum desc ) AS [PageIndex] ,* FROM ( select vtb.ID,
vtb.ParentID,
vtb.IsVariation,
pa.RecommendValue,
vtb.IsFirstLevelProduct,
vtb.IsSaleProduct,
vtb.isEmergencyStock,
vtb.ExpectedArrivalDays,
vtb.DeliveryDay,
Isnull(BuyBoxNum1, 0) BuyBoxNum1,
Isnull(BuyBoxNum2, 0) BuyBoxNum2,
Isnull(AllBuyBoxNum1, 0) AllBuyBoxNum1,
Isnull(BuyBoxNum3, 0) BuyBoxNum3,
Isnull(AllBuyBoxNum2, 0) AllBuyBoxNum2,
Isnull(AllBuyBoxNum3, 0) AllBuyBoxNum3,
Isnull(OrdinaryBuyBoxNum1, 0) OrdinaryBuyBoxNum1,
Isnull(OrdinaryAllBuyBoxNum1, 0) OrdinaryAllBuyBoxNum1,
Isnull(OrdinaryBuyBoxNum2, 0) OrdinaryBuyBoxNum2,
Isnull(OrdinaryAllBuyBoxNum2, 0) OrdinaryAllBuyBoxNum2,
Isnull(OrdinaryBuyBoxNum3, 0) OrdinaryBuyBoxNum3,
Isnull(OrdinaryAllBuyBoxNum3, 0) OrdinaryAllBuyBoxNum3,
AUID,
vtb.ImageUrl,
vtb.ClientSKU,
vtb.ProductName,
vtb.ProductNameCN,
PID,
vtb.SalePrice,
vtb.LastBuyPrice,
vtb.LastSupplierPrice,
vtb.GrossWeight,
vtb.PackWeight,
vtb.IsGroup,
vtb.ProductProperty,
o.OrderSourceCountry,
o.OrderSourceName,
cgzNum,
ystzNum,
ProductNum,
ReadyLibraryNum,
todaysaleNum,
zsaleNum,
qsaleNum,
sqsaleNum,
WeekSaleNum,
TwoWeekSaleNum,
vtb.APIID,
DevIDSellerId,
Cycle,
vtb.SafetyDays,
WPID,
LastUPdateTime,
vtb.AddCycle,
vtb.HaulageTime,
vtb.EstimatedSaleNum,
vtb.BuyTime,
IsBuyBox,
RobBuyBox,
Kl,
vtb.AvgDailySales,
ToBuyBoxProduct,
IsTiming,
vtb.WID,
vtb.CustomerID,
vtb.BasePrice,
vtb.OrderSourceID,
vtb.UpdateTime,
vtb.FNSKU,
vtb.LockNum,
IsFBA,
vtb.OrderSourceSKU,
vtb.WareHouseName,
ASINorItemID,
SellerType,
vtb.SKU,
vtb.BusinessTeam,
vtb.BusinessTeamName,
vtb.OrderSourceSKUID,
KykcNum,
CnKyNum,
CnWPID,
vtb.WareHouseType,
msaleNum,
lastmsaleNum,
zhanyong,
vtb.IsActive,
vtb.AddTime,
daysNum,
BuyBoxUpdateTime,
SyncLastUpdateTime,
isBeiKu,
LastUpTiming,
LastDownTiming,
rankNum,
rankZTNum,
rankQTNum,
rankSQNum,
rankClassName,
bhnum,
IsOffShelf,
ListingPrice,
ListingSoldNum,
StopProduct,
StopAndNullStockProduct,
BusinessAdminID,
BusinessUserName,
vtb.Currency,
ExchangeRMB,
FBASeller_Num,
ThreeMonthSaleNum,
RobBuyBoxType,
Attention,
Isnull(LowestPriceBuyBoxNum1, 0) LowestPriceBuyBoxNum1,
Isnull(LowestPriceAllBuyBoxNum1, 0) LowestPriceAllBuyBoxNum1,
Isnull(LowestPriceBuyBoxNum2, 0) LowestPriceBuyBoxNum2,
Isnull(LowestPriceAllBuyBoxNum2, 0) LowestPriceAllBuyBoxNum2,
Isnull(LowestPriceBuyBoxNum3, 0) LowestPriceBuyBoxNum3,
Isnull(LowestPriceAllBuyBoxNum3, 0) LowestPriceAllBuyBoxNum3,
ProductVitalityType,
ProductNewType,
UnsalableDayNum,
AmazonShelvesNum,
EbayShelvesNum,
SMTShelvesNum,
WishShelvesNum,
OtherShelvesNum,
TotalShelvesNum,
vtb.FirstLegShippingType,
IsRemind,
(SELECT TOP 1 ID FROM RB_Listing_Sync_GoodNum sync (nolock) WHERE sync.IsActive = 1 AND sync.ListingType = 2 AND sync.ListingID = vtb.OrderSourceSKUID AND sync.CustomerID = vtb.CustomerID) IsSet,
Isnull(vtb.BrandType, 0) BrandType,
Isnull(scd.ID, 0) AS IsClear,
scs.Name,
scd.WarehouseNum,
( WarehouseNum - Inventory ) AS ClearInventory,
vtb.IsAmazonListingReview,
vtb.ReviewStar,
vtb.ReviewNum,
vtb.ReviewUnReadNum,
vtb.LastReviewCollectionTime,
vtb.LastSynReviewTime,
vtb.BadReviewNum,
vtb.ThreeDayReviewNum,
vtb.SevenDayDayReviewNum,
vtb.IsAmazonKeywordRank,
vtb.FBA_Reserved_CustomerOrders,
vtb.FBA_Reserved_Transfers,
vtb.FBA_Reserved_Processing,
YesterdaySessions,
BeforeYesterdaySessions,
HeretoforeSessions,
Isnull(YesterdayUnitSessionPercentage, 0) AS YesterdayUnitSessionPercentage,
Isnull(BeforeYesterdayUnitSessionPercentage, 0) AS BeforeYesterdayUnitSessionPercentage,
Isnull(HeretoforeUnitSessionPercentage, 0) AS HeretoforeUnitSessionPercentage,
vtb.TaxPoint,
vtb.TaxRate,
Isnull(vtb.IsFBABarCode, 0) IsFBABarCode,
Isnull(vtb.IsRecommendOcean, 0) IsRecommendOcean,
Isnull(w.WareHouseName, '') AS DefaultWareHouseName,
Isnull(vtb.YesterdaySpend, 0) YesterdaySpend,
Isnull(vtb.TotalSpend, 0) TotalSpend,
Isnull(vtb.YesterdayAvgCPC, 0) YesterdayAvgCPC,
Isnull(vtb.TotalAvgCPC, 0) TotalAvgCPC,
Isnull(vtb.YesterdayClicks, 0) YesterdayClicks,
Isnull(vtb.TotalClicks, 0) TotalClicks,
Isnull(vtb.YesterdayImpressions, 0) YesterdayImpressions,
Isnull(vtb.TotalImpressions, 0) TotalImpressions,
Isnull(vtb.IsEFN, 0) AS IsEFN,
vtb.EFNCountry,
Isnull(vtb.IsCheckDeclarationCode, 0) IsCheckDeclarationCode,
Isnull(vtb.IsCheckTransport, 0) IsCheckTransport,
Isnull(vtb.IsSalesRank, 0) IsSalesRank,
p.ProdutcArrivalDate,
vtb.HolidaysID,
wh.WareHouseName AS DefaultLocalWarehouse,
swh.WareHouseName SupplierWareHouseName,
vtb.AddAdminName,
vtb.IsSetNoSupplyReason,
vtb.IsEmergencyStockReminder,
vtb.TranslateStatus,
p.MinSaleNum,
p.WithBattery,
pa.IsAmazonSale,
pa.NoSalePlatform,
vtb.TemplateID,
vtb.LableColor,
vtb.LableName,
p.PictureSource,
pa.ImageTime,
vtb.ProfitMargin,
vtb.PublishTime,
vtb.MonthAvgProfits,
vtb.PlanID,
vtb.PlanDetailId,
vtb.PlanName,
vtb.IsAgainPublish,
vtb.IsAutoAdjustPrice,
vtb.IsAutoLowerShelf,
vtb.IsAutoPromotion,
OnShelfMode,
vtb.OrderSourceSkuOrderTime,
vtb.AsinOrderTime,
p.IsIntelligentStocking,
ntf.Reason,
vtb.WaitToFbaType ,
vtb.SevenDaySales,
vtb.SevenDayAcos,
vtb.DefaultWarehouseID,
vtb.RecommendedOrderQuantity,
vtb.DiscountStartTime,
vtb.DiscountEndTime,
vtb.DiscountSalesPrice,
p.ImageUrl as ProductImageUrl,
p.ProductName as ProductTitle,
vtb.IsAdvertising,
vtb.UnsellableQuatity,
pa.NoSaleCountry,
vtb.IsNARF,
vtb.MaximumShipmentQuantity,
vtb.RecommendFinalNum,
vtb.MonitorStockFinalNum,
vtb.IsJoinSmall,
vtb.RecommendJoinSmall,
vtb.NoJoinSmallReason 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=1
AND vtb.IsDelete=0
and isnull(IsOffShelf,0)<>3
and vtb.OrderSourceSKUID>0
And vtb.OnShelfMode in (SELECT CONVERT(INT, item) FROM Charsplitforin('9', ',')) )
AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(maxdop 8)