4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético Paraná
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 2021/2022
TORNEO FEDERAL A TRANSICIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Córdoba Racing 32 52 16 68
2 Sarm. Resistencia Sarm. 32 44 19 64
3 San Martín Formosa Martín 32 56 30 59
4 Central Norte Central 32 44 25 57
5 Gimnasia y Tiro Gimnasia 32 35 30 54
6 Douglas Haig Douglas Haig 32 42 32 48
7 Sportivo Belgrano Sportivo 32 41 34 48
8 Sportivo Las Parejas Sportivo 32 33 33 46
9 Gimnasia Concepción Gimnasia 32 33 39 44
10 Juventud Antoniana Juventud 32 34 41 40
11 Crucero del Norte Crucero 32 26 45 40
12 Boca Unidos Boca Unidos 32 34 34 37
13 Def. de Pronunciamiento Def. 32 27 40 31
14 Defensores Belgrano VR Defensores 32 24 37 30
15 Unión Sunchales Unión 32 30 48 30
16 Atlético Paraná Atlético 32 25 48 26
17 JU Gualeguaychu Gualeguaychu 32 27 56 23
TEMPORADA 2020/2021
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Carcarañá Atlético 6 16 10 13
2 Ben Hur Ben Hur 6 11 6 13
3 9 de Julio Rafaela Julio 6 13 11 9
4 ADIUR ADIUR 6 2 15 0
5 Atlético Paraná Atlético 6 13 4 13
6 Libertad Concordia Libertad 6 10 10 11
7 Urquiza Urquiza 6 7 9 7
8 Malvinas De Federal Malvinas 6 2 9 3
TEMPORADA 2019/2020
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo PJ GF GC Puntos
1 9 de Julio Rafaela Julio 4 8 2 10
2 Brown De San vicente Brown 4 4 3 4
3 Libertad Sunchales Libertad 4 2 9 3
4 ADIUR ADIUR 4 5 3 8
5 Atlético Carcarañá Atlético 4 7 4 6
6 PSM Futbol PSM Futbol 4 3 8 1
7 Ben Hur Ben Hur 4 7 2 9
8 Atlético San Jorge Atlético 4 9 5 9
9 Ateneo Inmaculada Ateneo 4 3 12 0
10 Atlético Uruguay Atlético 4 6 4 7
11 9 De Julio De Colonia Julio 4 6 5 7
12 Rivadavia De Concepción Rivadavia 4 4 7 3
13 Libertad Concordia Libertad 4 10 2 10
14 Malvinas De Federal Malvinas 3 2 3 4
15 Estudiantes De Federación Estudiantes 3 3 10 0
16 Atlético Paraná Atlético 4 7 4 10
17 Urquiza Urquiza 4 5 7 4
18 Belgrano Paraná Belgrano 4 6 7 3
TEMPORADA 2018/2019
TORNEO FEDERAL A TRANSICIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Deportivo Madryn Deportivo 8 12 5 16
2 Cipolletti Cipolletti 8 11 5 12
3 Ferro General Pico Ferro 8 12 7 11
4 Independiente Neuquén Independient 8 7 16 7
5 Dep. Roca Dep. Roca 8 5 14 6
6 Sportivo Las Parejas Sportivo 8 12 8 14
7 Def. de Pronunciamiento Def. 8 11 7 14
8 Douglas Haig Douglas Haig 8 11 7 13
9 Atlético Paraná Atlético 8 9 15 6
10 JU Gualeguaychu Gualeguaychu 8 7 13 6
11 Sportivo Estudiantes Sportivo 8 10 7 15
12 Sportivo Belgrano Sportivo 8 15 11 13
13 Racing Córdoba Racing 8 13 10 11
14 Juventud Universitario Juventud 8 8 12 10
15 San Lorenzo Alem Lorenzo Alem 8 11 17 3
16 San Martín Formosa Martín 8 14 6 17
17 Juventud Antoniana Juventud 8 8 8 11
18 Crucero del Norte Crucero 8 5 6 10
19 Altos Hornos Zapla Altos Hornos 8 5 6 9
20 Gimnasia y Tiro Gimnasia 8 4 10 8
TEMPORADA 2017/2018
TORNEO FEDERAL A TRANSICIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Deportivo Madryn Deportivo 8 10 5 17
2 Sansinena Sansinena 8 9 7 14
3 Independiente Neuquén Independient 8 7 12 9
4 Rivadavia Lincoln Rivadavia 8 9 11 8
5 Cipolletti Cipolletti 8 9 9 7
6 Huracán Las Heras Huracán 10 15 7 19
7 Unión Villa Krause Unión Villa 10 9 8 15
8 Dep. Maipú Dep. Maipú 10 15 14 13
9 San Lorenzo Alem Lorenzo Alem 10 10 13 13
10 Unión Aconquija Unión 10 9 13 10
11 Gutiérrez Gutiérrez 10 11 14 8
12 Atlético Paraná Atlético 10 15 9 18
13 Sportivo Las Parejas Sportivo 10 13 8 17
14 Def. de Pronunciamiento Def. 10 12 12 13
15 Douglas Haig Douglas Haig 10 15 19 12
16 Libertad Sunchales Libertad 10 13 16 10
17 Gimnasia Concepción Gimnasia 10 12 16 9
18 San Jorge Tucumán Jorge 10 14 9 19
19 Sportivo Patria Sportivo 10 18 14 14
20 CD Mandiyú CD Mandiyú 10 10 10 14
21 Juventud Antoniana Juventud 10 12 12 12
22 Altos Hornos Zapla Altos Hornos 10 8 11 9
23 Guaraní A. Franco Guaraní 10 10 16 8
TEMPORADA 2016/2017
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Argentinos Juniors Argentinos 44 61 24 88
2 Chacarita Juniors Chacarita 44 57 40 77
3 Guillermo Brown Guillermo 44 53 30 75
4 Indep. Rivadavia Indep. 44 48 44 67
5 Brown Adrogue Brown 44 57 50 65
6 Instituto Instituto 44 58 51 63
7 All Boys All Boys 44 43 45 62
8 Dep. Santamarina Dep. 44 45 43 61
9 San Martín Tucumán Martín 44 62 54 61
10 Almagro Almagro 44 35 34 60
11 Ferro Carril Oeste Ferro Carril 44 51 44 60
12 Nueva Chicago Nueva 44 53 47 60
13 Los Andes Los Andes 44 47 50 59
14 Central Córdoba Central 44 57 49 58
15 Flandria Flandria 44 39 40 56
16 JU Gualeguaychu Gualeguaychu 44 50 66 55
17 Sportivo Estudiantes Sportivo 44 40 58 54
18 Gimnasia Jujuy Gimnasia 44 36 45 52
19 Douglas Haig Douglas Haig 44 36 49 50
20 Boca Unidos Boca Unidos 44 42 54 47
21 Villa Dálmine Villa 44 45 60 47
22 Atlético Paraná Atlético 44 34 58 38
23 Crucero del Norte Crucero 44 36 50 37
TEMPORADA 2015/2016
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 21 31 11 49
2 Chacarita Juniors Chacarita 21 30 12 43
3 Gimnasia Jujuy Gimnasia 21 26 16 38
4 Boca Unidos Boca Unidos 21 28 19 38
5 Villa Dálmine Villa 21 35 28 33
6 Crucero del Norte Crucero 21 26 25 32
7 Nueva Chicago Nueva 21 32 27 30
8 Guillermo Brown Guillermo 21 31 29 30
9 Los Andes Los Andes 21 21 22 30
10 Brown Adrogue Brown 21 27 26 28
11 JU Gualeguaychu Gualeguaychu 21 25 26 28
12 Almagro Almagro 21 23 25 28
13 Dep. Santamarina Dep. 21 16 19 27
14 All Boys All Boys 21 30 28 26
15 Ferro Carril Oeste Ferro Carril 21 21 27 26
16 Sportivo Estudiantes Sportivo 21 17 25 24
17 Juventud Universitario Juventud 21 20 23 22
18 Central Córdoba Central 21 23 27 21
19 Douglas Haig Douglas Haig 21 20 24 20
20 Indep. Rivadavia Indep. 21 14 26 20
21 Atlético Paraná Atlético 21 16 32 19
22 Instituto Instituto 21 18 33 16
TEMPORADA 2014/2015
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Atl. Tucumán Atl. 42 69 31 85
2 Patronato Patronato 42 60 24 82
3 Ferro Carril Oeste Ferro Carril 42 44 37 67
4 Dep. Santamarina Dep. 42 54 40 66
5 Instituto Instituto 42 48 38 62
6 Villa Dálmine Villa 42 44 42 60
7 Atlético Paraná Atlético 42 50 46 58
8 Douglas Haig Douglas Haig 42 45 46 58
9 Sportivo Estudiantes Sportivo 42 47 44 56
10 Gimnasia Jujuy Gimnasia 42 35 43 55
11 Los Andes Los Andes 42 46 49 54
12 JU Gualeguaychu Gualeguaychu 42 43 47 54
13 Boca Unidos Boca Unidos 42 37 42 54
14 All Boys All Boys 42 38 37 53
15 Central Córdoba Central 42 37 44 51
16 Indep. Rivadavia Indep. 42 38 46 51
17 Guaraní A. Franco Guaraní 42 38 43 50
18 Chacarita Juniors Chacarita 42 49 62 50
19 Guillermo Brown Guillermo 42 43 50 48
20 Gimnasia Mendoza Gimnasia 42 37 53 48
21 Sportivo Belgrano Sportivo 42 36 50 40
22 Unión Mar del Plata Unión Plata 42 36 60 37
TEMPORADA 2013/2014
ARGENTINO B GRUPO 8
Equipo PJ GF GC Puntos
1 Atlético Paraná Atlético 18 31 12 35
2 Belgrano Paraná Belgrano 18 24 13 35
3 Textil Mandiyú Textil 18 28 19 31
4 Huracán Goya Huracán 18 24 17 31
5 Ferroviario Corrientes Ferroviario 18 26 13 29
6 Deportivo Achirense Deportivo 18 17 18 21
7 Viale FC María Grande Viale María 18 16 25 20
8 Deportivo Curupay Deportivo 18 18 26 19
9 Colegiales Concordia Colegiales 18 15 27 17
10 Central Goya Central Goya 18 11 40 10

  USO DE MEMORIA  
6,838,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1358
Total Execution Time  0.1371
  CADENA URL  
/historico/Atletico-Parana
  GET DATOS  
$_GET['/historico/Atletico-Parana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0031  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-Parana' 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.0018  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=16766 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=16766 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=16766 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16766 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16766 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 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 (71341,102666,145109,145113,244634) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '16766' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '16766' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '16766' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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=16766 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 74781 AND teamId = 16766
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '16766' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16766' and rp.type = 4
0.0020  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 = '16766' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 16766 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.0020  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 = 16766 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 16766 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 16766 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039  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.0029  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.0027  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 = 66957 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2021` 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 = 60922 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.0025  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.0025  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.0022  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 `tables2019` 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 = 45042 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2019` 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 = 48455 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2018` 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 = 40144 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2018` 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 = 41925 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 33440 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 20209 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 3990 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045  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 = 9170 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2014` 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 = 3507 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC