4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Martín Formosa
TEMPORADA 2023/2024
TORNEO FEDERAL A TRANSICIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Central Norte Central 6 6 2 14
2 Sarmiento La Banda Sarmiento 6 11 4 13
3 San Martín Formosa Martín 5 7 2 9
4 Sol de América Formosa América 6 5 6 7
5 Crucero del Norte Crucero 6 3 5 6
6 Sarm.  Resistencia Sarm. 6 2 4 6
7 Juventud Antoniana Juventud 5 2 5 6
8 Boca Unidos Boca Unidos 5 2 4 3
9 Unión Sunchales Unión 5 4 10 3
TEMPORADA 2022/2023
TORNEO FEDERAL A TRANSICIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Gimnasia y Tiro Gimnasia 32 32 17 59
2 Central Norte Central 32 38 30 49
3 Boca Unidos Boca Unidos 32 31 36 46
4 Sol de América Formosa América 32 33 29 45
5 San Martín Formosa Martín 32 31 26 43
6 9 de Julio Rafaela Julio 32 34 34 41
7 Sarm.  Resistencia Sarm. 32 27 31 39
8 Crucero del Norte Crucero 32 28 35 36
9 Juventud Antoniana Juventud 32 20 36 32
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 2019/2020
TORNEO FEDERAL A TRANSICIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Club Atlético Güemes Club 22 29 18 38
2 Sarm.  Resistencia Sarm. 21 22 14 36
3 Chaco For Ever Chaco Ever 21 26 19 35
4 Sportivo Las Parejas Sportivo 21 25 14 33
5 Central Norte Central 22 30 22 32
6 Def. de Pronunciamiento Def. 22 22 25 31
7 Douglas Haig Douglas Haig 22 24 28 31
8 Defensores Belgrano VR Defensores 22 20 18 29
9 Crucero del Norte Crucero 21 20 20 29
10 Unión Sunchales Unión 21 25 21 28
11 Boca Unidos Boca Unidos 21 27 34 26
12 JU Gualeguaychu Gualeguaychu 21 17 23 22
13 San Martín Formosa Martín 21 20 31 21
14 Sportivo Belgrano Sportivo 22 21 29 20
15 Gimnasia Concepción Gimnasia 22 16 28 18
TEMPORADA 2018/2019
TORNEO FEDERAL A TRANSICIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Boca Unidos Boca Unidos 16 22 9 36
2 Chaco For Ever Chaco Ever 16 26 14 30
3 Sarm.  Resistencia Sarm. 16 22 14 27
4 San Jorge Tucumán Jorge 16 26 18 26
5 Crucero del Norte Crucero 16 21 17 24
6 Gimnasia y Tiro Gimnasia 16 11 21 17
7 Juventud Antoniana Juventud 16 13 18 14
8 Altos Hornos Zapla Altos Hornos 16 10 26 12
9 San Martín Formosa Martín 16 9 23 8
TEMPORADA 2016/2017
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 3
Equipo PJ GF GC Puntos
1 San Martín Formosa Martín 18 38 14 37
2 Sol de América Formosa América 18 24 15 34
3 CD Comercio CD Comercio 18 26 27 27
4 Argentinos del Norte Argentinos 18 21 15 26
5 Atlético Laguna Blanca Atlético 18 20 18 26
6 Libertad Formosa Libertad 18 21 29 23
7 Primero de Mayo Primero Mayo 18 25 28 22
8 Juventud Unida Charata Juventud 18 28 30 20
9 Alianza Campo Largo Alianza 18 16 25 17
10 Huracán Las Breñas Huracán 18 17 35 14
11 Deportivo Madariaga Deportivo 18 26 19 30
12 Resistencia Central Resistencia 18 27 20 29
13 Comunicaciones Comunicacion 18 24 19 29
14 Ferroviario Corrientes Ferroviario 18 28 26 26
15 Fontana Fontana 18 24 22 25
16 Huracán Goya Huracán 18 22 21 22
17 Defensores Pt. Vilelas Defensores 18 21 23 20
18 Huracán Montecarlo Huracán 18 19 30 20
19 Central Goya Central Goya 18 20 27 19
20 Villa Alvear Villa Alvear 18 16 20 18
TEMPORADA 2015/2016
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 6
Equipo PJ GF GC Puntos
1 Ferroviario Corrientes Ferroviario 10 18 17 18
2 San Martín Formosa Martín 10 17 14 16
3 Huracán Goya Huracán 10 17 11 15
4 Resistencia Central Resistencia 10 19 16 14
5 CD Comercio CD Comercio 10 14 20 10
6 Fontana Fontana 10 12 19 7
TEMPORADA 2014/2015
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 12
Equipo PJ GF GC Puntos
1 Villa Mitre Bahia Blanca Villa Mitre 6 12 6 13
2 Sansinena Sansinena 6 14 9 13
3 Germinal de Rawson Germinal 6 11 8 9
4 Boxing Club AA Boxing Club 6 9 13 9
5 Huracán de Comodoro Huracán 6 5 6 7
6 Sol de Mayo Sol de Mayo 6 9 14 5
7 Cruz del Sur Cruz 6 10 14 3
8 Ayacucho Ayacucho 6 12 7 13
9 Argentino Agropecuario Argentino 6 14 6 12
10 Def. de Pronunciamiento Def. 6 8 5 11
11 CA Liniers CA Liniers 6 4 3 9
12 Rivadavia Lincoln Rivadavia 6 5 5 9
13 El Linqueño Linqueño 6 9 10 8
14 Jorge Newbery Junín Jorge 6 6 12 4
15 Kimberley Mar del Plata Kimberley 6 3 10 3
16 Rivadavia Venado Tuerto Rivadavia 6 9 2 11
17 La Emilia La Emilia 6 8 5 11
18 Camioneros Bs As Camioneros 6 6 9 9
19 Defensores de Salto Defensores 6 4 7 8
20 Coronel Aguirre Coronel 6 5 7 5
21 Belgrano San Nicolás Belgrano 6 3 8 2
22 Estudiantes Río Cuarto Estudiantes 6 9 4 13
23 Sarmiento Leones Sarmiento 6 6 6 10
24 Jorge Newbery VM Jorge 6 10 8 9
25 Tiro Federal Morteros Tiro Federal 6 9 7 9
26 Racing Córdoba Racing 6 5 7 7
27 Deportivo Montecaseros Deportivo 6 5 7 5
28 Atlético Las Palmas Atlético 6 7 12 4
29 San Martín Mendoza Martín 6 11 7 11
30 Sportivo Desamparados Sportivo 6 9 6 9
31 Huracán San Rafael Huracán 6 8 7 9
32 Huracán Las Heras Huracán 6 7 6 9
33 Alianza Coronel Moldes Alianza 6 4 5 8
34 Trinidad San Juan Trinidad 6 5 9 5
35 Sportivo Peñarol Sportivo 6 6 10 3
36 Unión Santiago Unión 6 8 5 13
37 Club Atlético Güemes Club 6 10 4 10
38 Almirante Brown de Lules Almirante 6 6 8 10
39 9 de Julio Rafaela Julio 6 8 7 9
40 Villa Cubas Villa Cubas 6 10 10 7
41 Ben Hur Ben Hur 6 6 7 4
42 Atlético Amalia Atlético 6 9 16 4
43 Sportivo Guzmán Sportivo 6 13 4 13
44 Talleres Perico Talleres 6 11 6 13
45 Central Norte Central 6 13 4 11
46 Tabacal Orán Tabacal 6 8 6 11
47 Mitre de Salta Mitre Salta 6 5 8 7
48 Lastenia Lastenia 6 3 14 2
49 Tiro y Gimnasia San Pedro Tiro 6 7 18 1
50 Resistencia Central Resistencia 6 11 8 10
51 San Martín Formosa Martín 6 9 6 10
52 Huracán Goya Huracán 6 10 10 10
53 CD Comercio CD Comercio 6 11 8 8
54 Fontana Fontana 6 10 11 8
55 Deportivo Achirense Deportivo 6 8 8 7
56 Ex Alumnos 185 Alumnos 6 5 13 2
TEMPORADA 2013/2014
ARGENTINO B GRUPO 9
Equipo PJ GF GC Puntos
1 Sol de América Formosa América 16 27 19 30
2 Sportivo Patria Sportivo 16 17 14 29
3 Resistencia Central Resistencia 16 22 18 21
4 Independiente Fontana Independient 16 16 16 21
5 Fontana Fontana 16 19 21 21
6 Sarm.  Resistencia Sarm. 16 11 12 19
7 Ex Alumnos 185 Alumnos 16 21 25 19
8 San Martín Formosa Martín 16 11 15 18
9 Atlético Laguna Blanca Atlético 16 15 19 16
TEMPORADA 1973/1974
LIGA PROFESIONAL ARGENTINA GRUPO 4
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 18 43 14 38
2 Racing Club Racing Club 18 35 23 31
3 San Martín Tucumán Martín 18 24 18 30
4 Chacarita Juniors Chacarita 18 31 29 26
5 Aldosivi Aldosivi 18 24 30 22
6 Atlético Regina Atlético 18 13 30 15
7 CD Mandiyú CD Mandiyú 18 20 37 13
8 Godoy Cruz Godoy Cruz 18 15 35 11
9 Vélez Sarsfield Vélez 18 34 12 37
10 Independiente Independient 18 49 19 35
11 San Martín Formosa Martín 18 27 18 34
12 CA Huracán CA Huracán 18 38 24 32
13 Atl. Tucumán Atl. 18 29 26 21
14 Huracán de Comodoro Huracán 18 20 40 19
15 Chaco For Ever Chaco Ever 18 19 30 17
16 San Lorenzo Mar del Plata Lorenzo 18 21 40 14
17 Atlanta Atlanta 18 12 41 12
TEMPORADA 1971/1972
LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 13 29 6 33
2 River Plate River Plate 13 50 23 32
3 San Martín Tucumán Martín 26 37 46 32
4 Vélez Sarsfield Vélez 13 31 19 26
5 Atlanta Atlanta 13 31 15 22
6 Rosario Central Rosario 13 28 18 19
7 Independiente Independient 13 24 20 17
8 San Lorenzo Mar del Plata Lorenzo 13 24 28 17
9 Lanús Lanús 13 17 23 14
10 Gimnasia La Plata Gimnasia 14 15 26 13
11 Club Atlético Bartolomé Mit Club 13 11 36 5
12 Independiente Tandil Independient 13 10 46 3
13 Boca Juniors Boca Juniors 13 31 15 32
14 Colón Colón 13 21 16 26
15 Argentinos Juniors Argentinos 13 26 16 24
16 CA Huracán CA Huracán 12 24 19 19
17 Racing Club Racing Club 13 20 18 19
18 Banfield Banfield 12 23 24 18
19 Belgrano Belgrano 13 19 18 17
20 Ferro Carril Oeste Ferro Carril 13 20 20 16
21 Sportivo Desamparados Sportivo 13 15 25 16
22 Chacarita Juniors Chacarita 12 16 18 11
23 Gimnasia Mendoza Gimnasia 12 16 21 11
24 Estudiantes La Plata Estudiantes 13 12 25 10
25 Newell's Old Boys Newell's 12 17 26 7
TEMPORADA 1968/1969
LIGA PROFESIONAL ARGENTINA GRUPO 1
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 17 35 11 29
2 San Lorenzo San Lorenzo 17 41 18 27
3 River Plate River Plate 17 34 11 27
4 Independiente Independient 17 36 14 25
5 San Martín Tucumán Martín 34 31 71 23
6 Vélez Sarsfield Vélez 17 22 14 19
7 Quilmes Quilmes 17 35 30 19
8 Chacarita Juniors Chacarita 17 26 26 18
9 Racing Club Racing Club 17 25 20 17
10 CA Huracán CA Huracán 17 22 18 17
11 Estudiantes La Plata Estudiantes 17 26 26 16
12 Talleres Córdoba Talleres 17 22 35 14
13 Sportivo Desamparados Sportivo 17 28 38 13
14 Lanús Lanús 17 18 24 12
15 Unión Santa Fe Unión Santa 17 17 26 12
16 Platense Platense 17 25 35 10
17 San Lorenzo Mar del Plata Lorenzo 17 18 44 8

  USO DE MEMORIA  
6,249,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.1320
Total Execution Time  0.1347
  CADENA URL  
/historico/San-Martin-Formosa
  GET DATOS  
$_GET['/historico/San-Martin-Formosa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0026  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 = 'San-Martin-Formosa' 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=16779 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=16779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 75543
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16779 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16779 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (92158,1231891) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '16779' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '16779' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '16779' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 75543 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=16779 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 (75543,70412) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75543 AND teamId = 16779
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 70412 AND teamId = 16779
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 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 = 75543 AND t.round = 7 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 = '16779' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16779' and rp.type = 4
0.0019  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 = '16779' 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 = 75543 WHERE rp.league_id = 75543 AND rp.teamId = 16779 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.0024  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 = 75543 WHERE rp.league_id = 75543 AND rp.teamId = 16779 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 75543 WHERE rp.league_id = 75543 AND rp.teamId = 16779 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 = 16779 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75543 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 `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 = 71108 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.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 `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.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 = 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.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 `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.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 `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 = 49543 AND t.round = 3 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 = 45044 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 `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 = 34127 AND t.round = 14 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 `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 = 39147 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 `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 = 20291 AND t.round = 10 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 = 15588 AND t.round = 22 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 `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 `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 = 3508 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 `tables1974` 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 = 26601 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 `tables1972` 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 = 26633 AND t.round = 13 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 `tables1969` 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 = 26751 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 75543 ORDER BY nameShow LIMIT 100