4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Orlando City

Orlando City

Entrenador: Óscar Pareja

Temporada 2023/2024
TEMPORADA 2023/2024
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Inter Miami Inter Miami 10 22 15 18
2 New York RB New York RB 9 13 9 16
3 Cincinnati Cincinnati 9 10 8 15
4 Columbus Crew Columbus 9 12 9 14
5 Philadelphia Union Philadelphia 7 14 9 13
6 Toronto FC Toronto FC 9 9 12 13
7 Atlanta United Atlanta 8 13 9 11
8 New York City York City 9 9 9 11
9 Charlotte FC Charlotte 9 9 11 11
10 CF Montréal Montréal 8 12 16 11
11 DC United DC United 9 12 14 10
12 Orlando City Orlando City 8 10 15 9
13 Chicago Fire Chicago Fire 9 11 18 9
14 Nashville SC Nashville 8 9 16 7
15 New England Revolution England 8 5 14 4
16 LA Galaxy LA Galaxy 9 21 15 18
17 Vancouver Whitecaps Vancouver 8 17 9 16
18 Real Salt Lake Real Salt L. 9 15 8 15
19 Colorado Rapids Colorado 9 15 13 15
20 Minnesota United Minnesota 8 13 9 14
21 Houston Dynamo Houston 8 9 8 13
22 Los Angeles FC Angeles 9 15 14 12
23 St. Louis City Louis City 9 15 14 12
24 Austin FC Austin FC 9 12 13 12
25 Sporting Kansas City Sporting 9 17 16 11
26 Portland Timbers Portland 9 18 18 10
27 Seattle Sounders Seattle 8 9 9 6
28 FC Dallas FC Dallas 8 7 12 5
29 San Jose Earthquakes Jose 9 13 24 3
TEMPORADA 2022/2023
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Cincinnati Cincinnati 34 57 39 69
2 Orlando City Orlando City 34 55 39 63
3 Columbus Crew Columbus 34 67 46 57
4 Philadelphia Union Philadelphia 34 57 41 55
5 New England Revolution England 34 58 46 55
6 Atlanta United Atlanta 34 66 53 51
7 Nashville SC Nashville 34 39 32 49
8 New York RB New York RB 34 36 39 43
9 Charlotte FC Charlotte 34 45 52 43
10 CF Montréal Montréal 34 36 52 41
11 New York City York City 34 35 39 41
12 DC United DC United 34 45 49 40
13 Chicago Fire Chicago Fire 34 39 51 40
14 Inter Miami Inter Miami 34 41 54 34
15 Toronto FC Toronto FC 34 26 59 22
16 St. Louis City Louis City 33 62 43 56
17 Los Angeles FC Angeles 33 53 38 51
18 Houston Dynamo Houston 34 51 38 51
19 Real Salt Lake Real Salt L. 34 48 50 50
20 Seattle Sounders Seattle 33 39 32 50
21 Vancouver Whitecaps Vancouver 33 54 47 47
22 FC Dallas FC Dallas 34 41 37 46
23 San Jose Earthquakes Jose 34 39 43 44
24 Portland Timbers Portland 34 46 58 43
25 Sporting Kansas City Sporting 33 45 50 41
26 Minnesota United Minnesota 33 45 48 41
27 Austin FC Austin FC 34 49 55 39
28 LA Galaxy LA Galaxy 34 51 67 36
29 Colorado Rapids Colorado 34 26 54 27
TEMPORADA 2021/2022
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Philadelphia Union Philadelphia 34 72 26 67
2 CF Montréal Montréal 34 63 50 65
3 New York City York City 34 57 41 55
4 New York RB New York RB 34 50 41 53
5 Cincinnati Cincinnati 34 64 56 49
6 Inter Miami Inter Miami 34 47 56 48
7 Orlando City Orlando City 34 44 53 48
8 Columbus Crew Columbus 34 46 41 46
9 Charlotte FC Charlotte 34 44 52 42
10 New England Revolution England 34 47 50 42
11 Atlanta United Atlanta 34 48 54 40
12 Chicago Fire Chicago Fire 34 39 48 39
13 Toronto FC Toronto FC 34 49 66 34
14 DC United DC United 34 36 71 27
15 Los Angeles FC Angeles 34 66 38 67
16 Austin FC Austin FC 34 65 49 56
17 FC Dallas FC Dallas 34 48 37 53
18 LA Galaxy LA Galaxy 34 58 51 50
19 Nashville SC Nashville 34 52 41 50
20 Minnesota United Minnesota 34 48 51 48
21 Real Salt Lake Real Salt L. 34 43 45 47
22 Portland Timbers Portland 34 53 53 46
23 Vancouver Whitecaps Vancouver 34 40 57 43
24 Colorado Rapids Colorado 34 46 57 43
25 Seattle Sounders Seattle 34 47 46 41
26 Sporting Kansas City Sporting 34 42 54 40
27 Houston Dynamo Houston 34 43 56 36
28 San Jose Earthquakes Jose 34 52 69 35
TEMPORADA 2020/2021
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New England Revolution England 34 65 41 73
2 Philadelphia Union Philadelphia 34 48 35 54
3 Nashville SC Nashville 34 55 33 54
4 New York City York City 34 56 36 51
5 Atlanta United Atlanta 34 45 37 51
6 Orlando City Orlando City 34 50 48 51
7 New York RB New York RB 34 39 33 48
8 DC United DC United 34 56 54 47
9 Columbus Crew Columbus 34 46 45 47
10 CF Montréal Montréal 34 46 44 46
11 Inter Miami Inter Miami 34 36 53 41
12 Chicago Fire Chicago Fire 34 36 54 34
13 Toronto FC Toronto FC 34 39 66 28
14 Cincinnati Cincinnati 34 37 74 20
15 Colorado Rapids Colorado 34 51 35 61
16 Seattle Sounders Seattle 34 53 33 60
17 Sporting Kansas City Sporting 34 58 40 58
18 Portland Timbers Portland 34 56 52 55
19 Minnesota United Minnesota 34 42 44 49
20 Vancouver Whitecaps Vancouver 34 45 45 49
21 Real Salt Lake Real Salt L. 34 55 54 48
22 LA Galaxy LA Galaxy 34 50 54 48
23 Los Angeles FC Angeles 34 53 51 45
24 San Jose Earthquakes Jose 34 46 54 41
25 FC Dallas FC Dallas 34 47 56 33
26 Austin FC Austin FC 34 35 56 31
27 Houston Dynamo Houston 34 36 54 30
TEMPORADA 2019/2020
MLS - LIGA USA GRUPO 2
Equipo PJ GF GC Puntos
1 Orlando City Orlando City 3 6 3 7
2 Philadelphia Union Philadelphia 3 4 2 7
3 New York City York City 3 2 4 3
4 Inter Miami Inter Miami 3 2 5 0
5 San Jose Earthquakes Jose 3 6 3 7
6 Seattle Sounders Seattle 3 4 2 4
7 Vancouver Whitecaps Vancouver 3 5 7 3
8 Chicago Fire Chicago Fire 3 2 5 3
9 Toronto FC Toronto FC 3 6 5 5
10 New England Revolution England 3 2 1 5
11 CF Montréal Montréal 3 4 5 3
12 DC United DC United 3 3 4 2
13 Sporting Kansas City Sporting 3 6 4 6
14 Minnesota United Minnesota 3 4 3 5
15 Real Salt Lake Real Salt L. 3 2 2 4
16 Colorado Rapids Colorado 3 4 7 1
17 Columbus Crew Columbus 3 7 0 9
18 Cincinnati Cincinnati 3 3 4 6
19 New York RB New York RB 3 1 4 3
20 Atlanta United Atlanta 3 0 3 0
21 Portland Timbers Portland 3 6 4 7
22 Los Angeles FC Angeles 3 11 7 5
23 Houston Dynamo Houston 3 5 6 2
24 LA Galaxy LA Galaxy 3 4 9 1
TEMPORADA 2018/2019
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New York City York City 34 63 42 64
2 Atlanta United Atlanta 34 58 43 58
3 Philadelphia Union Philadelphia 34 58 50 55
4 Toronto FC Toronto FC 34 57 52 50
5 DC United DC United 34 42 38 50
6 New York RB New York RB 34 53 51 48
7 New England Revolution England 34 50 57 45
8 Chicago Fire Chicago Fire 34 55 47 42
9 CF Montréal Montréal 34 47 60 41
10 Columbus Crew Columbus 34 39 47 38
11 Orlando City Orlando City 34 44 52 37
12 Cincinnati Cincinnati 34 31 75 24
13 Los Angeles FC Angeles 34 85 37 72
14 Seattle Sounders Seattle 34 52 49 56
15 Minnesota United Minnesota 34 52 43 53
16 Real Salt Lake Real Salt L. 34 46 41 53
17 LA Galaxy LA Galaxy 34 58 59 51
18 Portland Timbers Portland 34 52 49 49
19 FC Dallas FC Dallas 34 54 46 48
20 San Jose Earthquakes Jose 34 52 55 44
21 Colorado Rapids Colorado 34 58 63 42
22 Houston Dynamo Houston 34 49 59 40
23 Sporting Kansas City Sporting 34 49 67 38
24 Vancouver Whitecaps Vancouver 34 37 59 34
TEMPORADA 2017/2018
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New York RB New York RB 34 62 33 71
2 Atlanta United Atlanta 34 70 44 69
3 New York City York City 34 59 45 56
4 DC United DC United 34 60 50 51
5 Columbus Crew Columbus 34 43 45 51
6 Philadelphia Union Philadelphia 34 49 50 50
7 CF Montréal Montréal 34 47 53 46
8 New England Revolution England 34 49 55 41
9 Toronto FC Toronto FC 34 59 64 36
10 Chicago Fire Chicago Fire 34 48 61 32
11 Orlando City Orlando City 34 43 74 28
12 Sporting Kansas City Sporting 34 65 40 62
13 Seattle Sounders Seattle 34 52 37 59
14 Los Angeles FC Angeles 34 68 52 57
15 FC Dallas FC Dallas 34 52 44 57
16 Portland Timbers Portland 34 54 48 54
17 Real Salt Lake Real Salt L. 34 55 58 49
18 LA Galaxy LA Galaxy 34 66 64 48
19 Vancouver Whitecaps Vancouver 34 54 67 47
20 Houston Dynamo Houston 34 58 58 38
21 Minnesota United Minnesota 34 49 71 36
22 Colorado Rapids Colorado 34 36 63 31
23 San Jose Earthquakes Jose 34 49 71 21
TEMPORADA 2016/2017
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Toronto FC Toronto FC 34 74 37 69
2 New York City York City 34 56 43 57
3 Chicago Fire Chicago Fire 34 61 47 55
4 Atlanta United Atlanta 34 70 40 55
5 Columbus Crew Columbus 34 53 49 54
6 New York RB New York RB 34 53 47 50
7 New England Revolution England 34 53 61 45
8 Philadelphia Union Philadelphia 34 50 47 42
9 CF Montréal Montréal 34 52 58 39
10 Orlando City Orlando City 34 39 58 39
11 DC United DC United 34 31 60 32
12 Portland Timbers Portland 34 60 50 53
13 Seattle Sounders Seattle 34 52 39 53
14 Vancouver Whitecaps Vancouver 34 50 49 52
15 Houston Dynamo Houston 34 57 45 50
16 Sporting Kansas City Sporting 34 40 29 49
17 San Jose Earthquakes Jose 34 39 60 46
18 FC Dallas FC Dallas 34 48 48 46
19 Real Salt Lake Real Salt L. 34 49 55 45
20 Minnesota United Minnesota 34 47 70 36
21 Colorado Rapids Colorado 34 31 51 33
22 LA Galaxy LA Galaxy 34 45 67 32
TEMPORADA 2015/2016
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New York RB New York RB 34 61 44 57
2 New York City York City 34 62 57 54
3 Toronto FC Toronto FC 34 51 39 53
4 DC United DC United 34 53 47 46
5 CF Montréal Montréal 34 49 53 45
6 Philadelphia Union Philadelphia 34 52 55 42
7 New England Revolution England 34 44 54 42
8 Orlando City Orlando City 34 55 60 41
9 Columbus Crew Columbus 34 50 58 36
10 Chicago Fire Chicago Fire 34 42 58 31
11 FC Dallas FC Dallas 34 50 40 60
12 Colorado Rapids Colorado 34 39 32 58
13 LA Galaxy LA Galaxy 34 54 39 52
14 Seattle Sounders Seattle 34 44 43 48
15 Sporting Kansas City Sporting 34 42 41 47
16 Real Salt Lake Real Salt L. 34 44 46 46
17 Portland Timbers Portland 34 48 53 44
18 Vancouver Whitecaps Vancouver 34 45 52 39
19 San Jose Earthquakes Jose 34 32 40 38
20 Houston Dynamo Houston 34 39 45 34
TEMPORADA 2014/2015
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New York RB New York RB 34 62 43 60
2 Columbus Crew Columbus 34 58 53 53
3 CF Montréal Montréal 34 48 44 51
4 DC United DC United 34 43 45 51
5 New England Revolution England 34 48 47 50
6 Toronto FC Toronto FC 34 58 58 49
7 Orlando City Orlando City 34 46 56 44
8 New York City York City 34 49 58 37
9 Philadelphia Union Philadelphia 34 42 55 37
10 Chicago Fire Chicago Fire 34 43 58 30
11 FC Dallas FC Dallas 34 52 39 60
12 Vancouver Whitecaps Vancouver 34 45 36 53
13 Portland Timbers Portland 34 41 39 53
14 LA Galaxy LA Galaxy 34 56 43 52
15 Seattle Sounders Seattle 34 44 36 51
16 Sporting Kansas City Sporting 34 48 45 51
17 San Jose Earthquakes Jose 34 41 39 47
18 Houston Dynamo Houston 34 42 49 42
19 Real Salt Lake Real Salt L. 34 35 48 39
20 Colorado Rapids Colorado 34 33 43 37
TEMPORADA 2013/2014
USL CHAMPIONSHIP - USA
Equipo PJ GF GC Puntos
1 LA Galaxy II Galaxy 2 4 2 4
2 Charleston Battery Charleston 2 3 3 2
3 Orlando City Orlando City 2 2 2 2
4 Richmond Kickers Richmond 1 2 2 1
5 Pittsburgh Riverhounds Pittsburgh 1 1 1 1
6 Sacramento Republic Sacramento 1 1 1 1
7 Charlotte Eagles Charlotte 0 0 0 0
8 OKC Energy OKC Energy 0 0 0 0
9 Penn FC Penn FC 0 0 0 0
10 Phoenix Rising Phoenix 0 0 0 0
11 Rochester New York Rochester 0 0 0 0
12 Wilmington Hammerheads Wilmington 0 0 0 0
13 Orange County SC Orange 1 1 3 0
14 Dayton Dutch Lions Dayton Dutch 1 0 3 0
15 FC Dallas Reservas Dallas 2 4 0 6
16 New York RB Reservas York 2 4 2 3
17 Chicago Fire Reservas Chicago Fire 1 2 1 3
18 Montreal Impact II Montreal 1 0 2 0
19 Colorado Rapid Reservas Colorado 0 0 0 0
20 Real Salt Lake Reservas Real Salt L. 0 0 0 0
21 Seattle Sounders II Seattle 0 0 0 0
22 Chivas USA Reservas Chivas 1 0 2 0
TEMPORADA 2011/2012
USL CHAMPIONSHIP - USA
Equipo PJ GF GC Puntos
1 Orlando City Orlando City 24 50 18 57
2 Rochester New York Rochester 24 27 23 41
3 Penn FC Penn FC 24 35 29 38
4 Wilmington Hammerheads Wilmington 24 35 32 38
5 Charlotte Eagles Charlotte 24 34 26 36
6 Richmond Kickers Richmond 24 31 28 36
7 Charleston Battery Charleston 23 33 26 35
8 Orange County SC Orange 24 26 30 28
9 Dayton Dutch Lions Dayton Dutch 24 20 29 22
10 Pittsburgh Riverhounds Pittsburgh 24 20 39 17
11 Antigua Barracuda Antigua 23 16 47 16
TEMPORADA 2010/2011
USL CHAMPIONSHIP - USA
Equipo PJ GF GC Puntos
1 Wilmington Hammerheads Wilmington 24 42 30 45
2 FC New York FC New York 24 27 37 25
3 Orlando City Orlando City 23 34 14 50
4 Richmond Kickers Richmond 24 35 21 41
5 Charleston Battery Charleston 24 24 25 35
6 Charlotte Eagles Charlotte 24 31 30 30
7 Antigua Barracuda Antigua 18 18 29 14
8 Rochester New York Rochester 24 31 23 40
9 Penn FC Penn FC 24 37 30 37
10 Orange County SC Orange 21 27 25 29
11 Pittsburgh Riverhounds Pittsburgh 24 23 32 27
12 Dayton Dutch Lions Dayton Dutch 24 21 54 12

  USO DE MEMORIA  
7,648,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4948
Total Execution Time  0.4961
  CADENA URL  
/historico/Orlando-City-Us
  GET DATOS  
$_GET['/historico/Orlando-City-Us']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0162  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 = '17824' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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=17824 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136  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 (75358,74866,74856,71432,71035) 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.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 74856 AND teamId = 17824
0.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 71035 AND teamId = 17824
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 74866 AND teamId = 17824
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 75358 AND teamId = 17824
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17824
0.0162  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 = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 17824 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.0149  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 = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 17824 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 17824 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 17824 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0137  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 = 74856 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0259  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 = 70768 AND t.round = 35 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 `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 = 66172 AND t.round = 48 ORDER BY team.conference ASC,t.position 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 `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 = 60903 AND t.round = 46 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 `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 = 51829 AND t.round = 25 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 = 56783 AND t.round = 3 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 `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 = 48587 AND t.round = 41 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 `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 = 42029 AND t.round = 39 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 `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 = 37668 AND t.round = 38 ORDER BY team.conference 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 `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 = 20168 AND t.round = 34 ORDER BY team.conference 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 `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 = 9057 AND t.round = 34 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 `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 = 14027 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 `tables2012` 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 = 14045 AND t.round = 21 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 `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 = 14046 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC