4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
27 Mar 23 UTC CajamarcaCajamarca 0 - 0 Cusco FCCusco FC 186
27 Mar 23 Deportivo GarcilasoDeportivo 1 - 2 CA ManucciCA Manucci 232
26 Mar 23 Univ. César VallejoUniv. 0 - 2 Sport HuancayoSport 203
26 Mar 23 Atlético GrauAtlético 1 - 2 Alianza LimaAlianza 468
25 Mar 23 Universitario de DeportesUniversitar 3 - 0 CiencianoCienciano 285
26 Mar 23 Deportivo MunicipalDeportivo 2 - 0 Unión ComercioUnión 75
26 Mar 23 ADT de TarmaTarma 0 - 0 FBC MelgarFBC Melgar 206
26 Mar 23 Sport Boys AssociationSport Boys 0 - 1 Alianza Atl. SullanaAlianza 197
25 Mar 23 Sporting CristalSporting 2 - 0 Academia CantolaoAcademia 217
Ver jornada
Jornada 2
14 May 23 CA ManucciCA Manucci 1 - 0 Atlético GrauAtlético 89
16 May 23 Academia CantolaoAcademia 0 - 0 Sport Boys AssociationSport Boys 332
14 May 23 Alianza Atl. SullanaAlianza 3 - 1 Universitario de DeportesUniversitar 498
12 May 23 Sport HuancayoSport 5 - 1 UTC CajamarcaCajamarca 30
15 May 23 FBC MelgarFBC Melgar 2 - 4 Deportivo GarcilasoDeportivo 331
13 May 23 Unión ComercioUnión 1 - 6 Sporting CristalSporting 82
16 May 23 Alianza LimaAlianza 2 - 1 Deportivo MunicipalDeportivo 655
14 May 23 CiencianoCienciano 1 - 1 Univ. César VallejoUniv. 110
13 May 23 Deportivo BinacionalDeportivo 1 - 0 ADT de TarmaTarma 198
Ver jornada
Jornada 3
03 Feb 23 Cusco FCCusco FC 0 - 3 Sport HuancayoSport 75
04 Feb 23 UTC CajamarcaCajamarca 3 - 0 CiencianoCienciano 44
05 Feb 23 Deportivo GarcilasoDeportivo 3 - 0 Deportivo BinacionalDeportivo 34
06 Feb 23 Univ. César VallejoUniv. 2 - 2 Alianza Atl. SullanaAlianza 193
04 Feb 23 Atlético GrauAtlético 3 - 0 FBC MelgarFBC Melgar 69
04 Feb 23 Universitario de DeportesUniversitar 4 - 0 Academia CantolaoAcademia 143
07 Feb 23 Deportivo MunicipalDeportivo 0 - 3 CA ManucciCA Manucci 58
06 Feb 23 Sport Boys AssociationSport Boys 2 - 1 Unión ComercioUnión 216
05 Feb 23 Sporting CristalSporting 3 - 0 Alianza LimaAlianza 75
Ver jornada
Jornada 4
12 Feb 23 CA ManucciCA Manucci 1 - 1 Sporting CristalSporting 190
11 Feb 23 Academia CantolaoAcademia 1 - 2 Univ. César VallejoUniv. 68
12 Feb 23 Alianza Atl. SullanaAlianza 2 - 0 UTC CajamarcaCajamarca 73
13 Feb 23 FBC MelgarFBC Melgar 0 - 2 Deportivo MunicipalDeportivo 202
12 Feb 23 Unión ComercioUnión 1 - 0 Universitario de DeportesUniversitar 321
11 Feb 23 ADT de TarmaTarma 1 - 2 Deportivo GarcilasoDeportivo 68
12 Feb 23 Alianza LimaAlianza 2 - 0 Sport Boys AssociationSport Boys 211
11 Feb 23 CiencianoCienciano 2 - 0 Cusco FCCusco FC 117
11 Feb 23 Deportivo BinacionalDeportivo 2 - 4 Atlético GrauAtlético 95
Ver jornada
Jornada 5
20 Feb 23 Cusco FCCusco FC 2 - 1 Alianza Atl. SullanaAlianza 210
22 Feb 23 UTC CajamarcaCajamarca 1 - 0 Academia CantolaoAcademia 78
18 Feb 23 Univ. César VallejoUniv. 3 - 1 Unión ComercioUnión 352
19 Feb 23 Atlético GrauAtlético 1 - 1 ADT de TarmaTarma 250
19 Feb 23 Universitario de DeportesUniversitar 1 - 2 Alianza LimaAlianza 406
20 Feb 23 Deportivo MunicipalDeportivo 2 - 0 Deportivo BinacionalDeportivo 139
18 Feb 23 Sport HuancayoSport 1 - 3 CiencianoCienciano 40
18 Feb 23 Sport Boys AssociationSport Boys 0 - 1 CA ManucciCA Manucci 52
17 Feb 23 Sporting CristalSporting 1 - 0 FBC MelgarFBC Melgar 170
Ver jornada
Jornada 6
27 Feb 23 CA ManucciCA Manucci 2 - 0 Universitario de DeportesUniversitar 194
27 Feb 23 Academia CantolaoAcademia 2 - 3 Cusco FCCusco FC 159
25 Feb 23 Deportivo GarcilasoDeportivo 2 - 0 Atlético GrauAtlético 35
25 Feb 23 Alianza Atl. SullanaAlianza 4 - 2 Sport HuancayoSport 26
12 May 23 FBC MelgarFBC Melgar 2 - 0 Sport Boys AssociationSport Boys 122
26 Feb 23 Unión ComercioUnión 1 - 0 UTC CajamarcaCajamarca 52
26 Feb 23 ADT de TarmaTarma 3 - 0 Deportivo MunicipalDeportivo 30
12 May 23 Alianza LimaAlianza 2 - 0 Univ. César VallejoUniv. 586
18 May 23 Deportivo BinacionalDeportivo 0 - 1 Sporting CristalSporting 321
Ver jornada
Jornada 7
06 Mar 23 Cusco FCCusco FC 2 - 1 Unión ComercioUnión 127
05 Mar 23 UTC CajamarcaCajamarca 0 - 1 Alianza LimaAlianza 113
05 Mar 23 Univ. César VallejoUniv. 2 - 0 CA ManucciCA Manucci 110
05 Mar 23 Universitario de DeportesUniversitar 1 - 0 FBC MelgarFBC Melgar 105
06 Mar 23 Deportivo MunicipalDeportivo 0 - 3 Deportivo GarcilasoDeportivo 79
04 Mar 23 Sport HuancayoSport 4 - 0 Academia CantolaoAcademia 20
10 May 23 CiencianoCienciano 5 - 2 Alianza Atl. SullanaAlianza 230
03 Mar 23 Sport Boys AssociationSport Boys 2 - 2 Deportivo BinacionalDeportivo 119
04 Mar 23 Sporting CristalSporting 0 - 0 ADT de TarmaTarma 460
Ver jornada
Jornada 8
17 May 23 CA ManucciCA Manucci 0 - 1 UTC CajamarcaCajamarca 195
12 Mar 23 Academia CantolaoAcademia 1 - 0 CiencianoCienciano 50
13 Mar 23 Deportivo GarcilasoDeportivo 4 - 4 Sporting CristalSporting 417
12 Mar 23 Atlético GrauAtlético 1 - 1 Deportivo MunicipalDeportivo 167
01 Jun 23 FBC MelgarFBC Melgar 2 - 2 Univ. César VallejoUniv. 283
12 Mar 23 Unión ComercioUnión 2 - 0 Sport HuancayoSport 61
10 Mar 23 ADT de TarmaTarma 1 - 0 Sport Boys AssociationSport Boys 70
12 Mar 23 Alianza LimaAlianza 2 - 0 Cusco FCCusco FC 235
14 Mar 23 Deportivo BinacionalDeportivo 1 - 2 Universitario de DeportesUniversitar 328
Ver jornada
Jornada 9
20 Mar 23 Cusco FCCusco FC 3 - 0 CA ManucciCA Manucci 165
18 Mar 23 UTC CajamarcaCajamarca 0 - 0 FBC MelgarFBC Melgar 121
19 Mar 23 Univ. César VallejoUniv. 2 - 0 Deportivo BinacionalDeportivo 26
18 Mar 23 Alianza Atl. SullanaAlianza 2 - 1 Academia CantolaoAcademia 173
19 Mar 23 Universitario de DeportesUniversitar 3 - 1 ADT de TarmaTarma 266
20 Mar 23 Sport HuancayoSport 2 - 1 Alianza LimaAlianza 377
19 Mar 23 CiencianoCienciano 3 - 1 Unión ComercioUnión 58
17 Mar 23 Sport Boys AssociationSport Boys 2 - 1 Deportivo GarcilasoDeportivo 260
19 Mar 23 Sporting CristalSporting 2 - 1 Atlético GrauAtlético 220
Ver jornada
Jornada 10
02 Abr 23 CA ManucciCA Manucci 0 - 0 Sport HuancayoSport 74
01 Abr 23 Deportivo GarcilasoDeportivo 0 - 0 Universitario de DeportesUniversitar 318
02 Abr 23 Atlético GrauAtlético 3 - 0 Sport Boys AssociationSport Boys 30
31 Mar 23 Deportivo MunicipalDeportivo 1 - 1 Sporting CristalSporting 193
01 Abr 23 FBC MelgarFBC Melgar 1 - 1 Cusco FCCusco FC 225
02 Abr 23 Unión ComercioUnión 3 - 3 Alianza Atl. SullanaAlianza 151
31 Mar 23 ADT de TarmaTarma 2 - 0 Univ. César VallejoUniv. 52
02 Abr 23 Alianza LimaAlianza 2 - 0 CiencianoCienciano 269
03 Abr 23 Deportivo BinacionalDeportivo 1 - 1 UTC CajamarcaCajamarca 99
Ver jornada
Jornada 11
07 Abr 23 Cusco FCCusco FC 2 - 1 Deportivo BinacionalDeportivo 69
10 Abr 23 Academia CantolaoAcademia 1 - 2 Unión ComercioUnión 84
08 Abr 23 UTC CajamarcaCajamarca 1 - 0 ADT de TarmaTarma 69
11 Abr 23 Univ. César VallejoUniv. 3 - 0 Deportivo GarcilasoDeportivo 113
09 Abr 23 Alianza Atl. SullanaAlianza 0 - 1 Alianza LimaAlianza 273
10 Abr 23 Universitario de DeportesUniversitar 2 - 1 Atlético GrauAtlético 359
09 Abr 23 Sport HuancayoSport 1 - 1 FBC MelgarFBC Melgar 155
09 Abr 23 CiencianoCienciano 1 - 0 CA ManucciCA Manucci 96
08 Abr 23 Sport Boys AssociationSport Boys 0 - 2 Deportivo MunicipalDeportivo 56
Ver jornada
Jornada 12
17 Abr 23 CA ManucciCA Manucci 1 - 0 Alianza Atl. SullanaAlianza 64
16 Abr 23 Deportivo GarcilasoDeportivo 2 - 2 UTC CajamarcaCajamarca 48
15 Abr 23 Atlético GrauAtlético 1 - 1 Univ. César VallejoUniv. 94
16 Abr 23 Deportivo MunicipalDeportivo 1 - 2 Universitario de DeportesUniversitar 234
15 Abr 23 FBC MelgarFBC Melgar 1 - 0 CiencianoCienciano 180
16 Abr 23 ADT de TarmaTarma 0 - 2 Cusco FCCusco FC 32
16 Abr 23 Alianza LimaAlianza 3 - 0 Academia CantolaoAcademia 162
17 Abr 23 Deportivo BinacionalDeportivo 5 - 3 Sport HuancayoSport 136
14 Abr 23 Sporting CristalSporting 1 - 1 Sport Boys AssociationSport Boys 761
Ver jornada
Jornada 13
23 Abr 23 Cusco FCCusco FC 2 - 1 Deportivo GarcilasoDeportivo 197
22 Abr 23 Academia CantolaoAcademia 0 - 2 CA ManucciCA Manucci 36
21 Abr 23 UTC CajamarcaCajamarca 1 - 1 Atlético GrauAtlético 268
25 Abr 23 Univ. César VallejoUniv. 1 - 1 Deportivo MunicipalDeportivo 266
24 Abr 23 Alianza Atl. SullanaAlianza 3 - 3 FBC MelgarFBC Melgar 258
25 Abr 23 Universitario de DeportesUniversitar 2 - 0 Sporting CristalSporting 561
22 Abr 23 Sport HuancayoSport 1 - 3 ADT de TarmaTarma 183
23 Abr 23 Unión ComercioUnión 1 - 3 Alianza LimaAlianza 155
23 Abr 23 CiencianoCienciano 1 - 1 Deportivo BinacionalDeportivo 126
Ver jornada
Jornada 14
01 May 23 CA ManucciCA Manucci 2 - 0 Unión ComercioUnión 256
29 Abr 23 Deportivo GarcilasoDeportivo 1 - 1 Sport HuancayoSport 67
29 Abr 23 Atlético GrauAtlético 3 - 0 Cusco FCCusco FC 90
30 Abr 23 Deportivo MunicipalDeportivo 2 - 0 UTC CajamarcaCajamarca 84
30 Abr 23 FBC MelgarFBC Melgar 5 - 0 Academia CantolaoAcademia 115
30 Abr 23 ADT de TarmaTarma 3 - 4 CiencianoCienciano 86
29 Abr 23 Sport Boys AssociationSport Boys 0 - 3 Universitario de DeportesUniversitar 260
30 Abr 23 Deportivo BinacionalDeportivo 4 - 2 Alianza Atl. SullanaAlianza 51
28 Abr 23 Sporting CristalSporting 1 - 1 Univ. César VallejoUniv. 311
Ver jornada
Jornada 15
05 May 23 Cusco FCCusco FC 1 - 0 Deportivo MunicipalDeportivo 220
05 May 23 Academia CantolaoAcademia 1 - 0 Deportivo BinacionalDeportivo 138
07 May 23 UTC CajamarcaCajamarca 1 - 1 Sporting CristalSporting 359
08 May 23 Univ. César VallejoUniv. 2 - 0 Sport Boys AssociationSport Boys 86
06 May 23 Alianza Atl. SullanaAlianza 1 - 1 ADT de TarmaTarma 113
06 May 23 Sport HuancayoSport 1 - 0 Atlético GrauAtlético 151
08 May 23 Unión ComercioUnión 1 - 1 FBC MelgarFBC Melgar 157
08 May 23 Alianza LimaAlianza 3 - 0 CA ManucciCA Manucci 389
07 May 23 CiencianoCienciano 0 - 0 Deportivo GarcilasoDeportivo 157
Ver jornada
Jornada 16
21 May 23 Deportivo GarcilasoDeportivo 3 - 2 Alianza Atl. SullanaAlianza 47
21 May 23 Atlético GrauAtlético 4 - 0 CiencianoCienciano 40
20 May 23 Universitario de DeportesUniversitar 4 - 0 Univ. César VallejoUniv. 170
21 May 23 Deportivo MunicipalDeportivo 1 - 2 Sport HuancayoSport 41
20 May 23 FBC MelgarFBC Melgar 2 - 1 Alianza LimaAlianza 899
20 May 23 ADT de TarmaTarma 1 - 1 Academia CantolaoAcademia 53
22 May 23 Sport Boys AssociationSport Boys 3 - 2 UTC CajamarcaCajamarca 145
23 May 23 Deportivo BinacionalDeportivo 5 - 0 Unión ComercioUnión 94
21 May 23 Sporting CristalSporting 3 - 2 Cusco FCCusco FC 335
Ver jornada
Jornada 17
29 May 23 CA ManucciCA Manucci 1 - 2 FBC MelgarFBC Melgar 316
27 May 23 Cusco FCCusco FC 2 - 1 Sport Boys AssociationSport Boys 116
26 May 23 Academia CantolaoAcademia 1 - 1 Deportivo GarcilasoDeportivo 235
28 May 23 UTC CajamarcaCajamarca 1 - 0 Universitario de DeportesUniversitar 365
27 May 23 Alianza Atl. SullanaAlianza 3 - 2 Atlético GrauAtlético 57
29 May 23 Sport HuancayoSport 1 - 2 Sporting CristalSporting 192
28 May 23 Unión ComercioUnión 4 - 3 ADT de TarmaTarma 104
29 May 23 Alianza LimaAlianza 6 - 1 Deportivo BinacionalDeportivo 295
27 May 23 CiencianoCienciano 1 - 0 Deportivo MunicipalDeportivo 232
Ver jornada
Jornada 18
04 Jun 23 Deportivo GarcilasoDeportivo 2 - 2 Unión ComercioUnión 200
05 Jun 23 Univ. César VallejoUniv. 3 - 1 UTC CajamarcaCajamarca 228
04 Jun 23 Atlético GrauAtlético 3 - 0 Academia CantolaoAcademia 14
03 Jun 23 Universitario de DeportesUniversitar 1 - 0 Cusco FCCusco FC 560
03 Jun 23 Deportivo MunicipalDeportivo 2 - 1 Alianza Atl. SullanaAlianza 23
03 Jun 23 ADT de TarmaTarma 2 - 1 Alianza LimaAlianza 399
04 Jun 23 Sport Boys AssociationSport Boys 1 - 0 Sport HuancayoSport 119
04 Jun 23 Deportivo BinacionalDeportivo 3 - 0 CA ManucciCA Manucci 33
02 Jun 23 Sporting CristalSporting 4 - 2 CiencianoCienciano 282
Ver jornada
Jornada 19
11 Jun 23 CA ManucciCA Manucci 1 - 1 ADT de TarmaTarma 148
11 Jun 23 Cusco FCCusco FC 2 - 0 Univ. César VallejoUniv. 102
10 Jun 23 Academia CantolaoAcademia 0 - 1 Deportivo MunicipalDeportivo 42
11 Jun 23 Alianza Atl. SullanaAlianza 0 - 0 Sporting CristalSporting 367
12 Jun 23 Sport HuancayoSport 1 - 0 Universitario de DeportesUniversitar 111
11 Jun 23 FBC MelgarFBC Melgar 2 - 1 Deportivo BinacionalDeportivo 135
10 Jun 23 Unión ComercioUnión 2 - 2 Atlético GrauAtlético 131
11 Jun 23 Alianza LimaAlianza 3 - 2 Deportivo GarcilasoDeportivo 239
10 Jun 23 CiencianoCienciano 0 - 1 Sport Boys AssociationSport Boys 526

Clasificación

Equipo PJ GF GC Puntos
1 Alianza Lima Alianza Lima 18 37 16 42
2 Sporting Cristal Sporting 18 33 18 35
3 Universitario de Deportes Universitari 18 29 14 34
4 Cusco FC Cusco FC 18 24 22 32
5 Sport Huancayo Sport 18 30 25 27
6 Univ. César Vallejo Univ. César 18 25 23 27
7 CA Manucci CA Manucci 18 17 18 27
8 Deportivo Garcilaso Deportivo 18 32 27 25
9 FBC Melgar FBC Melgar 18 24 22 25
10 Deportivo Municipal Deportivo 18 19 21 24
11 Cienciano Cienciano 18 23 28 24
12 Atlético Grau Atlético 18 31 21 23
13 Alianza Atl. Sullana Alianza Atl. 18 32 33 23
14 ADT de Tarma Tarma 18 23 23 21
15 UTC Cajamarca Cajamarca 18 16 22 21
16 Unión Comercio Unión 18 24 40 19
17 Deportivo Binacional Deportivo 18 28 34 18
18 Sport Boys Association Sport Boys. 18 13 26 18
19 Academia Cantolao Academia 18 9 36 9

  USO DE MEMORIA  
6,372,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3351
Total Execution Time  0.3371
  CADENA URL  
/apertura_peru2023/grupo1/calendario
  GET DATOS  
$_GET['/apertura_peru2023/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0105  SELECT type FROM routes WHERE alias = 'apertura_peru2023'
0.0215  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_peru' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=45 AND type_rel = 3
0.0114  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 45 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1308316,1302164,1264407,1261212,1258591) ORDER BY n.cover_points DESC, update_date DESC
0.0107  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 70808 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 70808 ORDER BY round ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 18:29:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 18:29:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 18:29:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 18:29:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_peru' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0171  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70808 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70808 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0248  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70808 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70808 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0119  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70808 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70808 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0120  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 70808 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC