Referto Partita: Skoppiati vs Pellegrini Venaria
Skoppiati
Pellegrini Venaria
RISULTATO FINALE
113
66
1° Tempo
34
26
2° Tempo
33
29
3° Tempo
46
11
INVASIONI A MURO
1
3
Data e Luogo
Campionato
Campionato Eccellenza 2023/2024 A2
Giornata: 7
Giornata: 7
Data e Luogo
09-01-2024 20:45 - Cavour
Arbitri
Primo Arbitro
Da Re Francesca
Secondo Arbitro
Bracesco Martina
Refertista
ASD Polaris
Sorteggio
Sorteggio Vinto Da
Pellegrini Venaria
Scelta Sorteggio
Palla
Annotazioni
Refertista di società: Gaspare Guarrato
Addetto media Pellegrini Venaria: Lorenzo Curti
Progresso
Punteggi Individuali
Skoppiati
-
Ion SoroceanuTot.22
8
x22
x3
0
x AUTOHIT -
Riccardo FrancabandieraTot.24
12
x20
x3
0
x AUTOHIT -
Federico SuppoTot.7
2
x21
x3
0
x AUTOHIT -
Giovanni MarsicoTot.16
5
x22
x3
0
x AUTOHIT -
Marco BresselloTot.18
6
x22
x3
0
x AUTOHIT -
Lennin Jarek GarciaTot.13
5
x21
x3
1
x AUTOHIT -
Lorenzo FontanaTot.12
3
x22
x3
0
x AUTOHIT
Pellegrini Venaria
-
Davide Casalegno
0
x20
x3
0
x AUTOHITTot.0
Luca Curti
2
x21
x3
0
x AUTOHITTot.7
Domenico Pirozzolo
2
x20
x3
0
x AUTOHITTot.4
Luca Dragna
1
x20
x3
0
x AUTOHITTot.2
Gabriele Barone
4
x23
x3
0
x AUTOHITTot.17
Barbara Tombolato
0
x20
x3
0
x AUTOHITTot.0
Luca Mocciaro
1
x25
x3
0
x AUTOHITTot.17
Alberto Casalegno
2
x21
x3
1
x AUTOHITTot.7
Federico Sisci
4
x21
x3
0
x AUTOHITTot.11
Total Queries: 155 Total Time: 1.0437574386597 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1791353786.8951 [end] => 1791353786.8954 [time] => 0.00025391578674316 ) [1] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353786.8978 [end] => 1791353786.898 [time] => 0.00022292137145996 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353786.898 [end] => 1791353786.9005 [time] => 0.0024700164794922 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353786.9006 [end] => 1791353786.9164 [time] => 0.015793085098267 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353786.9167 [end] => 1791353786.9192 [time] => 0.0025210380554199 ) [5] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353786.9193 [end] => 1791353786.9195 [time] => 0.00019502639770508 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353786.9195 [end] => 1791353786.922 [time] => 0.0024638175964355 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353786.922 [end] => 1791353786.9376 [time] => 0.015630006790161 ) [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 (11,14) ORDER BY lastname,firstname ASC [start] => 1791353786.938 [end] => 1791353786.9391 [time] => 0.0010769367218018 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1791353786.9405 [end] => 1791353786.941 [time] => 0.0004420280456543 ) [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] => 1791353786.9411 [end] => 1791353786.9477 [time] => 0.0066120624542236 ) [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] => 1791353786.948 [end] => 1791353786.9513 [time] => 0.0032811164855957 ) [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] => 1791353786.9515 [end] => 1791353786.9581 [time] => 0.0065908432006836 ) [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] => 1791353786.9584 [end] => 1791353786.9616 [time] => 0.0032720565795898 ) [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] => 1791353786.9619 [end] => 1791353786.9684 [time] => 0.0065100193023682 ) [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] => 1791353786.9686 [end] => 1791353786.9719 [time] => 0.0033011436462402 ) [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] => 1791353786.9721 [end] => 1791353786.9788 [time] => 0.0066590309143066 ) [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] => 1791353786.9791 [end] => 1791353786.9824 [time] => 0.0033080577850342 ) [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] => 1791353786.9826 [end] => 1791353786.9888 [time] => 0.0061969757080078 ) [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] => 1791353786.989 [end] => 1791353786.9952 [time] => 0.0062048435211182 ) [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] => 1791353786.9953 [end] => 1791353787.0016 [time] => 0.0062358379364014 ) [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] => 1791353787.0017 [end] => 1791353787.008 [time] => 0.0062329769134521 ) [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] => 1791353787.0081 [end] => 1791353787.0144 [time] => 0.0062880516052246 ) [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] => 1791353787.0146 [end] => 1791353787.0209 [time] => 0.0062968730926514 ) [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] => 1791353787.021 [end] => 1791353787.0273 [time] => 0.0062551498413086 ) [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] => 1791353787.0274 [end] => 1791353787.0336 [time] => 0.0062308311462402 ) [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] => 1791353787.0338 [end] => 1791353787.0399 [time] => 0.0061318874359131 ) [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] => 1791353787.0401 [end] => 1791353787.0463 [time] => 0.0062530040740967 ) [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] => 1791353787.0465 [end] => 1791353787.0526 [time] => 0.0061278343200684 ) [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] => 1791353787.0527 [end] => 1791353787.0589 [time] => 0.0061180591583252 ) [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] => 1791353787.059 [end] => 1791353787.0651 [time] => 0.006119966506958 ) [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] => 1791353787.0653 [end] => 1791353787.0715 [time] => 0.0061898231506348 ) [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] => 1791353787.0716 [end] => 1791353787.0778 [time] => 0.0061728954315186 ) [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] => 1791353787.0779 [end] => 1791353787.084 [time] => 0.006105899810791 ) [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] => 1791353787.0841 [end] => 1791353787.0903 [time] => 0.00618577003479 ) [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] => 1791353787.0905 [end] => 1791353787.0966 [time] => 0.0061521530151367 ) [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] => 1791353787.0968 [end] => 1791353787.1029 [time] => 0.0061028003692627 ) [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] => 1791353787.103 [end] => 1791353787.1092 [time] => 0.0062100887298584 ) [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] => 1791353787.1094 [end] => 1791353787.1156 [time] => 0.0062031745910645 ) [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] => 1791353787.1157 [end] => 1791353787.122 [time] => 0.0062220096588135 ) [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] => 1791353787.1221 [end] => 1791353787.1283 [time] => 0.0061659812927246 ) [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] => 1791353787.1284 [end] => 1791353787.1345 [time] => 0.0061070919036865 ) [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] => 1791353787.1346 [end] => 1791353787.1407 [time] => 0.0060789585113525 ) [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] => 1791353787.1409 [end] => 1791353787.1473 [time] => 0.0064270496368408 ) [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] => 1791353787.1474 [end] => 1791353787.1539 [time] => 0.006505012512207 ) [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] => 1791353787.1541 [end] => 1791353787.1603 [time] => 0.0061910152435303 ) [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] => 1791353787.1604 [end] => 1791353787.1666 [time] => 0.0062079429626465 ) [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] => 1791353787.1668 [end] => 1791353787.1729 [time] => 0.0060701370239258 ) [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] => 1791353787.173 [end] => 1791353787.1791 [time] => 0.0061428546905518 ) [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] => 1791353787.1793 [end] => 1791353787.1855 [time] => 0.0061850547790527 ) [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] => 1791353787.1857 [end] => 1791353787.1918 [time] => 0.0061178207397461 ) [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] => 1791353787.1919 [end] => 1791353787.198 [time] => 0.0061321258544922 ) [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] => 1791353787.1982 [end] => 1791353787.2044 [time] => 0.006195068359375 ) [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] => 1791353787.2045 [end] => 1791353787.2108 [time] => 0.0062360763549805 ) [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] => 1791353787.2109 [end] => 1791353787.2171 [time] => 0.0061881542205811 ) [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] => 1791353787.2172 [end] => 1791353787.2234 [time] => 0.0061438083648682 ) [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] => 1791353787.2235 [end] => 1791353787.2301 [time] => 0.0065720081329346 ) [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] => 1791353787.2302 [end] => 1791353787.2364 [time] => 0.0061888694763184 ) [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] => 1791353787.2365 [end] => 1791353787.2428 [time] => 0.0062289237976074 ) [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] => 1791353787.2429 [end] => 1791353787.249 [time] => 0.0061380863189697 ) [60] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1791353787.2492 [end] => 1791353787.2495 [time] => 0.00030016899108887 ) [61] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1791353787.2496 [end] => 1791353787.2502 [time] => 0.00063204765319824 ) [62] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.2507 [end] => 1791353787.2509 [time] => 0.00022411346435547 ) [63] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.2509 [end] => 1791353787.2534 [time] => 0.0025079250335693 ) [64] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.2535 [end] => 1791353787.2692 [time] => 0.015732049942017 ) [65] => Array ( [query] => select * from match_roster where match_id = '3092' [start] => 1791353787.2695 [end] => 1791353787.2783 [time] => 0.0087978839874268 ) [66] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.2784 [end] => 1791353787.2786 [time] => 0.00023603439331055 ) [67] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.2786 [end] => 1791353787.2811 [time] => 0.0024821758270264 ) [68] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.2812 [end] => 1791353787.2969 [time] => 0.015746116638184 ) [69] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '3092' and (point.point = 'P' or point.point = 'E') [start] => 1791353787.2994 [end] => 1791353787.3785 [time] => 0.079108953475952 ) [70] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1791353787.3787 [end] => 1791353787.379 [time] => 0.00037288665771484 ) [71] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1791353787.3791 [end] => 1791353787.3793 [time] => 0.00018811225891113 ) [72] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.3794 [end] => 1791353787.3796 [time] => 0.00020790100097656 ) [73] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.3796 [end] => 1791353787.3821 [time] => 0.0025038719177246 ) [74] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.3821 [end] => 1791353787.398 [time] => 0.015851974487305 ) [75] => Array ( [query] => select * from match_roster where match_id = '3092' [start] => 1791353787.3983 [end] => 1791353787.4071 [time] => 0.008821964263916 ) [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 = '3092' group by player_id [start] => 1791353787.4071 [end] => 1791353787.4568 [time] => 0.049691915512085 ) [77] => Array ( [query] => select * from penalty_to_team where match_id = '3092' [start] => 1791353787.457 [end] => 1791353787.4574 [time] => 0.00042986869812012 ) [78] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.4575 [end] => 1791353787.4577 [time] => 0.00023412704467773 ) [79] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.4578 [end] => 1791353787.4602 [time] => 0.0024950504302979 ) [80] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.4603 [end] => 1791353787.476 [time] => 0.015733957290649 ) [81] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1791353787.4764 [end] => 1791353787.4767 [time] => 0.00027298927307129 ) [82] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1791353787.4768 [end] => 1791353787.4774 [time] => 0.0006101131439209 ) [83] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.4776 [end] => 1791353787.4779 [time] => 0.00033998489379883 ) [84] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.478 [end] => 1791353787.4805 [time] => 0.0025231838226318 ) [85] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.4805 [end] => 1791353787.4966 [time] => 0.016042947769165 ) [86] => Array ( [query] => select * from match_staff_roster where match_id = '3092' [start] => 1791353787.4969 [end] => 1791353787.4981 [time] => 0.0011639595031738 ) [87] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1791353787.4982 [end] => 1791353787.4984 [time] => 0.00019097328186035 ) [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 = '3092' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1791353787.4984 [end] => 1791353787.4986 [time] => 0.00024008750915527 ) [89] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1791353787.4988 [end] => 1791353787.499 [time] => 0.0001978874206543 ) [90] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1791353787.499 [end] => 1791353787.4992 [time] => 0.00018095970153809 ) [91] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.4994 [end] => 1791353787.4996 [time] => 0.00021791458129883 ) [92] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.4996 [end] => 1791353787.5022 [time] => 0.0026009082794189 ) [93] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.5023 [end] => 1791353787.5182 [time] => 0.015888929367065 ) [94] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.5185 [end] => 1791353787.5188 [time] => 0.00028204917907715 ) [95] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.5188 [end] => 1791353787.5213 [time] => 0.0025279521942139 ) [96] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.5214 [end] => 1791353787.5495 [time] => 0.028103113174438 ) [97] => Array ( [query] => select * from match_roster where match_id = '3092' [start] => 1791353787.5499 [end] => 1791353787.5621 [time] => 0.012244939804077 ) [98] => Array ( [query] => select * from point where match_id = '3092' order by point_id ASC [start] => 1791353787.5622 [end] => 1791353787.6378 [time] => 0.075642108917236 ) [99] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1791353787.6386 [end] => 1791353787.6389 [time] => 0.00038504600524902 ) [100] => Array ( [query] => select * from matches where match_id = '3092' [start] => 1791353787.639 [end] => 1791353787.6392 [time] => 0.00022006034851074 ) [101] => Array ( [query] => select time,closed from match_time where match_id = '3092' [start] => 1791353787.6393 [end] => 1791353787.6418 [time] => 0.0025351047515869 ) [102] => Array ( [query] => SELECT * FROM match_data where match_id = '3092' [start] => 1791353787.6418 [end] => 1791353787.6577 [time] => 0.015851020812988 ) [103] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1791353787.6604 [end] => 1791353787.661 [time] => 0.0005640983581543 ) [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] => 1791353787.6611 [end] => 1791353787.6682 [time] => 0.0071220397949219 ) [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] => 1791353787.6685 [end] => 1791353787.672 [time] => 0.0034949779510498 ) [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] => 1791353787.6723 [end] => 1791353787.6792 [time] => 0.00689697265625 ) [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] => 1791353787.6795 [end] => 1791353787.6829 [time] => 0.0033600330352783 ) [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] => 1791353787.6832 [end] => 1791353787.69 [time] => 0.0068860054016113 ) [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] => 1791353787.6903 [end] => 1791353787.6936 [time] => 0.0032970905303955 ) [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] => 1791353787.6939 [end] => 1791353787.7006 [time] => 0.006702184677124 ) [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] => 1791353787.7009 [end] => 1791353787.7042 [time] => 0.0032861232757568 ) [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] => 1791353787.7045 [end] => 1791353787.7107 [time] => 0.0062649250030518 ) [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] => 1791353787.7109 [end] => 1791353787.717 [time] => 0.0061671733856201 ) [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] => 1791353787.7172 [end] => 1791353787.7234 [time] => 0.0061910152435303 ) [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] => 1791353787.7235 [end] => 1791353787.7297 [time] => 0.0062131881713867 ) [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] => 1791353787.7299 [end] => 1791353787.7362 [time] => 0.0062780380249023 ) [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] => 1791353787.7363 [end] => 1791353787.7427 [time] => 0.0063889026641846 ) [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] => 1791353787.7429 [end] => 1791353787.7491 [time] => 0.0062341690063477 ) [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] => 1791353787.7494 [end] => 1791353787.7556 [time] => 0.0062010288238525 ) [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] => 1791353787.7558 [end] => 1791353787.7619 [time] => 0.0061781406402588 ) [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] => 1791353787.7621 [end] => 1791353787.7682 [time] => 0.0061659812927246 ) [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] => 1791353787.7684 [end] => 1791353787.7745 [time] => 0.0061619281768799 ) [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] => 1791353787.7747 [end] => 1791353787.7808 [time] => 0.0061120986938477 ) [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] => 1791353787.781 [end] => 1791353787.7872 [time] => 0.0062549114227295 ) [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] => 1791353787.7874 [end] => 1791353787.7935 [time] => 0.0061559677124023 ) [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] => 1791353787.7937 [end] => 1791353787.7999 [time] => 0.006148099899292 ) [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] => 1791353787.8 [end] => 1791353787.8062 [time] => 0.0061759948730469 ) [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] => 1791353787.8063 [end] => 1791353787.8125 [time] => 0.0061619281768799 ) [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] => 1791353787.8126 [end] => 1791353787.8188 [time] => 0.0061981678009033 ) [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] => 1791353787.819 [end] => 1791353787.8251 [time] => 0.0061130523681641 ) [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] => 1791353787.8252 [end] => 1791353787.8314 [time] => 0.0062458515167236 ) [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] => 1791353787.8316 [end] => 1791353787.8378 [time] => 0.0062479972839355 ) [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] => 1791353787.838 [end] => 1791353787.8442 [time] => 0.0061960220336914 ) [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] => 1791353787.8443 [end] => 1791353787.8505 [time] => 0.0062050819396973 ) [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] => 1791353787.8506 [end] => 1791353787.8567 [time] => 0.0061390399932861 ) [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] => 1791353787.8569 [end] => 1791353787.863 [time] => 0.0061378479003906 ) [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] => 1791353787.8631 [end] => 1791353787.8694 [time] => 0.0062551498413086 ) [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] => 1791353787.8696 [end] => 1791353787.8758 [time] => 0.0062289237976074 ) [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] => 1791353787.8759 [end] => 1791353787.8822 [time] => 0.0062360763549805 ) [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] => 1791353787.8823 [end] => 1791353787.8885 [time] => 0.0061759948730469 ) [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] => 1791353787.8886 [end] => 1791353787.8947 [time] => 0.0061168670654297 ) [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] => 1791353787.8949 [end] => 1791353787.901 [time] => 0.0061008930206299 ) [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] => 1791353787.9011 [end] => 1791353787.9072 [time] => 0.0061380863189697 ) [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] => 1791353787.9075 [end] => 1791353787.9136 [time] => 0.0061609745025635 ) [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] => 1791353787.9138 [end] => 1791353787.9199 [time] => 0.006126880645752 ) [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] => 1791353787.9201 [end] => 1791353787.9263 [time] => 0.0062501430511475 ) [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] => 1791353787.9264 [end] => 1791353787.9327 [time] => 0.0062179565429688 ) [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] => 1791353787.9328 [end] => 1791353787.939 [time] => 0.0062179565429688 ) [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] => 1791353787.9392 [end] => 1791353787.9453 [time] => 0.0061430931091309 ) [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] => 1791353787.9455 [end] => 1791353787.9517 [time] => 0.0062270164489746 ) [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] => 1791353787.9518 [end] => 1791353787.9581 [time] => 0.0062661170959473 ) [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] => 1791353787.9582 [end] => 1791353787.9644 [time] => 0.0061948299407959 ) [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] => 1791353787.9645 [end] => 1791353787.9708 [time] => 0.0062191486358643 ) [154] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1791353787.9714 [end] => 1791353787.9717 [time] => 0.00031185150146484 ) )