4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Defensores Belgrano VR
TEMPORADA 2023/2024
TORNEO FEDERAL A TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Defensores Belgrano VR Defensores 5 7 2 12
2 Sportivo Belgrano Sportivo 6 5 2 12
3 Independiente Chivilcoy Independient 5 7 3 10
4 El Linqueño Linqueño 6 2 2 9
5 Def. de Pronunciamiento Def. 6 6 10 7
6 Douglas Haig Douglas Haig 5 6 3 6
7 Sportivo Las Parejas Sportivo 5 3 4 5
8 9 de Julio Rafaela Julio 5 3 7 4
9 Gimnasia Concepción Gimnasia 5 1 7 1
TEMPORADA 2022/2023
TORNEO FEDERAL A TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Douglas Haig Douglas Haig 32 43 22 67
2 Independiente Chivilcoy Independient 32 31 25 49
3 Sportivo Belgrano Sportivo 32 42 34 47
4 Sportivo Las Parejas Sportivo 32 37 33 47
5 El Linqueño Linqueño 32 41 37 44
6 Def. de Pronunciamiento Def. 32 32 39 40
7 Defensores Belgrano VR Defensores 32 29 39 38
8 Unión Sunchales Unión 32 25 38 37
9 Gimnasia Concepción Gimnasia 32 24 37 33
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 FEDERAL A TRANSICIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Córdoba Racing 28 43 16 57
2 Gimnasia y Tiro Gimnasia 28 36 20 55
3 Central Norte Central 28 40 22 49
4 Chaco For Ever Chaco Ever 28 33 20 47
5 Sportivo Las Parejas Sportivo 28 34 28 41
6 Def. de Pronunciamiento Def. 28 32 32 38
7 JU Gualeguaychu Gualeguaychu 28 28 34 38
8 Defensores Belgrano VR Defensores 28 36 40 37
9 Sarm. Resistencia Sarm. 28 38 41 36
10 Boca Unidos Boca Unidos 28 38 36 33
11 Unión Sunchales Unión 28 28 40 30
12 Douglas Haig Douglas Haig 28 19 25 27
13 Sportivo Belgrano Sportivo 28 25 35 26
14 Gimnasia Concepción Gimnasia 28 21 42 26
15 Crucero del Norte Crucero 28 19 39 22
TEMPORADA 2019/2020
TORNEO FEDERAL A TRANSICIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Sportivo Belgrano Sportivo 4 8 3 10
2 JU Gualeguaychu Gualeguaychu 4 10 8 5
3 Boca Unidos Boca Unidos 4 6 6 5
4 Unión Sunchales Unión 4 5 5 4
5 Defensores Belgrano VR Defensores 4 2 9 1
6 Deportivo Camioneros RG Deportivo 6 5 0 14
7 Sportivo Desamparados Sportivo 6 4 2 9
8 Sportivo Estudiantes Sportivo 6 5 5 8
9 CSYD Sol de Mayo CSYD Mayo 6 4 7 8
10 Sportivo Peñarol Sportivo 6 6 5 7
11 Cipolletti Cipolletti 6 3 3 7
12 Circulo Deportivo Circulo 6 0 5 2
TEMPORADA 2018/2019
TORNEO FEDERAL A TRANSICIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Estudiantes Río Cuarto Estudiantes 4 7 1 12
2 Sarm. Resistencia Sarm. 4 9 7 9
3 Alvarado Alvarado 4 4 5 4
4 San Jorge Tucumán Jorge 4 3 6 4
5 Defensores Belgrano VR Defensores 4 3 7 0
TEMPORADA 2017/2018
TORNEO FEDERAL A TRANSICIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Central Córdoba Central 4 8 3 10
2 Gimnasia Mendoza Gimnasia 4 7 5 7
3 Defensores Belgrano VR Defensores 4 3 3 4
4 Juventud Universitario Juventud 4 4 7 4
5 Estudiantes Río Cuarto Estudiantes 4 2 6 3
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 3
Equipo PJ GF GC Puntos
1 Defensores Belgrano VR Defensores 12 18 7 21
2 Alvarado Alvarado 12 15 10 21
3 Ferro General Pico Ferro 12 15 10 20
4 Belgrano Santa Rosa Belgrano 12 13 20 14
5 Tiro Federal Bahia Blanca Tiro Federal 12 8 22 5
TEMPORADA 2014/2015
TORNEO FEDERAL A GRUPO 5
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 13 22 8 31
2 Defensores Belgrano VR Defensores 13 23 10 28
3 Juventud Universitario Juventud 13 18 11 23
4 Unión Aconquija Unión 13 12 11 20
5 Atlético Mitre SdE Atlético 13 9 9 19
6 Juventud Antoniana Juventud 13 12 11 17
7 Unión Sunchales Unión 13 15 17 17
8 Chaco For Ever Chaco Ever 13 18 16 16
9 Gimnasia y Tiro Gimnasia 13 9 11 16
10 Sol de América Formosa América 13 14 20 16
11 Tiro Federal Bahia Blanca Tiro Federal 13 16 22 15
12 Cipolletti Cipolletti 13 14 18 13
13 San Martín Tucumán Martín 13 11 17 11
14 Dep. Roca Dep. Roca 13 10 22 7
TEMPORADA 2013/2014
ARGENTINO A
Equipo PJ GF GC Puntos
1 Tiro Federal Rosario Tiro Federal 22 30 20 35
2 Guaraní A. Franco Guaraní 22 19 20 35
3 San Martín Tucumán Martín 22 21 16 34
4 JU Gualeguaychu Gualeguaychu 22 22 19 34
5 Central Córdoba Central 22 23 23 31
6 San Jorge Tucumán Jorge 22 22 23 31
7 Juventud Antoniana Juventud 22 21 17 30
8 Libertad Sunchales Libertad 22 22 19 30
9 Central Norte Central 22 26 27 26
10 Gimnasia Concepción Gimnasia 22 25 36 25
11 Gimnasia y Tiro Gimnasia 22 26 30 21
12 Chaco For Ever Chaco Ever 22 24 31 21
13 Dep. Santamarina Dep. 22 33 21 45
14 Juventud Universitario Juventud 22 35 20 38
15 Defensores Belgrano VR Defensores 22 34 23 37
16 Guillermo Brown Guillermo 22 31 24 33
17 CAI CAI 22 37 33 33
18 Cipolletti Cipolletti 22 29 25 32
19 Dep. Maipú Dep. Maipú 22 24 32 29
20 Unión Mar del Plata Unión Plata 22 26 27 28
21 Alvarado Alvarado 22 13 16 27
22 Sportivo Estudiantes Sportivo 22 28 32 27
23 Racing Olavarría Racing 22 22 37 18
24 Rivadavia Lincoln Rivadavia 22 18 40 15
TEMPORADA 2012/2013
ARGENTINO A
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 24 42 23 46
2 Gimnasia y Tiro Gimnasia 24 36 26 42
3 San Martín Tucumán Martín 24 29 22 37
4 Sportivo Belgrano Sportivo 24 37 28 36
5 San Jorge Tucumán Jorge 24 25 35 36
6 Juventud Antoniana Juventud 24 20 18 35
7 Central Norte Central 24 33 29 33
8 Central Córdoba Central 24 32 28 33
9 Libertad Sunchales Libertad 24 22 28 29
10 Tiro Federal Rosario Tiro Federal 24 20 24 27
11 Guaraní A. Franco Guaraní 24 24 29 23
12 Alumni Villa Maria Alumni Villa 24 17 29 20
13 Racing Córdoba Racing 24 18 36 18
14 Dep. Santamarina Dep. 22 28 18 39
15 Juventud Universitario Juventud 22 28 23 35
16 Dep. Maipú Dep. Maipú 22 31 27 33
17 Racing Olavarría Racing 22 33 28 30
18 Gimnasia Conce… Gimnasia 22 26 27 30
19 Defensores Belgrano VR Defensores 22 19 22 30
20 Rivadavia Lincoln Rivadavia 22 32 36 29
21 Cipolletti Cipolletti 22 27 26 28
22 Alvarado Alvarado 22 20 21 28
23 Unión Mar del Plata Unión Plata 22 24 30 28
24 Guillermo Brown Guillermo 22 25 33 27
25 Sportivo Desamparados Sportivo 22 26 28 25

  USO DE MEMORIA  
5,888,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1217
Total Execution Time  0.1229
  CADENA URL  
/historico/Defensores-Belgrano-V-Ramallo
  GET DATOS  
$_GET['/historico/Defensores-Belgrano-V-Ramallo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0050  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 = 75542
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16430 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16430 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (33413,74196,162958,196424,240449) ORDER BY n.cover_points DESC, update_date DESC
0.0031  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 = '16430' 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,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=16430 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 (75542) 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.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 75542 AND teamId = 16430
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 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 = 75542 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030  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 = 75542 WHERE rp.league_id = 75542 AND rp.teamId = 16430 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.0029  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 = 75542 WHERE rp.league_id = 75542 AND rp.teamId = 16430 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 75542 WHERE rp.league_id = 75542 AND rp.teamId = 16430 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 16430 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75542 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.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 `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 = 71107 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 = 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 = 61891 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.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 = 51042 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.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 = 60172 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.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 `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 = 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.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 `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 = 49322 AND t.round = 5 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 `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.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 = 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.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 = 43166 AND t.round = 5 ORDER BY team.conference 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 `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.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 `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.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 `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 = 20250 AND t.round = 15 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 = 3991 AND t.round = 14 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 `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 = 10882 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 16600 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 2548 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2013` 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 = 2003 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC