4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Villa Mitre Bahia Blanca

Villa Mitre Bahia Blanca

Entrenador: Carlos Mungo

Temporada 2023/2024
TEMPORADA 2023/2024
TORNEO FEDERAL A TRANSICIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Germinal de Rawson Germinal 5 10 4 11
2 Olimpo Olimpo 5 4 3 10
3 Villa Mitre Bahia Blanca Villa Mitre 5 8 5 9
4 Circulo Deportivo Circulo 5 7 6 9
5 Kimberley Mar del Plata Kimberley 5 4 2 8
6 CSYD Sol de Mayo CSYD Mayo 5 6 7 7
7 Deportivo Rincón Deportivo 5 1 2 5
8 Sansinena Sansinena 5 5 7 4
9 Cipolletti Cipolletti 5 2 6 4
10 Dep. Santamarina Dep. 5 2 7 2
TEMPORADA 2022/2023
TORNEO FEDERAL A TRANSICIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Olimpo Olimpo 32 58 20 70
2 Villa Mitre Bahia Blanca Villa Mitre 32 55 15 67
3 Cipolletti Cipolletti 32 35 34 47
4 Dep. Santamarina Dep. 32 33 31 44
5 Sansinena Sansinena 32 33 37 43
6 CSYD Sol de Mayo CSYD Mayo 32 35 52 38
7 Germinal de Rawson Germinal 32 30 45 34
8 Circulo Deportivo Circulo 32 25 46 29
9 CA Liniers CA Liniers 32 18 42 24
TEMPORADA 2021/2022
TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Olimpo Olimpo 32 53 19 73
2 Villa Mitre Bahia Blanca Villa Mitre 32 42 25 57
3 Ciudad De Bolívar Ciudad 32 30 28 49
4 Independiente Chivilcoy Independient 32 33 22 47
5 CSYD Sol de Mayo CSYD Mayo 32 32 26 46
6 Sportivo Estudiantes Sportivo 32 34 29 46
7 Juventud Universitario Juventud 32 28 25 45
8 Sansinena Sansinena 32 44 42 42
9 Argentino Monte Maíz Argentino 32 29 34 40
10 Cipolletti Cipolletti 32 26 35 38
11 Sportivo Peñarol Sportivo 32 31 42 37
12 Circulo Deportivo Circulo 32 31 40 36
13 CA Liniers CA Liniers 32 34 44 36
14 Huracán Las Heras Huracán 32 23 26 35
15 Ferro General Pico Ferro 32 28 32 35
16 Sportivo Desamparados Sportivo 32 24 36 34
17 Camioneros Bs As Camioneros 32 27 44 31
TEMPORADA 2020/2021
TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Deportivo Madryn Deportivo 30 39 23 56
2 CSYD Sol de Mayo CSYD Mayo 30 32 24 50
3 Cipolletti Cipolletti 30 41 26 49
4 Olimpo Olimpo 30 42 32 49
5 Sportivo Peñarol Sportivo 30 44 38 49
6 Independiente Chivilcoy Independient 30 30 21 48
7 Juventud Universitario Juventud 30 28 18 47
8 Villa Mitre Bahia Blanca Villa Mitre 30 35 28 45
9 Ferro General Pico Ferro 30 39 38 43
10 Sportivo Desamparados Sportivo 30 29 37 43
11 Sansinena Sansinena 30 38 37 40
12 Ciudad De Bolívar Ciudad 30 30 28 38
13 Huracán Las Heras Huracán 30 38 40 35
14 Deportivo Camioneros RG Deportivo 30 25 34 29
15 Sportivo Estudiantes Sportivo 30 18 48 15
16 Circulo Deportivo Circulo 30 18 54 13
TEMPORADA 2019/2020
TORNEO FEDERAL A TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Club Atlético Güemes Club 6 10 5 15
2 Central Norte Central 6 7 6 10
3 Chaco For Ever Chaco Ever 6 8 6 9
4 Douglas Haig Douglas Haig 6 5 4 9
5 Sarm. Resistencia Sarm. 6 4 5 7
6 Def. de Pronunciamiento Def. 6 5 8 5
7 Sportivo Las Parejas Sportivo 6 6 11 3
8 Villa Mitre Bahia Blanca Villa Mitre 6 9 5 12
9 Dep. Maipú Dep. Maipú 6 7 4 10
10 Olimpo Olimpo 6 6 5 10
11 Juventud Universitario Juventud 6 8 6 8
12 Huracán Las Heras Huracán 6 4 6 7
13 Deportivo Madryn Deportivo 6 6 10 7
14 Sansinena Sansinena 6 2 6 3
TEMPORADA 2018/2019
TORNEO FEDERAL A TRANSICIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Alvarado Alvarado 7 10 6 12
2 Defensores Belgrano VR Defensores 7 9 7 12
3 Gimnasia Concepción Gimnasia 7 10 7 11
4 Sansinena Sansinena 7 7 4 11
5 Villa Mitre Bahia Blanca Villa Mitre 7 8 5 10
6 Unión Sunchales Unión 7 9 12 8
7 Deportivo Camioneros RG Deportivo 7 10 17 4
8 CSYD Sol de Mayo CSYD Mayo 7 7 12 3
9 Estudiantes Río Cuarto Estudiantes 7 16 8 15
10 Sarm. Resistencia Sarm. 7 9 5 12
11 San Jorge Tucumán Jorge 7 16 11 11
12 Chaco For Ever Chaco Ever 7 13 12 11
13 Huracán Las Heras Huracán 7 6 10 9
14 Sportivo Desamparados Sportivo 7 4 8 8
15 Dep. Maipú Dep. Maipú 7 9 14 6
16 Boca Unidos Boca Unidos 7 5 10 5
TEMPORADA 2017/2018
TORNEO FEDERAL A TRANSICIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Estudiantes Río Cuarto Estudiantes 7 13 6 15
2 Gimnasia Mendoza Gimnasia 7 11 6 14
3 Juventud Universitario Juventud 7 9 7 13
4 Alvarado Alvarado 7 8 8 10
5 Dep. Roca Dep. Roca 7 12 14 9
6 Sportivo Desamparados Sportivo 7 4 6 8
7 Villa Mitre Bahia Blanca Villa Mitre 7 6 10 5
8 Ferro General Pico Ferro 7 5 11 5
9 Central Córdoba Central 7 10 5 14
10 Defensores Belgrano VR Defensores 7 11 5 13
11 Unión Sunchales Unión 7 9 8 10
12 Sportivo Belgrano Sportivo 7 8 7 10
13 Crucero del Norte Crucero 7 7 6 10
14 Sarm. Resistencia Sarm. 7 5 9 9
15 Chaco For Ever Chaco Ever 7 5 8 6
16 Gimnasia y Tiro Gimnasia 7 7 14 6
TEMPORADA 2016/2017
TORNEO FEDERAL A TRANSICIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Unión Sunchales Unión 8 17 10 17
2 Gimnasia Mendoza Gimnasia 8 15 10 15
3 Argentino Agropecuario Argentino 8 10 9 15
4 Defensores Belgrano VR Defensores 8 11 7 14
5 Villa Mitre Bahia Blanca Villa Mitre 8 7 5 11
6 Cipolletti Cipolletti 8 7 8 10
7 Deportivo Madryn Deportivo 8 6 11 7
8 Sportivo Las Parejas Sportivo 8 5 14 5
9 Alvarado Alvarado 8 7 11 4
10 Gimnasia y Tiro Gimnasia 8 15 7 19
11 Atlético Mitre SdE Atlético 8 12 8 16
12 Sportivo Patria Sportivo 8 11 11 14
13 Sarm. Resistencia Sarm. 8 10 9 13
14 Unión Villa Krause Unión Villa 8 7 5 12
15 Unión Aconquija Unión 8 10 10 9
16 Juventud Antoniana Juventud 8 3 8 7
17 Chaco For Ever Chaco Ever 8 7 13 7
18 Altos Hornos Zapla Altos Hornos 8 5 9 4
TEMPORADA 2015/2016
TORNEO FEDERAL A GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Madryn Deportivo 12 27 17 21
2 Independiente Neuquén Independient 12 17 17 20
3 Cipolletti Cipolletti 12 17 12 17
4 Villa Mitre Bahia Blanca Villa Mitre 12 13 19 12
5 Dep. Roca Dep. Roca 12 11 20 12
TEMPORADA 2014/2015
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 2
Equipo PJ GF GC Puntos
1 Sansinena Sansinena 22 50 16 56
2 CA Liniers CA Liniers 22 38 16 49
3 Villa Mitre Bahia Blanca Villa Mitre 22 46 18 43
4 Kimberley Mar del Plata Kimberley 22 25 12 43
5 Ayacucho Ayacucho 22 28 20 38
6 América Pirán América 22 29 23 32
7 Ferro Carril Sud Olavarria Ferro Carril 22 32 29 29
8 Bella Vista Bahia Blanca Bella Vista 22 31 33 23
9 Sarmiento Coronel Suarez Sarmiento 22 22 38 22
10 Racing Olavarría Racing 22 17 26 17
11 Valeria del Mar Valeria 22 17 46 10
12 Tres Algarrobos Tres 22 11 69 7
TEMPORADA 2013/2014
ARGENTINO B GRUPO 13
Equipo PJ GF GC Puntos
1 Villa Mitre Bahia Blanca Villa Mitre 16 35 17 33
2 CSYD Sol de Mayo CSYD Mayo 16 32 22 31
3 Tiro Federal Bahia Blanca Tiro Federal 16 27 15 30
4 CA Liniers CA Liniers 16 31 23 29
5 Bella Vista Bahia Blanca Bella Vista 16 27 26 22
6 Independiente Río Colorado Independient 16 18 19 19
7 Deportivo Patagones Viedma Deportivo 16 22 29 14
8 Defensores Buena Parada Defensores 16 20 33 13
9 Villa Congreso Villa 16 17 45 6
TEMPORADA 2010/2011
ARGENTINO A GRUPO 3
Equipo PJ GF GC Puntos
1 Dep. Maipú Dep. Maipú 8 13 6 19
2 Racing Córdoba Racing 8 13 8 16
3 Estudiantes Río Cuarto Estudiantes 8 10 11 9
4 Alumni Villa Maria Alumni Villa 8 11 17 9
5 Juventud Universitario Juventud 8 9 14 4
6 Crucero del Norte Crucero 8 13 8 13
7 Juventud Antoniana Juventud 8 11 8 13
8 Central Córdoba Central 8 14 12 11
9 Gimnasia Concepción Gimnasia 8 12 15 11
10 9 de Julio Rafaela Julio 8 11 18 8
11 Douglas Haig Douglas Haig 8 12 5 18
12 Cipolletti Cipolletti 8 6 5 10
13 Rivadavia Lincoln Rivadavia 8 5 8 9
14 Villa Mitre Bahia Blanca Villa Mitre 8 11 13 8
15 Dep. Santamarina Dep. 8 6 9 7
TEMPORADA 2009/2010
ARGENTINO A GRUPO 3
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
6,112,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1359
Total Execution Time  0.1372
  CADENA URL  
