4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 CD Olympia Las Rozas B Olympia 30 96 30 79
2 Villaviciosa de Odon Villaviciosa 30 110 27 76
3 Leganés Fem Leganés 30 91 34 65
4 Getafe Femenino B Getafe 30 69 37 63
5 Madrid CF D Madrid CF D 30 100 72 56
6 Colmenar Viejo Colmenar 30 63 54 48
7 Mostoles Urjc Mostoles 30 69 63 47
8 Alcorcón Alcorcón 30 46 71 38
9 Juventud Sanse Juventud 30 41 66 36
10 Esc. Fut. Carabanchel Esc. Fut. C. 30 51 74 35
11 Las Rozas A Las Rozas A 30 39 57 32
12 CF Pozuelo B Fem Pozuelo 30 51 72 32
13 Ciudad De Getafe A Ciudad 30 48 75 27
14 Samper B Samper B 30 56 91 26
15 Magerit Magerit 30 57 113 19
16 Masriver Masriver 30 44 95 16
17 E Olimpico de Madrid B Olimpico 0 0 0 0
18 UD Tres Cantos Fem Tres Cantos 0 0 0 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Futbolellas CFF Fem Futbolellas 34 125 22 90
2 Las Rozas A Las Rozas A 34 127 27 85
3 Leganés Fem Leganés 34 127 48 80
4 Colmenar Viejo Colmenar 34 79 40 63
5 Mostoles Urjc Mostoles 34 70 55 53
6 Alcorcón Alcorcón 34 60 44 52
7 Villaviciosa de Odon Villaviciosa 34 64 54 52
8 CF Pozuelo B Fem Pozuelo 34 58 61 52
9 Getafe Femenino B Getafe 34 64 69 48
10 Fuenlabrada Fuenlabrada 34 65 79 46
11 Samper B Samper B 34 58 65 43
12 Magerit Magerit 34 54 76 43
13 E Olimpico de Madrid B Olimpico 34 59 77 41
14 Juventud Sanse Juventud 34 49 72 38
15 Electrocor Las Rozas Electrocor 34 46 84 33
16 Cantera Cantera 34 54 106 29
17 Fundacion Rayo Vallecano Fundacion 34 49 94 28
18 AD Torrejón Femenino Torrejón 34 3 138 0
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Real Madrid B Fem Real Madrid 19 124 11 55
2 Olympia Las Rozas Fem Olympia 20 94 16 54
3 Colmenar Viejo Colmenar 20 72 14 52
4 Las Rozas A Las Rozas A 20 52 27 41
5 Fuenlabrada Fuenlabrada 20 46 31 38
6 Mostoles Urjc Mostoles 20 50 27 36
7 Leganés Fem Leganés 20 57 34 35
8 CF Pozuelo B Fem Pozuelo 20 48 24 34
9 E Olimpico de Madrid B Olimpico 20 53 30 32
10 Alcorcón Alcorcón 20 40 27 32
11 Fundacion Rayo Vallecano Fundacion 20 57 52 28
12 Electrocor Electrocor 20 40 44 27
13 Magerit Magerit 20 34 48 25
14 AD Torrejón Femenino Torrejón 20 33 39 23
15 Atletico de Pinto Atletico 20 42 65 23
16 EF Arganda EF Arganda 20 30 81 18
17 Tres Cantos B Tres Cantos 19 28 62 13
18 Cff Sur Getafe Getafe 20 24 81 11
19 EF Valdemoro Valdemoro 20 16 81 7
20 Colonia Moscardo Colonia 20 23 90 7
21 Valdemoro Club de Futbol Valdemoro 20 25 104 4
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Madrid CF C Fem Madrid 21 60 13 53
2 CF Pozuelo B Fem Pozuelo 23 57 29 53
3 Olympia Las Rozas Fem Olympia 23 82 32 51
4 Colmenar Viejo Colmenar 22 54 21 48
5 AD Torrejón Femenino Torrejón 22 58 23 43
6 Las Rozas A Las Rozas A 23 56 23 42
7 Alcorcón Alcorcón 23 46 32 39
8 Fundacion Rayo Vallecano Fundacion 23 41 39 37
9 Tres Cantos B Tres Cantos 23 43 35 34
10 Magerit Magerit 23 40 31 31
11 Fuenlabrada Fuenlabrada 23 44 66 31
12 E Olimpico de Madrid B Olimpico 23 39 52 28
13 Cff Sur Getafe Getafe 23 35 43 26
14 Mostoles Urjc Mostoles 23 37 38 25
15 Atletico de Pinto Atletico 23 25 46 20
16 Valdemoro Club de Futbol Valdemoro 23 28 63 19
17 Colonia Moscardo Colonia 23 22 94 6
18 Club Polideportivo Parla Es Club 23 2 89 1
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 At. de Madrid Fem Madrid 34 158 29 90
2 Union Deportiva Tres Cantos Union 34 86 25 85
3 Samper A Samper A 34 108 38 82
4 Las Rozas A Las Rozas A 34 95 63 71
5 Vallecas A Vallecas A 34 81 41 62
6 Colmenar Viejo Colmenar 34 80 52 62
7 Magerit Magerit 34 81 51 58
8 CF Pozuelo B Fem Pozuelo 34 59 39 56
9 Mostoles Urjc Mostoles 34 74 77 42
10 Fundacion Rayo Vallecano Fundacion 34 80 96 42
11 E Olimpico de Madrid B Olimpico 34 58 84 40
12 Fuenlabrada Fuenlabrada 34 43 76 35
13 Cff Sur Getafe Getafe 34 52 98 34
14 Alhondiga B Alhondiga B 34 52 94 33
15 Juventud Sanse Juventud 34 56 76 30
16 Villaconejos Villaconejos 34 55 114 27
17 Escfut El Olivo Coslada A Escfut Olivo 34 44 117 19
18 Escfutfem Alcobendas A Escfutfem 34 26 118 8
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Madrid Femenino B Madrid 33 138 30 87
2 At. de Madrid Fem Madrid 34 130 22 86
3 Union Deportiva Tres Cantos Union 34 126 34 86
4 Juventud Sanse Juventud 34 88 58 60
5 Escfutfem Alcobendas A Escfutfem 34 93 61 58
6 CF Pozuelo B Fem Pozuelo 34 60 43 56
7 Samper A Samper A 34 69 52 51
8 Ady C Pinto Ady C Pinto 34 75 80 51
9 E Olimpico de Madrid B Olimpico 34 64 68 48
10 Magerit Magerit 34 88 98 48
11 Cff Sur Getafe Getafe 34 95 87 47
12 Alhondiga B Alhondiga B 34 53 99 34
13 Mostoles Urjc Mostoles 34 41 92 33
14 Racing Parla Humans Racing Parla 34 32 90 31
15 Spartac de Manoteras Spartac 34 43 79 28
16 Masriver Masriver 33 41 104 28
17 Atletico Cañada Alcorcon Atletico 34 46 110 26
18 Las Rozas A Las Rozas A 34 26 101 16
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 At. de Madrid Fem Madrid 33 151 22 85
2 Vallecas A Vallecas A 33 150 29 84
3 Union Deportiva Tres Cantos Union 32 126 29 76
4 Madrid Femenino B Madrid 32 134 38 75
5 Samper A Samper A 34 102 41 69
6 Magerit Magerit 33 99 57 63
7 Escfutfem Alcobendas A Escfutfem 34 108 49 59
8 Olimpico de Moratalaz B Olimpico 34 91 83 58
9 Mostoles Urjc Mostoles 34 60 73 40
10 Las Rozas A Las Rozas A 32 40 58 39
11 CF Pozuelo B Fem Pozuelo 34 41 65 38
12 Racing Parla Racing Parla 33 53 91 36
13 Spartac de Manoteras Spartac 33 32 53 33
14 Ady C Pinto Ady C Pinto 34 54 125 29
15 EF Valdemoro Valdemoro 34 38 86 27
16 Camarma Camarma 33 34 108 23
17 Seseña Futbol Base Seseña 33 29 134 14
18 At. Torrejon de Ardoz Torrejon 31 19 220 3
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Atlético de Madrid Feminas Atlético 32 96 19 83
2 Madrid CF Femenino B Madrid 32 106 34 78
3 Cff Sur Getafe Getafe 32 88 34 75
4 Olímpico de Madrid Fem Olímpico 32 90 38 69
5 Mostoles Urjc Mostoles 32 80 50 64
6 Vallecas Vallecas 32 79 38 59
7 Alcobendas A Alcobendas 32 57 49 48
8 Spartac de Manoteras Spartac 32 54 67 44
9 Tres Cantos B Tres Cantos 32 72 71 43
10 Las Rozas A Las Rozas A 32 50 59 39
11 Pozuelo de Alarcón B Pozuelo 32 51 60 38
12 Seseña Futbol Base Seseña 32 47 66 32
13 At. Torrejon de Ardoz Torrejon 32 48 109 31
14 Racing Parla CD Racing Parla 32 46 77 27
15 Inter Valdemoro Inter 32 41 78 24
16 CDAV San Nicasio Femenino CDAV Nicasio 32 27 98 11
17 Avance Avance 32 23 108 8

  USO DE MEMORIA  
6,047,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4972
Total Execution Time  0.4994
  CADENA URL  
/preferente_madrid_femenino2023/grupo1/historico
  GET DATOS  
$_GET['/preferente_madrid_femenino2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0144  SELECT type FROM routes WHERE alias = 'preferente_madrid_femenino2023'
0.0298  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'preferente_madrid_femenino' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=742 AND type_rel = 3
0.0144  SELECT id,name,alias,stepParent FROM categories WHERE parentId=742 ORDER BY order_id ASC
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 742 GROUP BY l.categoryId
0.0145  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=742 GROUP BY l.year ORDER BY l.year DESC
0.0146  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 68939 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 742 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0150  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 = 68939 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 65055 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 61253 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 55300 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 35126 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 19614 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 4707 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:36:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:36:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:36:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:36:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'preferente_madrid_femenino' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  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 events2023 e ON e.player_id = p.id AND e.league_id = 68939 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68939 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.0155  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 events2023 e ON e.player_id = p.id AND e.league_id = 68939 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68939 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  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 events2023 e ON e.player_id = p.id AND e.league_id = 68939 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68939 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0204  SELECT *,(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 = 68939 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC