Referto Partita: Lighting Bugs vs Pellegrini Venaria
Lighting Bugs
Pellegrini Venaria
RISULTATO FINALE
66
63
1° Tempo
17
16
2° Tempo
25
26
3° Tempo
24
21
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 B1
Giornata: 15
Giornata: 15
Data e Luogo
23-04-2022 18:15 - Palazzeschi
Arbitri
Primo Arbitro
Spina Gabriele
Secondo Arbitro
Da Re Francesca
Refertista
Da Re Francesca
Sorteggio
Sorteggio Vinto Da
Pellegrini Venaria
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Lighting Bugs
-
Andrea CrovagnaTot.2
1
x20
x3
0
x AUTOHIT -
Davide BarboniTot.14
1
x24
x3
0
x AUTOHIT -
Alessio RimicciTot.
25
5
x25
x3
0
x AUTOHIT -
Fabrizio OlivieriTot.
4
2
x20
x3
0
x AUTOHIT -
Gianluca SabatinoTot.6
3
x20
x3
0
x AUTOHIT -
Davide GattiTot.
15
6
x21
x3
0
x AUTOHIT
Pellegrini Venaria
-
Gabriele Cappero
0
x20
x3
0
x AUTOHITTot.0
Domenico Pirozzolo
7
x20
x3
0
x AUTOHITTot.14
Luca Dragna
4
x21
x3
0
x AUTOHITTot.11
Gabriele Barone
3
x20
x3
0
x AUTOHITTot.6
Barbara Tombolato
1
x20
x3
0
x AUTOHITTot.2
Christian Alescio
1
x20
x3
0
x AUTOHITTot.2
Federico Zoccarato
0
x20
x3
0
x AUTOHITTot.0
Alberto Casalegno
5
x20
x3
0
x AUTOHITTot.10
Federico Sisci
9
x20
x3
0
x AUTOHITTot.18
Total Queries: 155 Total Time: 1.0419285297394 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1791350297.1884 [end] => 1791350297.1887 [time] => 0.00029110908508301 ) [1] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.1911 [end] => 1791350297.1913 [time] => 0.00023293495178223 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.1913 [end] => 1791350297.1938 [time] => 0.0025169849395752 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.1939 [end] => 1791350297.2096 [time] => 0.015734910964966 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.21 [end] => 1791350297.2126 [time] => 0.002593994140625 ) [5] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.2127 [end] => 1791350297.2129 [time] => 0.00022602081298828 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.2129 [end] => 1791350297.2154 [time] => 0.002471923828125 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.2154 [end] => 1791350297.2311 [time] => 0.015705108642578 ) [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 (15,14) ORDER BY lastname,firstname ASC [start] => 1791350297.2315 [end] => 1791350297.2326 [time] => 0.0011041164398193 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1791350297.2338 [end] => 1791350297.2343 [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] => 1791350297.2344 [end] => 1791350297.2412 [time] => 0.0067319869995117 ) [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] => 1791350297.2415 [end] => 1791350297.2448 [time] => 0.0033690929412842 ) [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] => 1791350297.2452 [end] => 1791350297.252 [time] => 0.0068819522857666 ) [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] => 1791350297.2523 [end] => 1791350297.2557 [time] => 0.0033721923828125 ) [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] => 1791350297.256 [end] => 1791350297.2627 [time] => 0.0066850185394287 ) [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] => 1791350297.263 [end] => 1791350297.2663 [time] => 0.0033159255981445 ) [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] => 1791350297.2666 [end] => 1791350297.2733 [time] => 0.0067059993743896 ) [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] => 1791350297.2736 [end] => 1791350297.2769 [time] => 0.0033140182495117 ) [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] => 1791350297.2772 [end] => 1791350297.2834 [time] => 0.006234884262085 ) [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] => 1791350297.2836 [end] => 1791350297.2898 [time] => 0.0062429904937744 ) [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] => 1791350297.29 [end] => 1791350297.2962 [time] => 0.0062069892883301 ) [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] => 1791350297.2963 [end] => 1791350297.3027 [time] => 0.0063669681549072 ) [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] => 1791350297.3029 [end] => 1791350297.3091 [time] => 0.0062670707702637 ) [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] => 1791350297.3093 [end] => 1791350297.3156 [time] => 0.0063269138336182 ) [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] => 1791350297.3158 [end] => 1791350297.3221 [time] => 0.0062592029571533 ) [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] => 1791350297.3222 [end] => 1791350297.3285 [time] => 0.0062699317932129 ) [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] => 1791350297.3286 [end] => 1791350297.3349 [time] => 0.006260871887207 ) [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] => 1791350297.3351 [end] => 1791350297.3413 [time] => 0.0062589645385742 ) [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] => 1791350297.3415 [end] => 1791350297.3481 [time] => 0.006540060043335 ) [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] => 1791350297.3482 [end] => 1791350297.3545 [time] => 0.0062379837036133 ) [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] => 1791350297.3546 [end] => 1791350297.3608 [time] => 0.0061829090118408 ) [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] => 1791350297.361 [end] => 1791350297.3673 [time] => 0.0062310695648193 ) [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] => 1791350297.3675 [end] => 1791350297.3737 [time] => 0.0061948299407959 ) [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] => 1791350297.3738 [end] => 1791350297.38 [time] => 0.0061709880828857 ) [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] => 1791350297.3802 [end] => 1791350297.3864 [time] => 0.0061891078948975 ) [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] => 1791350297.3865 [end] => 1791350297.3929 [time] => 0.0064470767974854 ) [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] => 1791350297.3931 [end] => 1791350297.3993 [time] => 0.0062100887298584 ) [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] => 1791350297.3995 [end] => 1791350297.4058 [time] => 0.0063159465789795 ) [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] => 1791350297.4059 [end] => 1791350297.4122 [time] => 0.006289005279541 ) [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] => 1791350297.4124 [end] => 1791350297.4188 [time] => 0.0063889026641846 ) [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] => 1791350297.419 [end] => 1791350297.4253 [time] => 0.0063199996948242 ) [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] => 1791350297.4255 [end] => 1791350297.4318 [time] => 0.0062432289123535 ) [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] => 1791350297.4319 [end] => 1791350297.4382 [time] => 0.0062811374664307 ) [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] => 1791350297.4384 [end] => 1791350297.445 [time] => 0.0065820217132568 ) [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] => 1791350297.4452 [end] => 1791350297.4516 [time] => 0.0064449310302734 ) [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] => 1791350297.4518 [end] => 1791350297.4583 [time] => 0.0064229965209961 ) [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] => 1791350297.4584 [end] => 1791350297.4648 [time] => 0.0063400268554688 ) [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] => 1791350297.465 [end] => 1791350297.4713 [time] => 0.0063130855560303 ) [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] => 1791350297.4715 [end] => 1791350297.4778 [time] => 0.0063300132751465 ) [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] => 1791350297.478 [end] => 1791350297.4843 [time] => 0.0062968730926514 ) [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] => 1791350297.4845 [end] => 1791350297.4911 [time] => 0.00655198097229 ) [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] => 1791350297.4913 [end] => 1791350297.4976 [time] => 0.006321907043457 ) [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] => 1791350297.4979 [end] => 1791350297.5076 [time] => 0.0097179412841797 ) [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] => 1791350297.5078 [end] => 1791350297.5144 [time] => 0.0065269470214844 ) [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] => 1791350297.5146 [end] => 1791350297.5215 [time] => 0.0068609714508057 ) [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] => 1791350297.5218 [end] => 1791350297.5283 [time] => 0.0065062046051025 ) [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] => 1791350297.5285 [end] => 1791350297.5356 [time] => 0.0070741176605225 ) [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] => 1791350297.5359 [end] => 1791350297.5424 [time] => 0.006587028503418 ) [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] => 1791350297.5427 [end] => 1791350297.5493 [time] => 0.0065710544586182 ) [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] => 1791350297.5496 [end] => 1791350297.5561 [time] => 0.0064821243286133 ) [60] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1791350297.5563 [end] => 1791350297.5566 [time] => 0.00036001205444336 ) [61] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1791350297.5568 [end] => 1791350297.5575 [time] => 0.00077009201049805 ) [62] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.558 [end] => 1791350297.5583 [time] => 0.00023603439331055 ) [63] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.5583 [end] => 1791350297.5609 [time] => 0.0025949478149414 ) [64] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.5609 [end] => 1791350297.577 [time] => 0.016078948974609 ) [65] => Array ( [query] => select * from match_roster where match_id = '1900' [start] => 1791350297.5773 [end] => 1791350297.5866 [time] => 0.0092689990997314 ) [66] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.5867 [end] => 1791350297.587 [time] => 0.00030088424682617 ) [67] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.5871 [end] => 1791350297.5897 [time] => 0.0026030540466309 ) [68] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.5898 [end] => 1791350297.6057 [time] => 0.015961885452271 ) [69] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '1900' and (point.point = 'P' or point.point = 'E') [start] => 1791350297.6083 [end] => 1791350297.6884 [time] => 0.080185890197754 ) [70] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1791350297.6886 [end] => 1791350297.689 [time] => 0.0003669261932373 ) [71] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1791350297.689 [end] => 1791350297.6892 [time] => 0.00018596649169922 ) [72] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.6893 [end] => 1791350297.6895 [time] => 0.00023698806762695 ) [73] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.6895 [end] => 1791350297.6921 [time] => 0.0025570392608643 ) [74] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.6922 [end] => 1791350297.708 [time] => 0.015783071517944 ) [75] => Array ( [query] => select * from match_roster where match_id = '1900' [start] => 1791350297.7082 [end] => 1791350297.7172 [time] => 0.0089700222015381 ) [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 = '1900' group by player_id [start] => 1791350297.7172 [end] => 1791350297.7681 [time] => 0.050904035568237 ) [77] => Array ( [query] => select * from penalty_to_team where match_id = '1900' [start] => 1791350297.7683 [end] => 1791350297.7687 [time] => 0.00036096572875977 ) [78] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.7687 [end] => 1791350297.7689 [time] => 0.00019097328186035 ) [79] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.7689 [end] => 1791350297.7715 [time] => 0.0025398731231689 ) [80] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.7715 [end] => 1791350297.7874 [time] => 0.015831232070923 ) [81] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1791350297.7877 [end] => 1791350297.788 [time] => 0.0002901554107666 ) [82] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1791350297.7881 [end] => 1791350297.7887 [time] => 0.00058603286743164 ) [83] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.7889 [end] => 1791350297.7891 [time] => 0.00020408630371094 ) [84] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.7891 [end] => 1791350297.7917 [time] => 0.0025529861450195 ) [85] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.7918 [end] => 1791350297.8076 [time] => 0.015862941741943 ) [86] => Array ( [query] => select * from match_staff_roster where match_id = '1900' [start] => 1791350297.8079 [end] => 1791350297.809 [time] => 0.0010988712310791 ) [87] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1791350297.8091 [end] => 1791350297.8093 [time] => 0.00017404556274414 ) [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 = '1900' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1791350297.8093 [end] => 1791350297.8095 [time] => 0.00024008750915527 ) [89] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1791350297.8096 [end] => 1791350297.8098 [time] => 0.00017189979553223 ) [90] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1791350297.8098 [end] => 1791350297.81 [time] => 0.00014495849609375 ) [91] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.8101 [end] => 1791350297.8103 [time] => 0.0001680850982666 ) [92] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.8103 [end] => 1791350297.8128 [time] => 0.0024771690368652 ) [93] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.8128 [end] => 1791350297.8286 [time] => 0.015710830688477 ) [94] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.8289 [end] => 1791350297.8292 [time] => 0.00028204917907715 ) [95] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.8292 [end] => 1791350297.8317 [time] => 0.0025358200073242 ) [96] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.8318 [end] => 1791350297.8476 [time] => 0.015889883041382 ) [97] => Array ( [query] => select * from match_roster where match_id = '1900' [start] => 1791350297.8479 [end] => 1791350297.8568 [time] => 0.0088720321655273 ) [98] => Array ( [query] => select * from point where match_id = '1900' order by point_id ASC [start] => 1791350297.8568 [end] => 1791350297.9314 [time] => 0.074543952941895 ) [99] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1791350297.9321 [end] => 1791350297.9324 [time] => 0.00031614303588867 ) [100] => Array ( [query] => select * from matches where match_id = '1900' [start] => 1791350297.9325 [end] => 1791350297.9327 [time] => 0.00020194053649902 ) [101] => Array ( [query] => select time,closed from match_time where match_id = '1900' [start] => 1791350297.9327 [end] => 1791350297.9352 [time] => 0.0025060176849365 ) [102] => Array ( [query] => SELECT * FROM match_data where match_id = '1900' [start] => 1791350297.9353 [end] => 1791350297.9513 [time] => 0.015992164611816 ) [103] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1791350297.954 [end] => 1791350297.9545 [time] => 0.00050806999206543 ) [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] => 1791350297.9546 [end] => 1791350297.9614 [time] => 0.0067059993743896 ) [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] => 1791350297.9617 [end] => 1791350297.965 [time] => 0.0032780170440674 ) [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] => 1791350297.9652 [end] => 1791350297.9719 [time] => 0.0066659450531006 ) [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] => 1791350297.9721 [end] => 1791350297.9754 [time] => 0.0032901763916016 ) [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] => 1791350297.9757 [end] => 1791350297.9823 [time] => 0.0066359043121338 ) [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] => 1791350297.9826 [end] => 1791350297.9859 [time] => 0.0032820701599121 ) [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] => 1791350297.9861 [end] => 1791350297.9927 [time] => 0.0066428184509277 ) [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] => 1791350297.993 [end] => 1791350297.9963 [time] => 0.0032999515533447 ) [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] => 1791350297.9965 [end] => 1791350298.0028 [time] => 0.0062448978424072 ) [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] => 1791350298.0029 [end] => 1791350298.0092 [time] => 0.0062160491943359 ) [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] => 1791350298.0093 [end] => 1791350298.0156 [time] => 0.0062949657440186 ) [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] => 1791350298.0158 [end] => 1791350298.0221 [time] => 0.0062520503997803 ) [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] => 1791350298.0223 [end] => 1791350298.0285 [time] => 0.0062458515167236 ) [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] => 1791350298.0287 [end] => 1791350298.035 [time] => 0.0063059329986572 ) [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] => 1791350298.0351 [end] => 1791350298.0414 [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] => 1791350298.0416 [end] => 1791350298.0479 [time] => 0.0062470436096191 ) [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] => 1791350298.0481 [end] => 1791350298.0543 [time] => 0.0061860084533691 ) [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] => 1791350298.0544 [end] => 1791350298.0607 [time] => 0.0062358379364014 ) [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] => 1791350298.0609 [end] => 1791350298.0671 [time] => 0.006213903427124 ) [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] => 1791350298.0673 [end] => 1791350298.0736 [time] => 0.0062820911407471 ) [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] => 1791350298.074 [end] => 1791350298.0802 [time] => 0.0062458515167236 ) [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] => 1791350298.0805 [end] => 1791350298.0867 [time] => 0.0062382221221924 ) [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] => 1791350298.0869 [end] => 1791350298.0931 [time] => 0.0061390399932861 ) [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] => 1791350298.0932 [end] => 1791350298.0994 [time] => 0.006195068359375 ) [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] => 1791350298.0997 [end] => 1791350298.1059 [time] => 0.0062100887298584 ) [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] => 1791350298.106 [end] => 1791350298.1122 [time] => 0.0061469078063965 ) [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] => 1791350298.1123 [end] => 1791350298.1185 [time] => 0.0062239170074463 ) [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] => 1791350298.1187 [end] => 1791350298.125 [time] => 0.0062599182128906 ) [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] => 1791350298.1252 [end] => 1791350298.1314 [time] => 0.0062389373779297 ) [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] => 1791350298.1315 [end] => 1791350298.1379 [time] => 0.0063838958740234 ) [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] => 1791350298.1381 [end] => 1791350298.1444 [time] => 0.0062611103057861 ) [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] => 1791350298.1446 [end] => 1791350298.1508 [time] => 0.0062360763549805 ) [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] => 1791350298.1511 [end] => 1791350298.1572 [time] => 0.0061688423156738 ) [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] => 1791350298.1574 [end] => 1791350298.1637 [time] => 0.006270170211792 ) [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] => 1791350298.1639 [end] => 1791350298.1702 [time] => 0.0063240528106689 ) [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] => 1791350298.1704 [end] => 1791350298.1767 [time] => 0.0063021183013916 ) [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] => 1791350298.1768 [end] => 1791350298.1831 [time] => 0.0062339305877686 ) [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] => 1791350298.1832 [end] => 1791350298.1895 [time] => 0.0062069892883301 ) [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] => 1791350298.1896 [end] => 1791350298.1958 [time] => 0.0061709880828857 ) [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] => 1791350298.196 [end] => 1791350298.2021 [time] => 0.0061748027801514 ) [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] => 1791350298.2023 [end] => 1791350298.2084 [time] => 0.0061030387878418 ) [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] => 1791350298.2085 [end] => 1791350298.2147 [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] => 1791350298.2148 [end] => 1791350298.2211 [time] => 0.0062141418457031 ) [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] => 1791350298.2212 [end] => 1791350298.2274 [time] => 0.0062448978424072 ) [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] => 1791350298.2276 [end] => 1791350298.2339 [time] => 0.006274938583374 ) [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] => 1791350298.234 [end] => 1791350298.2402 [time] => 0.0061690807342529 ) [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] => 1791350298.2403 [end] => 1791350298.2465 [time] => 0.0062007904052734 ) [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] => 1791350298.2467 [end] => 1791350298.2529 [time] => 0.006195068359375 ) [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] => 1791350298.253 [end] => 1791350298.2593 [time] => 0.0062570571899414 ) [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] => 1791350298.2594 [end] => 1791350298.2656 [time] => 0.0061750411987305 ) [154] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1791350298.2662 [end] => 1791350298.2666 [time] => 0.00030303001403809 ) )