4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético Uruguay
TEMPORADA 2023/2024
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 4
Equipo PJ GF GC Puntos
1 Arsenal Viale Arsenal 6 18 7 15
2 Urquiza Urquiza 6 11 8 12
3 Union Agrarios Cerrito Union 6 8 12 6
4 Neuquen Parana Neuquen 6 4 14 3
5 Belgrano Paraná Belgrano 6 8 3 15
6 Atlético Paraná Atlético 6 13 3 13
7 Atlético San Martín Atlético 6 4 11 4
8 Deportivo Nobleza Deportivo 6 3 11 3
9 Libertad Concordia Libertad 4 7 3 10
10 Deportivo Achirense Deportivo 4 7 4 7
11 Deportivo América Deportivo 4 2 9 0
12 Atlético Uruguay Atlético 4 6 2 8
13 Deportivo San José Deportivo 4 6 4 7
14 Defensores Barrio Nebel Defensores 4 3 9 1
15 JU Gualeguaychu Gualeguaychu 4 15 0 12
16 Parque Sur Parque Sur 4 4 6 3
17 Defensores Martin Fierro Defensores 4 2 15 3
18 Colon de San Justo Colon Justo 6 15 3 16
19 Libertad Trinidad Libertad 6 8 10 10
20 Gimnasia Vera Gimnasia 6 7 10 5
21 Huracán Villa Ocampo Huracán 6 4 11 2
22 Ben Hur Ben Hur 6 19 1 12
23 Deportiva Juventud Deportiva 6 16 2 12
24 Argentino Franck Argentino 6 6 12 6
25 9 de Julio de Arocena Julio 6 3 29 1
26 Peñarol Rafaela Peñarol 6 9 6 11
27 Náutico el Quillá Náutico 6 7 5 10
28 Sportivo Norte Sportivo 6 7 9 8
29 Universidad Santa Fe Universidad 6 9 12 4
30 Libertad Sunchales Libertad 6 12 6 13
31 Ferrocarril del Estado Ferrocarril 6 10 5 12
32 Atlético San Jorge Atlético 6 10 10 7
33 San Martin MSyB Martin MSyB 6 3 14 1
34 ADEO ADEO 6 7 4 11
35 Atlético Carcarañá Atlético 6 10 6 10
36 Atlético Sastre Atlético 6 6 9 7
37 Juventud Unida Rosquin Juventud 6 3 7 5
38 Coronel Aguirre Coronel 6 24 4 15
39 Rosario Morning Star Rosario 6 9 5 13
40 PSM Futbol PSM Futbol 6 5 13 3
41 Colón de San Lorenzo Colón 6 2 18 2
42 Studebaker Studebaker 6 9 5 12
43 Rivadavia Venado Tuerto Rivadavia 6 10 7 10
44 Arteaga Arteaga 6 8 10 9
45 Eduardo Hertz VM Eduardo 6 7 12 4
46 Aprendices Casildenses Aprendices 6 13 5 15
47 Teodelina Teodelina 6 8 7 11
48 Argentino de Firmat Argentino 6 6 10 4
49 Jorge Newbery Venado Tuerto Jorge 6 6 11 4
TEMPORADA 2022/2023
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 4
Equipo PJ GF GC Puntos
1 Belgrano Paraná Belgrano 3 5 2 7
2 Urquiza Urquiza 4 2 3 4
3 Huracan Diamante Huracan 3 2 4 3
4 Arsenal Viale Arsenal 4 6 3 8
5 Cañadita Central Cañadita 3 1 2 4
6 El Silbido El Silbido 3 3 5 1
7 San Lorenzo Villa Adela Lorenzo 4 7 2 10
8 Santa María de Oro Santa María 3 4 4 4
9 Deportivo América Deportivo 3 3 8 0
10 Atlético Uruguay Atlético 5 10 3 10
11 Deportivo Achirense Deportivo 5 5 3 8
12 Parque Sur Parque Sur 5 7 8 6
13 Central Larroque Central 5 5 13 4
14 Ferrocarril del Estado Ferrocarril 5 7 3 10
15 Argentino Quilmes Rafaela Argentino 5 7 4 10
16 Sportivo Norte Sportivo 5 5 6 7
17 Libertad Sunchales Libertad 5 0 6 1
18 Ben Hur Ben Hur 5 7 0 11
19 Deportiva Juventud Deportiva 5 5 2 8
20 9 de Julio Rafaela Julio 5 3 1 7
21 Santa Clara FBC Santa Clara 5 0 12 0
22 Atlético San Jorge Atlético 4 8 4 7
23 Coronel Aguirre Coronel 3 5 6 4
24 Williams Kemmis Williams 3 3 6 3
25 Náutico el Quillá Náutico 5 9 1 11
26 Gimnasia y Esgrima de Santa Gimnasia 5 6 3 8
27 La Perla del Oeste Perla Oeste 5 7 5 8
28 San Martín Monte Vera Martín 5 1 14 0
29 Rivadavia Venado Tuerto Rivadavia 4 6 1 10
30 Studebaker Studebaker 4 2 4 4
31 Olimpia Santa Teresa Olimpia 4 4 7 3
32 Atlético Carcarañá Atlético 4 8 1 12
33 Cañadense Cañadense 4 6 5 6
34 General San Martin General 4 1 9 0
TEMPORADA 2021/2022
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 4
Equipo PJ GF GC Puntos
1 Belgrano Paraná Belgrano 6 14 3 12
2 Atlético Paraná Atlético 6 11 6 12
3 Don Bosco Paraná Bosco 6 8 9 10
4 Atlético San Martín Atlético 6 3 18 1
5 Santa María de Oro Santa María 4 7 0 10
6 Libertad Concordia Libertad 4 4 5 5
7 Deportivo América Deportivo 4 3 9 1
8 Atlético Uruguay Atlético 6 8 6 10
9 San Jorge Villa Elisa Jorge Villa 6 7 6 9
10 Atlético Sauce Atlético 6 8 12 7
11 Deportivo Achirense Deportivo 6 10 9 6
12 Caballu Caballu 4 7 5 9
13 Arsenal Viale Arsenal 4 6 4 9
14 Union Agrarios Cerrito Union 4 5 9 0
15 PSM Futbol PSM Futbol 6 10 4 11
16 Atlético Carcarañá Atlético 6 6 5 11
17 Campaña Campaña 6 4 6 6
18 Union de Álvarez Union 6 2 7 3
19 9 de Julio Rafaela Julio 4 11 4 8
20 Libertad Sunchales Libertad 4 6 3 8
21 Unión y Juventud Unión 4 1 11 0
22 Atlético San Jorge Atlético 4 8 2 10
23 Argentino Quilmes Rafaela Argentino 4 4 6 3
24 Argentino San Carlos Argentino 4 2 6 2
25 Ben Hur Ben Hur 4 8 0 10
26 Colon de San Justo Colon Justo 4 6 3 7
27 Atlético Miramar Atlético 4 1 12 0
TEMPORADA 2019/2020
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 13
Equipo PJ GF GC Puntos
1 Atlético Paraná Atlético 1 3 0 3
2 ADIUR ADIUR 1 2 0 3
3 Atlético Carcarañá Atlético 1 0 2 0
4 Urquiza Urquiza 1 0 3 0
5 Ben Hur Ben Hur 1 3 0 3
6 Brown De San vicente Brown 1 2 1 3
7 9 de Julio Rafaela Julio 1 1 2 0
8 Atlético San Jorge Atlético 1 0 3 0
9 Atlético Uruguay Atlético 1 2 1 3
10 Libertad Concordia Libertad 1 1 0 3
11 Malvinas De Federal Malvinas 1 1 2 0
12 9 De Julio De Colonia Julio 1 0 1 0
TEMPORADA 2016/2017
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 4
Equipo PJ GF GC Puntos
1 Deportivo Achirense Deportivo 18 35 13 35
2 Belgrano Paraná Belgrano 18 20 18 31
3 Libertad Concordia Libertad 18 20 14 29
4 Santa María de Oro Santa María 18 23 26 29
5 Atlético Uruguay Atlético 18 25 20 28
6 Arsenal Viale Arsenal 18 17 19 24
7 Atlético Villa Elisa Atlético 18 27 23 23
8 Cosmos Cosmos 18 17 23 16
9 Viale FC María Grande Viale María 18 12 22 16
10 Colegiales Concordia Colegiales 18 15 33 14
11 Atlético San Jorge Atlético 18 27 16 36
12 Rivadavia Venado Tuerto Rivadavia 18 30 16 33
13 Coronel Aguirre Coronel 18 32 29 29
14 9 de Julio Rafaela Julio 18 28 21 27
15 PSM Futbol PSM Futbol 18 25 18 27
16 Ben Hur Ben Hur 18 24 17 26
17 Unión Totoras Unión 18 11 22 19
18 Tiro Federal Rosario Tiro Federal 18 12 24 18
19 ADIUR ADIUR 18 15 28 15
20 Juventud Pueyrredón Juventud 18 25 38 11
TEMPORADA 2015/2016
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Uruguay Atlético 8 10 9 14
2 Belgrano Paraná Belgrano 8 11 7 13
3 Deportivo Achirense Deportivo 8 9 8 11
4 Libertad Concordia Libertad 8 11 13 10
5 Viale FC María Grande Viale María 8 7 11 8
TEMPORADA 2014/2015
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 5
Equipo PJ GF GC Puntos
1 Def. de Pronunciamiento Def. 20 34 22 35
2 9 de Julio Rafaela Julio 20 27 19 32
3 Ben Hur Ben Hur 20 26 18 32
4 Deportivo Achirense Deportivo 20 28 21 32
5 Libertad Concordia Libertad 20 21 22 27
6 Belgrano Paraná Belgrano 20 17 18 27
7 Atlético Uruguay Atlético 20 19 21 27
8 Viale FC María Grande Viale María 20 18 23 25
9 Sanjustino San Justo Sanjustino 20 21 20 24
10 La Salle Jobson Salle Jobson 20 23 34 21
11 Colegiales Concordia Colegiales 20 12 28 17
TEMPORADA 2006/2007
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 5
Equipo PJ GF GC Puntos
1 CD Coreano CD Coreano 2 3 1 6
2 Tres Algarrobos Tres 2 3 1 6
3 Colegiales Concordia Colegiales 2 5 2 4
4 Defensores de Salto Defensores 2 4 2 4
5 Famaillá Famaillá 2 3 2 4
6 Gimnasia y Tiro Gimnasia 2 3 2 4
7 Argentino Mendoza Argentino 2 2 3 1
8 Sarm. Resistencia Sarm. 2 2 3 1
9 Sportivo Las Parejas Sportivo 2 2 4 1
10 Atlético Uruguay Atlético 2 2 5 1
11 Huracán de Comodoro Huracán 2 1 3 0
12 Unión Mar del Plata Unión Plata 2 1 3 0
TEMPORADA 1983/1984
LIGA PROFESIONAL ARGENTINA GRUPO 5
Equipo PJ GF GC Puntos
1 River Plate River Plate 6 22 5 16
2 CA Huracán CA Huracán 6 14 8 12
3 Estudiantes Río Cuarto Estudiantes 6 9 10 5
4 Atlético Uruguay Atlético 6 2 24 1

  USO DE MEMORIA  
6,467,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.5554
Total Execution Time  0.5570
  CADENA URL  
/historico/Atletico-Uruguay
  GET DATOS  
$_GET['/historico/Atletico-Uruguay']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0171  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Atletico-Uruguay' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=64875 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=64875 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=64875 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0262  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74429
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64875 AND type_rel = 2
0.0140  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '64875' ORDER BY l.year DESC,cat.coefficient DESC
0.0139  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '64875' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0136  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '64875' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=64875 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74781) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 74781 AND teamId = 64875
0.0127  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '64875' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64875' and rp.type = 4
0.0126  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '64875' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74429 WHERE rp.league_id = 74429 AND rp.teamId = 64875 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74429 WHERE rp.league_id = 74429 AND rp.teamId = 64875 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74429 WHERE rp.league_id = 74429 AND rp.teamId = 64875 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 64875 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74429 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 70021 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 66002 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 53814 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 55644 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 34128 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 39148 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20290 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 15587 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 27943 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 27944 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 27946 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 27947 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1984` 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 = 26446 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC