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

Charlotte FC

Entrenador: Dean Smith

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

  USO DE MEMORIA  
5,752,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3774
Total Execution Time  0.3786
  CADENA URL  
/historico/Charlotte-Mls
  GET DATOS  
$_GET['/historico/Charlotte-Mls']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=137770 AND type_rel = 2
0.0138  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 = '137770' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 74856 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=137770 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 74856 AND teamId = 137770
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71035 AND teamId = 137770
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 75358 AND teamId = 137770
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 137770
0.0133  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 = '137770' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '137770' and rp.type = 4
0.0136  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 = '137770' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0170  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 = 137770 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.0168  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 = 137770 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 137770 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 137770 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140  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.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 `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