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 San Fernando de Henares Fernando 11 39 10 27
2 Juventud Torrejón Juventud 10 27 9 26
3 CF Rayo-70 B Rayo-70 10 34 10 25
4 La Plata TR82 B Plata TR82 10 39 16 24
5 CD Coslada B Coslada 11 28 23 21
6 Naya C Naya C 10 31 10 19
7 UD Velilla UD Velilla 10 24 9 19
8 Loeches Loeches 9 34 11 18
9 Deportivo Ardoz Deportivo 11 44 28 18
10 Samper - Coslada B Samper 10 27 28 15
11 Espartales Sur B Espartales 10 19 20 15
12 Peña Torrejonense S. Isidro Peña 10 20 20 13
13 Toledo Olivos B Toledo 10 21 22 12
14 Rivas Jarama Rivas Jarama 10 21 33 7
15 CD Daganzo C Daganzo 10 10 85 6
16 Inter Torrejón Inter 28 0 84 0
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Chinchón 21 Chinchón 28 99 28 69
2 Arganda UD Arganda UD 28 87 39 65
3 Seseña CF Seseña CF 28 80 45 60
4 Valdemoro CF Valdemoro 26 75 30 59
5 Ivero A Ivero A 28 94 46 56
6 Parque Sureste A Parque 28 59 55 43
7 Futbol Sala Chinchon Futbol Sala 27 68 58 39
8 Atlético Sur B Atlético 28 66 73 37
9 UD La Poveda Poveda 28 48 51 35
10 EF Valdemoro B Valdemoro 28 56 81 27
11 Villarejo - 69 Villarejo 27 52 94 26
12 Tajo-Fuentidueña Tajo-Fuentid 28 47 95 26
13 Villarejo CF Villarejo 28 34 59 20
14 Rivas Jarama Rivas Jarama 28 61 119 17
15 CD Morata CD Morata 28 20 73 12
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Sporting de Arganda Sporting 30 86 23 72
2 CD Villaconejos Villaconejos 29 84 23 70
3 Chinchón 21 Chinchón 29 82 18 67
4 Arganda UD Arganda UD 30 81 45 56
5 Ivero A Ivero A 30 67 41 56
6 Orusco Orusco 30 66 43 55
7 Rivas Jarama Rivas Jarama 27 63 55 43
8 Villarejo - 69 Villarejo 30 73 75 39
9 EF Valdemoro B Valdemoro 30 61 49 38
10 EMF de Carabaña Carabaña 29 59 67 36
11 EF San Martín de la Vega B Martín Vega 30 61 69 34
12 Valdaracete Valdaracete 30 63 85 32
13 Futbol Sala Chinchon Futbol Sala 30 40 56 29
14 Morata B Morata B 30 33 77 28
15 Villarejo CF Villarejo 30 41 85 26
16 Sporting Belmonteño Sporting 30 27 176 0
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 CD La Cañada B Cañada 16 46 14 39
2 Majadahonda Afar-4 Majadahonda 16 50 28 36
3 Fomento Alumni C Fomento 16 36 19 34
4 CD Puerta de Madrid B Puerta 16 37 30 30
5 SEK El Castillo UCJC Castillo 16 42 19 29
6 UD Arroyofresno Arroyofresno 16 32 18 28
7 Club Fuentelarreyna B Club 16 39 26 27
8 Fundacion B Fundacion B 16 34 23 26
9 Colegio Alameda de Osuna B Colegio 16 31 30 24
10 Encinas de Boadilla Encinas 16 38 36 23
11 IE University Athletics University 16 27 25 20
12 Rupe Sahagun B Rupe Sahagun 16 34 39 19
13 El Escorial B Escorial 16 30 36 18
14 San Fernando Escolapios Fernando 16 25 36 17
15 Masriver B Masriver B 16 15 60 9
16 CD Boca CD Boca 16 22 63 7
17 Sporting de Sarria Sporting 16 15 51 1
18 DUX Internacional Academy B Internaciona 0 0 0 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Villa Rosa Villa Rosa 22 96 14 57
2 Inter del Pilar Inter Pilar 23 59 26 53
3 CF Valdebebas Valdebebas 22 87 29 51
4 Trivema Naval Trivema 23 84 34 51
5 Atletico Santa Ana Atletico 23 90 40 45
6 ADC Malasaña Malasaña 22 69 39 43
7 Ntra.Sra. del Buen Consejo Ntra.Sra. 23 48 41 36
8 Club San Agustin B Club Agustin 23 48 40 31
9 Oña Sanchinarro B Oña 23 44 54 31
10 Espanyol de Madrid Espanyol 23 45 44 28
11 Fuencarral Fuencarral 23 59 60 28
12 Altamira A Altamira A 23 75 58 27
13 Santa Elena Santa Elena 22 46 53 27
14 Sporting Hortaleza C Sporting 23 56 67 24
15 Celtic Castilla CF B Celtic 23 34 70 22
16 Fomento Alumni C Fomento 23 34 77 12
17 Spartac de Manoteras B Spartac 23 30 95 12
18 Escuder San Pascual C Escuder 23 10 173 3
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 CD Canillas C Canillas 34 95 31 83
2 Atletico Alcobendas Atletico 34 124 30 81
3 Lacoma Lacoma 32 100 50 74
4 Fomento Alumni CD Fomento 33 93 58 69
5 Club Fuentelarreyna C Club 33 116 49 65
6 Atletico Santa Ana Atletico 34 108 52 64
7 Ntra.Sra. del Buen Consejo Ntra.Sra. 34 97 61 57
8 Club San Agustin B Club Agustin 34 79 53 57
9 CD Olimpico de Hortaleza Olimpico 34 93 58 55
10 AD Villa Rosa B Villa Rosa 34 60 64 50
11 Fuencarral Fuencarral 34 84 80 49
12 CD Samper-Coslada Samper-Cosla 34 73 69 49
13 Poligono H San Blas B Poligono 34 57 125 32
14 Españoleto B Españoleto 33 48 101 25
15 Altamira Altamira 33 44 110 17
16 Sporting Seis de Diciembre Sporting 34 46 139 17
17 Spartac de Manoteras B Spartac 33 53 117 15
18 Asoc. Rec. Dos de Mayo Asoc. Rec.. 31 35 158 3
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Escuder San Pascual Escuder 34 133 39 82
2 Colegio Alameda de Osuna Colegio 34 98 51 80
3 Fuencarral Fuencarral 34 88 51 73
4 Lacoma Lacoma 33 96 37 72
5 Cde Poligono H San Blas Poligono 34 100 72 63
6 Arual Canillejas Arual 33 80 45 62
7 CF San Jose B Jose 34 70 54 60
8 Racing San Blas Racing Blas 33 83 82 53
9 Ntra.Sra. del Buen Consejo Ntra.Sra. 34 79 72 52
10 CD Canillas C Canillas 34 85 76 50
11 Canillejas CF Canillejas 34 77 81 49
12 Spartac de Manoteras B Spartac 33 69 86 36
13 AD San Pascual-Montpellier Pascual-Mont 34 56 79 36
14 Liceo Sport Liceo Sport 34 48 74 31
15 Club San Agustin B Club Agustin 34 44 78 29
16 CD Olimpico de Hortaleza Olimpico 34 51 106 24
17 CD La Tierruca en Madrid Tierruca 34 35 111 14
18 Julian Marias Julian 34 42 140 10
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Futbol de Torres Futbol 33 145 33 83
2 Rayo 70 Rayo 70 33 95 35 77
3 Nuevo Baztan Nuevo Baztan 32 109 58 72
4 San Jose San Jose 33 110 61 64
5 La Plata TR82 Plata TR82 33 109 61 64
6 Valdilecha Sport Valdilecha 33 114 68 61
7 Santorcaz Santorcaz 32 77 62 53
8 Parque Granada Parque 33 92 71 52
9 Peña Torrejonense S. Isidro Peña 32 89 68 52
10 Villa de Mejorada Villa 32 66 67 52
11 EF El Olivo de Coslada Olivo 33 60 74 39
12 Belvis At. Belvis At. 33 57 84 39
13 Toledo Olivos Toledo 33 78 97 38
14 Villalbilla Villalbilla 33 80 124 29
15 Atletico Atalaya Atletico 33 47 144 18
16 Juventud Torrejon B Juventud 32 37 94 14
17 Espinilla Coslada Espinilla 33 25 151 14
18 Villar del Olmo Villar Olmo 12 18 56 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 CD Villa de Ajalvir Villa 32 95 22 79
2 Santos de la Humosa Santos 31 84 48 66
3 Naya B Naya B 31 76 40 64
4 Rayo Garena Rayo Garena 32 80 53 62
5 UD Camarma UD Camarma 32 83 48 61
6 Chorrillo Distrito VIII Chorrillo 31 69 54 56
7 Camarma CF B Camarma 32 76 60 52
8 Remar AD Remar AD 32 57 59 48
9 Sporting Alcalá Sporting 32 67 67 43
10 Santorcaz Santorcaz 31 51 61 43
11 Futbol Alcalá Futbol 31 64 71 39
12 Espartales Sur Espartales 32 62 74 38
13 Villalbilla Villalbilla 32 77 116 30
14 Racing Veracruz Racing 31 61 103 26
15 Futuro San Francisco Futuro 32 57 84 24
16 Olivo de Coslada B Olivo 32 52 96 21
17 Rayo Ensanche Rayo 32 55 110 17
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 San Fernando de Henares Fernando 28 95 42 70
2 Escuder San Pascual Escuder 28 102 36 63
3 La Paz Vallehermoso Vallehermoso 28 66 36 58
4 Olivo de Coslada Olivo 28 62 33 55
5 Racing San Blas Racing Blas 28 61 37 54
6 Cde Poligono H San Blas Poligono 28 83 38 53
7 Escuela Fútbol Periso B Escuela 28 74 37 50
8 Británico Madrid Británico 28 67 63 46
9 Deportivo LFC Deportivo 28 69 53 40
10 Rayo 70 Rayo 70 28 57 57 35
11 Catedra Catedra 28 48 85 28
12 Espinilla Coslada Espinilla 28 43 100 20
13 Elida Olimpia B Elida 28 20 74 15
14 Barrio Aeropuerto-Nautilus Barrio 28 30 116 11
15 Altamira B Altamira B 28 35 105 4

  USO DE MEMORIA  
6,169,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4123
Total Execution Time  0.4142
  CADENA URL  
/tercera_madrid2024/grupo5/historico
  GET DATOS  
$_GET['/tercera_madrid2024/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0125  SELECT type FROM routes WHERE alias = 'tercera_madrid2024'
0.0256  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 = 5 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=5 DESC LIMIT 1
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=693 ORDER BY order_id ASC
0.0136  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 = 74661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 693 AND group_code = 5 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0133  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 = 74661 AND t.round = 28 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 = 69396 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 64207 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 60020 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 = 51525 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.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 `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 = 45252 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 = 39840 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 `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 = 34303 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 16857 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 = 4036 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:08:58' 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=2 AND last_update > '2024-04-27 10:08:58' 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=4 AND last_update > '2024-04-27 10:08:58' 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 10:08:58' 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 = 74661 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74661 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 = 74661 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74661 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 = 74661 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74661 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 = 74661 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC