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 Calasanz Pozuelo B Calasanz 22 84 18 55
2 EFMO Boadilla EFMO 21 91 20 54
3 Aravaca B Aravaca B 22 70 18 54
4 Club Fuentelarreyna B Club 22 54 50 38
5 IE University Athletics University 21 66 41 31
6 International Soccer Promis Internationa 21 74 48 29
7 San Fernando Escolapios Fernando 21 46 41 29
8 Aupa Mentema Boadilla B Aupa Mentema 22 61 65 28
9 Fundacion B Fundacion B 21 54 64 27
10 Escuela Europea Escuela 21 47 79 17
11 Nuevo Boadilla C Nuevo 22 10 111 4
12 CD Boca CD Boca 22 29 131 4
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Masriver Masriver 34 127 23 95
2 Club San Agustin Club Agustin 34 100 45 82
3 Inter del Pilar Inter Pilar 34 115 49 77
4 Celtic Castilla CF B Celtic 34 112 43 75
5 Ntra.Sra. del Buen Consejo Ntra.Sra. 34 127 52 70
6 Spartac de Manoteras C Spartac 34 103 77 55
7 Club Fuentelarreyna B Club 34 88 59 54
8 Lacoma Lacoma 34 80 53 54
9 Santa Elena Santa Elena 34 88 68 50
10 Fuente El Saz B Fuente 34 69 91 43
11 Rayo del Pilar Rayo Pilar 34 86 88 41
12 CD Alpedrete B Alpedrete 34 74 78 41
13 Conde Orgaz Conde Orgaz 34 66 62 37
14 CDE Malasaña Malasaña 34 84 105 37
15 Sporting Club Madrid Sporting 34 73 84 35
16 Rupe Sahagun B Rupe Sahagun 34 65 105 30
17 Alonso Cano B Alonso Cano 34 42 218 8
18 Madrid Olimpo Madrid 34 33 232 4
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Escuder San Pascual A Escuder 34 112 47 82
2 Escuela Deportiva Moratalaz Escuela 34 101 46 80
3 AD San Pascual-Montpellier Pascual-Mont 34 114 60 75
4 Alameda de Osuna EF B Alameda 34 107 54 71
5 Alcobendas Chamartin C Alcobendas 34 104 57 69
6 Conde Orgaz B Conde Orgaz 34 90 67 59
7 Guindalera B Guindalera 34 76 74 58
8 Spartac de Manoteras C Spartac 34 100 77 54
9 Amisport B Amisport B 34 92 70 52
10 Olímpico Las Rosas Olímpico 34 62 73 41
11 Sporting Valdebernardo B Sporting 34 69 113 37
12 Cde Poligono H San Blas Poligono 34 72 109 33
13 Esc. Deportiva Almudena B Esc. 34 74 99 32
14 Colegio Alameda de Osuna B Colegio 34 74 108 31
15 Liceo Sport Liceo Sport 34 46 97 25
16 EDM San Blas B Blas 34 61 111 24
17 Inter Las Rosas Almadraba Inter Rosas 34 64 111 23
18 Racing San Blas Racing Blas 34 58 103 19
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Inter de Valdemoro B Inter 17 57 16 46
2 Ancora Aranjuez B Ancora 17 42 22 43
3 Iberia Torrejon Iberia 17 46 11 40
4 Atlético De Pinto B Atlético 17 54 23 39
5 San Martin de la Vega Martin Vega 17 41 29 30
6 EM Torrejón de la Calzada Torrejón 17 31 24 30
7 CDE Anibal CDE Anibal 17 48 42 29
8 Ivero A Ivero A 17 33 34 27
9 Racing Calypso Racing 17 38 37 22
10 Sergio Panchon y Antonio Lo Sergio 17 30 35 20
11 Deportivo Naburo Deportivo 17 30 40 18
12 Unión 2000 Unión 2000 17 21 34 17
13 CF Inter Vicalvaro Inter 17 32 39 16
14 AD y C Pinto Pinto 17 18 36 15
15 Atlético Sur Atlético 17 26 55 15
16 CD Atl. Valdemoro 1966 Atl. 17 22 33 14
17 EF Valdemoro B Valdemoro 17 19 52 13
18 Parla C Parla C 17 7 33 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Los Rosales Los Rosales 23 70 30 54
2 La Chimenea La Chimenea 23 51 25 54
3 San Cristobal de los Ángele Cristobal 23 78 38 50
4 CD Alzola-Halcones B Alzola-Halco 23 75 21 49
5 UD Usera B UD Usera B 23 71 49 47
6 Santander CF Santander 22 45 30 43
7 Parque Arganzuela Parque 22 65 40 39
8 Orcasitas B Orcasitas B 23 62 48 38
9 Ciudad Los Angeles B Ciudad 23 52 29 36
10 Racing Villaverde B Racing 23 59 41 35
11 Casa de Canarias Casa 21 48 39 34
12 Inter Promesas Inter 23 62 72 29
13 Atletico Vallecas B Atletico 23 55 63 24
14 Balonmano Villaverde Balonmano 22 50 74 24
15 CD Union Huaral Union Huaral 22 42 74 14
16 Orcavilla Orcavilla 23 24 105 10
17 La Mancha B La Mancha B 23 20 79 7
18 ADC Fermin B Fermin 23 17 89 4
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Alcorcón C Alcorcón C 32 130 29 78
2 Estudiantes Alcorcon Estudiantes 32 98 32 74
3 Parque Picasso Parque 32 88 30 72
4 Peña Amistad Peña 32 112 36 68
5 Municipal Arroyomolinos Municipal 32 116 41 65
6 Arroyoculebro Arroyoculebr 32 90 71 58
7 CDAV San Nicasio A CDAV Nicasio 32 74 66 51
8 Navas del Rey Navas 32 72 75 48
9 Chapineria Chapineria 32 68 61 45
10 Nuevo Boadilla B Nuevo 32 83 87 45
11 Amistad Alcorcon B Amistad 32 68 85 36
12 Parque Verde Parque Verde 32 59 81 36
13 At. Cañada Alcorcon B Cañada 32 80 115 31
14 FC Zarzaquemada Zarzaquemada 32 51 89 23
15 Rocio Leganes Rocio 32 56 114 22
16 Leganes Academia Leganes 32 57 117 22
17 UD Móstoles Balompié Móstoles 32 41 214 5
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Villamantilla Villamantill 34 107 40 78
2 Cenicientos Cenicientos 33 110 46 74
3 Dani Bouzas Dani Bouzas 34 122 53 71
4 CD Griñon B Griñon 33 94 40 71
5 Villamanta Villamanta 34 89 60 67
6 El Alamo B El Alamo B 34 85 46 61
7 Nuevo Ciudad Nuevo Ciudad 34 72 53 58
8 CD Arroyo CD Arroyo 33 91 67 53
9 Paco Cordoba Paco Cordoba 34 64 44 51
10 Chapineria Chapineria 34 83 77 47
11 FC Zarzaquemada Zarzaquemada 34 71 66 47
12 Fuenlabrada El Naranjo Fuenlabrada 33 72 76 41
13 Independiente Navalcarnero Independient 33 53 80 36
14 UD Arroyomolinos B Arroyomolino 33 48 86 32
15 Rayo 13 Rayo 13 34 59 110 26
16 Rayo Alua Rayo Alua 34 55 111 22
17 Racing Sur Madrid Racing 33 43 157 9
18 Atletico Fuenlabreño Atletico 27 22 128 4
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Sevilla la Nueva Sevilla 25 83 26 64
2 Cadalso Cadalso 26 78 31 53
3 Navas del Rey Navas 24 65 32 51
4 Libertad Alcorcón Libertad 26 62 46 49
5 Estudiantes Alcorcon Estudiantes 27 69 45 47
6 Chapineria Chapineria 26 71 52 47
7 Villamanta Villamanta 26 59 47 46
8 UD Móstoles Balompié Móstoles 25 67 53 40
9 CD Celmig CD Celmig 24 48 54 30
10 Quijorna Quijorna 25 44 53 29
11 CD Elithe CD Elithe 25 46 91 20
12 Hogar-70 Hogar-70 26 34 92 13
13 At. Cañada Alcorcon B Cañada 25 35 87 12
14 Sporting Laguna Sporting 11 15 43 7
15 ACD Entiergal Entiergal 9 7 31 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Internacional de Mostoles Internaciona 32 128 32 85
2 Mostoles CF B Mostoles 32 105 41 75
3 Robledo Robledo 30 125 49 72
4 Sevilla la Nueva Sevilla 32 119 49 70
5 CD Celmig CD Celmig 31 95 60 63
6 UD Móstoles Balompié Móstoles 31 96 66 57
7 Navas del Rey Navas 32 61 68 45
8 Atletico Cañada B Atletico 32 64 78 37
9 ACD Entiergal Entiergal 32 74 110 35
10 Chapineria Chapineria 31 45 73 34
11 Ciudad de Mostoles Ciudad 32 68 109 31
12 Estudiantes Alcorcon Estudiantes 31 58 82 31
13 Parque Ondarreta Parque 32 85 113 31
14 Hogar-70 Hogar-70 31 45 102 25
15 Aldea del Fresno Aldea Fresno 27 60 80 23
16 Pelayos Pelayos 31 54 105 23
17 CD Elithe CD Elithe 31 58 123 22
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Villa del Prado Villa Prado 31 159 30 86
2 Villamantilla Villamantill 31 93 29 74
3 Robledo Robledo 33 143 57 69
4 Mostoleño Mostoleño 33 71 69 61
5 Mostoles CF B Mostoles 31 92 44 60
6 Navas del Rey Navas 34 62 52 59
7 Atletico Villanueva de Pera Atletico 33 111 73 58
8 Humanes B Humanes B 31 65 51 54
9 Chapineria Chapineria 31 45 64 36
10 Rayo Serranillos Rayo 33 54 93 36
11 UD Móstoles Balompié Móstoles 31 69 96 34
12 ACD Entiergal Entiergal 31 52 117 32
13 Ciudad de Mostoles Ciudad 31 63 79 31
14 Moraleja de Enmedio B Moraleja 23 55 46 28
15 Cultural Batres Cultural 30 54 97 27
16 Naval Juniors Naval 21 24 57 16
17 Aldea del Fresno Aldea Fresno 31 39 132 8
18 Malvarrosa Malvarrosa 19 34 99 7

  USO DE MEMORIA  
6,022,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3823
Total Execution Time  0.3842
  CADENA URL  
/tercera_madrid2024/grupo12/historico
  GET DATOS  
$_GET['/tercera_madrid2024/grupo12/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_madrid' AND (l.group_code = 12 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=12 DESC LIMIT 1
0.0127  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 = 74668 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 693 AND group_code = 12 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129  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 = 74668 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 69403 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.0130  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 = 64214 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.0130  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 = 60027 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 51532 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.0131  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 = 45259 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 39848 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 34309 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16865 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 4043 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 20:00:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 20:00:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 20:00:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 20:00:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  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 = 74668 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74668 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.0126  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 = 74668 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74668 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 = 74668 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74668 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  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 = 74668 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC