4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
10 Ago 98 Unión Santa FeUnión 3 - 2 Gimnasia La PlataGimnasia ...
10 Ago 98 Argentinos JuniorsArgentinos 2 - 2 Gimnasia JujuyGimnasia ...
10 Ago 98 IndependienteIndependien 4 - 2 BelgranoBelgrano ...
10 Ago 98 River PlateRiver Plate 1 - 1 Vélez SarsfieldVélez ...
10 Ago 98 LanúsLanús 3 - 1 CA HuracánHuracán ...
10 Ago 98 Ferro Carril OesteFerro 2 - 4 Boca JuniorsBoca ...
10 Ago 98 Rosario CentralRosario 1 - 1 Newell's Old BoysNewell's ...
10 Ago 98 San LorenzoLorenzo 2 - 2 PlatensePlatense ...
10 Ago 98 Estudiantes La PlataEstudiantes 2 - 0 ColónColón ...
10 Ago 98 Talleres CórdobaTalleres 2 - 4 Racing ClubRacing Club ...
Jornada 2
17 Ago 98 BelgranoBelgrano 0 - 1 LanúsLanús ...
17 Ago 98 CA HuracánHuracán 1 - 1 Unión Santa FeUnión ...
17 Ago 98 Boca JuniorsBoca 3 - 2 Gimnasia JujuyGimnasia ...
17 Ago 98 Newell's Old BoysNewell's 2 - 1 IndependienteIndependien ...
17 Ago 98 Gimnasia La PlataGimnasia 2 - 1 Ferro Carril OesteFerro ...
17 Ago 98 ColónColón 2 - 0 San LorenzoLorenzo ...
17 Ago 98 Racing ClubRacing Club 3 - 5 Rosario CentralRosario ...
17 Ago 98 Vélez SarsfieldVélez 2 - 0 Estudiantes La PlataEstudiantes ...
17 Ago 98 Argentinos JuniorsArgentinos 0 - 1 River PlateRiver Plate ...
17 Ago 98 PlatensePlatense 1 - 0 Talleres CórdobaTalleres ...
Jornada 3
24 Ago 98 LanúsLanús 0 - 1 Newell's Old BoysNewell's ...
24 Ago 98 Unión Santa FeUnión 3 - 0 BelgranoBelgrano ...
24 Ago 98 Gimnasia JujuyGimnasia 1 - 2 Gimnasia La PlataGimnasia ...
24 Ago 98 IndependienteIndependien 1 - 3 Racing ClubRacing Club ...
24 Ago 98 Ferro Carril OesteFerro 1 - 3 CA HuracánHuracán ...
24 Ago 98 Boca JuniorsBoca 2 - 2 Argentinos JuniorsArgentinos ...
24 Ago 98 Rosario CentralRosario 2 - 0 PlatensePlatense ...
24 Ago 98 Estudiantes La PlataEstudiantes 1 - 0 River PlateRiver Plate ...
24 Ago 98 San LorenzoLorenzo 0 - 0 Vélez SarsfieldVélez ...
24 Ago 98 Talleres CórdobaTalleres 2 - 1 ColónColón ...
Jornada 4
31 Ago 98 Racing ClubRacing Club 2 - 2 LanúsLanús ...
31 Ago 98 Newell's Old BoysNewell's 0 - 0 Unión Santa FeUnión ...
31 Ago 98 CA HuracánHuracán 3 - 2 Gimnasia JujuyGimnasia ...
31 Ago 98 PlatensePlatense 1 - 4 IndependienteIndependien ...
31 Ago 98 BelgranoBelgrano 1 - 0 Ferro Carril OesteFerro ...
31 Ago 98 ColónColón 4 - 0 Rosario CentralRosario ...
31 Ago 98 Vélez SarsfieldVélez 3 - 0 Talleres CórdobaTalleres ...
31 Ago 98 Argentinos JuniorsArgentinos 0 - 0 Estudiantes La PlataEstudiantes ...
31 Ago 98 River PlateRiver Plate 3 - 4 San LorenzoLorenzo ...
31 Ago 98 Gimnasia La PlataGimnasia 0 - 0 Boca JuniorsBoca ...
Jornada 5
07 Sep 98 LanúsLanús 1 - 0 PlatensePlatense ...
07 Sep 98 Ferro Carril OesteFerro 1 - 1 Newell's Old BoysNewell's ...
07 Sep 98 Gimnasia JujuyGimnasia 2 - 2 BelgranoBelgrano ...
07 Sep 98 IndependienteIndependien 0 - 0 ColónColón ...
07 Sep 98 Unión Santa FeUnión 1 - 0 Racing ClubRacing Club ...
07 Sep 98 Rosario CentralRosario 1 - 2 Vélez SarsfieldVélez ...
07 Sep 98 Boca JuniorsBoca 6 - 2 CA HuracánHuracán ...
07 Sep 98 San LorenzoLorenzo 0 - 0 Estudiantes La PlataEstudiantes ...
07 Sep 98 Talleres CórdobaTalleres 3 - 1 River PlateRiver Plate ...
07 Sep 98 Gimnasia La PlataGimnasia 1 - 1 Argentinos JuniorsArgentinos ...
Jornada 6
14 Sep 98 ColónColón 0 - 0 LanúsLanús ...
14 Sep 98 PlatensePlatense 2 - 5 Unión Santa FeUnión ...
14 Sep 98 Newell's Old BoysNewell's 0 - 0 Gimnasia JujuyGimnasia ...
14 Sep 98 Vélez SarsfieldVélez 1 - 1 IndependienteIndependien ...
14 Sep 98 Racing ClubRacing Club 1 - 0 Ferro Carril OesteFerro ...
14 Sep 98 CA HuracánHuracán 1 - 2 Gimnasia La PlataGimnasia ...
14 Sep 98 River PlateRiver Plate 1 - 1 Rosario CentralRosario ...
14 Sep 98 Argentinos JuniorsArgentinos 1 - 5 San LorenzoLorenzo ...
14 Sep 98 Estudiantes La PlataEstudiantes 2 - 0 Talleres CórdobaTalleres ...
14 Sep 98 BelgranoBelgrano 2 - 4 Boca JuniorsBoca ...
Jornada 7
21 Sep 98 LanúsLanús 0 - 2 Vélez SarsfieldVélez ...
21 Sep 98 Unión Santa FeUnión 0 - 2 ColónColón ...
21 Sep 98 Ferro Carril OesteFerro 1 - 1 PlatensePlatense ...
21 Sep 98 CA HuracánHuracán 1 - 3 Argentinos JuniorsArgentinos ...
21 Sep 98 Gimnasia JujuyGimnasia 1 - 1 Racing ClubRacing Club ...
21 Sep 98 Gimnasia La PlataGimnasia 3 - 1 BelgranoBelgrano ...
21 Sep 98 Rosario CentralRosario 2 - 1 Estudiantes La PlataEstudiantes ...
21 Sep 98 IndependienteIndependien 2 - 1 River PlateRiver Plate ...
21 Sep 98 Talleres CórdobaTalleres 2 - 2 San LorenzoLorenzo ...
21 Sep 98 Boca JuniorsBoca 2 - 0 Newell's Old BoysNewell's ...
Jornada 8
28 Sep 98 BelgranoBelgrano 1 - 1 CA HuracánHuracán ...
28 Sep 98 Vélez SarsfieldVélez 2 - 2 Unión Santa FeUnión ...
28 Sep 98 ColónColón 3 - 1 Ferro Carril OesteFerro ...
28 Sep 98 Newell's Old BoysNewell's 0 - 0 Gimnasia La PlataGimnasia ...
28 Sep 98 PlatensePlatense 1 - 3 Gimnasia JujuyGimnasia ...
28 Sep 98 Racing ClubRacing Club 1 - 1 Boca JuniorsBoca ...
28 Sep 98 Estudiantes La PlataEstudiantes 4 - 1 IndependienteIndependien ...
28 Sep 98 River PlateRiver Plate 0 - 1 LanúsLanús ...
28 Sep 98 San LorenzoLorenzo 4 - 1 Rosario CentralRosario ...
28 Sep 98 Argentinos JuniorsArgentinos 2 - 0 Talleres CórdobaTalleres ...
Jornada 9
05 Oct 98 BelgranoBelgrano 2 - 2 Argentinos JuniorsArgentinos ...
05 Oct 98 CA HuracánHuracán 3 - 2 Newell's Old BoysNewell's ...
05 Oct 98 Ferro Carril OesteFerro 2 - 1 Vélez SarsfieldVélez ...
05 Oct 98 Gimnasia La PlataGimnasia 0 - 2 Racing ClubRacing Club ...
05 Oct 98 Gimnasia JujuyGimnasia 3 - 3 ColónColón ...
05 Oct 98 Boca JuniorsBoca 3 - 0 PlatensePlatense ...
05 Oct 98 Rosario CentralRosario 1 - 1 Talleres CórdobaTalleres ...
05 Oct 98 Unión Santa FeUnión 1 - 1 River PlateRiver Plate ...
05 Oct 98 LanúsLanús 2 - 1 Estudiantes La PlataEstudiantes ...
05 Oct 98 IndependienteIndependien 3 - 1 San LorenzoLorenzo ...
Jornada 10
12 Oct 98 ColónColón 0 - 3 Boca JuniorsBoca ...
12 Oct 98 PlatensePlatense 0 - 1 Gimnasia La PlataGimnasia ...
12 Oct 98 Vélez SarsfieldVélez 1 - 1 Gimnasia JujuyGimnasia ...
12 Oct 98 Newell's Old BoysNewell's 0 - 2 BelgranoBelgrano ...
12 Oct 98 Racing ClubRacing Club 2 - 1 CA HuracánHuracán ...
12 Oct 98 Argentinos JuniorsArgentinos 3 - 0 Rosario CentralRosario ...
12 Oct 98 Talleres CórdobaTalleres 1 - 0 IndependienteIndependien ...
12 Oct 98 Estudiantes La PlataEstudiantes 1 - 1 Unión Santa FeUnión ...
12 Oct 98 River PlateRiver Plate 4 - 1 Ferro Carril OesteFerro ...
12 Oct 98 San LorenzoLorenzo 1 - 1 LanúsLanús ...
Jornada 11
23 Oct 98 CA HuracánHuracán 2 - 1 PlatensePlatense ...
23 Oct 98 BelgranoBelgrano 3 - 2 Racing ClubRacing Club ...
23 Oct 98 Newell's Old BoysNewell's 0 - 0 Argentinos JuniorsArgentinos ...
23 Oct 98 Gimnasia La PlataGimnasia 4 - 2 ColónColón ...
23 Oct 98 Boca JuniorsBoca 2 - 0 Vélez SarsfieldVélez ...
23 Oct 98 Gimnasia JujuyGimnasia 2 - 2 River PlateRiver Plate ...
23 Oct 98 Unión Santa FeUnión 3 - 6 San LorenzoLorenzo ...
23 Oct 98 Ferro Carril OesteFerro 1 - 0 Estudiantes La PlataEstudiantes ...
23 Oct 98 LanúsLanús 1 - 4 Talleres CórdobaTalleres ...
23 Oct 98 IndependienteIndependien 1 - 1 Rosario CentralRosario ...
Jornada 12
26 Oct 98 Vélez SarsfieldVélez 0 - 1 Gimnasia La PlataGimnasia ...
26 Oct 98 ColónColón 2 - 0 CA HuracánHuracán ...
26 Oct 98 Racing ClubRacing Club 2 - 1 Newell's Old BoysNewell's ...
26 Oct 98 Argentinos JuniorsArgentinos 1 - 1 IndependienteIndependien ...
26 Oct 98 PlatensePlatense 1 - 1 BelgranoBelgrano ...
26 Oct 98 River PlateRiver Plate 0 - 0 Boca JuniorsBoca ...
26 Oct 98 Rosario CentralRosario 2 - 0 LanúsLanús ...
26 Oct 98 Estudiantes La PlataEstudiantes 1 - 1 Gimnasia JujuyGimnasia ...
26 Oct 98 San LorenzoLorenzo 2 - 1 Ferro Carril OesteFerro ...
26 Oct 98 Talleres CórdobaTalleres 1 - 1 Unión Santa FeUnión ...
Jornada 13
02 Nov 98 Racing ClubRacing Club 3 - 3 Argentinos JuniorsArgentinos ...
02 Nov 98 CA HuracánHuracán 1 - 1 Vélez SarsfieldVélez ...
02 Nov 98 LanúsLanús 2 - 2 IndependienteIndependien ...
02 Nov 98 Newell's Old BoysNewell's 2 - 1 PlatensePlatense ...
02 Nov 98 BelgranoBelgrano 1 - 1 ColónColón ...
02 Nov 98 Gimnasia La PlataGimnasia 3 - 2 River PlateRiver Plate ...
02 Nov 98 Unión Santa FeUnión 2 - 4 Rosario CentralRosario ...
02 Nov 98 Gimnasia JujuyGimnasia 3 - 2 San LorenzoLorenzo ...
02 Nov 98 Boca JuniorsBoca 3 - 0 Estudiantes La PlataEstudiantes ...
02 Nov 98 Ferro Carril OesteFerro 3 - 0 Talleres CórdobaTalleres ...
Jornada 14
09 Nov 98 Argentinos JuniorsArgentinos 0 - 1 LanúsLanús ...
09 Nov 98 PlatensePlatense 2 - 2 Racing ClubRacing Club ...
09 Nov 98 Vélez SarsfieldVélez 1 - 2 BelgranoBelgrano ...
09 Nov 98 ColónColón 2 - 1 Newell's Old BoysNewell's ...
09 Nov 98 IndependienteIndependien 0 - 1 Unión Santa FeUnión ...
09 Nov 98 Rosario CentralRosario 0 - 1 Ferro Carril OesteFerro ...
09 Nov 98 Estudiantes La PlataEstudiantes 2 - 2 Gimnasia La PlataGimnasia ...
09 Nov 98 River PlateRiver Plate 3 - 4 CA HuracánHuracán ...
09 Nov 98 San LorenzoLorenzo 1 - 3 Boca JuniorsBoca ...
09 Nov 98 Talleres CórdobaTalleres 1 - 2 Gimnasia JujuyGimnasia ...
Jornada 15
16 Nov 98 Racing ClubRacing Club 3 - 1 ColónColón ...
16 Nov 98 Unión Santa FeUnión 2 - 3 LanúsLanús ...
16 Nov 98 PlatensePlatense 1 - 0 Argentinos JuniorsArgentinos ...
16 Nov 98 Newell's Old BoysNewell's 1 - 0 Vélez SarsfieldVélez ...
16 Nov 98 Ferro Carril OesteFerro 2 - 2 IndependienteIndependien ...
16 Nov 98 Gimnasia La PlataGimnasia 3 - 2 San LorenzoLorenzo ...
16 Nov 98 BelgranoBelgrano 0 - 1 River PlateRiver Plate ...
16 Nov 98 CA HuracánHuracán 2 - 2 Estudiantes La PlataEstudiantes ...
16 Nov 98 Gimnasia JujuyGimnasia 0 - 0 Rosario CentralRosario ...
16 Nov 98 Boca JuniorsBoca 2 - 1 Talleres CórdobaTalleres ...
Jornada 16
23 Nov 98 LanúsLanús 0 - 0 Ferro Carril OesteFerro ...
23 Nov 98 Argentinos JuniorsArgentinos 2 - 2 Unión Santa FeUnión ...
23 Nov 98 ColónColón 2 - 1 PlatensePlatense ...
23 Nov 98 IndependienteIndependien 0 - 0 Gimnasia JujuyGimnasia ...
23 Nov 98 Vélez SarsfieldVélez 0 - 3 Racing ClubRacing Club ...
23 Nov 98 Rosario CentralRosario 2 - 3 Boca JuniorsBoca ...
23 Nov 98 River PlateRiver Plate 2 - 0 Newell's Old BoysNewell's ...
23 Nov 98 San LorenzoLorenzo 2 - 0 CA HuracánHuracán ...
23 Nov 98 Estudiantes La PlataEstudiantes 2 - 0 BelgranoBelgrano ...
23 Nov 98 Talleres CórdobaTalleres 2 - 1 Gimnasia La PlataGimnasia ...
Jornada 17
30 Nov 98 Gimnasia JujuyGimnasia 0 - 1 LanúsLanús ...
30 Nov 98 ColónColón 2 - 3 Argentinos JuniorsArgentinos ...
30 Nov 98 PlatensePlatense 3 - 5 Vélez SarsfieldVélez ...
30 Nov 98 Boca JuniorsBoca 0 - 0 IndependienteIndependien ...
30 Nov 98 Ferro Carril OesteFerro 1 - 2 Unión Santa FeUnión ...
30 Nov 98 Gimnasia La PlataGimnasia 1 - 1 Rosario CentralRosario ...
30 Nov 98 Newell's Old BoysNewell's 3 - 0 Estudiantes La PlataEstudiantes ...
30 Nov 98 Racing ClubRacing Club 2 - 2 River PlateRiver Plate ...
30 Nov 98 CA HuracánHuracán 2 - 5 Talleres CórdobaTalleres ...
30 Nov 98 BelgranoBelgrano 2 - 2 San LorenzoLorenzo ...
Jornada 18
07 Dic 98 Unión Santa FeUnión 1 - 3 Gimnasia JujuyGimnasia ...
07 Dic 98 Estudiantes La PlataEstudiantes 1 - 0 Racing ClubRacing Club ...
07 Dic 98 LanúsLanús 1 - 1 Boca JuniorsBoca ...
07 Dic 98 Vélez SarsfieldVélez 2 - 0 ColónColón ...
07 Dic 98 Argentinos JuniorsArgentinos 1 - 1 Ferro Carril OesteFerro ...
07 Dic 98 IndependienteIndependien 2 - 2 Gimnasia La PlataGimnasia ...
07 Dic 98 San LorenzoLorenzo 2 - 2 Newell's Old BoysNewell's ...
07 Dic 98 River PlateRiver Plate 1 - 0 PlatensePlatense ...
07 Dic 98 Rosario CentralRosario 2 - 0 CA HuracánHuracán ...
07 Dic 98 Talleres CórdobaTalleres 1 - 0 BelgranoBelgrano ...
Jornada 19
14 Dic 98 Gimnasia La PlataGimnasia 1 - 0 LanúsLanús ...
14 Dic 98 Boca JuniorsBoca 3 - 1 Unión Santa FeUnión ...
14 Dic 98 Gimnasia JujuyGimnasia 3 - 4 Ferro Carril OesteFerro ...
14 Dic 98 CA HuracánHuracán 1 - 1 IndependienteIndependien ...
14 Dic 98 Vélez SarsfieldVélez 2 - 5 Argentinos JuniorsArgentinos ...
14 Dic 98 Racing ClubRacing Club 3 - 2 San LorenzoLorenzo ...
14 Dic 98 ColónColón 1 - 1 River PlateRiver Plate ...
14 Dic 98 PlatensePlatense 3 - 2 Estudiantes La PlataEstudiantes ...
14 Dic 98 Newell's Old BoysNewell's 4 - 2 Talleres CórdobaTalleres ...
14 Dic 98 BelgranoBelgrano 0 - 0 Rosario CentralRosario ...

Clasificación

Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 19 45 17 45
2 Gimnasia La Plata Gimnasia 19 31 23 36
3 Racing Club Racing Club 19 39 29 33
4 Lanús Lanús 19 20 20 30
5 Colón Colón 19 28 27 26
6 San Lorenzo San Lorenzo 19 40 35 25
7 Argentinos Juniors Argentinos 19 31 27 25
8 Newell's Old Boys Newell's 19 21 21 25
9 Unión Santa Fe Unión Santa 19 32 34 25
10 Rosario Central Rosario 19 26 28 25
11 Vélez Sarsfield Vélez 19 26 26 24
12 Estudiantes La Plata Estudiantes 19 22 23 24
13 Talleres Córdoba Talleres 19 28 33 24
14 Gimnasia Jujuy Gimnasia 19 31 30 22
15 River Plate River Plate 19 27 27 22
16 Independiente Independient 19 26 26 22
17 Ferro Carril Oeste Ferro Carril 19 24 31 20
18 CA Huracán CA Huracán 19 29 42 20
19 Belgrano Belgrano 19 22 31 19
20 Platense Platense 19 21 39 13

  USO DE MEMORIA  
6,307,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.3975
Total Execution Time  0.4000
  CADENA URL  
/torneo_inicial1999/grupo1/calendario
  GET DATOS  
$_GET['/torneo_inicial1999/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0130  SELECT type FROM routes WHERE alias = 'torneo_inicial1999'
0.0264  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_inicial' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=26 ORDER BY order_id ASC
0.0132  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 = 8403 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0262  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 calendars1999 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 8403 ORDER BY round ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 08:56:37' 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=2 AND last_update > '2024-05-08 08:56:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 08:56:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 08:56:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0142  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_inicial' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0137  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1999
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (8403) 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, e.player_id ASC LIMIT 10
0.0136  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1999
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (8403) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1999
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (8403) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0139  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 8403 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC