4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Kansas City Kansas City 6 20 11 16
2 North Carolina Courage North 6 11 5 12
3 Washington Spirit Washington 6 11 7 12
4 Orlando Pride Orlando 6 9 6 12
5 Chicago Red Stars Fem Chicago 6 7 6 10
6 Racing Louisville FC Racing 6 10 6 8
7 Portland Thorns Fem Portland 6 12 11 7
8 San Diego Wave Diego Wave 5 4 4 7
9 Angel City Angel City 6 7 10 7
10 Bay Bay 6 10 14 6
11 Gotham FC Gotham FC 5 3 5 5
12 Houston Dash Fem Houston Dash 6 6 14 5
13 Utah Royals Utah Royals 6 4 11 4
14 OL Reign OL Reign 6 5 9 3
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 San Diego Wave Diego Wave 22 31 22 37
2 Portland Thorns Fem Portland 22 42 32 35
3 North Carolina Courage North 22 29 22 33
4 OL Reign OL Reign 22 29 24 32
5 Angel City Angel City 22 31 30 31
6 Gotham FC Gotham FC 22 25 24 31
7 Orlando Pride Orlando 22 27 28 31
8 Washington Spirit Washington 22 26 29 30
9 Racing Louisville FC Racing 22 25 24 27
10 Houston Dash Fem Houston Dash 22 16 18 26
11 Kansas City Kansas City 22 30 36 26
12 Chicago Red Stars Fem Chicago 22 28 50 24
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 OL Reign OL Reign 22 32 19 40
2 Portland Thorns Fem Portland 22 49 24 39
3 San Diego Wave Diego Wave 22 32 21 36
4 Houston Dash Fem Houston Dash 22 35 27 36
5 Kansas City Kansas City 22 29 29 36
6 Chicago Red Stars Fem Chicago 22 34 28 33
7 North Carolina Courage North 22 46 33 32
8 Angel City Angel City 22 23 27 29
9 Racing Louisville FC Racing 22 23 35 23
10 Orlando Pride Orlando 22 22 45 22
11 Washington Spirit Washington 22 26 33 19
12 Gotham FC Gotham FC 22 16 46 13
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Portland Thorns Fem Portland 24 33 17 44
2 OL Reign OL Reign 24 37 24 42
3 Washington Spirit Washington 24 29 26 39
4 Chicago Red Stars Fem Chicago 24 29 28 38
5 Gotham FC Gotham FC 24 29 21 35
6 North Carolina Courage North 24 28 23 33
7 Houston Dash Fem Houston Dash 24 31 31 32
8 Orlando Pride Orlando 24 27 32 28
9 Racing Louisville FC Racing 24 21 41 22
10 Kansas City Kansas City 24 15 36 16
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Portland Thorns Fem Portland 4 10 3 10
2 Houston Dash Fem Houston Dash 4 12 7 9
3 Washington Spirit Washington 4 5 4 7
4 Sky Blue Sky Blue 4 6 7 6
5 North Carolina Courage North 4 8 10 5
6 Chicago Red Stars Fem Chicago 4 7 7 4
7 OL Reign OL Reign 4 6 8 4
8 Orlando Pride Orlando 4 5 8 2
9 Utah Royals Utah Royals 4 3 8 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 North Carolina Courage North 24 54 23 49
2 Chicago Red Stars Fem Chicago 24 41 28 44
3 Portland Thorns Fem Portland 24 40 31 40
4 OL Reign OL Reign 24 27 27 38
5 Washington Spirit Washington 24 30 25 34
6 Utah Royals Utah Royals 24 25 25 34
7 Houston Dash Fem Houston Dash 24 21 36 26
8 Sky Blue Sky Blue 24 20 34 20
9 Orlando Pride Orlando 24 24 53 16
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 North Carolina Courage North 24 53 17 57
2 Portland Thorns Fem Portland 24 40 28 42
3 OL Reign OL Reign 24 27 19 41
4 Chicago Red Stars Fem Chicago 24 38 28 37
5 Utah Royals Utah Royals 24 22 23 35
6 Houston Dash Fem Houston Dash 24 35 39 32
7 Orlando Pride Orlando 24 30 37 30
8 Washington Spirit Washington 24 12 35 11
9 Sky Blue Sky Blue 24 21 52 9
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 North Carolina Courage North 24 38 22 49
2 Portland Thorns Fem Portland 24 37 20 47
3 Orlando Pride Orlando 24 45 31 40
4 Chicago Red Stars Fem Chicago 24 33 30 39
5 OL Reign OL Reign 24 43 37 34
6 Sky Blue Sky Blue 24 42 51 33
7 Kansas City Kansas City 24 29 31 31
8 Houston Dash Fem Houston Dash 24 23 39 24
9 Boston Breakers Boston 24 24 35 19
10 Washington Spirit Washington 24 30 48 19
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Portland Thorns Fem Portland 20 35 19 41
2 Washington Spirit Washington 20 30 21 39
3 Chicago Red Stars Fem Chicago 20 24 20 33
4 Western New York Western York 20 40 26 32
5 OL Reign OL Reign 20 29 21 30
6 Kansas City Kansas City 20 18 20 26
7 Sky Blue Sky Blue 20 24 30 26
8 Houston Dash Fem Houston Dash 20 29 29 22
9 Orlando Pride Orlando 20 20 30 19
10 Boston Breakers Boston 20 14 47 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 OL Reign OL Reign 20 41 21 43
2 Chicago Red Stars Fem Chicago 20 31 22 33
3 Kansas City Kansas City 20 32 20 32
4 Washington Spirit Washington 20 31 28 30
5 Houston Dash Fem Houston Dash 20 21 26 24
6 Portland Thorns Fem Portland 20 27 29 23
7 Western New York Western York 20 24 34 23
8 Sky Blue Sky Blue 20 22 28 22
9 Boston Breakers Boston 20 22 43 15
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 OL Reign OL Reign 23 48 19 51
2 Kansas City Kansas City 24 39 32 41
3 Portland Thorns Fem Portland 23 38 34 35
4 Washington Spirit Washington 24 36 43 35
5 Chicago Red Stars Fem Chicago 23 31 25 34
6 Sky Blue Sky Blue 24 30 37 34
7 Western New York Western York 23 41 36 28
8 Boston Breakers Boston 24 37 53 20
9 Houston Dash Fem Houston Dash 24 23 44 18
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Western New York Western York 22 36 20 38
2 Kansas City Kansas City 22 34 22 38
3 Portland Thorns Fem Portland 22 32 25 38
4 Sky Blue Sky Blue 22 31 26 36
5 Boston Breakers Boston 22 35 34 30
6 Chicago Red Stars Fem Chicago 22 32 36 30
7 OL Reign OL Reign 22 22 36 18
8 Washington Spirit Washington 22 16 39 14

  USO DE MEMORIA  
5,788,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1029
Total Execution Time  0.1050
  CADENA URL  
/nwsl2024/grupo1/historico
  GET DATOS  
$_GET['/nwsl2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'nwsl2024'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nwsl' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1885 ORDER BY order_id ASC
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1885 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 71041 AND t.round = 8 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 `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 = 67407 AND t.round = 22 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 `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 = 62301 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 55541 AND t.round = 1 ORDER BY team.conference ASC,t.position 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 `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 = 49074 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 42907 AND t.round = 11 ORDER BY team.conference 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 `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 = 38014 AND t.round = 12 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 `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 = 31448 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 38381 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 38383 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables2013` 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 = 38385 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 17:09:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-29 17:09:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-29 17:09:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-29 17:09:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0084  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75198 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75198 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0042  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75198 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75198 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75198 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75198 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  SELECT *,(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 = 75198 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC