Referto Partita: All Blacks vs Sheet
All Blacks
Sheet
RISULTATO FINALE
73
66
1° Tempo
19
9
2° Tempo
28
32
3° Tempo
26
25
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 A2
Giornata: 15
Giornata: 15
Data e Luogo
22-04-2022 21:45 - Palazzeschi
Arbitri
Primo Arbitro
Coletta Roberto
Secondo Arbitro
Cangialosi Luca
Refertista
Cangialosi Luca
Sorteggio
Sorteggio Vinto Da
Sheet
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
All Blacks
-
Alessandro VarettoTot.11
4
x21
x3
0
x AUTOHIT -
Marcello BacchiniTot.14
4
x22
x3
0
x AUTOHIT -
Diego LeonardiTot.10
5
x20
x3
0
x AUTOHIT -
Gianluca ZingarelliTot.7
2
x21
x3
0
x AUTOHIT -
Gianluca VarettoTot.7
2
x21
x3
0
x AUTOHIT -
Alessandro BosaTot.24
9
x22
x3
0
x AUTOHIT
Sheet
-
Andrea Lavalle
4
x22
x3
0
x AUTOHITTot.14
Daniele Demarchi
0
x20
x3
0
x AUTOHITTot.0
Stefano Benedetti
2
x23
x3
0
x AUTOHITTot.13
Carlo Pangallo
6
x22
x3
0
x AUTOHITTot.18
Filippo Venturini
3
x22
x3
0
x AUTOHITTot.12
Davide Salvaggio
3
x21
x3
0
x AUTOHITTot.9
Total Queries: 155
Total Time: 3.3668098449707
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1791350494.798
[end] => 1791350494.7989
[time] => 0.00090980529785156
)
[1] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350494.8044
[end] => 1791350494.8056
[time] => 0.001209020614624
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350494.8056
[end] => 1791350494.8151
[time] => 0.0094308853149414
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350494.8151
[end] => 1791350494.8936
[time] => 0.07850193977356
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350494.8939
[end] => 1791350494.9052
[time] => 0.011294841766357
)
[5] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350494.9053
[end] => 1791350494.9078
[time] => 0.0024571418762207
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350494.9078
[end] => 1791350494.9208
[time] => 0.012962818145752
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350494.9208
[end] => 1791350495.0068
[time] => 0.085938215255737
)
[8] => Array
(
[query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
left join player_to_team on (player.player_id = player_to_team.player_id) where deleted = '0' AND team_id in (31,32) ORDER BY lastname,firstname ASC
[start] => 1791350495.0072
[end] => 1791350495.0229
[time] => 0.015733003616333
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1791350495.0243
[end] => 1791350495.0293
[time] => 0.0049269199371338
)
[10] => Array
(
[query] => select * from matches where championship_id = '52' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.0294
[end] => 1791350495.0725
[time] => 0.043035984039307
)
[11] => Array
(
[query] => select * from match_time where match_id in (4813,4814,4815,4816,4817,4818,4819,4820,4821,4822,4823,4824,4825,4826,4827,4828,4829,4830,4831,4832,4833,4834,4835,4836,4837,4838,4839,4840,4841,4842,4843,4844,4845,4846,4847,4848,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,4861,4862,4863,4864,4865,4866,4867,4868,4869,4870,4871,4872,4873,4874,4875,4876,4877,4878,4879,4880,4881,4882,4883,4884,4885,4886,4887,4888,4889,4890,4891,4892,4893,4894,4895,4896,4897,4898,4899,4900,4901,4902) order by id ASC
[start] => 1791350495.0738
[end] => 1791350495.0955
[time] => 0.021696805953979
)
[12] => Array
(
[query] => select * from matches where championship_id = '53' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.0958
[end] => 1791350495.1283
[time] => 0.032526969909668
)
[13] => Array
(
[query] => select * from match_time where match_id in (4903,4904,4905,4906,4907,4908,4909,4910,4911,4912,4913,4914,4915,4916,4917,4918,4919,4920,4921,4922,4923,4924,4925,4926,4927,4928,4929,4930,4931,4932,4933,4934,4935,4936,4937,4938,4939,4940,4941,4942,4943,4944,4945,4946,4947,4948,4949,4950,4951,4952,4953,4954,4955,4956,4957,4958,4959,4960,4961,4962,4963,4964,4965,4966,4967,4968,4969,4970,4971,4972,4973,4974,4975,4976,4977,4978,4979,4980,4981,4982,4983,4984,4985,4986,4987,4988,4989,4990,4991,4992) order by id ASC
[start] => 1791350495.1286
[end] => 1791350495.144
[time] => 0.015356063842773
)
[14] => Array
(
[query] => select * from matches where championship_id = '54' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.1443
[end] => 1791350495.1671
[time] => 0.022864103317261
)
[15] => Array
(
[query] => select * from match_time where match_id in (4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5042,5043,5044,5045,5046,5047,5048,5049,5050,5051,5052,5053,5054,5055,5056,5057,5058,5059,5060,5061,5062,5063,5064,5065,5066,5067,5068,5069,5070,5071,5072,5073,5074,5075,5076,5077,5078,5079,5080,5081,5082) order by id ASC
[start] => 1791350495.1674
[end] => 1791350495.1749
[time] => 0.0074291229248047
)
[16] => Array
(
[query] => select * from matches where championship_id = '55' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.176
[end] => 1791350495.1941
[time] => 0.018193006515503
)
[17] => Array
(
[query] => select * from match_time where match_id in (5083,5084,5085,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5105,5106,5107,5108,5109,5110,5111,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124,5125,5126,5127,5128,5129,5130,5131,5132,5133,5134,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,5160,5161,5162,5163,5164,5165,5166,5167,5168,5169,5170,5171,5172) order by id ASC
[start] => 1791350495.1944
[end] => 1791350495.2008
[time] => 0.0063109397888184
)
[18] => Array
(
[query] => select * from matches where championship_id = '51' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.201
[end] => 1791350495.2164
[time] => 0.015346050262451
)
[19] => Array
(
[query] => select * from matches where championship_id = '49' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.2166
[end] => 1791350495.2299
[time] => 0.013307809829712
)
[20] => Array
(
[query] => select * from matches where championship_id = '50' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.2301
[end] => 1791350495.2434
[time] => 0.013301134109497
)
[21] => Array
(
[query] => select * from matches where championship_id = '48' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.2435
[end] => 1791350495.2565
[time] => 0.012988805770874
)
[22] => Array
(
[query] => select * from matches where championship_id = '39' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.2568
[end] => 1791350495.2699
[time] => 0.013095140457153
)
[23] => Array
(
[query] => select * from matches where championship_id = '41' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.27
[end] => 1791350495.2856
[time] => 0.015605926513672
)
[24] => Array
(
[query] => select * from matches where championship_id = '42' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.2858
[end] => 1791350495.298
[time] => 0.012203931808472
)
[25] => Array
(
[query] => select * from matches where championship_id = '43' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.2982
[end] => 1791350495.3131
[time] => 0.014909029006958
)
[26] => Array
(
[query] => select * from matches where championship_id = '47' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.3133
[end] => 1791350495.3265
[time] => 0.013190984725952
)
[27] => Array
(
[query] => select * from matches where championship_id = '46' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.3267
[end] => 1791350495.3391
[time] => 0.012399911880493
)
[28] => Array
(
[query] => select * from matches where championship_id = '38' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.3393
[end] => 1791350495.3539
[time] => 0.01459002494812
)
[29] => Array
(
[query] => select * from matches where championship_id = '33' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.3541
[end] => 1791350495.3663
[time] => 0.01221489906311
)
[30] => Array
(
[query] => select * from matches where championship_id = '34' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.3665
[end] => 1791350495.3795
[time] => 0.013012886047363
)
[31] => Array
(
[query] => select * from matches where championship_id = '35' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.3797
[end] => 1791350495.3991
[time] => 0.019424915313721
)
[32] => Array
(
[query] => select * from matches where championship_id = '30' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.3993
[end] => 1791350495.4218
[time] => 0.0224769115448
)
[33] => Array
(
[query] => select * from matches where championship_id = '31' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.4219
[end] => 1791350495.4613
[time] => 0.039367914199829
)
[34] => Array
(
[query] => select * from matches where championship_id = '32' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.4616
[end] => 1791350495.4948
[time] => 0.033212900161743
)
[35] => Array
(
[query] => select * from matches where championship_id = '36' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.495
[end] => 1791350495.5254
[time] => 0.030413866043091
)
[36] => Array
(
[query] => select * from matches where championship_id = '37' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.5256
[end] => 1791350495.5481
[time] => 0.022511005401611
)
[37] => Array
(
[query] => select * from matches where championship_id = '25' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.5483
[end] => 1791350495.5669
[time] => 0.018556118011475
)
[38] => Array
(
[query] => select * from matches where championship_id = '26' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.567
[end] => 1791350495.5896
[time] => 0.022578001022339
)
[39] => Array
(
[query] => select * from matches where championship_id = '29' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.5898
[end] => 1791350495.6079
[time] => 0.018084049224854
)
[40] => Array
(
[query] => select * from matches where championship_id = '28' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.6081
[end] => 1791350495.6216
[time] => 0.013499021530151
)
[41] => Array
(
[query] => select * from matches where championship_id = '22' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.6218
[end] => 1791350495.6451
[time] => 0.023365020751953
)
[42] => Array
(
[query] => select * from matches where championship_id = '23' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.6453
[end] => 1791350495.665
[time] => 0.019723892211914
)
[43] => Array
(
[query] => select * from matches where championship_id = '18' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.6652
[end] => 1791350495.6857
[time] => 0.020539999008179
)
[44] => Array
(
[query] => select * from matches where championship_id = '19' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.6859
[end] => 1791350495.7045
[time] => 0.01855206489563
)
[45] => Array
(
[query] => select * from matches where championship_id = '20' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.7047
[end] => 1791350495.7242
[time] => 0.019525051116943
)
[46] => Array
(
[query] => select * from matches where championship_id = '21' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.7244
[end] => 1791350495.7418
[time] => 0.017369031906128
)
[47] => Array
(
[query] => select * from matches where championship_id = '13' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.742
[end] => 1791350495.7637
[time] => 0.021766901016235
)
[48] => Array
(
[query] => select * from matches where championship_id = '15' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.7639
[end] => 1791350495.7848
[time] => 0.020834922790527
)
[49] => Array
(
[query] => select * from matches where championship_id = '16' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.7849
[end] => 1791350495.8023
[time] => 0.017396926879883
)
[50] => Array
(
[query] => select * from matches where championship_id = '17' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.8025
[end] => 1791350495.8154
[time] => 0.012885808944702
)
[51] => Array
(
[query] => select * from matches where championship_id = '14' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.8156
[end] => 1791350495.8347
[time] => 0.019137144088745
)
[52] => Array
(
[query] => select * from matches where championship_id = '8' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.835
[end] => 1791350495.8578
[time] => 0.022806882858276
)
[53] => Array
(
[query] => select * from matches where championship_id = '10' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.858
[end] => 1791350495.878
[time] => 0.01999306678772
)
[54] => Array
(
[query] => select * from matches where championship_id = '11' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.8782
[end] => 1791350495.8953
[time] => 0.017109870910645
)
[55] => Array
(
[query] => select * from matches where championship_id = '12' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.8955
[end] => 1791350495.9153
[time] => 0.019828081130981
)
[56] => Array
(
[query] => select * from matches where championship_id = '6' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.9155
[end] => 1791350495.9365
[time] => 0.020932912826538
)
[57] => Array
(
[query] => select * from matches where championship_id = '5' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.9367
[end] => 1791350495.9499
[time] => 0.013188123703003
)
[58] => Array
(
[query] => select * from matches where championship_id = '2' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.9501
[end] => 1791350495.9644
[time] => 0.014358043670654
)
[59] => Array
(
[query] => select * from matches where championship_id = '3' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350495.9646
[end] => 1791350495.981
[time] => 0.016422986984253
)
[60] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1791350495.9812
[end] => 1791350495.9816
[time] => 0.00033903121948242
)
[61] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1791350495.9816
[end] => 1791350495.9824
[time] => 0.00074505805969238
)
[62] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350495.9829
[end] => 1791350495.9831
[time] => 0.00022101402282715
)
[63] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350495.9831
[end] => 1791350495.9906
[time] => 0.0074689388275146
)
[64] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350495.9906
[end] => 1791350496.0428
[time] => 0.05211615562439
)
[65] => Array
(
[query] => select * from match_roster where match_id = '2067'
[start] => 1791350496.043
[end] => 1791350496.0668
[time] => 0.023804903030396
)
[66] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350496.067
[end] => 1791350496.069
[time] => 0.0019829273223877
)
[67] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350496.069
[end] => 1791350496.0715
[time] => 0.002547025680542
)
[68] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350496.0716
[end] => 1791350496.112
[time] => 0.040428161621094
)
[69] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2067' and (point.point = 'P' or point.point = 'E')
[start] => 1791350496.1145
[end] => 1791350496.3067
[time] => 0.19224882125854
)
[70] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1791350496.3068
[end] => 1791350496.3072
[time] => 0.0003209114074707
)
[71] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1791350496.3072
[end] => 1791350496.3074
[time] => 0.00020694732666016
)
[72] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350496.3075
[end] => 1791350496.3078
[time] => 0.00024914741516113
)
[73] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350496.3078
[end] => 1791350496.3123
[time] => 0.004504919052124
)
[74] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350496.3124
[end] => 1791350496.3444
[time] => 0.032042980194092
)
[75] => Array
(
[query] => select * from match_roster where match_id = '2067'
[start] => 1791350496.3447
[end] => 1791350496.3644
[time] => 0.019690036773682
)
[76] => Array
(
[query] =>
SELECT
player_id,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN point
END )
,0)
as attack,
COALESCE(
SUM(
CASE
WHEN point = '3' THEN point
END )
,0)
as defense,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN point
WHEN point = '3' THEN point
END )
,0)
as total,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN 1
END )
,0)
as hit_attack,
COALESCE(
SUM(
CASE
WHEN point = '3' THEN 1
END )
,0)
as hit_defense,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN 1
WHEN point = '3' THEN 1
END )
,0)
as hit_total,
COALESCE(
SUM(
CASE
WHEN point = 'A' THEN 1
END )
,0)
as autohit
FROM point where match_id = '2067' group by player_id
[start] => 1791350496.3644
[end] => 1791350496.5373
[time] => 0.17281889915466
)
[77] => Array
(
[query] => select * from penalty_to_team where match_id = '2067'
[start] => 1791350496.5375
[end] => 1791350496.5407
[time] => 0.0032720565795898
)
[78] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350496.5408
[end] => 1791350496.5449
[time] => 0.0040991306304932
)
[79] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350496.5449
[end] => 1791350496.552
[time] => 0.0070569515228271
)
[80] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350496.5521
[end] => 1791350496.6329
[time] => 0.080872058868408
)
[81] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1791350496.6332
[end] => 1791350496.6335
[time] => 0.00026798248291016
)
[82] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1791350496.6336
[end] => 1791350496.638
[time] => 0.0043411254882812
)
[83] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350496.6382
[end] => 1791350496.6398
[time] => 0.0015759468078613
)
[84] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350496.6398
[end] => 1791350496.6512
[time] => 0.011395931243896
)
[85] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350496.6512
[end] => 1791350496.7306
[time] => 0.079397201538086
)
[86] => Array
(
[query] => select * from match_staff_roster where match_id = '2067'
[start] => 1791350496.7319
[end] => 1791350496.7357
[time] => 0.0038220882415771
)
[87] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1791350496.7359
[end] => 1791350496.736
[time] => 0.00019001960754395
)
[88] => Array
(
[query] => select penalty_to_staff.*, staff_penalty.cumulative from penalty_to_staff
inner join staff_penalty on (penalty_to_staff.staff_penalty_id = staff_penalty.staff_penalty_id)
where penalty_to_staff.match_id = '2067' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1791350496.7361
[end] => 1791350496.7397
[time] => 0.0036659240722656
)
[89] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1791350496.7398
[end] => 1791350496.7439
[time] => 0.0040440559387207
)
[90] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1791350496.7439
[end] => 1791350496.7441
[time] => 0.00018715858459473
)
[91] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350496.7443
[end] => 1791350496.7445
[time] => 0.00021600723266602
)
[92] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350496.7446
[end] => 1791350496.7531
[time] => 0.0085361003875732
)
[93] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350496.7531
[end] => 1791350496.8436
[time] => 0.090468168258667
)
[94] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350496.8439
[end] => 1791350496.8489
[time] => 0.0049870014190674
)
[95] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350496.8489
[end] => 1791350496.8593
[time] => 0.010401010513306
)
[96] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350496.8594
[end] => 1791350496.8925
[time] => 0.033106088638306
)
[97] => Array
(
[query] => select * from match_roster where match_id = '2067'
[start] => 1791350496.8928
[end] => 1791350496.9017
[time] => 0.0089340209960938
)
[98] => Array
(
[query] => select * from point where match_id = '2067' order by point_id ASC
[start] => 1791350496.9017
[end] => 1791350496.9915
[time] => 0.089715003967285
)
[99] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1791350496.9922
[end] => 1791350496.9954
[time] => 0.0032088756561279
)
[100] => Array
(
[query] => select * from matches where match_id = '2067'
[start] => 1791350496.9955
[end] => 1791350496.996
[time] => 0.00055122375488281
)
[101] => Array
(
[query] => select time,closed from match_time where match_id = '2067'
[start] => 1791350496.996
[end] => 1791350496.9986
[time] => 0.0025448799133301
)
[102] => Array
(
[query] => SELECT * FROM match_data where match_id = '2067'
[start] => 1791350496.9986
[end] => 1791350497.0316
[time] => 0.032999038696289
)
[103] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1791350497.0364
[end] => 1791350497.037
[time] => 0.00057816505432129
)
[104] => Array
(
[query] => select * from matches where championship_id = '52' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.0371
[end] => 1791350497.0631
[time] => 0.026028871536255
)
[105] => Array
(
[query] => select * from match_time where match_id in (4813,4814,4815,4816,4817,4818,4819,4820,4821,4822,4823,4824,4825,4826,4827,4828,4829,4830,4831,4832,4833,4834,4835,4836,4837,4838,4839,4840,4841,4842,4843,4844,4845,4846,4847,4848,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,4861,4862,4863,4864,4865,4866,4867,4868,4869,4870,4871,4872,4873,4874,4875,4876,4877,4878,4879,4880,4881,4882,4883,4884,4885,4886,4887,4888,4889,4890,4891,4892,4893,4894,4895,4896,4897,4898,4899,4900,4901,4902) order by id ASC
[start] => 1791350497.0634
[end] => 1791350497.0708
[time] => 0.0073871612548828
)
[106] => Array
(
[query] => select * from matches where championship_id = '53' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.0711
[end] => 1791350497.0841
[time] => 0.013002157211304
)
[107] => Array
(
[query] => select * from match_time where match_id in (4903,4904,4905,4906,4907,4908,4909,4910,4911,4912,4913,4914,4915,4916,4917,4918,4919,4920,4921,4922,4923,4924,4925,4926,4927,4928,4929,4930,4931,4932,4933,4934,4935,4936,4937,4938,4939,4940,4941,4942,4943,4944,4945,4946,4947,4948,4949,4950,4951,4952,4953,4954,4955,4956,4957,4958,4959,4960,4961,4962,4963,4964,4965,4966,4967,4968,4969,4970,4971,4972,4973,4974,4975,4976,4977,4978,4979,4980,4981,4982,4983,4984,4985,4986,4987,4988,4989,4990,4991,4992) order by id ASC
[start] => 1791350497.0844
[end] => 1791350497.0912
[time] => 0.0068378448486328
)
[108] => Array
(
[query] => select * from matches where championship_id = '54' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.0915
[end] => 1791350497.1122
[time] => 0.020684957504272
)
[109] => Array
(
[query] => select * from match_time where match_id in (4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5042,5043,5044,5045,5046,5047,5048,5049,5050,5051,5052,5053,5054,5055,5056,5057,5058,5059,5060,5061,5062,5063,5064,5065,5066,5067,5068,5069,5070,5071,5072,5073,5074,5075,5076,5077,5078,5079,5080,5081,5082) order by id ASC
[start] => 1791350497.1125
[end] => 1791350497.1474
[time] => 0.034884929656982
)
[110] => Array
(
[query] => select * from matches where championship_id = '55' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.1476
[end] => 1791350497.2045
[time] => 0.056828022003174
)
[111] => Array
(
[query] => select * from match_time where match_id in (5083,5084,5085,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5105,5106,5107,5108,5109,5110,5111,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124,5125,5126,5127,5128,5129,5130,5131,5132,5133,5134,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,5160,5161,5162,5163,5164,5165,5166,5167,5168,5169,5170,5171,5172) order by id ASC
[start] => 1791350497.2048
[end] => 1791350497.2199
[time] => 0.015137910842896
)
[112] => Array
(
[query] => select * from matches where championship_id = '51' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.2202
[end] => 1791350497.2544
[time] => 0.034170150756836
)
[113] => Array
(
[query] => select * from matches where championship_id = '49' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.2546
[end] => 1791350497.2902
[time] => 0.035540103912354
)
[114] => Array
(
[query] => select * from matches where championship_id = '50' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.2904
[end] => 1791350497.3378
[time] => 0.047318935394287
)
[115] => Array
(
[query] => select * from matches where championship_id = '48' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.338
[end] => 1791350497.3725
[time] => 0.03449010848999
)
[116] => Array
(
[query] => select * from matches where championship_id = '39' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.3728
[end] => 1791350497.3953
[time] => 0.022490978240967
)
[117] => Array
(
[query] => select * from matches where championship_id = '41' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.3956
[end] => 1791350497.4116
[time] => 0.016014099121094
)
[118] => Array
(
[query] => select * from matches where championship_id = '42' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.4118
[end] => 1791350497.4333
[time] => 0.021573066711426
)
[119] => Array
(
[query] => select * from matches where championship_id = '43' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.4336
[end] => 1791350497.4562
[time] => 0.022564888000488
)
[120] => Array
(
[query] => select * from matches where championship_id = '47' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.4564
[end] => 1791350497.4769
[time] => 0.020507097244263
)
[121] => Array
(
[query] => select * from matches where championship_id = '46' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.4771
[end] => 1791350497.4983
[time] => 0.021229982376099
)
[122] => Array
(
[query] => select * from matches where championship_id = '38' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.4985
[end] => 1791350497.5154
[time] => 0.016924858093262
)
[123] => Array
(
[query] => select * from matches where championship_id = '33' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.5156
[end] => 1791350497.5305
[time] => 0.014906883239746
)
[124] => Array
(
[query] => select * from matches where championship_id = '34' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.5307
[end] => 1791350497.561
[time] => 0.030298948287964
)
[125] => Array
(
[query] => select * from matches where championship_id = '35' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.5612
[end] => 1791350497.5956
[time] => 0.034393072128296
)
[126] => Array
(
[query] => select * from matches where championship_id = '30' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.5968
[end] => 1791350497.6388
[time] => 0.04198694229126
)
[127] => Array
(
[query] => select * from matches where championship_id = '31' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.639
[end] => 1791350497.6842
[time] => 0.045202016830444
)
[128] => Array
(
[query] => select * from matches where championship_id = '32' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.6844
[end] => 1791350497.7212
[time] => 0.036765813827515
)
[129] => Array
(
[query] => select * from matches where championship_id = '36' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.7215
[end] => 1791350497.7468
[time] => 0.025315999984741
)
[130] => Array
(
[query] => select * from matches where championship_id = '37' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.747
[end] => 1791350497.7636
[time] => 0.016546964645386
)
[131] => Array
(
[query] => select * from matches where championship_id = '25' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.7638
[end] => 1791350497.7837
[time] => 0.019838809967041
)
[132] => Array
(
[query] => select * from matches where championship_id = '26' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.7839
[end] => 1791350497.7978
[time] => 0.01387619972229
)
[133] => Array
(
[query] => select * from matches where championship_id = '29' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.7979
[end] => 1791350497.8133
[time] => 0.015307903289795
)
[134] => Array
(
[query] => select * from matches where championship_id = '28' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.8135
[end] => 1791350497.8404
[time] => 0.026938915252686
)
[135] => Array
(
[query] => select * from matches where championship_id = '22' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.8406
[end] => 1791350497.8647
[time] => 0.024127960205078
)
[136] => Array
(
[query] => select * from matches where championship_id = '23' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.865
[end] => 1791350497.8879
[time] => 0.022936105728149
)
[137] => Array
(
[query] => select * from matches where championship_id = '18' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.8881
[end] => 1791350497.9092
[time] => 0.021111011505127
)
[138] => Array
(
[query] => select * from matches where championship_id = '19' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.9095
[end] => 1791350497.9286
[time] => 0.019106149673462
)
[139] => Array
(
[query] => select * from matches where championship_id = '20' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.9288
[end] => 1791350497.9502
[time] => 0.021420955657959
)
[140] => Array
(
[query] => select * from matches where championship_id = '21' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.9505
[end] => 1791350497.9703
[time] => 0.019864082336426
)
[141] => Array
(
[query] => select * from matches where championship_id = '13' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.9705
[end] => 1791350497.9935
[time] => 0.022942066192627
)
[142] => Array
(
[query] => select * from matches where championship_id = '15' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350497.9937
[end] => 1791350498.0112
[time] => 0.017511129379272
)
[143] => Array
(
[query] => select * from matches where championship_id = '16' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.0113
[end] => 1791350498.0295
[time] => 0.018149137496948
)
[144] => Array
(
[query] => select * from matches where championship_id = '17' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.03
[end] => 1791350498.0496
[time] => 0.019607067108154
)
[145] => Array
(
[query] => select * from matches where championship_id = '14' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.0498
[end] => 1791350498.0666
[time] => 0.016783952713013
)
[146] => Array
(
[query] => select * from matches where championship_id = '8' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.0668
[end] => 1791350498.0884
[time] => 0.02157998085022
)
[147] => Array
(
[query] => select * from matches where championship_id = '10' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.0886
[end] => 1791350498.1105
[time] => 0.021878957748413
)
[148] => Array
(
[query] => select * from matches where championship_id = '11' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.1107
[end] => 1791350498.1301
[time] => 0.019412994384766
)
[149] => Array
(
[query] => select * from matches where championship_id = '12' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.1303
[end] => 1791350498.1501
[time] => 0.019777059555054
)
[150] => Array
(
[query] => select * from matches where championship_id = '6' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.1503
[end] => 1791350498.1638
[time] => 0.013414144515991
)
[151] => Array
(
[query] => select * from matches where championship_id = '5' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.1639
[end] => 1791350498.1765
[time] => 0.012601137161255
)
[152] => Array
(
[query] => select * from matches where championship_id = '2' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.1767
[end] => 1791350498.1925
[time] => 0.015806913375854
)
[153] => Array
(
[query] => select * from matches where championship_id = '3' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791350498.1928
[end] => 1791350498.2089
[time] => 0.016178846359253
)
[154] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1791350498.2096
[end] => 1791350498.2122
[time] => 0.0026309490203857
)
)