/historico/Villa-Mitre
  GET DATOS  
$_GET['/historico/Villa-Mitre']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0030  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 = 'Villa-Mitre' 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.0019  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=16435 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=16435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=16435 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=16435 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16435 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 (264057,561326,604859,791039) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '16435' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '16435' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '16435' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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=16435 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75540,74909) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 75540 AND teamId = 16435
0.0045  SELECT count(id) as num_players from rel_players WHERE league_id = 74909 AND teamId = 16435
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 = '16435' 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 = '16435' and rp.type = 4
0.0021  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 = '16435' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 75540 WHERE rp.league_id = 75540 AND rp.teamId = 16435 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 = 75540 WHERE rp.league_id = 75540 AND rp.teamId = 16435 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 75540 WHERE rp.league_id = 75540 AND rp.teamId = 16435 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 16435 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75540 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.0021  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 = 71105 AND t.round = 36 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 `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 = 66958 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.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 `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 = 61892 AND t.round = 30 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 `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 = 51043 AND t.round = 23 ORDER BY team.conference ASC,t.position 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 `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 = 60171 AND t.round = 7 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 = 45041 AND t.round = 18 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 `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 = 48454 AND t.round = 7 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 `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 = 40142 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 `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 = 41924 AND t.round = 7 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 `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 = 34104 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 37687 AND t.round = 9 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 `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 = 20248 AND t.round = 15 ORDER BY team.conference 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 `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 = 19805 AND t.round = 7 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 `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 = 4449 AND t.round = 14 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 `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 = 15582 AND t.round = 22 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 = 3512 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2011` 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 = 16541 AND t.round = 28 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 `tables2011` 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 = 16545 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2010` 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 = 16557 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC