4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Los Angeles FC

Los Angeles FC

Entrenador: Steve Cherundolo

Temporada 2023/2024
TEMPORADA 2023/2024
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Inter Miami Inter Miami 11 22 16 18
2 New York RB New York RB 10 13 9 17
3 Cincinnati Cincinnati 10 10 8 16
4 Columbus Crew Columbus 10 12 9 15
5 Philadelphia Union Philadelphia 8 14 9 14
6 Charlotte FC Charlotte 10 10 11 14
7 Toronto FC Toronto FC 10 9 12 14
8 CF Montréal Montréal 9 12 16 12
9 Atlanta United Atlanta 8 13 9 11
10 New York City York City 10 9 10 11
11 DC United DC United 10 12 14 11
12 Orlando City Orlando City 9 10 15 10
13 Chicago Fire Chicago Fire 9 11 18 9
14 Nashville SC Nashville 8 9 16 7
15 New England Revolution England 9 6 14 7
16 LA Galaxy LA Galaxy 10 21 17 18
17 Vancouver Whitecaps Vancouver 9 17 9 17
18 Real Salt Lake Real Salt L. 10 15 8 16
19 Colorado Rapids Colorado 10 15 13 16
20 Austin FC Austin FC 10 14 13 15
21 Minnesota United Minnesota 8 13 9 14
22 Houston Dynamo Houston 8 9 8 13
23 Los Angeles FC Angeles 9 15 14 12
24 St. Louis City Louis City 9 15 14 12
25 Sporting Kansas City Sporting 9 17 16 11
26 Portland Timbers Portland 9 18 18 10
27 Seattle Sounders Seattle 9 9 9 7
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

  USO DE MEMORIA  
6,793,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1035
Total Execution Time  0.1047
  CADENA URL  
/historico/Los-Angeles-Football-Club
  GET DATOS  
$_GET['/historico/Los-Angeles-Football-Club']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=99747 AND type_rel = 2
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 99747 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 (274522,273422,273958,272396,274157) ORDER BY n.cover_points DESC, update_date 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 = '99747' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=99747 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75531,75359,74856,72352,71432,70474) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74856 AND teamId = 99747
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 75531 AND teamId = 99747
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70474 AND teamId = 99747
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75359 AND teamId = 99747
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72352 AND teamId = 99747
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 99747
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 = '99747' 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 = '99747' and rp.type = 4
0.0020  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 = '99747' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 99747 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.0027  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 = 99747 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 99747 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 99747 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0042  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.0039  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.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 `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.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 `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.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 `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.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 `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.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 = 42029 AND t.round = 39 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC