prometheus告警
开始时间: 15:56:14
错误代码: N1556141
sql类型: --TITLE
sql: [15:56:14] -------------------------------------------------------------
CODE:N1556141
Error:15_102_1_-2146232060
SQL:--title 销售业绩统计报表2022-08-01至2022-08-31
--DECLARE @CustomerID INT = 1,@StartTime DATETIME = '2022-09-01',@EndTime DATETIME='2022-09-30',SELECT item FROM dbo.CharSplitForIn(@OrderSourceID,',') NVARCHAR(MAX)='10464,6673,6670,10783'
DECLARE @OrderSourceTb TABLE(ID INT);
INSERT INTO @OrderSourceTb
EXEC proc_string_split SELECT item FROM dbo.CharSplitForIn(@OrderSourceID,','),',' ;
IF OBJECT_ID(N'tempdb..#OrderSettlement', N'U') IS NOT NULL BEGIN DROP TABLE #OrderSettlement
END
SELECT
T1.SalesPrice,
T2.SalesPrice AS TotalPrice,CASE
WHEN T2.SalesPrice = 0
AND T1.IsFBAOrder = 0 THEN 1
WHEN T2.SalesPrice = 0
AND T1.IsFBAOrder = 1 THEN 0
ELSE ROUND(T1.SalesPrice / T2.SalesPrice, 2)
END AS OrderSourceRete,
T1.OrderSourceID,
T1.IsFBAOrder INTO #OrderSettlement
FROM
(
SELECT
SUM(A.SalesPrice) AS SalesPrice,
CONVERT(decimal(18, 2), 0) AS OrderSourceRete,
A.OrderSourceID,
B.IsFBAOrder
FROM
RB_Report_OrderSettlement A(NOLOCK)
INNER JOIN RB_OrderInfo B(NOLOCK) ON A.OrderSourceID = B.OrderSourceID
INNER JOIN @OrderSourceTb C ON A.OrderSourceID=C.ID
AND A.OrderCode = B.OrderCode
WHERE
A.CustomerID = @CustomerID
AND B.IsStockOrder = 0
AND ShipDate >= @StartTime
AND ShipDate <= @EndTime
AND A.SalesPrice <> 0
GROUP BY
A.OrderSourceID,
B.IsFBAOrder
) T1
INNER JOIN (
SELECT
SUM(A.SalesPrice) AS SalesPrice,
A.OrderSourceID
FROM
RB_Report_OrderSettlement A(NOLOCK)
INNER JOIN RB_OrderInfo B(NOLOCK) ON A.OrderSourceID = B.OrderSourceID
AND A.OrderCode = B.OrderCode
INNER JOIN @OrderSourceTb C ON A.OrderSourceID=C.ID
WHERE
A.CustomerID = @CustomerID
AND B.IsStockOrder = 0
AND ShipDate >= @StartTime
AND ShipDate <= @EndTime
AND A.SalesPrice <> 0
GROUP BY
A.OrderSourceID
) T2 ON T1.OrderSourceID = T2.OrderSourceID
SELECT
*
FROM
(
SELECT
OrderSourceTypeName '平台',
OrderSourceName '来源渠道',
a.BusinessAdminName '销售人员',
e.EmpoyeeNumber '销售人员工号',
ISNULL(c.BusinessTeamName, '') '大组名称',
CASE
WHEN ISNULL(a.BusinessTeamName, '') = '' THEN '未分组'
ELSE a.BusinessTeamName
END '销售小组',
'CNY' '币种',
ROUND(Sum(Profits / 1), 2) '总毛利润',
ROUND(
SUM(
(
SalesPrice + a.TransportPay + SalesRefunds + PromotionRebates + OtherCredits + ISNULL(Tax, 0) + ISNULL(MarketplaceFacilitatorTax, 0)
) / 1
),
2
) '总销售额',
ROUND(Sum(SalesPrice / 1), 2) '销售收入',
ROUND(Sum(a.TransportPay / 1), 2) '运费收入',
ROUND(Sum(SalesRefunds / 1), 2) '退款金额',
ROUND(Sum(PromotionRebates / 1), 2) '促销折扣',
ROUND(Sum(OtherCredits / 1), 2) '其他收入',
ROUND(
SUM(
(
ISNULL(Tax, 0) + ISNULL(MarketplaceFacilitatorTax, 0)
) / 1
),
2
) '税费收入',
ROUND(Sum(CommisionFee / 1), 2) '交易佣金',
ROUND(Sum(FBATransactionFees / 1), 2) 'FBA操作费',
ROUND(Sum(OrderSourceOtherDebits / 1), 2) '平台其他支出',
ROUND(Sum(CostOfAdvertising / 1), 2) as '广告费用',
ROUND(
Sum((BuyPrice + ISNULL(DistributionPrice, 0)) / 1),
2
) '采购成本',
ROUND(Sum(TaxRefundFee / 1), 2) '退税收益',
ROUND(Sum(ISNULL(SalesVatFee, 0) / 1), 2) '销售VAT',
ROUND(Sum(ISNULL(SubsidyPrice, 0) / 1), 2) '补贴调整',
ROUND(Sum(PackageFees / 1), 2) '本地仓运费',
ROUND(Sum(OverSeasShipFees / 1), 2) '海外仓运费',
ROUND(Sum(FirstLegFees / 1), 2) '头程运费',
ROUND(Sum(TariffFees / 1), 2) '进口关税',
ROUND(Sum(ExchangeLost / 1), 2) '汇率折损',
ROUND(Sum(PackagedCost / 1), 2) '包装成本',
ROUND(Sum(ISNULL(WareHouseManagementPrice, 0) / 1), 2) '仓库管理成本(自定义费用项)',
ROUND(Sum(ISNULL(CustomFeeOtherCostPrice, 0) / 1), 2) '其它费用成本(自定义费用项)',
ROUND(Sum(ISNULL(ImportFee, 0) / 1), 2) '人工导入费用',
CASE
WHEN ISNULL(f.IsFBAOrder, 0) = 1 THEN 'FBA发货'
ELSE '本地发货'
END '发货方式',
'是' as '是否发票订单'
FROM
RB_Report_OrderSettlement a WITH(nolock)
LEFT JOIN RB_BusinessTeam(nolock) b ON a.CustomerID = b.CustomerID
AND a.BusinessTeamID = b.ID
LEFT JOIN RB_BusinessTeam(nolock) c ON c.CustomerID = b.CustomerID
AND c.ID = b.BusinessTeamParentID
LEFT JOIN RB_Admin e on e.ID = a.SalesAdminID
LEFT JOIN RB_OrderInfo f(nolock) on a.OrderSourceID = f.OrderSourceID
AND a.OrderCode = f.OrderCode
INNER JOIN @OrderSourceTb g ON a.OrderSourceID=g.ID
WHERE
a.CustomerID = @CustomerID
AND a.SettlementShortDate >= @StartTime
AND a.SettlementShortDate <= @EndTime
AND OrderSourceType = 1
AND f.ID IS NOT NULL
AND a.PromotionType = 1
GROUP BY
OrderSourceTypeName,
OrderSourceName,
e.EmpoyeeNumber,
a.BusinessAdminName,
ISNULL(c.BusinessTeamName, ''),CASE
WHEN ISNULL(a.BusinessTeamName, '') = '' THEN '未分组'
ELSE a.BusinessTeamName
END,
ISNULL(f.IsFBAOrder, 0)
UNION ALL
SELECT
OrderSourceTypeName '平台',
OrderSourceName '来源渠道',
a.BusinessAdminName '销售人员',
e.EmpoyeeNumber '销售人员工号',
ISNULL(c.BusinessTeamName, '') '大组名称',
CASE
WHEN ISNULL(a.BusinessTeamName, '') = '' THEN '未分组'
ELSE a.BusinessTeamName
END '销售小组',
'CNY' '币种',
ROUND(Sum(Profits / 1), 2) '总毛利润',
ROUND(
SUM(
(
SalesPrice + a.TransportPay + SalesRefunds + PromotionRebates + OtherCredits + ISNULL(Tax, 0) + ISNULL(MarketplaceFacilitatorTax, 0)
) / 1
),
2
) '总销售额',
ROUND(Sum(SalesPrice / 1), 2) '销售收入',
ROUND(Sum(a.TransportPay / 1), 2) '运费收入',
ROUND(Sum(SalesRefunds / 1), 2) '退款金额',
ROUND(Sum(PromotionRebates / 1), 2) '促销折扣',
ROUND(Sum(OtherCredits / 1), 2) '其他收入',
ROUND(
SUM(
(
ISNULL(Tax, 0) + ISNULL(MarketplaceFacilitatorTax, 0)
) / 1
),
2
) '税费收入',
ROUND(Sum(CommisionFee / 1), 2) '交易佣金',
ROUND(Sum(FBATransactionFees / 1), 2) 'FBA操作费',
ROUND(Sum(OrderSourceOtherDebits / 1), 2) '平台其他支出',
ROUND(Sum(CostOfAdvertising / 1), 2) as '广告费用',
ROUND(
Sum((BuyPrice + ISNULL(DistributionPrice, 0)) / 1),
2
) '采购成本',
ROUND(Sum(TaxRefundFee / 1), 2) '退税收益',
ROUND(Sum(ISNULL(SalesVatFee, 0) / 1), 2) '销售VAT',
ROUND(Sum(ISNULL(SubsidyPrice, 0) / 1), 2) '补贴调整',
ROUND(Sum(PackageFees / 1), 2) '本地仓运费',
ROUND(Sum(OverSeasShipFees / 1), 2) '海外仓运费',
ROUND(Sum(FirstLegFees / 1), 2) '头程运费',
ROUND(Sum(TariffFees / 1), 2) '进口关税',
ROUND(Sum(ExchangeLost / 1), 2) '汇率折损',
ROUND(Sum(PackagedCost / 1), 2) '包装成本',
ROUND(Sum(ISNULL(WareHouseManagementPrice, 0) / 1), 2) '仓库管理成本(自定义费用项)',
ROUND(Sum(ISNULL(CustomFeeOtherCostPrice, 0) / 1), 2) '其它费用成本(自定义费用项)',
ROUND(Sum(ISNULL(ImportFee, 0) / 1), 2) '人工导入费用',
CASE
WHEN ISNULL(f.IsFBAOrder, 0) = 1 THEN 'FBA发货'
ELSE '本地发货'
END '发货方式',
'否' as '是否发票订单'
FROM
RB_Report_OrderSettlement a WITH(nolock)
LEFT JOIN RB_BusinessTeam(nolock) b ON a.CustomerID = b.CustomerID
AND a.BusinessTeamID = b.ID
LEFT JOIN RB_BusinessTeam(nolock) c ON c.CustomerID = b.CustomerID
AND c.ID = b.BusinessTeamParentID
LEFT JOIN RB_Admin e on e.ID = a.SalesAdminID
LEFT JOIN RB_OrderInfo f(nolock) on a.OrderSourceID = f.OrderSourceID
AND a.OrderCode = f.OrderCode
INNER JOIN @OrderSourceTb g ON a.OrderSourceID=g.ID
WHERE
a.CustomerID = @CustomerID
AND a.ShipDate >= @StartTime
AND a.ShipDate <= @EndTime
AND OrderSourceType = 1
AND f.ID IS NOT NULL
AND ISNULL(a.PromotionType, 0) = 0
GROUP BY
OrderSourceTypeName,
OrderSourceName,
e.EmpoyeeNumber,
a.BusinessAdminName,
ISNULL(c.BusinessTeamName, ''),CASE
WHEN ISNULL(a.BusinessTeamName, '') = '' THEN '未分组'
ELSE a.BusinessTeamName
END,
ISNULL(f.IsFBAOrder, 0)
UNION ALL
SELECT
OrderSourceTypeName '平台',
OrderSourceName '来源渠道',
a.BusinessAdminName '销售人员',
e.EmpoyeeNumber '销售人员工号',
ISNULL(c.BusinessTeamName, '') '大组名称',
CASE
WHEN ISNULL(a.BusinessTeamName, '') = '' THEN '未分组'
ELSE a.BusinessTeamName
END '销售小组',
'CNY' '币种',
ROUND(
SUM(a.Profits / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '总毛利润',
ROUND(
SUM(
(
a.SalesPrice + a.TransportPay + SalesRefunds + PromotionRebates + OtherCredits + ISNULL(Tax, 0) + ISNULL(MarketplaceFacilitatorTax, 0)
) / 1
) * ISNULL(g.OrderSourceRete, 1),
2
) '总销售额',
ROUND(
Sum(a.SalesPrice / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '销售收入',
ROUND(
Sum(a.TransportPay / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '运费收入',
ROUND(
Sum(SalesRefunds / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '退款金额',
ROUND(
Sum(PromotionRebates / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '促销折扣',
ROUND(
Sum(OtherCredits / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '其他收入',
ROUND(
SUM(
(
ISNULL(Tax, 0) + ISNULL(MarketplaceFacilitatorTax, 0)
) / 1
) * ISNULL(g.OrderSourceRete, 1),
2
) '税费收入',
ROUND(
Sum(CommisionFee / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '交易佣金',
CASE
WHEN ISNULL(g.OrderSourceRete, 1) <> 1
AND ISNULL(g.IsFBAOrder, 0) = 0 THEN 0
WHEN ISNULL(g.OrderSourceRete, 1) <> 1
AND ISNULL(g.IsFBAOrder, 0) = 1 THEN ROUND(SUM(FBATransactionFees / 1), 2)
ELSE ROUND(
SUM(FBATransactionFees / 1) * ISNULL(g.OrderSourceRete, 1),
2
)
END 'FBA操作费',
ROUND(
Sum(OrderSourceOtherDebits / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '平台其他支出',
ROUND(
Sum(CostOfAdvertising / 1) * ISNULL(g.OrderSourceRete, 1),
2
) as '广告费用',
ROUND(
Sum((BuyPrice + ISNULL(DistributionPrice, 0)) / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '采购成本',
ROUND(
Sum(TaxRefundFee / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '退税收益',
ROUND(
Sum(ISNULL(SalesVatFee, 0) / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '销售VAT',
ROUND(
Sum(ISNULL(SubsidyPrice, 0) / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '补贴调整',
ROUND(
Sum(PackageFees / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '本地仓运费',
ROUND(
Sum(OverSeasShipFees / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '海外仓运费',
ROUND(
Sum(FirstLegFees / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '头程运费',
ROUND(
Sum(TariffFees / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '进口关税',
ROUND(
Sum(ExchangeLost / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '汇率折损',
ROUND(
Sum(PackagedCost / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '包装成本',
ROUND(
Sum(ISNULL(WareHouseManagementPrice, 0) / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '仓库管理成本(自定义费用项)',
ROUND(
Sum(ISNULL(CustomFeeOtherCostPrice, 0) / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '其它费用成本(自定义费用项)',
ROUND(
Sum(ISNULL(ImportFee, 0) / 1) * ISNULL(g.OrderSourceRete, 1),
2
) '人工导入费用',
CASE
WHEN ISNULL(g.IsFBAOrder, 0) = 1 THEN 'FBA发货'
ELSE '本地发货'
END '发货方式',
'否' as '是否发票订单'
FROM
RB_Report_OrderSettlement a WITH(nolock)
LEFT JOIN RB_BusinessTeam(nolock) b ON a.CustomerID = b.CustomerID
AND a.BusinessTeamID = b.ID
LEFT JOIN RB_BusinessTeam(nolock) c ON c.CustomerID = b.CustomerID
AND c.ID = b.BusinessTeamParentID
LEFT JOIN RB_Admin e on e.ID = a.SalesAdminID
LEFT JOIN RB_OrderInfo f(nolock) on a.OrderSourceID = f.OrderSourceID
AND a.OrderCode = f.OrderCode
LEFT JOIN #OrderSettlement g on a.OrderSourceID = g.OrderSourceID
INNER JOIN @OrderSourceTb h ON a.OrderSourceID=h.ID
WHERE
a.CustomerID = @CustomerID
AND a.ShipDate >= @StartTime
AND a.ShipDate <= @EndTime
AND a.OrderSourceType = 1
AND f.ID IS NULL
GROUP BY
a.OrderSourceTypeName,
a.OrderSourceName,
e.EmpoyeeNumber,
a.BusinessAdminName,
ISNULL(c.BusinessTeamName, ''),
CASE
WHEN ISNULL(a.BusinessTeamName, '') = '' THEN '未分组'
ELSE a.BusinessTeamName
END,
ISNULL(g.IsFBAOrder, 0),
ISNULL(g.OrderSourceRete, 1)
) T
ORDER BY T.平台,T.来源渠道
PARAMS:@StartTime = 2022-10-01 00:00:00 ,@EndTime = 2022-10-26 23:59:59 ,@OrderSourceID = 8542,8541,9747,8992,8601,9947,8567,8568,8573,8595,9970,8689,8641,8569,8570,8574,8572,8160,8548,8602,8544,8598,8515,8525,8599,8597,8524,8642,9978,8543,8540,9971,9976,12530,9946,8566,9977,12566,8517,9980,13431,9969,9979,11991,12105,14672,12269,12266,12262,12334,12271,12267,12341,12611,13798,13440,12249,12201,13494,12450,12610,13448,13159,14694,12573,14644,13444,16139,13446,14698,15678,16969,16374,15897,15904,17159,16966,15892,17253,15894,16353,16116,15898,15900,15902,16281,15582,16110,16128,15839,16112,16114,15702,15554,16086,15950,15874,16173,15525,15355,15790,16254,15983,15373,15416,15322,15491,15339,15597,15675,15641,16358,15769,16190,15965,16044,16002,16156,16017,15987,16158,16229,16058,15806,5782,5809,5781,6260,5779,6506,5783,5944,6757,5813,5780,6758,6137,6405,7892,6433,6507,7893,7894,7890,7891,13547,10416,10420,10414,7896,10415,14086,13275,9562,17134,10745,11682,11695,11867,11880,11893,11853,11840,11827,11800,11813,11975,11963,13424,13560,13559,13426,12357,12362,12440,12397,12410,12436,12469,12475,12488,12515,12529,12548,12561,12683,12698,12778,12740,12917,12768,12801,12734,12815,12639,12675,12885,12899,12913,12939,12957,13038,13187,13116,13083,13076,13105,13138,13147,13411,13605,15069,13799,13609,13493,15250,13853,14290,14295,13848,13876,13811,13816,13821,13838,13871,13843,14340,14314,14371,14366,14309,14997,14470,15042,14353,14327,14967,15017,15030,14571,15013,15073,14728,14716,14538,17379,14899,14545,14579,15068,14533,14559,15091,14977,14583,14914,14526,14507,14847,14823,14931,14835,14502,14935,14803,14479,14483,14487,14474,14926,14512,14742,14497,14720,14973,14765,14724,14712,14678,16539,14859,15003,14807,14799,14879,14819,14682,15085,15580,16266,16304,15137,15504,15213,15837,15181,16764,15193,15700,15552,16316,16085,15949,15262,15658,16392,15523,15353,15788,15539,16252,16341,15982,15371,15414,15323,15616,15489,15337,15595,15673,15639,16275,16373,15767,16192,15964,16177,16042,16012,16154,16027,16294,15997,16329,16160,16227,16057,15804,15388,15423,15380,15400,16440,16490,16813,16525,16613,16453,16708,16627,16905,16666,16681,16600,16864,16722,16736,16653,16982,16827,17443,16503,16552,16567,16587,16695,17038,16779,16792,17052,17222,17094,16961,16996,16749,16919,17242,17174,17080,16878,16933,17127,16947,17428,17111,17458,16841,16892,17010,17066,17543,17147,17024,17204,17181,17482,17274,17509,17470,17189,17327,17384,17291,17296,16119,17496,17325,17254,17297,17312,17191,17180,17386,17479,17326,17483,17192,17478,17364,17530,17262,17497,17304,17329,17316,17255,17477,17351,17476,17387,17527,17460,17310,17190,17522,17484,17323,17471,17349,17256,17512,17188,17388,17485,17275,17257,17486,17508,17491,17513,17284,17276,17462,17480,17205,17333,17303,17461,17357,17359,17186,17268,17271,17494,17315,17514,17365,17305,17469,17285,17302,17463,17320,17298,17526,17277,17179,17403,17492,17317,17193,17270,17332,17396,17397,17319,17507,17311,17481,17266,17381,17251,17281,17330,17206,17490,17265,17301,17472,17398,17178,17318,17464,17361,17278,17389,17385,17321,17404,17366,17390,17473,17352,17358,17362,17260,17391,17267,17264,17290,17286,17322,17353,17313,17405,17399,17511,17287,17307,17400,17182,17331,17363,17282,17521,17360,17525,17306,17314,17295,17269,17300,17289,17395,17488,17279,17493,17350,17176,17283,17324,17375,17383,17430,17280,17177,17292,17489,16118,17272,17393,17392,17355,17487,17328,17203,17354,17465,17263,17273,17474,17394,17207,17498,17408,17258,17309,17261,17293,17475,17294,17411,17510,17299,17259,17356,17308,17524,17466,17382,17523,17288,16320,17406,17407,17413,17401,16609,17412,16704,16623,17410,16662,16677,16629,16860,16718,16978,16823,17439,16582,16684,17415,17414,17409,17048,17218,17090,16957,16992,16750,16915,17238,17170,17076,16874,16929,17123,16943,17424,17107,17454,16837,16888,17006,17062,17539,17143,17020,16103,9618,10861,10862,9887,9620,9619,9617,9649,9652,10884,9655,9667,9646,9647,9650,9641,10851,10852,9640,9644,9643,10875,10889,10864,10863,10853,10886,9889,9882,10869,9886,10870,10894,11363,10885,9653,9881,9645,10845,9651,9648,9654,9883,12047,12071,12072,11404,10890,10854,10887,9884,10895,9890,14565,9885,11364,11403,10892,10881,10849,13229,10846,10891,10867,10878,11388,10855,11393,10860,10844,10888,11389,10874,10896,10865,9888,10893,10868,10866,11624,10847,11584,10879,10873,10897,11710,16425,12240,11583,11705,11625,11713,10898,9891,13219,15144,11365,11405,13218,10880,13217,12048,14518,10882,14447,14522,11513,14560,14561,13228,14562,14564,11512,11703,11387,11578,10848,13225,10872,11406,11394,13618,10876,10899,13515,14645,10856,10901,11407,11390,12588,10850,10900,10858,10859,10902,11582,10871,11395,13614,11511,10857,11702,12124,10883,12073,17133,13215,10877,12216,11572,14448,12021,13226,11391,11553,14563,13615,12125,13271,12268,13216,13619,13214,12155,13221,12123,12075,13272,13887,13227,14550,13514,14552,13513,15145,14449,14520,14553,13395,13220,13511,13398,13396,13394,13613,13612,13512,13224,13223,13516,13616,13617,13222,13878,14519,15680,15177,14895,16417,15302,17545,15383,16424,15565,15808,15645,14551,14750,14555,14554,15566,16064,16419,16473,15143,15285,15286,15465,15825,15435,15141,15816,15402,15564,15455,15814,16062,15809,16414,16476,15167,15559,16477,16420,15433,15810,14894,15817,15567,16474,16416,16421,15457,16063,15824,15818,15821,14908,15492,15142,16418,15009,16415,15815,15359,16475,15458,16068,15301,16067,16422,15140,15563,15822,15303,16423,15604,16069,15555,16070,15753,15812,15456,16065,15556,16102,16204,16755,15562,15811,15551,16459,16464,15646,15937,16478,15603,16098,16504,16463,15599,15886,15600,16061,15602,16351,16393,16104,16505,17550,16375,16472,16460,16471,16458,16461,16506,16457,16508,16462,16470,16507,16456,16465,17548,16751,17546,17547,16767,5093,6925,5522,6782,6406,5094,5642,7357,5132,5326,5091,10467,6555,5095,6776,5051,12205,5367,5520,6655,5514,5946,5384,5327,5325,5139,5555,5532,5368,5516,5504,5535,5641,5533,5537,5544,5546,5553,5574,5582,5589,5596,5604,5615,5624,5632,5661,5668,5683,5702,5741,5739,5757,5764,5766,5949,5935,5803,6076,6024,6031,6033,6047,6124,6083,6090,6104,6102,6111,6139,6147,6154,6293,6304,6398,6400,6511,6449,6451,6625,8260,6604,6606,6890,6609,6611,6623,6892,6695,6670,6943,6702,6443,6755,6936,6837,6867,6883,6928,7914,7532,7934,6954,6900,7516,6907,6922,6984,7198,7388,7364,7390,7381,7392,7527,8258,7443,7733,7400,7402,7404,7406,7408,7411,7740,7704,7716,7728,7760,7750,7888,7905,7907,7922,7936,7949,7992,8337,7997,8004,8011,8078,8857,8071,8147,8093,8858,8149,8244,8251,8477,8523,8339,8346,8377,8519,8553,13518,8560,8693,13623,8838,8696,9571,12127,11637,13600,13573,9009,10138,12107,9263,12260,12264,12058,12118,13528,9411,9901,9034,10813,9129,9407,9543,9266,9767,9769,9771,9773,10252,12258,9777,9794,10250,9807,10008,9812,10006,9950,10042,10375,9555,10254,11012,9849,9857,9866,10024,10032,10034,10036,10040,12090,10054,10056,10058,10060,10062,10199,10276,13331,10314,10316,10318,10320,13594,13470,11306,9928,10758,10737,10748,10941,11314,11045,11301,13562,11680,11693,11865,11878,11898,12016,11891,11852,11839,11826,11797,11810,11976,11960,13607,13466,12192,13568,11978,13288,13429,13200,13336,13406,13540,13525,13342,13339,12346,12360,12438,12395,12408,12425,12458,12473,12486,12504,12518,12546,12681,12696,12776,12738,12915,12766,12799,12732,12813,12628,12664,12882,12896,12910,12936,12954,13036,13114,13081,13074,13103,13136,13145,13370,13409,13400,13627,13603,13579,13582,13597,13576,13565,13585,13923,13588,13490,15248,13850,14287,14292,13845,13874,13808,13813,13818,13835,13869,13840,14337,14311,14368,14363,14306,14995,14469,15040,14350,14324,14965,15015,15028,14570,15011,15072,14726,14714,14537,17377,14898,14543,14577,15066,14532,14557,15090,14976,14581,14912,14524,14505,14846,14822,14930,14834,14500,14934,14801,14477,14481,14485,14473,14924,14510,14740,14496,14718,14972,14763,14722,14729,14677,16537,14858,15001,14805,14797,14878,14817,14681,15083,15159,15162,15165,15578,16264,16306,15135,15502,15211,15835,15180,16753,15192,15698,15549,16318,16083,15947,15261,15656,16390,15521,15351,15786,15537,16250,16343,15980,15369,15412,15318,15614,15487,15335,15593,15671,15637,16277,15884,15730,16371,15765,16202,15962,16187,16040,16014,16152,16029,16292,15999,16331,16170,16225,16055,15802,15386,15421,15378,15398,16438,16488,16811,16523,16611,16451,16706,16625,16903,16664,16679,16598,16862,16720,16734,16643,16980,16825,17441,16501,16550,16565,16585,16693,17036,16777,16790,17050,17220,17092,16959,16994,16739,16917,17240,17172,17078,16876,16931,17125,16945,17426,17109,17456,16839,16890,17008,17064,17541,17145,17022,5200,5305,5252,5400,5405,5475,5482,5576,5598,5606,5617,5626,5634,5663,5670,5712,5748,5743,5774,5768,5952,5805,6078,6026,6070,6035,6040,6055,6060,6049,6065,6085,6092,6097,6106,6113,6141,6281,6149,6156,6306,6437,6460,6550,6513,6571,6592,6597,6613,6618,6642,6648,6657,6672,6697,6688,6938,7977,6806,6878,6869,6885,6930,7929,6949,6901,7518,6909,6916,6986,7157,7162,7167,7359,7366,7371,7376,7511,7383,7395,7735,7711,7706,7718,7842,7752,7882,7900,7909,7924,7943,7953,7999,8006,8013,8073,8472,8066,8095,8246,8253,8348,8379,8447,8031,8036,8485,8487,8491,8493,8468,8469,8494,8495,8496,8498,8499,8501,8609,8956,8555,9270,8562,8622,8637,8852,8833,13915,8925,9004,9011,13241,13533,9626,9216,9016,9021,9028,9211,9199,9207,9067,9077,9082,9087,9097,9107,9137,9147,9152,9162,9167,9172,9124,9513,9223,9258,9285,9290,9295,9300,9157,9361,9432,9437,9442,9447,9452,9457,9467,9504,9509,9523,9529,9545,9550,9557,9564,9817,9823,9829,9835,9851,9859,9868,10026,10046,10080,13298,9952,9957,10052,10064,10289,10294,10309,10322,10327,10332,10379,10729,10739,10750,10944,11024,11215,11246,11251,11256,11261,11376,11430,11437,11455,12770,11528,11493,11504,11610,11602,11646,11654,11672,11685,11721,11882,11843,11830,11817,11789,11802,11972,11952,13291,13476,13496,12132,12138,13280,14435,15119,12350,12367,12445,12386,12399,12429,12462,12493,12508,12522,12819,12537,12550,12688,12703,12783,12922,12757,12790,12723,12804,12632,12668,12828,12833,12843,12888,12902,12928,12946,13192,13121,13088,13065,13094,13127,13152,13387,13416,13649,13769,13665,13657,13779,13482,15240,13907,14279,14403,15437,13889,13859,14070,13899,15866,15620,14329,14412,15682,13823,14355,14427,14987,16234,15032,14342,14316,14957,15045,15705,14684,15053,15075,14945,15148,17368,14901,14665,15216,15224,14595,14657,15093,14979,14629,15252,16211,14585,14849,14825,15109,14837,14611,15019,15169,14637,15924,15916,14916,14603,14732,15908,14937,15431,14755,14767,14780,14869,16529,14861,15274,15713,14789,14881,14809,16091,15746,15570,16256,16302,15127,15494,15203,15827,15183,16757,15195,15690,15541,16314,16075,15939,15264,15648,16382,15513,15343,15778,15529,16242,16339,15972,15361,15404,15310,15606,15479,15327,15585,15663,15629,16273,15876,15722,16363,15757,16199,15954,16184,16032,16010,16144,16025,16284,15995,16327,16167,16217,16047,15794,15390,16430,16480,16803,16515,16602,16443,16697,16616,16895,16655,16670,16590,16853,16711,16725,16646,16971,16816,17432,16493,16542,16557,16576,16685,17028,16769,16782,17041,17211,17083,16950,16985,16742,16908,17231,17163,17069,16867,16922,17116,16936,17417,17100,17447,16830,16881,16999,17055,17532,17136,17013,5167,5178,5203,5345,5308,5377,5402,5407,5477,5484,5578,5586,5593,5600,5608,5628,5636,5665,5672,5714,5706,5750,5745,5776,5770,5954,5807,6080,6028,6072,6037,6042,6057,6062,6051,6067,6087,6094,6099,6108,6115,6143,6283,6151,6158,6308,6439,6462,6552,6515,6573,6594,6599,6615,6620,6644,6650,6659,6674,6699,6690,6940,7979,6808,6880,6871,6887,6932,7931,6951,6903,7520,6911,6918,6988,7159,7164,7169,7361,7368,7378,7513,7385,7397,7737,7713,7708,7720,7844,7754,7884,7902,7911,7926,7945,8001,8008,8015,8075,8473,8068,8097,8248,8255,8350,8381,8449,8033,8038,8058,8125,8129,8452,8458,8313,8317,8325,8329,8462,8466,8958,8557,9272,8564,8624,8639,8855,8835,13918,8926,9006,9013,13240,13536,9628,9218,9018,9023,9030,9038,9201,9209,9069,9079,9084,9089,9099,9109,9139,9149,9154,9164,9169,9174,9126,9515,9225,9260,9287,9292,9297,9302,9159,9363,9434,9439,9444,9449,9454,9459,9469,9506,9511,9525,9531,9547,9559,9566,9819,9825,9831,9837,9853,9861,9870,10028,10048,10082,13297,9954,9959,10077,10066,10290,10295,10310,10323,10328,10333,10381,10731,10741,10752,10947,11027,11216,11249,11254,11259,11264,11379,11433,11440,11458,12773,11531,11496,11507,11613,11605,11649,11657,11675,11688,11724,11872,11885,11846,11833,11820,11792,11805,11971,11955,13294,13479,13499,12134,12140,13283,14438,15122,12353,12365,12443,12389,12402,12432,12465,12491,12511,12525,12822,12540,12553,12686,12701,12781,12920,12760,12793,12726,12807,12635,12671,12831,12836,12846,12891,12905,12931,12949,13190,13119,13086,13068,13097,13130,13150,13390,13414,13652,13772,13668,13660,13782,13485,15243,13910,14282,14406,15440,13892,13862,14073,13902,15869,15623,14332,14415,15685,13826,14358,14430,14990,16237,15035,14345,14319,14960,15048,15708,14687,15056,15078,14948,15151,17371,14904,14668,15219,15227,14598,14660,15096,14982,14632,15255,16208,14588,14852,14828,15112,14840,14614,15022,15172,14640,15927,15919,14919,14606,14735,15911,14940,15426,14758,14770,14783,14872,16532,14864,15277,15716,14792,14884,14812,16094,15749,15573,16259,16299,15130,15497,15206,15830,15186,16760,15198,15693,15544,16311,16078,15942,15267,15651,16385,15516,15346,15781,15532,16245,16336,15975,15364,15407,15313,15609,15482,15330,15588,15666,15632,16270,15879,15725,16366,15760,16196,15957,16181,16035,16007,16147,16022,16287,15992,16324,16164,16220,16050,15797,15393,16433,16483,16806,16518,16605,16446,16700,16619,16898,16658,16673,16593,16856,16714,16728,16652,16974,16819,17435,16496,16545,16560,16579,16688,17031,16772,16785,17044,17214,17086,16953,16988,16745,16911,17234,17166,17072,16870,16925,17119,16939,17420,17103,17450,16833,16884,17002,17058,17535,17139,17016,5165,5176,5201,5344,5306,5253,5374,5401,5406,5483,5577,5585,5592,5599,5607,5618,5627,5635,5664,5671,5713,5705,5749,5744,5775,5769,5953,5806,6079,6027,6071,6036,6041,6056,6061,6050,6066,6086,6093,6098,6107,6114,6142,6282,6150,6157,6307,6438,6461,6551,6514,6572,6593,6598,6614,6619,6643,6649,6658,6673,6698,6689,6939,7978,6807,6879,6870,6886,6931,7930,6950,6902,7519,6910,6917,6987,7158,7163,7168,7360,7367,7377,7512,7384,7396,7736,7712,7707,7719,7843,7753,7883,7901,7910,7925,7944,8000,8007,8014,8074,8474,8067,8096,8247,8254,8349,8380,8448,8032,8037,8057,8099,8116,8124,8128,8453,8456,8312,8316,8324,8328,8461,8465,8957,8556,9271,8563,8623,8638,8853,8834,13917,8927,9005,9012,13243,13535,9627,9217,9017,9022,9029,9037,9200,9208,9068,9078,9083,9088,9098,9108,9138,9148,9153,9163,9168,9173,9125,9514,9224,9259,9286,9291,9296,9301,9158,9362,9433,9438,9443,9448,9453,9458,9468,9505,9510,9524,9530,9546,9551,9558,9565,9818,9824,9830,9836,9852,9860,9869,10027,10047,10081,13301,9953,9958,10076,10065,10291,10296,10311,10324,10329,10334,10380,10730,10740,10751,10946,11026,11217,11341,11248,11253,11258,11263,11378,11432,11439,11457,12772,11530,11495,11506,11612,11604,11648,11656,11674,11687,11723,11871,11884,11845,11832,11819,11791,11804,11969,11954,13293,13478,13498,12133,12139,13282,14437,15121,12352,12371,12449,12388,12401,12431,12464,12497,12510,12524,12821,12539,12552,12692,12707,12787,12926,12759,12792,12725,12806,12634,12670,12830,12835,12845,12890,12904,12930,12948,13196,13125,13092,13067,13096,13129,13156,13389,13420,13651,13771,13667,13659,13781,13484,15242,13909,14281,14405,15439,13891,13861,14072,13901,15868,15622,14331,14414,15684,13824,14357,14429,14989,16236,15034,14344,14318,14959,15047,15707,14686,15055,15077,14947,15150,17370,14903,14667,15218,15226,14597,14659,15095,14981,14631,15254,16210,14587,14851,14827,15111,14839,14613,15020,15171,14639,15926,15918,14918,14605,14734,15910,14939,15425,14757,14769,14782,14871,16531,14863,15276,15715,14791,14883,14811,16093,15748,15572,16258,16300,15129,15496,15205,15829,15185,16759,15197,15692,15543,16312,16077,15941,15266,15650,16384,15515,15345,15780,15531,16244,16337,15974,15363,15406,15312,15608,15481,15329,15587,15665,15631,16272,15878,15724,16365,15759,16198,15956,16183,16034,16009,16146,16024,16286,15994,16325,16166,16219,16049,15796,15392,16432,16482,16805,16517,16604,16445,16699,16618,16897,16657,16672,16592,16855,16713,16727,16647,16973,16818,17434,16495,16544,16559,16578,16687,17030,16771,16784,17043,17213,17085,16952,16987,16744,16910,17233,17165,17071,16869,16924,17118,16938,17419,17102,17449,16832,16883,17001,17057,17534,17138,17015,5199,5304,5373,5399,5404,5481,5486,5575,5590,5597,5605,5616,5625,5633,5669,5711,5747,5742,5773,5767,5951,5804,6077,6025,6069,6034,6039,6054,6059,6048,6064,6084,6091,6096,6105,6112,6140,6280,6148,6155,6294,6305,6436,6459,6549,6512,6570,6591,6596,6612,6617,6641,6647,6656,6671,6696,6687,6937,7976,6805,6877,6868,6884,6929,7928,6948,6895,7517,6908,6915,6985,7156,7161,7166,7358,7365,7370,7375,7510,7382,7394,7734,7710,7705,7717,7841,7751,7881,7899,7908,7923,7942,7998,8005,8012,8072,8471,8065,8094,8245,8252,8347,8378,8446,8030,8035,8056,8115,8123,8127,8451,8455,8311,8315,8323,8327,8460,8464,8955,8554,9269,8561,8621,8636,8851,8832,13914,8924,9003,9010,13239,13532,9625,9215,9015,9020,9027,9035,9055,9206,9066,9076,9081,9086,9096,9106,9136,9146,9151,9161,9166,9171,9123,9249,9222,9257,9284,9289,9294,9299,9156,9061,9431,9436,9441,9446,9451,9456,9466,9503,9508,9522,9528,9544,9549,9556,9563,9816,9822,9828,9834,9850,9858,9867,10025,10045,10079,13296,9951,9956,10051,10063,10288,10293,10308,10321,10326,10331,10378,10728,10738,10749,10943,11023,11214,11338,11245,11250,11255,11260,11375,11429,11436,11454,12769,11527,11492,11503,11609,11601,11645,11653,11671,11684,11720,11868,11881,11842,11829,11816,11788,11801,11973,11951,13290,13475,13495,12130,12136,13279,14434,15118,12349,12364,12442,12385,12398,12428,12461,12490,12507,12521,12818,12536,12549,12685,12700,12780,12742,12919,12756,12789,12722,12803,12631,12667,12827,12832,12842,12887,12901,12927,12945,13189,13118,13085,13064,13093,13126,13149,13386,13413,13648,13768,13664,13656,13778,13481,15239,13906,14278,14402,15436,13888,13858,14069,13898,15865,15619,14328,14411,15681,13822,14354,14426,14986,16233,15031,14341,14315,14956,15044,15704,14683,15052,15074,14944,15147,17367,14900,14664,15215,15223,14594,14656,15092,14978,14628,15251,16212,14584,14848,14824,15108,14836,14610,15018,15168,14636,15923,15915,14915,14602,14731,15907,14936,15430,14754,14766,14779,14868,16528,14860,15273,15712,14788,14880,14808,16090,15745,15569,16255,16303,15126,15493,15202,15826,15182,16756,15194,15689,15540,16315,16074,15938,15263,15647,16381,15512,15342,15777,15528,16241,16340,15971,15360,15403,15309,15605,15478,15326,15584,15662,15628,16274,15875,15721,16362,15756,16200,15968,16185,16031,16011,16143,16026,16283,15996,16328,16168,16216,16046,15793,15389,16429,16479,16802,16514,16601,16442,16696,16615,16894,16654,16669,16589,16852,16710,16724,16645,16970,16815,17431,16492,16541,16556,16575,16683,17027,16768,16781,17040,17210,17082,16949,16984,16741,16907,17230,17162,17068,16866,16921,17115,16935,17416,17099,17446,16829,16880,16998,17054,17531,17135,17012,7723,7724,7828,7286,12217,7822,7837,7117,7119,7289,7290,12199,7700,7898,7287,7116,7175,7823,12202,12219,7293,7702,7698,12218,7725,7831,7824,7829,7879,7832,7839,7897,8363,7821,7825,7726,8406,7830,6228,8362,7826,8365,8407,7835,7827,8364,7880,8400,8404,8409,7878,8156,8157,8392,8374,8393,8394,8395,6926,6955,8390,8375,8396,8391,8336,8403,8408,8401,8405,12323,7440,8399,8402,7770,12736,8140,8137,8353,8373,8422,12325,12313,9176,9205,9212,10277,10336,12318,5166,5177,5202,5346,5307,5255,5376,5141,5403,5408,5478,5485,5579,5587,5594,5601,5609,5620,5629,5637,5666,5673,5715,5707,5751,5746,5777,5771,5955,5808,6081,6029,6073,6038,6043,6058,6063,6068,6088,6095,6100,6109,6116,6144,6284,6152,6159,6312,6440,6463,6553,6516,6574,6595,6600,6616,6621,6645,6651,6660,6675,6700,6691,6941,7980,6809,6881,6872,6888,6933,7932,6952,6904,7521,6912,6919,6989,7160,7165,7170,7362,7369,7379,7514,7386,7398,7738,7714,7709,7721,7845,7755,7885,7903,7912,7927,7946,8002,8009,8016,8076,8475,8069,8098,8249,8256,8351,8382,8450,8034,8039,8059,8101,8118,8126,8130,8454,8457,8314,8318,8326,8330,8463,8467,8959,8558,9273,8565,8625,8640,8854,8836,13916,8928,9007,9014,13242,13534,9629,9219,9019,9024,9031,9039,9202,9210,9070,9080,9085,9090,9100,9110,9140,9150,9155,9165,9170,9175,9127,9516,9226,9261,9288,9293,9298,9303,9160,9364,9435,9440,9445,9450,9455,9460,9470,9507,9512,9526,9532,9548,9553,9560,9567,9820,9826,9832,9838,9854,9862,9871,10029,10049,10083,13299,9955,9961,10078,10067,10292,10297,10312,10325,10330,10335,10382,10732,10742,10753,10945,11025,11218,11340,11247,11252,11257,11262,11377,11431,11438,11456,12771,11529,11494,11505,11611,11603,11647,11655,11673,11686,11722,11870,11883,11844,11831,11818,11790,11803,11966,11953,13292,13477,13497,12131,12137,13281,14436,15120,12351,12368,12446,12387,12400,12430,12463,12494,12509,12523,12820,12538,12551,12689,12704,12784,12923,12758,12791,12724,12805,12633,12669,12829,12834,12844,12889,12903,12929,12947,13193,13122,13089,13066,13095,13128,13153,13388,13417,13650,13770,13666,13658,13780,13483,15241,13908,14280,14404,15438,13890,13860,14071,13900,15867,15621,14330,14413,15683,13825,14356,14428,14988,16235,15033,14343,14317,14958,15046,15706,14685,15054,15076,14946,15149,17369,14902,14666,15217,15225,14596,14658,15094,14980,14630,15253,16206,14586,14850,14826,15110,14838,14612,15021,15170,14638,15925,15917,14917,14604,14733,15909,14938,15432,14756,14768,14781,14870,16530,14862,15275,15714,14790,14882,14810,16092,15747,15571,16257,16301,15128,15495,15204,15828,15184,16758,15196,15691,15542,16313,16076,15940,15265,15649,16383,15514,15344,15779,15530,16243,16338,15973,15362,15405,15311,15607,15480,15328,15586,15664,15630,16271,15877,15723,16364,15758,16194,15955,16179,16033,16008,16145,16023,16285,15993,16326,16162,16218,16048,15795,15391,16431,16481,16804,16516,16603,16444,16698,16617,16896,16656,16671,16591,16854,16712,16726,16648,16972,16817,17433,16494,16543,16558,16577,16686,17029,16770,16783,17042,17212,17084,16951,16986,16743,16909,17232,17164,17070,16868,16923,17117,16937,17418,17101,17448,16831,16882,17000,17056,17533,17137,17014,5109,5678,5117,5073,5098,5691,5556,5679,5557,5730,6236,5647,5676,5657,5677,5645,5580,5674,5610,5639,5630,5685,5684,5716,5690,6237,6263,6238,6275,6264,6265,6266,6267,6381,6268,8366,6958,6964,6960,6963,8930,6961,10003,9785,9780,9787,8987,8859,8860,10002,8861,8862,8988,8989,8990,10004,9786,9781,9788,9751,9789,14087,9032,9040,10814,9130,9782,11013,10022,10069,10735,10746,10754,10948,11988,11683,11696,11864,11877,11890,11854,11841,11828,11799,11812,11974,11962,11980,13425,15776,12363,12441,12396,12427,12460,12476,12506,12520,12547,12560,12684,12699,12779,12741,12918,12767,12800,12733,12814,12630,12666,12884,12898,12912,12938,12956,13039,13188,13117,13084,13075,13104,13137,13148,13412,13570,13800,13610,13492,15026,13852,14289,14294,13847,13877,13810,13815,13820,13837,13872,13842,14339,14313,14370,14365,14308,14352,14326,14787,14648,14539,17380,14546,14998,14534,14567,14592,14527,14508,15004,14999,14503,14475,14513,14498,15005,15775,15006,15732,16540,15007,15287,15008,16135,16801,15288,17129,15289,16142,16136,16140,15617,17131,17132,16279,15627,15568,16131,16155,16231,16968,16141,16137,15424,15381,15401,16441,16491,16814,16526,16614,16454,16709,16628,16906,16667,16682,16865,16737,17130,16983,16828,17444,17039,16780,16793,17053,17223,17095,16962,16997,16920,17243,17175,17081,16879,16934,17128,16948,17429,17112,17459,16842,16893,17011,17067,17544,17148,17025,13304,6173,7995,6783,6407,7192,6557,7421,6499,6464,6563,6561,6486,7121,7297,6556,6485,6484,8687,6479,9662,13107,6562,6607,10465,6558,6777,6756,8240,6639,6923,8428,7298,6638,6652,10952,6554,10953,6637,11063,9121,6564,7295,9074,13926,9713,8549,7701,12085,11016,11060,10429,9711,8520,7196,6640,10230,8677,7296,9661,8505,9113,8679,8017,8678,11269,9892,10263,9114,12194,8018,8357,8023,8511,6934,8411,9572,8412,10386,9112,11070,10906,8676,9799,11990,8414,8024,8413,8410,11066,8242,9712,11398,8155,14566,8437,17026,9379,9805,11399,16394,9905,11351,12045,11400,11401,9714,9057,14521,8694,9663,13519,9283,13629,13624,9903,9904,12128,11638,13601,13574,9902,13709,12108,10264,12261,12265,12059,12119,13529,10266,10001,11267,9804,13520,10363,9380,10246,10075,10247,10043,10428,12272,10908,11068,10282,9877,10245,11057,10073,10709,10280,10427,9876,10283,10285,10106,10089,10281,10087,10916,10417,12091,10265,10229,10284,10094,10454,10388,13332,10561,10395,10710,11239,13595,13471,11305,11392,10954,10942,11315,11033,11046,11302,13563,11681,11694,11866,11879,11899,12015,11892,11851,11838,11825,11798,11811,11965,11961,13606,13468,12193,13569,11979,13289,13430,13201,13337,13407,13541,13526,13343,13340,12347,12361,12439,12394,12407,12426,12459,12474,12487,12505,12519,12545,12682,12697,12777,12739,12916,12765,12798,12731,12812,12629,12665,12883,12897,12911,12937,12955,13037,13115,13082,13073,13102,13135,13146,13371,13410,13401,13628,13604,13580,13583,13598,13577,13566,13586,13924,13589,13491,15249,13851,14288,14293,13846,13875,13809,13814,13819,13836,13870,13841,14338,14312,14369,14364,14307,14996,14468,15041,14351,14325,14966,15016,15029,14569,15012,15071,14727,14715,14536,17378,14897,14544,14578,15067,14531,14558,15089,14975,14582,14913,14525,14506,14845,14821,14929,14833,14501,14933,14802,14478,14482,14486,14472,14925,14511,14741,14495,14719,14971,14764,14723,14730,14676,16538,14857,15002,14806,14798,14877,14818,14680,15084,15160,15163,15166,15579,16265,16305,15136,15503,15212,15836,15179,16754,15191,15699,15550,16317,16084,15948,15260,15657,16391,15522,15352,15787,15538,16251,16342,15981,15370,15413,15319,15615,15488,15336,15594,15672,15638,16276,15885,15731,16372,15766,16201,15963,16186,16041,16013,16153,16028,16293,15998,16330,16169,16226,16056,15803,15387,15422,15379,15399,16439,16489,16812,16524,16612,16452,16707,16626,16904,16665,16680,16599,16863,16721,16735,16644,16981,16826,17442,16502,16551,16566,16586,16694,17037,16778,16791,17051,17221,17093,16960,16995,16740,16918,17241,17173,17079,16877,16932,17126,16946,17427,17110,17457,16840,16891,17009,17065,17542,17146,17023,9601,9492,9588,9664,9589,9611,10426,10981,9603,9585,9534,9419,9598,9478,9493,9621,9425,9595,11064,9486,9414,9596,9475,9047,9483,9593,9586,9581,9487,9484,9417,9421,9600,9476,9587,9488,9608,12187,9582,9594,9482,9489,9477,9604,9535,9583,9494,9490,10989,9416,12195,9533,10965,9491,10988,9605,10815,9536,9613,9577,9624,9479,9481,9597,9584,9580,11573,9496,9614,9599,9413,9749,11067,9612,9610,9480,13590,9592,9602,9495,16122,10992,9616,12186,9579,9591,9426,9415,9428,9607,9578,10980,11109,9429,10800,10982,11021,9422,9423,13920,10905,10843,10554,17336,10556,10071,10804,10809,9908,10991,11051,10397,11108,10459,10799,11034,11015,10557,10801,10835,10826,10975,10568,9679,10070,10074,9615,9622,9606,9623,9798,10558,11069,10128,9810,10044,10424,10072,10095,9965,9945,9966,10818,9561,9568,9821,9827,9833,9839,9855,9863,9872,10030,10050,10084,13300,9968,10088,12092,10068,10398,10364,10490,12129,11072,10450,10734,10744,10990,11059,11028,11219,11349,12179,12145,11312,11380,11434,11441,11501,11533,11498,11509,11615,11607,11651,12164,11677,11690,11726,11874,11887,11848,11835,11822,11794,11807,11970,11957,13295,13480,13500,12135,12141,13284,14440,15125,12354,12370,12448,12392,12405,12433,12466,12496,12512,12526,12543,12556,12691,12706,12786,12748,12925,12763,12796,12729,12810,12636,12672,12892,12906,12932,12950,13195,13124,13091,13071,13100,13133,13155,13391,13419,13655,13773,13670,13663,13783,13486,15246,13912,14284,14408,15443,13895,13864,14075,13904,15872,15626,14335,14418,15688,13829,14361,14433,14993,16240,15038,14348,14321,14963,15050,15711,14689,15058,15080,14951,15153,17374,14906,14671,15222,15230,14599,14663,15098,14984,14633,15258,16209,14589,14854,14830,15114,14842,14615,15024,15175,14641,15930,15922,14922,14607,14738,15914,14943,15429,14761,14773,14785,14874,16535,14866,15280,15719,14795,14886,14815,16097,15752,15576,16262,16298,15133,15500,15209,15833,15188,16761,15200,15696,15547,16310,16081,15945,15269,15654,16388,15519,15349,15784,15535,16248,16335,15978,15367,15410,15314,15612,15485,15333,15591,15669,15635,16269,15882,15728,16369,15763,16197,15960,16182,16038,16006,16150,16021,16290,15991,16323,16165,16223,16053,15800,15395,16436,16486,16809,16521,16608,16449,16703,16622,16901,16661,16676,16596,16859,16717,16731,16649,16977,16822,17438,16499,16548,16563,16583,16691,17034,16775,16788,17047,17217,17089,16956,16991,16746,16914,17237,17169,17075,16873,16928,17122,16942,17423,17106,17453,16836,16887,17005,17061,17538,17142,17019,11142,11232,11992,11086,11127,11134,11202,11096,11466,11156,13334,11450,11126,11172,11084,11168,11243,11544,11175,12017,11137,14573,11098,11200,11177,11463,11089,11145,11203,11169,11138,11190,14462,11163,11124,11143,11139,11184,12243,12196,11198,11461,11087,11462,11185,11205,11545,11135,11206,11130,11157,11094,11167,11179,11131,11187,11574,11092,11141,11896,11085,11091,11093,13592,11201,13034,11204,11144,16123,11090,11102,12185,11129,17528,11158,11207,11147,11192,11148,11150,11208,11159,11318,11125,11316,11186,11188,13919,11939,14088,17334,11191,12120,12061,11357,11132,11230,11329,11097,11100,11176,11146,11183,11160,11170,11449,11095,11319,11154,12244,12104,11193,12234,11173,12282,11225,12232,11343,11345,12230,11396,11212,11161,11717,12051,11088,12248,11178,12236,11164,11166,11180,12103,12003,12177,11944,17227,12229,15557,11644,12176,13866,11220,11348,12178,12144,11946,11664,14952,11500,11532,11497,11508,11614,11606,11650,11676,11689,11725,11860,11873,11886,11847,11834,11821,11793,11806,11968,11956,16120,16126,15506,15176,13285,14439,15123,12355,12366,12444,12390,12403,12434,12467,12492,12513,12527,12541,12554,12687,12702,12782,12921,12761,12794,12727,12808,12637,12673,12893,12907,12933,12951,13191,13120,13087,13069,13098,13131,13151,13392,13415,13653,13775,13669,13661,13785,13487,15244,13911,14283,14407,15441,13893,13863,14074,13903,15870,15624,14333,14416,15686,13827,14359,14431,14991,16238,15036,14346,14320,14961,15049,15709,14688,15057,15079,14949,15152,17372,14905,14669,15220,15228,14600,14661,15097,14983,14634,15256,16205,14590,14853,14829,15113,14841,14616,15023,15173,14642,15928,15920,14920,14608,14736,15912,14941,15427,14759,14771,14786,14875,16533,14865,15278,15717,14793,14885,14813,16095,15750,15574,16260,16296,15131,15498,15207,15831,15187,16763,15199,15694,15545,16308,16079,15943,15268,15652,16386,15517,15347,15782,15533,16246,16333,15976,15365,15408,15315,15610,15483,15331,15589,15667,15633,16267,15880,15726,16367,15761,16193,15958,16178,16036,16004,16148,16019,16288,15989,16321,16161,16221,16051,15798,15394,16434,16484,16807,16519,16606,16447,16701,16620,16899,16659,16674,16594,16857,16715,16729,16651,16975,16820,17436,16497,16546,16561,16580,16689,17032,16773,16786,17045,17215,17087,16954,16989,16748,16912,17235,17167,17073,16871,16926,17120,16940,17421,17104,17451,16834,16885,17003,17059,17536,17140,17017,11715,9669,10187,10256,11018,9801,9670,9800,13786,14692,12565,13690,13432,10970,10977,12038,12044,11757,12270,11756,11758,11903,11759,10978,10971,12204,10979,13797,13439,13158,13157,13447,14693,11421,11422,11423,11424,11425,11426,11427,11428,12572,13443,16138,13445,13449,14699,15677,14646,14700,15896,15905,17160,16967,15893,17252,15895,16352,16117,15899,17224,15901,15903,16280,15581,16111,16129,15838,16113,16115,15701,15553,16087,15951,15873,16172,15524,15354,15789,16253,15984,15372,15415,15320,15490,15338,15596,15674,15640,16357,15768,16189,15966,16174,16043,16001,16016,15986,16157,16228,16059,15805,10526,10539,10360,10425,10367,10717,10354,10349,10543,10387,10359,11065,10765,10548,10564,10920,10567,10430,10560,10431,10366,10766,10527,10348,10555,10536,10532,10433,10540,10528,10767,10353,10355,10541,10346,10550,10485,10549,10708,10764,10909,10351,12197,10533,10763,11227,10762,11010,11110,10816,10525,11226,10547,10537,10350,10356,10396,11335,11022,11575,10529,10358,11408,10531,10530,10534,13591,10926,10565,10918,10542,16124,11234,11240,10768,10551,17529,10365,11123,12052,10929,11665,13501,11397,12114,10986,11120,11317,10357,13921,10924,10911,17335,10912,11113,12060,11229,10361,11231,11213,10535,10960,10919,10496,11241,11210,11111,10915,11344,11464,10773,11211,10347,11320,10994,12245,11112,10976,10917,10910,10772,11321,10914,11009,10771,11336,10927,11114,12082,10921,10984,10770,11228,10928,11242,10769,11359,10524,10538,10343,10344,10922,10345,14593,11115,11116,10278,17228,11117,15558,10733,10743,11118,11008,14927,11714,11448,12180,12146,11311,11592,11435,14954,11502,11534,11499,11510,11616,11608,11652,11678,11691,11727,11875,11888,11849,11836,11823,11795,11808,11967,11958,16121,16125,14572,14574,13286,14441,15124,12356,12369,12447,12391,12404,12435,12468,12495,12514,12528,12542,12555,12690,12705,12785,12747,12924,12762,12795,12728,12809,12638,12674,12894,12908,12934,12952,13194,13123,13090,13070,13099,13132,13154,13393,13418,13654,13774,13671,13662,13784,13488,15245,13913,14285,14409,15442,13894,13865,14076,13905,15871,15625,14334,14417,15687,13828,14360,14432,14992,16239,15037,14347,14322,14962,15051,15710,14690,15059,15081,14950,15154,17373,14907,14670,15221,15229,14601,14662,15099,14985,14635,15257,16207,14591,14855,14831,15115,14843,14617,15025,15174,14643,15929,15921,14921,14609,14737,15913,14942,15428,14760,14772,14784,14873,16534,14867,15279,15718,14794,14887,14814,16096,15751,15575,16261,16297,15132,15499,15208,15832,15189,16762,15201,15695,15546,16309,16080,15944,15270,15653,16387,15518,15348,15783,15534,16247,16334,15977,15366,15409,15316,15611,15484,15332,15590,15668,15634,16268,15881,15727,16368,15762,16195,15959,16180,16037,16005,16149,16020,16289,15990,16322,16163,16222,16052,15799,15396,16435,16485,16808,16520,16607,16448,16702,16621,16900,16660,16675,16595,16858,16716,16730,16650,16976,16821,17437,16498,16547,16562,16581,16690,17033,16774,16787,17046,17216,17088,16955,16990,16747,16913,17236,17168,17074,16872,16927,17121,16941,17422,17105,17452,16835,16886,17004,17060,17537,17141,17018,9916,9917,9914,9915,9924,9920,9921,9918,9912,8841,9919,9792,9690,9691,9922,9699,9701,9748,9702,9696,9692,9913,9910,9911,9704,9873,9875,9775,9695,9703,9705,9693,15341,9698,9694,9700,9697,14753,9874,14752,11014,15679,15906,16356,15583,15840,15703,16088,15952,15526,15356,15985,15374,15417,15321,15340,15598,15676,15642,15770,16191,15967,16176,16045,16003,16018,16295,15988,16159,16230,16060,15807,12111,11745,13257,11122,11596,11151,11525,12110,11133,12011,11934,11280,11331,11524,11548,11521,13700,13701,11281,11993,11576,11171,13702,11981,15891,12721,11541,12113,11728,11330,11622,12070,11522,12980,11550,11282,12109,12069,11739,11567,13372,11564,12068,11362,12009,12981,11594,12983,11555,11526,11194,11332,11285,12010,11536,12049,11537,11708,11307,12100,12121,11565,12112,11289,11707,11597,11292,12053,15281,12050,11556,11712,11283,11709,13140,14749,11459,12012,11738,11276,11595,11543,11277,11540,11570,11731,11740,11557,11552,12284,11579,11566,11711,11621,12979,11278,11523,11743,11742,12285,14891,11741,11549,13258,11286,12002,11290,11558,11571,11460,12286,12013,11706,12283,11554,11551,13170,11569,12001,14691,11284,11279,12977,11568,17226,13172,11287,12972,13171,13830,11291,13867,13169,13313,13174,14888,14953,13268,12971,13168,15060,12984,13142,13167,12982,12978,15474,16127,13267,13173,15754,15755,15843,14889,16407,15475,15434,15461,15931,14890,14748,15476,16630,15846,15445,16638,15527,15446,15452,16633,15845,15847,16468,15451,15477,15933,15859,15468,15462,15823,15469,15470,15844,16408,16573,15463,15449,15860,15444,15448,16572,16568,15460,15856,16467,15471,16570,15849,16571,16634,15842,15447,15459,16635,15450,16469,15850,16406,15861,16798,15454,15934,16636,15813,16637,16569,15852,16632,15453,16404,15841,16466,15473,15851,15560,16401,16411,15561,16405,16513,16574,15376,15863,16395,16410,15375,15858,15382,15932,15384,15853,15854,15855,16509,16631,15862,16412,16409,16396,16400,16402,16397,16399,16511,16403,16512,16510,16398,15864,16794,16795,17200,16797,16799,16796,17196,16800,17246,17194,17195,17202,17197,17467,17201,17500,17198,17199,17501,17504,17250,17468,17229,17247,17503,17244,17248,17506,17249,17505,17245,17495,17502,17499,16213,16214,16215,5005,5059,5251,5250,5125,5007,5108,5249,5123,5288,5018,5105,5247,5014,5277,5042,5276,5075,5272,5515,5248,5383,5267,5269,5050,5554,5270,5361,5266,5086,5121,5517,5505,5536,5640,5534,5545,5552,5573,5581,5588,5595,5603,5614,5623,5631,5644,5660,5667,5682,5701,5740,5738,5756,5763,5765,5948,5934,5802,6075,6023,6030,6032,6046,6123,6082,6089,6103,6101,6110,6138,6146,6153,6292,6303,6397,6399,6510,6446,6448,6450,6518,6585,8259,6603,6605,6646,6608,6610,6622,6891,6694,6669,6942,6701,6442,6754,6935,6835,6866,6882,6927,7913,7531,7933,6953,6899,7515,6906,6921,6983,7197,7387,7363,7389,7380,7391,7526,8257,7442,7732,7399,7401,7403,7405,7407,7410,7739,7703,7715,7727,7759,7749,7887,7904,7906,7921,7935,7948,7991,8135,7996,8003,8010,8077,8856,8070,8092,8131,8605,8148,8243,8250,8476,8309,8522,8345,8376,8518,13517,8559,8674,13622,8603,8604,8695,9570,12126,8606,13599,13572,9008,10137,12106,9036,12259,12263,12057,12117,13527,9410,9900,9025,9033,10812,9128,9406,9542,9766,9768,9770,9772,10251,12257,9776,9793,10249,9806,10007,9811,10005,9949,10041,10374,9554,10253,11011,9848,9856,9865,10023,10031,10033,10035,10039,12089,10053,10055,10057,10059,10061,10198,10275,13330,10313,10315,10317,10319,13593,13469,11304,9927,10757,10736,10747,10937,11313,11031,11044,11296,13561,11679,11692,11863,11876,11897,12014,11889,11850,11837,11824,11796,11809,11964,11959,13608,13467,12191,13567,11977,13287,13428,13199,13335,13405,13539,13524,13341,13338,12345,12359,12437,12393,12406,12424,12457,12472,12485,12503,12517,12544,12680,12695,12775,12737,12914,12764,12797,12730,12811,12627,12663,12881,12895,12909,12935,12953,13035,13113,13080,13072,13101,13134,13144,13369,13408,13399,13626,13602,13578,13581,13596,13575,13564,13584,13922,13587,13489,15247,13849,14286,14291,13844,13873,13807,13812,13817,13834,13868,13839,14336,14310,14367,14362,14305,14994,14467,15039,14349,14323,14964,15014,15027,14568,15010,15070,14725,14713,14535,17376,14896,14542,14576,15065,14530,14556,15088,14974,14580,14911,14523,14504,14844,14820,14928,14832,14499,14932,14800,14476,14480,14484,14471,14923,14509,14739,14494,14717,14970,14762,14721,14711,14675,16536,14856,15000,14804,14796,14876,14816,14679,15082,15158,15161,15164,15577,16263,16307,15134,15501,15210,15834,15178,16752,15190,15697,15548,16319,16082,15946,15259,15655,16389,15520,15350,15785,15536,16249,16344,15979,15368,15411,15317,15613,15486,15334,15592,15670,15636,16278,15883,15729,16370,15764,16203,15961,16188,16039,16015,16151,16030,16291,16000,16332,16171,16224,16054,15801,15385,15420,15377,15397,16437,16487,16810,16522,16610,16450,16705,16624,16902,16663,16678,16597,16861,16719,16733,16642,16979,16824,17440,16500,16549,16564,16584,16692,17035,16776,16789,17049,17219,17091,16958,16993,16738,16916,17239,17171,17077,16875,16930,17124,16944,17425,17108,17455,16838,16889,17007,17063,17540,17144,17021 ,@CustomerId = 1 ,
MESSAGE:Incorrect syntax near ','.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary2 paramList, List1 exportFields, String orderBy, Int32 timeOut) 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary2 paramValues, List`1 exportFields, String orderField, Int32 timeOut)
在 Biz.Irobotbox.ReportCentre.CustomReportService.<>c__DisplayClass34_0.b__2()
在 System.Threading.Tasks.Task.InnerInvoke()
在 System.Threading.Tasks.Task.Execute()
在 System.Threading.Tasks.Task.ExecutionContextCallback(Object obj)
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
在 System.Threading.Tasks.ThreadPoolTaskScheduler.TryExecuteTaskInline(Task task, Boolean taskWasPreviouslyQueued)
在 System.Threading.Tasks.TaskScheduler.TryRunInline(Task task, Boolean taskWasPreviouslyQueued)
在 System.Threading.Tasks.Task.WrappedTryRunInline()
在 System.Threading.Tasks.Task.WaitAll(Task[] tasks, Int32 millisecondsTimeout, CancellationToken cancellationToken)
在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportFileByTask()
在 PandaBuy.ERP.Web.ProfitTest.btnCustomReportExport_Click(Object sender, EventArgs e)
在 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
在 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.profittest_aspx.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
EXEC proc_string_split @OrderSourceID,',';