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

Atlanta United

Entrenador: Gonzalo Pineda

Temporada 2020/2021
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

  USO DE MEMORIA  
6,173,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.1457
Total Execution Time  0.1481
  CADENA URL  
/historico/Atlanta-United-Fc/2021
  GET DATOS  
$_GET['/historico/Atlanta-United-Fc/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0063  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 = 'Atlanta-United-Fc' AND l.year = 2021 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=89624 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=89624 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=89624 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=89624 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=89624 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 60903
0.0029  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 = 65845
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89624 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 89624 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (107482,110609,112028,114917,115495) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '89624' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '89624' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 61285 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 65845 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=89624 AND l.year in (2020,2021,2022) 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 (66773,66172,62807,61285) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 66172 AND teamId = 89624
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 66773 AND teamId = 89624
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 61285 AND teamId = 89624
0.0242  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 89624
0.0042  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 events2021 e ON e.player_id = p.id AND e.league_id = 60903 WHERE rp.league_id = 60903 AND rp.teamId = 89624 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.0039  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 events2021 e ON e.player_id = p.id AND e.league_id = 60903 WHERE rp.league_id = 60903 AND rp.teamId = 89624 AND (e.action = 4 or e.action = 5) 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 events2021 e ON e.player_id = p.id AND e.league_id = 60903 WHERE rp.league_id = 60903 AND rp.teamId = 89624 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 89624 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0030  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.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 `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.0031  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.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 `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