4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
04 Feb 22 Univ. César VallejoUniv. 0 - 0 CiencianoCienciano 174
04 Feb 22 UTC CajamarcaCajamarca 2 - 1 Sport Boys AssociationSport Boys 91
05 Feb 22 Alianza LimaAlianza 1 - 1 Atlético GrauAtlético 363
05 Feb 22 Deportivo MunicipalDeportivo 3 - 2 Ayacucho FCAyacucho 33
05 Feb 22 Sport HuancayoSport 1 - 0 Sporting CristalSporting 81
06 Feb 22 FBC MelgarFBC Melgar 1 - 0 CA ManucciCA Manucci 71
06 Feb 22 Carlos SteinCarlos 0 - 0 ADT de TarmaTarma 35
06 Feb 22 Academia CantolaoAcademia 0 - 3 Universitario de DeportesUniversitar 150
25 Mar 22 Univ. San MartínUniv. 0 - 1 Deportivo BinacionalDeportivo 63
Ver jornada
Jornada 2
12 Feb 22 Universitario de DeportesUniversitar 3 - 0 Univ. San MartínUniv. 182
12 Feb 22 Alianza Atl. SullanaAlianza 1 - 0 UTC CajamarcaCajamarca 33
12 Feb 22 ADT de TarmaTarma 0 - 0 Univ. César VallejoUniv. 65
12 Feb 22 Ayacucho FCAyacucho 2 - 1 Carlos SteinCarlos 55
13 Feb 22 CiencianoCienciano 4 - 2 Deportivo MunicipalDeportivo 46
13 Feb 22 Sporting CristalSporting 2 - 2 FBC MelgarFBC Melgar 180
13 Feb 22 Atlético GrauAtlético 3 - 4 Sport HuancayoSport 77
13 Feb 22 Sport Boys AssociationSport Boys 0 - 0 Alianza LimaAlianza 119
15 Feb 22 Deportivo BinacionalDeportivo 5 - 0 Academia CantolaoAcademia 97
Ver jornada
Jornada 3
21 Feb 22 CiencianoCienciano 0 - 0 ADT de TarmaTarma 179
20 Feb 22 Univ. César VallejoUniv. 2 - 1 Ayacucho FCAyacucho 47
19 Feb 22 Carlos SteinCarlos 2 - 1 Universitario de DeportesUniversitar 158
21 Feb 22 Univ. San MartínUniv. 2 - 0 Sport Boys AssociationSport Boys 65
19 Feb 22 UTC CajamarcaCajamarca 0 - 0 Atlético GrauAtlético 34
20 Feb 22 Academia CantolaoAcademia 1 - 3 Alianza Atl. SullanaAlianza 29
20 Feb 22 Alianza LimaAlianza 3 - 1 CA ManucciCA Manucci 161
20 Feb 22 Sport HuancayoSport 3 - 0 FBC MelgarFBC Melgar 75
19 Feb 22 Deportivo MunicipalDeportivo 1 - 0 Deportivo BinacionalDeportivo 47
Ver jornada
Jornada 4
27 Feb 22 ADT de TarmaTarma 2 - 3 Deportivo MunicipalDeportivo 53
26 Feb 22 Ayacucho FCAyacucho 5 - 0 Univ. San MartínUniv. 37
27 Feb 22 Universitario de DeportesUniversitar 3 - 0 Univ. César VallejoUniv. 61
27 Feb 22 Sport Boys AssociationSport Boys 2 - 1 Carlos SteinCarlos 36
26 Feb 22 Atlético GrauAtlético 1 - 0 Academia CantolaoAcademia 23
27 Feb 22 Alianza Atl. SullanaAlianza 4 - 2 Alianza LimaAlianza 142
26 Feb 22 CA ManucciCA Manucci 0 - 1 Sport HuancayoSport 126
25 Feb 22 Sporting CristalSporting 3 - 2 UTC CajamarcaCajamarca 60
26 Feb 22 Deportivo BinacionalDeportivo 3 - 2 CiencianoCienciano 98
Ver jornada
Jornada 5
04 Mar 22 UTC CajamarcaCajamarca 3 - 1 FBC MelgarFBC Melgar 71
06 Mar 22 Alianza LimaAlianza 0 - 1 Sporting CristalSporting 139
06 Mar 22 Academia CantolaoAcademia 3 - 2 CA ManucciCA Manucci 57
06 Mar 22 Carlos SteinCarlos 0 - 1 Alianza Atl. SullanaAlianza 51
07 Mar 22 Univ. San MartínUniv. 1 - 2 Atlético GrauAtlético 182
06 Mar 22 Univ. César VallejoUniv. 1 - 1 Sport Boys AssociationSport Boys 53
05 Mar 22 Deportivo MunicipalDeportivo 2 - 1 Universitario de DeportesUniversitar 149
05 Mar 22 CiencianoCienciano 3 - 1 Ayacucho FCAyacucho 226
08 Mar 22 Deportivo BinacionalDeportivo 0 - 1 ADT de TarmaTarma 416
Ver jornada
Jornada 6
13 Mar 22 ADT de TarmaTarma 1 - 0 Sport HuancayoSport 72
12 Mar 22 FBC MelgarFBC Melgar 1 - 0 Alianza LimaAlianza 231
13 Mar 22 Sporting CristalSporting 2 - 2 Academia CantolaoAcademia 113
12 Mar 22 CA ManucciCA Manucci 1 - 0 Carlos SteinCarlos 70
12 Mar 22 Alianza Atl. SullanaAlianza 3 - 1 Univ. San MartínUniv. 41
13 Mar 22 Atlético GrauAtlético 1 - 1 Univ. César VallejoUniv. 39
13 Mar 22 Sport Boys AssociationSport Boys 1 - 2 Deportivo MunicipalDeportivo 63
13 Mar 22 Universitario de DeportesUniversitar 1 - 1 CiencianoCienciano 162
13 Mar 22 Ayacucho FCAyacucho 2 - 3 Deportivo BinacionalDeportivo 20
Ver jornada
Jornada 7
20 Mar 22 ADT de TarmaTarma 0 - 0 Ayacucho FCAyacucho 31
21 Mar 22 UTC CajamarcaCajamarca 3 - 4 Sport HuancayoSport 197
20 Mar 22 Academia CantolaoAcademia 0 - 1 FBC MelgarFBC Melgar 40
20 Mar 22 Carlos SteinCarlos 1 - 1 Sporting CristalSporting 142
22 Mar 22 Univ. San MartínUniv. 1 - 3 CA ManucciCA Manucci 71
20 Mar 22 Univ. César VallejoUniv. 3 - 1 Alianza Atl. SullanaAlianza 162
20 Mar 22 Deportivo MunicipalDeportivo 1 - 1 Atlético GrauAtlético 31
19 Mar 22 CiencianoCienciano 4 - 1 Sport Boys AssociationSport Boys 48
21 Mar 22 Deportivo BinacionalDeportivo 1 - 0 Universitario de DeportesUniversitar 113
Ver jornada
Jornada 8
05 Abr 22 Universitario de DeportesUniversitar 2 - 1 ADT de TarmaTarma 368
01 Abr 22 Ayacucho FCAyacucho 3 - 2 UTC CajamarcaCajamarca 171
05 Jun 22 Sport HuancayoSport 2 - 0 Alianza LimaAlianza 197
02 Abr 22 FBC MelgarFBC Melgar 3 - 0 Carlos SteinCarlos 73
01 Abr 22 Sporting CristalSporting 4 - 1 Univ. San MartínUniv. 138
04 Abr 22 CA ManucciCA Manucci 0 - 0 Univ. César VallejoUniv. 127
02 Abr 22 Alianza Atl. SullanaAlianza 2 - 2 Deportivo MunicipalDeportivo 80
03 Abr 22 Atlético GrauAtlético 1 - 2 CiencianoCienciano 89
02 Abr 22 Sport Boys AssociationSport Boys 1 - 3 Deportivo BinacionalDeportivo 66
Ver jornada
Jornada 9
10 Abr 22 ADT de TarmaTarma 3 - 0 Sport Boys AssociationSport Boys 67
10 Abr 22 Ayacucho FCAyacucho 1 - 2 Universitario de DeportesUniversitar 255
10 Abr 22 Alianza LimaAlianza 1 - 0 UTC CajamarcaCajamarca 228
09 Abr 22 Academia CantolaoAcademia 0 - 2 Sport HuancayoSport 161
11 Abr 22 Univ. San MartínUniv. 2 - 0 FBC MelgarFBC Melgar 239
09 Abr 22 Univ. César VallejoUniv. 2 - 0 Sporting CristalSporting 513
09 Abr 22 Deportivo MunicipalDeportivo 1 - 0 CA ManucciCA Manucci 77
10 Abr 22 CiencianoCienciano 5 - 0 Alianza Atl. SullanaAlianza 108
09 Abr 22 Deportivo BinacionalDeportivo 1 - 1 Atlético GrauAtlético 323
Ver jornada
Jornada 10
16 Abr 22 Atlético GrauAtlético 4 - 1 ADT de TarmaTarma 25
17 Abr 22 Sport Boys AssociationSport Boys 1 - 0 Ayacucho FCAyacucho 121
17 Abr 22 Universitario de DeportesUniversitar 1 - 4 Alianza LimaAlianza 268
15 Abr 22 UTC CajamarcaCajamarca 2 - 2 Academia CantolaoAcademia 158
17 Abr 22 Sport HuancayoSport 2 - 1 Carlos SteinCarlos 78
18 Abr 22 FBC MelgarFBC Melgar 1 - 0 Univ. César VallejoUniv. 212
16 Abr 22 Sporting CristalSporting 6 - 4 Deportivo MunicipalDeportivo 147
16 Abr 22 CA ManucciCA Manucci 0 - 2 CiencianoCienciano 107
15 Abr 22 Alianza Atl. SullanaAlianza 2 - 0 Deportivo BinacionalDeportivo 97
Ver jornada
Jornada 11
24 Abr 22 ADT de TarmaTarma 1 - 2 Alianza Atl. SullanaAlianza 114
22 Abr 22 Ayacucho FCAyacucho 1 - 2 Atlético GrauAtlético 211
24 Abr 22 Universitario de DeportesUniversitar 1 - 1 Sport Boys AssociationSport Boys 169
23 Abr 22 Academia CantolaoAcademia 1 - 2 Alianza LimaAlianza 205
24 Abr 22 Carlos SteinCarlos 2 - 0 UTC CajamarcaCajamarca 63
24 Abr 22 Univ. San MartínUniv. 1 - 1 Sport HuancayoSport 89
22 Abr 22 Deportivo MunicipalDeportivo 1 - 3 FBC MelgarFBC Melgar 192
23 Abr 22 CiencianoCienciano 0 - 1 Sporting CristalSporting 516
24 Abr 22 Deportivo BinacionalDeportivo 2 - 1 CA ManucciCA Manucci 94
Ver jornada
Jornada 12
01 May 22 CA ManucciCA Manucci 1 - 1 ADT de TarmaTarma 44
01 May 22 Alianza Atl. SullanaAlianza 2 - 1 Ayacucho FCAyacucho 60
01 May 22 Atlético GrauAtlético 0 - 1 Universitario de DeportesUniversitar 173
02 May 22 Academia CantolaoAcademia 0 - 1 Sport Boys AssociationSport Boys 93
01 May 22 Alianza LimaAlianza 5 - 2 Carlos SteinCarlos 249
02 May 22 UTC CajamarcaCajamarca 3 - 1 Univ. San MartínUniv. 52
02 May 22 Sport HuancayoSport 1 - 1 Univ. César VallejoUniv. 235
30 Abr 22 FBC MelgarFBC Melgar 1 - 0 CiencianoCienciano 211
30 Abr 22 Sporting CristalSporting 1 - 0 Deportivo BinacionalDeportivo 282
Ver jornada
Jornada 13
08 May 22 ADT de TarmaTarma 1 - 1 Sporting CristalSporting 197
08 May 22 Ayacucho FCAyacucho 2 - 2 CA ManucciCA Manucci 75
07 May 22 Universitario de DeportesUniversitar 3 - 1 Alianza Atl. SullanaAlianza 133
07 May 22 Sport Boys AssociationSport Boys 2 - 1 Atlético GrauAtlético 103
08 May 22 Carlos SteinCarlos 2 - 1 Academia CantolaoAcademia 132
09 May 22 Univ. San MartínUniv. 0 - 1 Alianza LimaAlianza 310
08 May 22 Univ. César VallejoUniv. 3 - 1 UTC CajamarcaCajamarca 147
08 May 22 Deportivo MunicipalDeportivo 0 - 1 Sport HuancayoSport 177
09 May 22 Deportivo BinacionalDeportivo 0 - 1 FBC MelgarFBC Melgar 153
Ver jornada
Jornada 14
13 May 22 FBC MelgarFBC Melgar 3 - 0 ADT de TarmaTarma 260
13 May 22 Sporting CristalSporting 3 - 2 Ayacucho FCAyacucho 424
15 May 22 CA ManucciCA Manucci 0 - 0 Universitario de DeportesUniversitar 160
15 May 22 Alianza Atl. SullanaAlianza 1 - 2 Sport Boys AssociationSport Boys 195
16 May 22 Carlos SteinCarlos 1 - 1 Atlético GrauAtlético 118
14 May 22 Academia CantolaoAcademia 2 - 2 Univ. San MartínUniv. 74
15 May 22 Alianza LimaAlianza 2 - 0 Univ. César VallejoUniv. 301
14 May 22 UTC CajamarcaCajamarca 4 - 3 Deportivo MunicipalDeportivo 111
16 May 22 Sport HuancayoSport 3 - 3 CiencianoCienciano 261
Ver jornada
Jornada 15
22 May 22 Ayacucho FCAyacucho 0 - 1 FBC MelgarFBC Melgar 134
22 May 22 Universitario de DeportesUniversitar 1 - 1 Sporting CristalSporting 207
22 May 22 Sport Boys AssociationSport Boys 1 - 4 CA ManucciCA Manucci 105
22 May 22 Atlético GrauAtlético 1 - 2 Alianza Atl. SullanaAlianza 52
21 May 22 Univ. San MartínUniv. 3 - 1 Carlos SteinCarlos 52
21 May 22 Univ. César VallejoUniv. 0 - 1 Academia CantolaoAcademia 332
22 May 22 Deportivo MunicipalDeportivo 0 - 3 Alianza LimaAlianza 109
21 May 22 CiencianoCienciano 3 - 2 UTC CajamarcaCajamarca 112
23 May 22 Deportivo BinacionalDeportivo 1 - 0 Sport HuancayoSport 174
Ver jornada
Jornada 16
28 May 22 Univ. San MartínUniv. 2 - 0 ADT de TarmaTarma 233
29 May 22 FBC MelgarFBC Melgar 2 - 0 Universitario de DeportesUniversitar 393
05 Jun 22 Sporting CristalSporting 3 - 0 Sport Boys AssociationSport Boys 123
29 May 22 CA ManucciCA Manucci 1 - 0 Atlético GrauAtlético 282
30 May 22 Sport HuancayoSport 4 - 1 Alianza Atl. SullanaAlianza 508
29 May 22 Carlos SteinCarlos 1 - 2 Univ. César VallejoUniv. 178
29 May 22 Academia CantolaoAcademia 0 - 2 Deportivo MunicipalDeportivo 237
31 May 22 Alianza LimaAlianza 1 - 0 CiencianoCienciano 623
31 May 22 UTC CajamarcaCajamarca 2 - 0 Deportivo BinacionalDeportivo 439
Ver jornada
Jornada 17
19 Jun 22 ADT de TarmaTarma 1 - 2 UTC CajamarcaCajamarca 65
20 Jun 22 Ayacucho FCAyacucho 1 - 1 Sport HuancayoSport 418
19 Jun 22 Sport Boys AssociationSport Boys 0 - 1 FBC MelgarFBC Melgar 164
19 Jun 22 Atlético GrauAtlético 0 - 2 Sporting CristalSporting 115
19 Jun 22 Alianza Atl. SullanaAlianza 0 - 0 CA ManucciCA Manucci 158
19 Jun 22 Univ. César VallejoUniv. 2 - 0 Univ. San MartínUniv. 111
18 Jun 22 Deportivo MunicipalDeportivo 1 - 1 Carlos SteinCarlos 366
18 Jun 22 CiencianoCienciano 1 - 0 Academia CantolaoAcademia 123
19 Jun 22 Deportivo BinacionalDeportivo 1 - 0 Alianza LimaAlianza 171
Ver jornada
Jornada 18
26 Jun 22 Academia CantolaoAcademia 3 - 0 ADT de TarmaTarma 84
27 Jun 22 Alianza LimaAlianza 2 - 0 Ayacucho FCAyacucho 253
24 Jun 22 UTC CajamarcaCajamarca 1 - 2 CA ManucciCA Manucci 311
26 Jun 22 Carlos SteinCarlos 2 - 2 CiencianoCienciano 340
26 Jun 22 Univ. César VallejoUniv. 4 - 0 Deportivo BinacionalDeportivo 92
25 Jun 22 FBC MelgarFBC Melgar 1 - 0 Atlético GrauAtlético 256
26 Jun 22 Sport HuancayoSport 2 - 0 Universitario de DeportesUniversitar 224
25 Jun 22 Sporting CristalSporting 1 - 0 Alianza Atl. SullanaAlianza 193
27 Jun 22 Univ. San MartínUniv. 1 - 1 Deportivo MunicipalDeportivo 282
Ver jornada
Jornada 19
03 Jul 22 ADT de TarmaTarma 1 - 1 Alianza LimaAlianza 221
03 Jul 22 Alianza Atl. SullanaAlianza 0 - 0 FBC MelgarFBC Melgar 287
01 Jul 22 Ayacucho FCAyacucho 1 - 2 Academia CantolaoAcademia 234
03 Jul 22 Deportivo BinacionalDeportivo 3 - 0 Carlos SteinCarlos 70
03 Jul 22 CA ManucciCA Manucci 1 - 3 Sporting CristalSporting 303
02 Jul 22 CiencianoCienciano 5 - 3 Univ. San MartínUniv. 433
02 Jul 22 Deportivo MunicipalDeportivo 1 - 4 Univ. César VallejoUniv. 204
03 Jul 22 Sport Boys AssociationSport Boys 2 - 3 Sport HuancayoSport 179
04 Jul 22 Universitario de DeportesUniversitar 1 - 0 UTC CajamarcaCajamarca 158

Clasificación

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

  USO DE MEMORIA  
6,372,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3597
Total Execution Time  0.3616
  CADENA URL  
/apertura_peru2022/grupo1/calendario
  GET DATOS  
$_GET['/apertura_peru2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0131  SELECT type FROM routes WHERE alias = 'apertura_peru2022'
0.0266  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0132  SELECT id,name,alias,stepParent FROM categories WHERE parentId=45 ORDER BY order_id ASC
0.0138  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 = 66203 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0170  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 66203 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 10:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 10:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 10:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 10:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0215  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 events2022 e ON e.player_id = p.id AND e.league_id = 66203 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66203 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.0251  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 events2022 e ON e.player_id = p.id AND e.league_id = 66203 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66203 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  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 events2022 e ON e.player_id = p.id AND e.league_id = 66203 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66203 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66203 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