Referto Partita: Krakens Chivasso vs AS Intomatici
Krakens Chivasso
AS Intomatici
RISULTATO FINALE
77
35
1° Tempo
25
10
2° Tempo
20
12
3° Tempo
32
13
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 B2
Giornata: 2
Giornata: 2
Data e Luogo
10-11-2021 20:30 - Palazzeschi
Arbitri
Primo Arbitro
Naggi Giulio
Secondo Arbitro
Sceusi Giuseppe
Refertista
Sceusi Giuseppe
Sorteggio
Sorteggio Vinto Da
Krakens Chivasso
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Krakens Chivasso
-
Davide MartiniTot.24
9
x22
x3
0
x AUTOHIT -
Emanuele Filiberto PellegrinTot.2
1
x20
x3
0
x AUTOHIT -
Andrea MerloTot.20
7
x22
x3
0
x AUTOHIT -
Luca TorreanoTot.8
1
x22
x3
0
x AUTOHIT -
Francesco GhioTot.4
2
x20
x3
0
x AUTOHIT -
Alessio ArganoTot.18
6
x22
x3
0
x AUTOHIT
AS Intomatici
-
Alberto Amoruso
1
x20
x3
0
x AUTOHITTot.2
Giulio Cocirio
3
x21
x3
0
x AUTOHITTot.9
Jairo Mattia Agaliati Fadda
0
x20
x3
1
x AUTOHITTot.0
Andrea Rossotto
2
x20
x3
0
x AUTOHITTot.4
Edoardo Di Noia
0
x20
x3
0
x AUTOHITTot.0
Simone Basano
3
x20
x3
0
x AUTOHITTot.6
Samuele Carnelli
2
x20
x3
0
x AUTOHITTot.4
Davide Rivetti
2
x20
x3
0
x AUTOHITTot.4
Gabriele Di Stefano
3
x20
x3
0
x AUTOHITTot.6
Total Queries: 155 Total Time: 1.044331073761 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1791347376.533 [end] => 1791347376.5334 [time] => 0.00034594535827637 ) [1] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347376.536 [end] => 1791347376.5362 [time] => 0.00026297569274902 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347376.5362 [end] => 1791347376.5388 [time] => 0.0025579929351807 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347376.5389 [end] => 1791347376.555 [time] => 0.016071081161499 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347376.5553 [end] => 1791347376.5579 [time] => 0.0026359558105469 ) [5] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347376.558 [end] => 1791347376.5582 [time] => 0.00023007392883301 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347376.5582 [end] => 1791347376.5607 [time] => 0.0024669170379639 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347376.5608 [end] => 1791347376.5765 [time] => 0.015710115432739 ) [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 (9,27) ORDER BY lastname,firstname ASC [start] => 1791347376.5769 [end] => 1791347376.5781 [time] => 0.0012328624725342 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1791347376.5799 [end] => 1791347376.5803 [time] => 0.00044703483581543 ) [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] => 1791347376.5805 [end] => 1791347376.5871 [time] => 0.0066468715667725 ) [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] => 1791347376.5874 [end] => 1791347376.5907 [time] => 0.0033140182495117 ) [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] => 1791347376.591 [end] => 1791347376.5976 [time] => 0.0066409111022949 ) [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] => 1791347376.5979 [end] => 1791347376.6012 [time] => 0.0032799243927002 ) [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] => 1791347376.6015 [end] => 1791347376.6081 [time] => 0.0066118240356445 ) [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] => 1791347376.6084 [end] => 1791347376.6117 [time] => 0.0032861232757568 ) [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] => 1791347376.6119 [end] => 1791347376.6185 [time] => 0.0065979957580566 ) [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] => 1791347376.6188 [end] => 1791347376.6221 [time] => 0.0032861232757568 ) [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] => 1791347376.6223 [end] => 1791347376.6285 [time] => 0.0061841011047363 ) [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] => 1791347376.6287 [end] => 1791347376.6349 [time] => 0.0062069892883301 ) [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] => 1791347376.635 [end] => 1791347376.6412 [time] => 0.0061390399932861 ) [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] => 1791347376.6413 [end] => 1791347376.6476 [time] => 0.0063490867614746 ) [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] => 1791347376.6478 [end] => 1791347376.654 [time] => 0.0062210559844971 ) [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] => 1791347376.6542 [end] => 1791347376.6604 [time] => 0.006187915802002 ) [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] => 1791347376.6605 [end] => 1791347376.6667 [time] => 0.0062379837036133 ) [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] => 1791347376.6669 [end] => 1791347376.6731 [time] => 0.0062341690063477 ) [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] => 1791347376.6732 [end] => 1791347376.6794 [time] => 0.0061590671539307 ) [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] => 1791347376.6795 [end] => 1791347376.6858 [time] => 0.0062129497528076 ) [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] => 1791347376.6859 [end] => 1791347376.6929 [time] => 0.0069801807403564 ) [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] => 1791347376.6931 [end] => 1791347376.6993 [time] => 0.0062010288238525 ) [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] => 1791347376.6994 [end] => 1791347376.7056 [time] => 0.006199836730957 ) [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] => 1791347376.7058 [end] => 1791347376.7119 [time] => 0.0061001777648926 ) [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] => 1791347376.712 [end] => 1791347376.7182 [time] => 0.0061311721801758 ) [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] => 1791347376.7183 [end] => 1791347376.7244 [time] => 0.0061349868774414 ) [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] => 1791347376.7246 [end] => 1791347376.7308 [time] => 0.006181001663208 ) [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] => 1791347376.7309 [end] => 1791347376.737 [time] => 0.0061209201812744 ) [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] => 1791347376.7372 [end] => 1791347376.7433 [time] => 0.0061550140380859 ) [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] => 1791347376.7435 [end] => 1791347376.7497 [time] => 0.00624680519104 ) [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] => 1791347376.7498 [end] => 1791347376.7562 [time] => 0.0063199996948242 ) [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] => 1791347376.7563 [end] => 1791347376.7625 [time] => 0.0062329769134521 ) [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] => 1791347376.7627 [end] => 1791347376.7689 [time] => 0.0061900615692139 ) [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] => 1791347376.7691 [end] => 1791347376.7752 [time] => 0.0061488151550293 ) [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] => 1791347376.7753 [end] => 1791347376.7815 [time] => 0.0061368942260742 ) [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] => 1791347376.7816 [end] => 1791347376.7879 [time] => 0.0062551498413086 ) [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] => 1791347376.788 [end] => 1791347376.7943 [time] => 0.0063049793243408 ) [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] => 1791347376.7945 [end] => 1791347376.8007 [time] => 0.0062620639801025 ) [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] => 1791347376.8009 [end] => 1791347376.8071 [time] => 0.0061709880828857 ) [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] => 1791347376.8072 [end] => 1791347376.8133 [time] => 0.0060710906982422 ) [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] => 1791347376.8134 [end] => 1791347376.8195 [time] => 0.0061118602752686 ) [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] => 1791347376.8197 [end] => 1791347376.8258 [time] => 0.006159782409668 ) [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] => 1791347376.826 [end] => 1791347376.8321 [time] => 0.0061261653900146 ) [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] => 1791347376.8322 [end] => 1791347376.8384 [time] => 0.0061380863189697 ) [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] => 1791347376.8385 [end] => 1791347376.8447 [time] => 0.0062150955200195 ) [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] => 1791347376.8448 [end] => 1791347376.8511 [time] => 0.0062119960784912 ) [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] => 1791347376.8512 [end] => 1791347376.8574 [time] => 0.0061929225921631 ) [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] => 1791347376.8575 [end] => 1791347376.8637 [time] => 0.0061378479003906 ) [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] => 1791347376.8638 [end] => 1791347376.8701 [time] => 0.0062439441680908 ) [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] => 1791347376.8702 [end] => 1791347376.8764 [time] => 0.0062260627746582 ) [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] => 1791347376.8766 [end] => 1791347376.8828 [time] => 0.0062150955200195 ) [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] => 1791347376.8829 [end] => 1791347376.8891 [time] => 0.0062119960784912 ) [60] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1791347376.8893 [end] => 1791347376.8896 [time] => 0.00031399726867676 ) [61] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1791347376.8897 [end] => 1791347376.8903 [time] => 0.00061392784118652 ) [62] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347376.8908 [end] => 1791347376.891 [time] => 0.00020599365234375 ) [63] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347376.891 [end] => 1791347376.8935 [time] => 0.0024869441986084 ) [64] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347376.8936 [end] => 1791347376.9093 [time] => 0.015751838684082 ) [65] => Array ( [query] => select * from match_roster where match_id = '1983' [start] => 1791347376.9096 [end] => 1791347376.9184 [time] => 0.0088062286376953 ) [66] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347376.9185 [end] => 1791347376.9188 [time] => 0.00026106834411621 ) [67] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347376.9188 [end] => 1791347376.9213 [time] => 0.0024759769439697 ) [68] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347376.9213 [end] => 1791347376.9371 [time] => 0.015774965286255 ) [69] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '1983' and (point.point = 'P' or point.point = 'E') [start] => 1791347376.9396 [end] => 1791347377.0214 [time] => 0.081788063049316 ) [70] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1791347377.0216 [end] => 1791347377.0221 [time] => 0.00053596496582031 ) [71] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1791347377.0222 [end] => 1791347377.0225 [time] => 0.00030207633972168 ) [72] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347377.0226 [end] => 1791347377.0229 [time] => 0.00030612945556641 ) [73] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347377.0229 [end] => 1791347377.0289 [time] => 0.0059449672698975 ) [74] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347377.0289 [end] => 1791347377.05 [time] => 0.021052122116089 ) [75] => Array ( [query] => select * from match_roster where match_id = '1983' [start] => 1791347377.0502 [end] => 1791347377.0591 [time] => 0.0088579654693604 ) [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 = '1983' group by player_id [start] => 1791347377.0591 [end] => 1791347377.1089 [time] => 0.049707174301147 ) [77] => Array ( [query] => select * from penalty_to_team where match_id = '1983' [start] => 1791347377.109 [end] => 1791347377.1095 [time] => 0.00042486190795898 ) [78] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347377.1095 [end] => 1791347377.1098 [time] => 0.00023007392883301 ) [79] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347377.1098 [end] => 1791347377.1123 [time] => 0.0025007724761963 ) [80] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347377.1123 [end] => 1791347377.1282 [time] => 0.015919923782349 ) [81] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1791347377.1286 [end] => 1791347377.1288 [time] => 0.0002901554107666 ) [82] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1791347377.1289 [end] => 1791347377.1295 [time] => 0.00059103965759277 ) [83] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347377.1298 [end] => 1791347377.13 [time] => 0.00021195411682129 ) [84] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347377.13 [end] => 1791347377.1325 [time] => 0.0024888515472412 ) [85] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347377.1325 [end] => 1791347377.1482 [time] => 0.015702962875366 ) [86] => Array ( [query] => select * from match_staff_roster where match_id = '1983' [start] => 1791347377.1485 [end] => 1791347377.1495 [time] => 0.0010950565338135 ) [87] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1791347377.1496 [end] => 1791347377.1498 [time] => 0.00018095970153809 ) [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 = '1983' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1791347377.1498 [end] => 1791347377.1501 [time] => 0.00020909309387207 ) [89] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1791347377.1501 [end] => 1791347377.1503 [time] => 0.00016903877258301 ) [90] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1791347377.1503 [end] => 1791347377.1505 [time] => 0.00013494491577148 ) [91] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347377.1506 [end] => 1791347377.1508 [time] => 0.00020289421081543 ) [92] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347377.1509 [end] => 1791347377.1533 [time] => 0.0024590492248535 ) [93] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347377.1534 [end] => 1791347377.1745 [time] => 0.021119117736816 ) [94] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347377.1748 [end] => 1791347377.1751 [time] => 0.00028800964355469 ) [95] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347377.1751 [end] => 1791347377.1778 [time] => 0.0026159286499023 ) [96] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347377.1778 [end] => 1791347377.1936 [time] => 0.015769004821777 ) [97] => Array ( [query] => select * from match_roster where match_id = '1983' [start] => 1791347377.1939 [end] => 1791347377.2027 [time] => 0.0088570117950439 ) [98] => Array ( [query] => select * from point where match_id = '1983' order by point_id ASC [start] => 1791347377.2028 [end] => 1791347377.2774 [time] => 0.074609041213989 ) [99] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1791347377.2781 [end] => 1791347377.2785 [time] => 0.00032806396484375 ) [100] => Array ( [query] => select * from matches where match_id = '1983' [start] => 1791347377.2785 [end] => 1791347377.2787 [time] => 0.00020599365234375 ) [101] => Array ( [query] => select time,closed from match_time where match_id = '1983' [start] => 1791347377.2787 [end] => 1791347377.2812 [time] => 0.0024681091308594 ) [102] => Array ( [query] => SELECT * FROM match_data where match_id = '1983' [start] => 1791347377.2813 [end] => 1791347377.297 [time] => 0.015759944915771 ) [103] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1791347377.2999 [end] => 1791347377.3004 [time] => 0.00050616264343262 ) [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] => 1791347377.3005 [end] => 1791347377.3073 [time] => 0.0067980289459229 ) [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] => 1791347377.3076 [end] => 1791347377.311 [time] => 0.0033488273620605 ) [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] => 1791347377.3112 [end] => 1791347377.3179 [time] => 0.00667405128479 ) [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] => 1791347377.3182 [end] => 1791347377.3214 [time] => 0.0032579898834229 ) [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] => 1791347377.3217 [end] => 1791347377.3283 [time] => 0.0066461563110352 ) [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] => 1791347377.3286 [end] => 1791347377.3319 [time] => 0.0033199787139893 ) [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] => 1791347377.3321 [end] => 1791347377.3388 [time] => 0.0066330432891846 ) [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] => 1791347377.3391 [end] => 1791347377.3424 [time] => 0.003303050994873 ) [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] => 1791347377.3426 [end] => 1791347377.3488 [time] => 0.0061850547790527 ) [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] => 1791347377.3489 [end] => 1791347377.3551 [time] => 0.0061910152435303 ) [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] => 1791347377.3552 [end] => 1791347377.3614 [time] => 0.0061650276184082 ) [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] => 1791347377.3616 [end] => 1791347377.3677 [time] => 0.0061581134796143 ) [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] => 1791347377.3679 [end] => 1791347377.3741 [time] => 0.006256103515625 ) [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] => 1791347377.3743 [end] => 1791347377.3805 [time] => 0.0062019824981689 ) [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] => 1791347377.3806 [end] => 1791347377.3869 [time] => 0.0062901973724365 ) [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] => 1791347377.387 [end] => 1791347377.3934 [time] => 0.0063509941101074 ) [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] => 1791347377.3936 [end] => 1791347377.3997 [time] => 0.0061609745025635 ) [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] => 1791347377.3999 [end] => 1791347377.4061 [time] => 0.0062351226806641 ) [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] => 1791347377.4063 [end] => 1791347377.4124 [time] => 0.0061681270599365 ) [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] => 1791347377.4126 [end] => 1791347377.4187 [time] => 0.0061469078063965 ) [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] => 1791347377.4189 [end] => 1791347377.425 [time] => 0.0061209201812744 ) [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] => 1791347377.4251 [end] => 1791347377.4313 [time] => 0.0062019824981689 ) [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] => 1791347377.4315 [end] => 1791347377.4377 [time] => 0.0061841011047363 ) [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] => 1791347377.4378 [end] => 1791347377.444 [time] => 0.0061650276184082 ) [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] => 1791347377.4442 [end] => 1791347377.4503 [time] => 0.0061731338500977 ) [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] => 1791347377.4505 [end] => 1791347377.4566 [time] => 0.0061378479003906 ) [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] => 1791347377.4568 [end] => 1791347377.463 [time] => 0.0062699317932129 ) [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] => 1791347377.4632 [end] => 1791347377.4695 [time] => 0.0062839984893799 ) [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] => 1791347377.4696 [end] => 1791347377.4759 [time] => 0.0062458515167236 ) [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] => 1791347377.476 [end] => 1791347377.4823 [time] => 0.0062720775604248 ) [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] => 1791347377.4824 [end] => 1791347377.4886 [time] => 0.0061969757080078 ) [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] => 1791347377.4888 [end] => 1791347377.495 [time] => 0.0061829090118408 ) [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] => 1791347377.4952 [end] => 1791347377.5013 [time] => 0.0061261653900146 ) [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] => 1791347377.5015 [end] => 1791347377.5077 [time] => 0.0062761306762695 ) [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] => 1791347377.5079 [end] => 1791347377.5142 [time] => 0.0063040256500244 ) [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] => 1791347377.5144 [end] => 1791347377.5207 [time] => 0.006303071975708 ) [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] => 1791347377.5208 [end] => 1791347377.5271 [time] => 0.0062370300292969 ) [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] => 1791347377.5272 [end] => 1791347377.5334 [time] => 0.0061662197113037 ) [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] => 1791347377.5336 [end] => 1791347377.5397 [time] => 0.006166934967041 ) [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] => 1791347377.5399 [end] => 1791347377.5461 [time] => 0.0061728954315186 ) [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] => 1791347377.5462 [end] => 1791347377.5524 [time] => 0.0061440467834473 ) [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] => 1791347377.5525 [end] => 1791347377.5587 [time] => 0.0061640739440918 ) [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] => 1791347377.5589 [end] => 1791347377.5651 [time] => 0.0062460899353027 ) [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] => 1791347377.5652 [end] => 1791347377.5715 [time] => 0.0062260627746582 ) [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] => 1791347377.5716 [end] => 1791347377.5779 [time] => 0.0062441825866699 ) [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] => 1791347377.578 [end] => 1791347377.5842 [time] => 0.0061640739440918 ) [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] => 1791347377.5843 [end] => 1791347377.5906 [time] => 0.0063290596008301 ) [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] => 1791347377.5908 [end] => 1791347377.5971 [time] => 0.0062470436096191 ) [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] => 1791347377.5973 [end] => 1791347377.6036 [time] => 0.0063450336456299 ) [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] => 1791347377.6038 [end] => 1791347377.61 [time] => 0.0061869621276855 ) [154] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1791347377.6106 [end] => 1791347377.6109 [time] => 0.00034093856811523 ) )