SQLize Online / PHPize Online  /  SQLtest Online

SELECT *, (balance + pnl) AS equity FROM ( SELECT time, pnl, deals_count, SUM(closed_profit) over (ORDER BY time) AS balance FROM ( SELECT * FROM ( SELECT time, SUM(pnl) AS pnl, COUNT(deal_id) AS deals_count, 0 AS closed_profit FROM deals__gross_pnl WHERE deal_id IN (16421,16427,16422,16429,16431,16430,16432,16426,16423,16424,16425,16436,16428,16437,16433,16434,16439,16440,16435,16441,16446,16438,16450,16461,16443,16467,16442,16474,16451,16448,16449,16447,16455,16445,16462,16444,16453,16452,16454,16456,16477,16481,16459,16460,16457,16458,16484,16463,16487,16464,16465,16466,16470,16469,16468,16499,16479,16501,16502,16500,16498,16489,16490,16483,16482,16472,16473,16471,16475,16476,16478,16491,16480,16493,16488,16485,16486,16495,16494,16492,16497,16506,16496,16516,16524,16523,16526,16504,16525,16503,16514,16515,16505,16508,16507,16509,16520,16530,16512,16511,16513,16510,16538,16541,16517,16519,16518,16521,16522,16528,16527,16534,16529,16531,16533,16532,16546,16544,16539,16545,16543,16542,16537,16535,16536,16551,16556,16540,16558,16562,16561,16549,16566,16550,16547,16548,16552,16555,16553,16554,16570,16559,16560,16557,16575,16586,16595,16600,16604,16612,16568,16565,16563,16564,16567,16585,16574,16576,16573,16571,16581,16572,16591,16578,16569,16580,16579,16577,16584,16583,16582,16590,16588,16589,16587,16614,16619,16603,16596,16601,16602,16597,16594,16592,16593,16598,16599,16607,16605,16606,16608,16618,16617,16616,16623,16615,16613,16611,16610,16609,16629,16627,16628,16624,16626,16622,16620,16621,16632,16625,16631,16630,16642,16649,16658,16664,16636,16635,16633,16634,16638,16637,16641,16639,16640,16644,16643,16670,16646,16645,16648,16653,16647,16651,16650,16652,16677,16656,16655,16654,16661,16657,16660,16659,16679,16686,16690,16699,16666,16703,16689,16669,16668,16663,16662,16665,16672,16671,16667,16687,16673,16685,16682,16684,16675,16676,16674,16683,16678,16681,16680,16695,16691,16692,16694,16688,16693,16704,16696,16709,16697,16698,16711,16705,16702,16701,16700,16710,16713,16712,16717,16714,16706,16708,16707,16718,16716,16719,16725,16715,16724,16726,16728,16721,16720,16723,16722,16727,16738,16748,16755,16753,16739,16736,16737,16729,16730,16731,16732,16733,16734,16735,16744,16741,16742,16743,16740,16752,16746,16745,16747,16750,16754,16749,16751,16759,16761,16762,16760,16766,16757,16767,16758,16756,16765,16764,16763,16770,16775,16782,16786,16771,16789,16794,16799,16806,16811,16815,16818,16820,16821,16819,16774,16772,16773,16768,16769,16778,16776,16817,16777,16812,16814,16783,16810,16792,16793,16787,16785,16781,16780,16779,16784,16801,16788,16791,16790,16803,16802,16795,16798,16797,16800,16796,16804,16807,16805,16828,16830,16839,16809,16846,16808,16850,16813,16855,16859,16816,16862,16865,16822,16823,16824,16871,16873,16877,16887,16826,16835,16827,16825,16834,16832,16831,16829,16833,16890,16893,16837,16842,16836,16838,16843,16840,16841,16892,16847,16894,16891,16888,16879,16878,16875,16868,16869,16851,16849,16848,16844,16845,16863,16854,16852,16853,16866,16858,16856,16857,16864,16860,16861,16867,16883,16870,16898,16900,16903,16874,16872,16902,16881,16876,16882,16880,16889,16884,16904,16886,16885,16899,16896,16895,16897,16907,16915,16917,16901,16923,16920,16908,16906,16911,16905,16910,16909,16918,16919,16916,16928,16914,16932,16912,16913,16941,16931,16933,16921,16922,16925,16935,16927,16926,16924,16930,16936,16934,16929,16949,16940,16939,16937,16945,16938,16959,16944,16942,16950,16943,16946,16948,16965,16947,16966,16962,16953,16952,16951,16964,16961,16955,16956,16954,16960,16971,16976,16957,16958,16963,16979,16988,16995,16972,16968,16998,16980,16970,16969,16967,16977,16981,16978,16975,16973,16974,16985,16982,16984,16983,17005,17014,17020,16994,17024,16992,16993,16989,16987,16986,16991,16990,16996,17026,17027,17025,17004,17003,17002,17001,16997,16999,17000,17006,17009,17010,17007,17008,17018,17015,17016,17019,17017,17011,17013,17012,17031,17038,17032,17022,17023,17030,17021,17028,17036,17029,17042,17045,17047,17037,17033,17035,17034,17048,17049,17050,17046,17043,17044,17054,17041,17063,17040,17039,17066,17073,17078,17052,17058,17053,17051,17056,17055,17057,17077,17068,17076,17061,17060,17062,17059,17075,17067,17065,17064,17071,17072,17069,17070,17084,17094,17098,17074,17097,17086,17082,17079,17081,17080,17083,17090,17087,17085,17088,17089,17095,17096,17093,17102,17091,17105,17092,17109,17116,17120,17125,17103,17130,17133,17101,17100,17099,17134,17112,17132,17107,17106,17104,17128,17127,17129,17110,17111,17108,17114,17113,17123,17122,17115,17139,17117,17118,17149,17153,17121,17119,17158,17124,17126,17157,17137,17138,17131,17135,17136,17140,17146,17144,17145,17159,17141,17142,17143,17156,17154,17151,17152,17167,17150,17147,17148,17165,17166,17169,17155,17168,17170,17162,17163,17164,17161,17160,17174,17175,17180,17183,17187,17188,17173,17171,17172,17176,17179,17177,17178,17185,17181,17182,17184,17194,17186,17201,17206,17189,17211,17190,17215,17218,17192,17191,17198,17197,17195,17193,17196,17216,17219,17204,17199,17202,17200,17203,17220,17213,17212,17214,17210,17223,17207,17205,17233,17208,17209,17241,17245,17225,17217,17224,17222,17221,17227,17226,17229,17228,17249,17255,17230,17232,17237,17231,17236,17235,17234,17261,17265,17246,17269,17271,17275,17282,17244,17240,17238,17239,17242,17243,17251,17286,17290,17294,17254,17248,17250,17247,17252,17257,17253,17256,17300,17303,17311,17321,17324,17262,17327,17330,17334,17337,17260,17258,17259,17266,17270,17264,17263,17274,17268,17267,17342,17347,17350,17353,17277,17276,17278,17273,17272,17280,17292,17279,17287,17288,17289,17284,17283,17296,17281,17310,17315,17285,17317,17295,17293,17291,17298,17297,17359,17305,17301,17302,17299,17309,17304,17306,17307,17361,17308,17312,17314,17313,17316,17368,17370,17379,17319,17335,17318,17320,17404,17403,17406,17405,17326,17322,17323,17328,17325,17397,17398,17395,17396,17401,17402,17331,17329,17399,17333,17332,17336,17341,17340,17338,17400,17339,17394,17392,17351,17391,17390,17344,17343,17387,17349,17348,17346,17345,17355,17356,17354,17352,17393,17362,17360,17358,17366,17357,17364,17365,17363,17389,17386,17367,17375,17369,17376,17372,17371,17373,17374,17378,17382,17377,17381,17380,17388,17385,17383,17384,17408,17416,17407,17420,17421,17425,17424,17423,17411,17409,17410,17422,17414,17417,17413,17412,17429,17418,17433,17437,17415,17419,17439,17438,17442,17443,17435,17436,17434,17432,17446,17428,17453,17426,17427,17430,17431,17455,17457,17456,17440,17441,17445,17450,17444,17451,17447,17452,17448,17454,17449,17467,17471,17476,17480,17460,17458,17459,17490,17495,17463,17477,17461,17462,17479,17472,17478,17475,17465,17466,17464,17470,17468,17469,17474,17485,17473,17484,17482,17481,17496,17483,17504,17486,17505,17498,17487,17499,17494,17489,17491,17500,17488,17509,17517,17493,17492,17522,17497,17526,17535,17506,17507,17508,17502,17503,17501,17511,17510,17512,17539,17543,17545,17513,17557,17560,17567,17546,17515,17514,17516,17518,17519,17542,17540,17541,17525,17524,17532,17523,17521,17520,17527,17528,17529,17531,17530,17538,17537,17550,17536,17534,17533,17552,17553,17551,17547,17548,17544,17549,17573,17577,17581,17579,17580,17571,17558,17572,17568,17559,17555,17556,17554,17561,17563,17562,17565,17564,17569,17586,17566,17593,17600,17570,17608,17601,17574,17575,17576,17578,17607,17583,17582,17606,17604,17605,17602,17603,17609,17589,17610,17588,17587,17584,17585,17611,17592,17591,17594,17590,17597,17598,17595,17596,17599,17617,17614,17619,17623,17626,17630,17633,17636,17615,17612,17613,17640,17643,17650,17654,17660,17664,17666,17675,17679,17678,17673,17618,17616,17637,17674,17665,17622,17621,17620,17625,17624,17667,17663,17628,17629,17627,17655,17652,17641,17642,17639,17638,17632,17631,17635,17634,17645,17672,17647,17646,17648,17644,17651,17683,17649,17684,17656,17701,17653,17662,17659,17657,17658,17661,17699,17700,17670,17671,17668,17669,17676,17706,17704,17705,17677,17702,17688,17689,17703,17682,17680,17681,17708,17686,17685,17687,17711,17707,17710,17709,17698,17690,17691,17696,17694,17695,17697,17692,17693,17714,17719,17712,17713,17718,17723,17717,17715,17716,17734,17724,17722,17720,17721,17728,17732,17733,17726,17725,17727,17730,17729,17731,17737,17743,17738,17735,17736,17741,17739,17740,17742,17745,17744,17747,17748,17746,17752,17758,17765,17771,17775,17778,17782,17754,17786,17753,17789,17751,17749,17750,17755,17756,17792,17797,17795,17793,17761,17790,17783,17764,17762,17759,17757,17760,17763,17767,17766,17781,17780,17777,17774,17773,17769,17799,17770,17768,17772,17812,17816,17819,17776,17824,17828,17832,17779,17785,17835,17784,17788,17787,17794,17839,17791,17796,17798,17800,17804,17802,17803,17801,17805,17849,17807,17853,17808,17806,17855,17813,17863,17868,17875,17881,17884,17817,17810,17809,17811,17815,17814,17821,17893,17869,17857,17850,17840,17837,17830,17829,17822,17823,17820,17818,17844,17826,17827,17825,17831,17843,17842,17834,17836,17833,17838,17845,17841,17852,17846,17847,17861,17873,17848,17851,17887,17860,17859,17856,17854,17858,17867,17866,17862,17865,17889,17864,17871,17872,17870,17896,17897,17877,17876,17874,17888,17878,17880,17879,17882,17883,17886,17885,17898,17891,17902,17892,17890,17895,17894,17906,17918,17903,17927,17930,17940,17943,17948,17951,17949,17942,17905,17907,17901,17900,17899,17904,17910,17911,17909,17908,17941,17931,17929,17916,17914,17913,17912,17917,17915,17920,17919,17921,17923,17928,17922,17925,17935,17936,17926,17924,17934,17932,17933,17944,17937,17938,17954,17939,17955,17956,17961,17970,17972,17947,17946,17945,17950,17962,17952,17960,17959,17957,17958,17953,17966,17963,17965,17964,17971,17975,17977,17968,17967,17969,17983,17984,17980,17979,17974,17988,17976,17973,17995,18001,17978,18004,17989,17982,17981,17991,17990,17987,17985,17986,18003,18002,17992,17998,18000,17997,17999,17996,17994,17993,18005,18011,18006,18007,18010,18015,18008,18009,18014,18017,18012,18018,18016,18013,18022,18019,18021,18026,18020,18030,18036,18042,18028,18041,18031,18027,18024,18023,18025,18032,18029,18038,18039,18033,18034,18037,18035,18040,18047,18046,18045,18050,18043,18044,18056,18052,18059,18049,18048,18051,18057,18062,18064,18065,18066,18061,18060,18058,18055,18054,18053,18072,18081,18090,18063,18082,18073,18068,18069,18067,18071,18077,18070,18075,18076,18074,18079,18078,18086,18080,18085,18084,18083,18091,18089,18087,18088,18094,18100,18099,18102,18097,18096,18101,18095,18093,18092,18106,18104,18098,18105,18111,18103,18110,18117,18107,18108,18109,18122,18114,18112,18113,18125,18131,18127,18133,18137,18147,18150,18155,18161,18186,18185,18138,18118,18116,18115,18135,18134,18128,18130,18119,18121,18120,18126,18123,18124,18129,18144,18140,18132,18142,18141,18143,18139,18136,18182,18181,18148,18153,18145,18146,18152,18177,18180,18179,18149,18151,18158,18178,18183,18184,18173,18175,18174,18176,18156,18157,18154,18168,18187,18170,18169,18159,18160,18171,18172,18166,18165,18167,18163,18164,18162,18189,18188,18190,18194,18196,18195,18193,18191,18192,18202,18200,18201,18199,18197,18198,18208,18205,18203,18204,18207,18211,18206,18214,18215,18223,18213,18212,18210,18209,18224,18230,18239,18216,18217,18244,18245,18252,18250,18251,18219,18218,18246,18231,18228,18229,18226,18236,18221,18220,18222,18225,18227,18235,18232,18233,18234,18247,18243,18241,18238,18255,18237,18240,18265,18242,18270,18272,18248,18254,18249,18256,18253,18257,18260,18258,18259,18280,18286,18284,18262,18282,18285,18261,18283,18290,18292,18275,18266,18264,18263,18289,18291,18269,18268,18267,18287,18288,18293,18274,18273,18271,18281,18276,18278,18277,18279,18301,18294,18295,18309,18316,18320,18328,18334,18297,18296,18340,18342,18299,18300,18298,18306,18312,18304,18305,18302,18351,18303,18354,18311,18357,18362,18310,18308,18307,18317,18365,18319,18318,18314,18313,18315,18322,18321,18324,18323,18360,18361,18366,18330,18329,18363,18331,18327,18326,18325,18333,18332,18336,18364,18335,18371,18372,18343,18339,18346,18337,18338,18344,18341,18347,18345,18369,18370,18375,18377,18350,18349,18348,18373,18374,18367,18368,18352,18353,18355,18376,18378,18356,18358,18359,18382,18383,18386,18384,18380,18381,18379,18391,18390,18385,18389,18396,18388,18387,18395,18400,18393,18399,18394,18392,18405,18398,18397,18404,18410,18415,18418,18417,18420,18419,18411,18403,18402,18401,18406,18408,18409,18407,18424,18413,18414,18412,18427,18416,18428,18426,18429,18421,18425,18423,18422,18434,18433,18432,18439,18430,18431,18438,18437,18442,18435,18436,18441,18446,18440,18447,18445,18443,18450,18444,18460,18468,18455,18451,18449,18448,18453,18452,18454,18466,18458,18465,18456,18457,18467,18463,18464,18462,18461,18459,18472,18471,18469,18475,18470,18479,18489,18477,18501,18502,18480,18481,18478,18476,18473,18474,18482,18484,18483,18485,18503,18487,18486,18488,18493,18496,18497,18492,18491,18490,18498,18500,18495,18494,18509,18499,18516,18521,18531,18541,18549,18552,18558,18529,18504,18519,18505,18518,18520,18507,18506,18512,18508,18513,18510,18511,18514,18515,18526,18536,18517,18522,18525,18523,18524,18530,18528,18527,18534,18532,18533,18535,18562,18569,18540,18539,18545,18538,18537,18542,18544,18543,18573,18579,18554,18548,18546,18547,18557,18556,18555,18553,18551,18550,18565,18563,18590,18559,18560,18561,18564,18599,18602,18570,18610,18614,18601,18581,18574,18571,18568,18567,18566,18576,18572,18575,18577,18578,18582,18583,18584,18580,18586,18585,18587,18588,18595,18594,18593,18589,18592,18591,18598,18596,18606,18597,18605,18600,18603,18604,18619,18624,18625,18632,18615,18631,18629,18608,18607,18609,18612,18611,18613,18633,18620,18628,18626,18621,18622,18617,18618,18616,18623,18637,18627,18639,18640,18638,18630,18634,18643,18635,18648,18660,18636,18661,18647,18646,18652,18641,18642,18644,18653,18645,18659,18668,18650,18651,18649,18672,18669,18654,18656,18655,18657,18658,18662,18664,18663,18670,18671,18666,18665,18676,18667,18684,18690,18693,18674,18675,18680,18673,18677,18679,18678,18700,18701,18682,18708,18681,18716,18719,18723,18722,18691,18705,18706,18704,18697,18685,18683,18686,18689,18688,18687,18696,18699,18692,18694,18695,18698,18712,18728,18703,18702,18737,18709,18707,18710,18711,18720,18714,18713,18715,18742,18748,18718,18717,18721,18725,18724,18731,18727,18726,18732,18736,18730,18729,18733,18745,18734,18735,18744,18738,18740,18741,18739,18754,18743,18765,18771,18778,18750,18755,18751,18747,18749,18746,18756,18757,18753,18752,18781,18759,18758,18786,18791,18799,18811,18761,18812,18762,18760,18814,18767,18813,18815,18769,18768,18766,18764,18763,18770,18774,18772,18773,18806,18805,18807,18783,18788,18787,18785,18780,18777,18776,18775,18779,18782,18784,18794,18795,18790,18789,18793,18792,18798,18796,18802,18797,18804,18803,18800,18801,18809,18817,18810,18816,18808,18818,18819,18820,18822,18821,18823,18825,18824,18826,18827,18828,18829,18830,18831,18832,18834,18833,18835,18837,18836,18838,18839,18840,18841,18842,18844,18843,18845,18848,18849,18846,18847,18851,18850,18853,18852,18855,18854,18856,18857,18859,18858,18860,18861,18862,18863,18864,18866,18865,18872,18871,18870,18868,18869,18867,18873,18878,18876,18874,18877,18875,18879,18880,18882,18881,18885,18886,18887,18884,18883,18889,18888,18890,18892,18891,18894,18893,18895,18896,18898,18897,18899,18907,18908,18906,18904,18901,18900,18903,18902,18905,18910,18911,18909,18912,18921,18919,18913,18920,18918,18916,18914,18915,18917,18923,18922,18924,18926,18925,18927) GROUP BY time ) t1 UNION ( SELECT -- round deal time to start of quarter FROM_UNIXTIME(UNIX_TIMESTAMP(close_time) - UNIX_TIMESTAMP(close_time) % 900) AS time, 0 AS pnl, 0 AS deals_count, (commission + swap + profit) AS closed_profit FROM deals WHERE deal_id IN (16421,16427,16422,16429,16431,16430,16432,16426,16423,16424,16425,16436,16428,16437,16433,16434,16439,16440,16435,16441,16446,16438,16450,16461,16443,16467,16442,16474,16451,16448,16449,16447,16455,16445,16462,16444,16453,16452,16454,16456,16477,16481,16459,16460,16457,16458,16484,16463,16487,16464,16465,16466,16470,16469,16468,16499,16479,16501,16502,16500,16498,16489,16490,16483,16482,16472,16473,16471,16475,16476,16478,16491,16480,16493,16488,16485,16486,16495,16494,16492,16497,16506,16496,16516,16524,16523,16526,16504,16525,16503,16514,16515,16505,16508,16507,16509,16520,16530,16512,16511,16513,16510,16538,16541,16517,16519,16518,16521,16522,16528,16527,16534,16529,16531,16533,16532,16546,16544,16539,16545,16543,16542,16537,16535,16536,16551,16556,16540,16558,16562,16561,16549,16566,16550,16547,16548,16552,16555,16553,16554,16570,16559,16560,16557,16575,16586,16595,16600,16604,16612,16568,16565,16563,16564,16567,16585,16574,16576,16573,16571,16581,16572,16591,16578,16569,16580,16579,16577,16584,16583,16582,16590,16588,16589,16587,16614,16619,16603,16596,16601,16602,16597,16594,16592,16593,16598,16599,16607,16605,16606,16608,16618,16617,16616,16623,16615,16613,16611,16610,16609,16629,16627,16628,16624,16626,16622,16620,16621,16632,16625,16631,16630,16642,16649,16658,16664,16636,16635,16633,16634,16638,16637,16641,16639,16640,16644,16643,16670,16646,16645,16648,16653,16647,16651,16650,16652,16677,16656,16655,16654,16661,16657,16660,16659,16679,16686,16690,16699,16666,16703,16689,16669,16668,16663,16662,16665,16672,16671,16667,16687,16673,16685,16682,16684,16675,16676,16674,16683,16678,16681,16680,16695,16691,16692,16694,16688,16693,16704,16696,16709,16697,16698,16711,16705,16702,16701,16700,16710,16713,16712,16717,16714,16706,16708,16707,16718,16716,16719,16725,16715,16724,16726,16728,16721,16720,16723,16722,16727,16738,16748,16755,16753,16739,16736,16737,16729,16730,16731,16732,16733,16734,16735,16744,16741,16742,16743,16740,16752,16746,16745,16747,16750,16754,16749,16751,16759,16761,16762,16760,16766,16757,16767,16758,16756,16765,16764,16763,16770,16775,16782,16786,16771,16789,16794,16799,16806,16811,16815,16818,16820,16821,16819,16774,16772,16773,16768,16769,16778,16776,16817,16777,16812,16814,16783,16810,16792,16793,16787,16785,16781,16780,16779,16784,16801,16788,16791,16790,16803,16802,16795,16798,16797,16800,16796,16804,16807,16805,16828,16830,16839,16809,16846,16808,16850,16813,16855,16859,16816,16862,16865,16822,16823,16824,16871,16873,16877,16887,16826,16835,16827,16825,16834,16832,16831,16829,16833,16890,16893,16837,16842,16836,16838,16843,16840,16841,16892,16847,16894,16891,16888,16879,16878,16875,16868,16869,16851,16849,16848,16844,16845,16863,16854,16852,16853,16866,16858,16856,16857,16864,16860,16861,16867,16883,16870,16898,16900,16903,16874,16872,16902,16881,16876,16882,16880,16889,16884,16904,16886,16885,16899,16896,16895,16897,16907,16915,16917,16901,16923,16920,16908,16906,16911,16905,16910,16909,16918,16919,16916,16928,16914,16932,16912,16913,16941,16931,16933,16921,16922,16925,16935,16927,16926,16924,16930,16936,16934,16929,16949,16940,16939,16937,16945,16938,16959,16944,16942,16950,16943,16946,16948,16965,16947,16966,16962,16953,16952,16951,16964,16961,16955,16956,16954,16960,16971,16976,16957,16958,16963,16979,16988,16995,16972,16968,16998,16980,16970,16969,16967,16977,16981,16978,16975,16973,16974,16985,16982,16984,16983,17005,17014,17020,16994,17024,16992,16993,16989,16987,16986,16991,16990,16996,17026,17027,17025,17004,17003,17002,17001,16997,16999,17000,17006,17009,17010,17007,17008,17018,17015,17016,17019,17017,17011,17013,17012,17031,17038,17032,17022,17023,17030,17021,17028,17036,17029,17042,17045,17047,17037,17033,17035,17034,17048,17049,17050,17046,17043,17044,17054,17041,17063,17040,17039,17066,17073,17078,17052,17058,17053,17051,17056,17055,17057,17077,17068,17076,17061,17060,17062,17059,17075,17067,17065,17064,17071,17072,17069,17070,17084,17094,17098,17074,17097,17086,17082,17079,17081,17080,17083,17090,17087,17085,17088,17089,17095,17096,17093,17102,17091,17105,17092,17109,17116,17120,17125,17103,17130,17133,17101,17100,17099,17134,17112,17132,17107,17106,17104,17128,17127,17129,17110,17111,17108,17114,17113,17123,17122,17115,17139,17117,17118,17149,17153,17121,17119,17158,17124,17126,17157,17137,17138,17131,17135,17136,17140,17146,17144,17145,17159,17141,17142,17143,17156,17154,17151,17152,17167,17150,17147,17148,17165,17166,17169,17155,17168,17170,17162,17163,17164,17161,17160,17174,17175,17180,17183,17187,17188,17173,17171,17172,17176,17179,17177,17178,17185,17181,17182,17184,17194,17186,17201,17206,17189,17211,17190,17215,17218,17192,17191,17198,17197,17195,17193,17196,17216,17219,17204,17199,17202,17200,17203,17220,17213,17212,17214,17210,17223,17207,17205,17233,17208,17209,17241,17245,17225,17217,17224,17222,17221,17227,17226,17229,17228,17249,17255,17230,17232,17237,17231,17236,17235,17234,17261,17265,17246,17269,17271,17275,17282,17244,17240,17238,17239,17242,17243,17251,17286,17290,17294,17254,17248,17250,17247,17252,17257,17253,17256,17300,17303,17311,17321,17324,17262,17327,17330,17334,17337,17260,17258,17259,17266,17270,17264,17263,17274,17268,17267,17342,17347,17350,17353,17277,17276,17278,17273,17272,17280,17292,17279,17287,17288,17289,17284,17283,17296,17281,17310,17315,17285,17317,17295,17293,17291,17298,17297,17359,17305,17301,17302,17299,17309,17304,17306,17307,17361,17308,17312,17314,17313,17316,17368,17370,17379,17319,17335,17318,17320,17404,17403,17406,17405,17326,17322,17323,17328,17325,17397,17398,17395,17396,17401,17402,17331,17329,17399,17333,17332,17336,17341,17340,17338,17400,17339,17394,17392,17351,17391,17390,17344,17343,17387,17349,17348,17346,17345,17355,17356,17354,17352,17393,17362,17360,17358,17366,17357,17364,17365,17363,17389,17386,17367,17375,17369,17376,17372,17371,17373,17374,17378,17382,17377,17381,17380,17388,17385,17383,17384,17408,17416,17407,17420,17421,17425,17424,17423,17411,17409,17410,17422,17414,17417,17413,17412,17429,17418,17433,17437,17415,17419,17439,17438,17442,17443,17435,17436,17434,17432,17446,17428,17453,17426,17427,17430,17431,17455,17457,17456,17440,17441,17445,17450,17444,17451,17447,17452,17448,17454,17449,17467,17471,17476,17480,17460,17458,17459,17490,17495,17463,17477,17461,17462,17479,17472,17478,17475,17465,17466,17464,17470,17468,17469,17474,17485,17473,17484,17482,17481,17496,17483,17504,17486,17505,17498,17487,17499,17494,17489,17491,17500,17488,17509,17517,17493,17492,17522,17497,17526,17535,17506,17507,17508,17502,17503,17501,17511,17510,17512,17539,17543,17545,17513,17557,17560,17567,17546,17515,17514,17516,17518,17519,17542,17540,17541,17525,17524,17532,17523,17521,17520,17527,17528,17529,17531,17530,17538,17537,17550,17536,17534,17533,17552,17553,17551,17547,17548,17544,17549,17573,17577,17581,17579,17580,17571,17558,17572,17568,17559,17555,17556,17554,17561,17563,17562,17565,17564,17569,17586,17566,17593,17600,17570,17608,17601,17574,17575,17576,17578,17607,17583,17582,17606,17604,17605,17602,17603,17609,17589,17610,17588,17587,17584,17585,17611,17592,17591,17594,17590,17597,17598,17595,17596,17599,17617,17614,17619,17623,17626,17630,17633,17636,17615,17612,17613,17640,17643,17650,17654,17660,17664,17666,17675,17679,17678,17673,17618,17616,17637,17674,17665,17622,17621,17620,17625,17624,17667,17663,17628,17629,17627,17655,17652,17641,17642,17639,17638,17632,17631,17635,17634,17645,17672,17647,17646,17648,17644,17651,17683,17649,17684,17656,17701,17653,17662,17659,17657,17658,17661,17699,17700,17670,17671,17668,17669,17676,17706,17704,17705,17677,17702,17688,17689,17703,17682,17680,17681,17708,17686,17685,17687,17711,17707,17710,17709,17698,17690,17691,17696,17694,17695,17697,17692,17693,17714,17719,17712,17713,17718,17723,17717,17715,17716,17734,17724,17722,17720,17721,17728,17732,17733,17726,17725,17727,17730,17729,17731,17737,17743,17738,17735,17736,17741,17739,17740,17742,17745,17744,17747,17748,17746,17752,17758,17765,17771,17775,17778,17782,17754,17786,17753,17789,17751,17749,17750,17755,17756,17792,17797,17795,17793,17761,17790,17783,17764,17762,17759,17757,17760,17763,17767,17766,17781,17780,17777,17774,17773,17769,17799,17770,17768,17772,17812,17816,17819,17776,17824,17828,17832,17779,17785,17835,17784,17788,17787,17794,17839,17791,17796,17798,17800,17804,17802,17803,17801,17805,17849,17807,17853,17808,17806,17855,17813,17863,17868,17875,17881,17884,17817,17810,17809,17811,17815,17814,17821,17893,17869,17857,17850,17840,17837,17830,17829,17822,17823,17820,17818,17844,17826,17827,17825,17831,17843,17842,17834,17836,17833,17838,17845,17841,17852,17846,17847,17861,17873,17848,17851,17887,17860,17859,17856,17854,17858,17867,17866,17862,17865,17889,17864,17871,17872,17870,17896,17897,17877,17876,17874,17888,17878,17880,17879,17882,17883,17886,17885,17898,17891,17902,17892,17890,17895,17894,17906,17918,17903,17927,17930,17940,17943,17948,17951,17949,17942,17905,17907,17901,17900,17899,17904,17910,17911,17909,17908,17941,17931,17929,17916,17914,17913,17912,17917,17915,17920,17919,17921,17923,17928,17922,17925,17935,17936,17926,17924,17934,17932,17933,17944,17937,17938,17954,17939,17955,17956,17961,17970,17972,17947,17946,17945,17950,17962,17952,17960,17959,17957,17958,17953,17966,17963,17965,17964,17971,17975,17977,17968,17967,17969,17983,17984,17980,17979,17974,17988,17976,17973,17995,18001,17978,18004,17989,17982,17981,17991,17990,17987,17985,17986,18003,18002,17992,17998,18000,17997,17999,17996,17994,17993,18005,18011,18006,18007,18010,18015,18008,18009,18014,18017,18012,18018,18016,18013,18022,18019,18021,18026,18020,18030,18036,18042,18028,18041,18031,18027,18024,18023,18025,18032,18029,18038,18039,18033,18034,18037,18035,18040,18047,18046,18045,18050,18043,18044,18056,18052,18059,18049,18048,18051,18057,18062,18064,18065,18066,18061,18060,18058,18055,18054,18053,18072,18081,18090,18063,18082,18073,18068,18069,18067,18071,18077,18070,18075,18076,18074,18079,18078,18086,18080,18085,18084,18083,18091,18089,18087,18088,18094,18100,18099,18102,18097,18096,18101,18095,18093,18092,18106,18104,18098,18105,18111,18103,18110,18117,18107,18108,18109,18122,18114,18112,18113,18125,18131,18127,18133,18137,18147,18150,18155,18161,18186,18185,18138,18118,18116,18115,18135,18134,18128,18130,18119,18121,18120,18126,18123,18124,18129,18144,18140,18132,18142,18141,18143,18139,18136,18182,18181,18148,18153,18145,18146,18152,18177,18180,18179,18149,18151,18158,18178,18183,18184,18173,18175,18174,18176,18156,18157,18154,18168,18187,18170,18169,18159,18160,18171,18172,18166,18165,18167,18163,18164,18162,18189,18188,18190,18194,18196,18195,18193,18191,18192,18202,18200,18201,18199,18197,18198,18208,18205,18203,18204,18207,18211,18206,18214,18215,18223,18213,18212,18210,18209,18224,18230,18239,18216,18217,18244,18245,18252,18250,18251,18219,18218,18246,18231,18228,18229,18226,18236,18221,18220,18222,18225,18227,18235,18232,18233,18234,18247,18243,18241,18238,18255,18237,18240,18265,18242,18270,18272,18248,18254,18249,18256,18253,18257,18260,18258,18259,18280,18286,18284,18262,18282,18285,18261,18283,18290,18292,18275,18266,18264,18263,18289,18291,18269,18268,18267,18287,18288,18293,18274,18273,18271,18281,18276,18278,18277,18279,18301,18294,18295,18309,18316,18320,18328,18334,18297,18296,18340,18342,18299,18300,18298,18306,18312,18304,18305,18302,18351,18303,18354,18311,18357,18362,18310,18308,18307,18317,18365,18319,18318,18314,18313,18315,18322,18321,18324,18323,18360,18361,18366,18330,18329,18363,18331,18327,18326,18325,18333,18332,18336,18364,18335,18371,18372,18343,18339,18346,18337,18338,18344,18341,18347,18345,18369,18370,18375,18377,18350,18349,18348,18373,18374,18367,18368,18352,18353,18355,18376,18378,18356,18358,18359,18382,18383,18386,18384,18380,18381,18379,18391,18390,18385,18389,18396,18388,18387,18395,18400,18393,18399,18394,18392,18405,18398,18397,18404,18410,18415,18418,18417,18420,18419,18411,18403,18402,18401,18406,18408,18409,18407,18424,18413,18414,18412,18427,18416,18428,18426,18429,18421,18425,18423,18422,18434,18433,18432,18439,18430,18431,18438,18437,18442,18435,18436,18441,18446,18440,18447,18445,18443,18450,18444,18460,18468,18455,18451,18449,18448,18453,18452,18454,18466,18458,18465,18456,18457,18467,18463,18464,18462,18461,18459,18472,18471,18469,18475,18470,18479,18489,18477,18501,18502,18480,18481,18478,18476,18473,18474,18482,18484,18483,18485,18503,18487,18486,18488,18493,18496,18497,18492,18491,18490,18498,18500,18495,18494,18509,18499,18516,18521,18531,18541,18549,18552,18558,18529,18504,18519,18505,18518,18520,18507,18506,18512,18508,18513,18510,18511,18514,18515,18526,18536,18517,18522,18525,18523,18524,18530,18528,18527,18534,18532,18533,18535,18562,18569,18540,18539,18545,18538,18537,18542,18544,18543,18573,18579,18554,18548,18546,18547,18557,18556,18555,18553,18551,18550,18565,18563,18590,18559,18560,18561,18564,18599,18602,18570,18610,18614,18601,18581,18574,18571,18568,18567,18566,18576,18572,18575,18577,18578,18582,18583,18584,18580,18586,18585,18587,18588,18595,18594,18593,18589,18592,18591,18598,18596,18606,18597,18605,18600,18603,18604,18619,18624,18625,18632,18615,18631,18629,18608,18607,18609,18612,18611,18613,18633,18620,18628,18626,18621,18622,18617,18618,18616,18623,18637,18627,18639,18640,18638,18630,18634,18643,18635,18648,18660,18636,18661,18647,18646,18652,18641,18642,18644,18653,18645,18659,18668,18650,18651,18649,18672,18669,18654,18656,18655,18657,18658,18662,18664,18663,18670,18671,18666,18665,18676,18667,18684,18690,18693,18674,18675,18680,18673,18677,18679,18678,18700,18701,18682,18708,18681,18716,18719,18723,18722,18691,18705,18706,18704,18697,18685,18683,18686,18689,18688,18687,18696,18699,18692,18694,18695,18698,18712,18728,18703,18702,18737,18709,18707,18710,18711,18720,18714,18713,18715,18742,18748,18718,18717,18721,18725,18724,18731,18727,18726,18732,18736,18730,18729,18733,18745,18734,18735,18744,18738,18740,18741,18739,18754,18743,18765,18771,18778,18750,18755,18751,18747,18749,18746,18756,18757,18753,18752,18781,18759,18758,18786,18791,18799,18811,18761,18812,18762,18760,18814,18767,18813,18815,18769,18768,18766,18764,18763,18770,18774,18772,18773,18806,18805,18807,18783,18788,18787,18785,18780,18777,18776,18775,18779,18782,18784,18794,18795,18790,18789,18793,18792,18798,18796,18802,18797,18804,18803,18800,18801,18809,18817,18810,18816,18808,18818,18819,18820,18822,18821,18823,18825,18824,18826,18827,18828,18829,18830,18831,18832,18834,18833,18835,18837,18836,18838,18839,18840,18841,18842,18844,18843,18845,18848,18849,18846,18847,18851,18850,18853,18852,18855,18854,18856,18857,18859,18858,18860,18861,18862,18863,18864,18866,18865,18872,18871,18870,18868,18869,18867,18873,18878,18876,18874,18877,18875,18879,18880,18882,18881,18885,18886,18887,18884,18883,18889,18888,18890,18892,18891,18894,18893,18895,18896,18898,18897,18899,18907,18908,18906,18904,18901,18900,18903,18902,18905,18910,18911,18909,18912,18921,18919,18913,18920,18918,18916,18914,18915,18917,18923,18922,18924,18926,18925,18927) ) ) t ) e WHERE e.deals_count != 0 ORDER BY e.time