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 Unión Europa Sanse Unión 8 22 5 22
2 CDE Academia Alcobendas Academia 8 26 8 21
3 La Moraleja B Moraleja 9 16 6 19
4 Atletico Chopera Alcobendas Atletico 8 32 11 16
5 Carranza B Carranza B 8 22 11 14
6 CD Algete CD Algete 9 20 19 13
7 Atl. Alcobendas B Atl. 9 22 22 13
8 UD Tres Cantos Tres Cantos 8 18 17 11
9 Pegaso Tres Cantos Pegaso Tres 8 19 14 10
10 CDB Base CDB Base 9 23 23 10
11 Las Tablas Valverde Tablas 8 27 19 9
12 Enjoy Football-Cosmos Enjoy 8 14 20 9
13 Sanse C Sanse C 9 17 28 6
14 CD Algeteño Algeteño 8 12 30 4
15 Futbol Base 3 Cantos Futbol Base 9 5 62 0
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Comandante Comandante 32 100 42 74
2 Futuro San Francisco Futuro 32 89 45 74
3 Club Ciudad Henares Club Ciudad 32 102 58 64
4 Valdeavero Valdeavero 32 90 68 60
5 Espartales Sur Espartales 32 92 58 56
6 Camarma CF B Camarma 32 96 66 55
7 Alalpardo B Alalpardo B 32 91 71 54
8 Chorrillo Distrito VIII Chorrillo 32 66 57 49
9 Atletico Alcala Atletico 32 78 66 48
10 Paracuellos C Paracuellos 32 74 66 48
11 CF Valdeolmos Valdeolmos 32 75 70 45
12 Naya B Naya B 32 80 73 44
13 Haro FC Haro FC 32 90 103 41
14 Daganzo B Daganzo B 32 64 85 32
15 Sinabro Pcah Sinabro Pcah 32 75 95 28
16 P. Torrejonense S. Isidro B Torrejonense 32 42 126 12
17 Deportivo Ardoz B Deportivo 32 25 180 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Henares DIV B Henares 34 118 37 79
2 Meco Meco 33 119 36 78
3 Espartales Sur Espartales 34 78 47 75
4 Fuente el Saz Fuente 34 110 43 74
5 Naya B Naya B 34 87 64 61
6 CF Valdeolmos Valdeolmos 34 68 51 61
7 Haro FC Haro FC 34 89 55 60
8 Comandante Comandante 34 98 83 54
9 CD Algete CD Algete 33 87 79 53
10 Racing Veracruz B Racing 33 94 88 50
11 Daganzo B Daganzo B 33 75 70 50
12 Rayo Alcalá Rayo Alcalá 34 58 91 28
13 Camarma CF B Camarma 33 46 86 26
14 Valdeavero B Valdeavero 33 53 100 26
15 CD Valdetorres Valdetorres 33 42 82 25
16 Sinabro Pcah Sinabro Pcah 34 56 110 23
17 Serracines Serracines 34 46 121 19
18 Chorrillo Distrito VIII Chorrillo 33 51 132 12
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Complutense Alcalá B Complutense 19 52 12 49
2 Alalpardo B Alalpardo B 19 37 16 46
3 Racing Veracruz B Racing 19 50 25 41
4 Naya B Naya B 19 52 32 40
5 Daganzo B Daganzo B 19 53 26 38
6 Haro FC Haro FC 19 41 23 38
7 Villalbilla Villalbilla 19 54 40 32
8 La Plata TR82 Plata TR82 19 55 40 29
9 Comandante Comandante 19 46 41 29
10 Espartales Sur Espartales 19 35 32 29
11 Torrejon Futbol Dxte Esport Torrejon 19 34 36 25
12 Valdeavero Valdeavero 19 46 57 23
13 P. Torrejonense S. Isidro B Torrejonense 19 32 47 21
14 Rayo Alcalá Rayo Alcalá 19 27 40 20
15 CF Valdeolmos Valdeolmos 19 23 36 18
16 CD Sporting Ardoz Sporting 19 29 60 17
17 San Fernando de Henares Fernando 19 39 49 16
18 Sinabro Pcah Sinabro Pcah 19 25 39 16
19 Camarma CF B Camarma 19 36 48 15
20 Deportivo Ardoz Deportivo 19 20 87 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Peña Torrejonense S. Isidro Peña 23 87 35 56
2 AD Remar AD Remar 23 83 29 53
3 CA Torres CA Torres 22 49 22 52
4 Daganzo B Daganzo B 22 53 30 49
5 Villalbilla Villalbilla 23 59 31 46
6 CF Valdeolmos Valdeolmos 23 45 35 39
7 La Plata TR82 Plata TR82 23 75 56 37
8 Sporting Alcalá Sporting 23 60 56 37
9 Torrejon Futbol Dxte Esport Torrejon 23 39 40 31
10 Espartales Sur Espartales 23 50 45 29
11 Haro FC Haro FC 23 37 45 28
12 Naya C Naya C 23 43 48 27
13 Camarma CF B Camarma 23 33 50 24
14 Valdeavero Valdeavero 23 39 67 21
15 Olivo de Coslada B Olivo 22 29 53 20
16 CD Sporting Ardoz Sporting 23 27 53 15
17 Union Deportiva Camarma Union 23 28 72 13
18 Alalpardo B Alalpardo B 22 25 94 7
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Futuro San Francisco Futuro 34 122 47 83
2 CD Villa de Ajalvir Villa 34 100 42 75
3 Peña Torrejonense S. Isidro Peña 34 118 55 74
4 Espartales Sur Espartales 34 94 58 72
5 Atletico Alcala Atletico 34 95 60 61
6 AD Remar AD Remar 34 82 64 58
7 Camarma CF B Camarma 34 77 64 57
8 Sporting Alcalá Sporting 34 106 112 49
9 Union Deportiva Camarma Union 34 73 76 46
10 Naya C Naya C 34 81 71 42
11 Daganzo B Daganzo B 34 72 81 42
12 Toledo Olivos Toledo 34 74 72 41
13 Villalbilla Villalbilla 34 62 74 41
14 Santorcaz Santorcaz 34 76 124 40
15 Atletico La Garena Atletico 34 72 122 33
16 AD Nuevo Baztan B Nuevo Baztan 34 78 127 30
17 CD Sporting Ardoz Sporting 34 50 101 26
18 Haro FC Haro FC 34 44 126 8
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Chorrillo Distrito VIII Chorrillo 34 123 34 80
2 Torrepista Torrepista 33 118 51 78
3 Futuro San Francisco Futuro 34 124 72 73
4 Atletico Alcala Atletico 33 96 35 70
5 Espartales Sur Espartales 34 114 61 67
6 Racing Veracruz B Racing 34 92 60 65
7 CF Valdeolmos Valdeolmos 34 82 61 59
8 Algete Algete 34 79 58 56
9 AD Villa Rosa B Villa Rosa 34 66 55 54
10 Atletico La Garena Atletico 34 98 84 53
11 AD Remar AD Remar 34 79 69 46
12 Sporting Alcalá Sporting 34 110 95 43
13 Union Deportiva Camarma Union 34 58 70 39
14 Haro FC Haro FC 34 59 89 29
15 Serracines Serracines 34 48 136 22
16 CD Algeteño Algeteño 34 38 113 18
17 AD Nuevo Baztan B Nuevo Baztan 33 51 152 11
18 Valdeavero Valdeavero 33 46 186 7
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Rayo Ciudad Alcobendas B Rayo Ciudad 33 120 46 79
2 Olimpico Rosillo-75 Olimpico 34 120 48 79
3 AD La Cabrera Cabrera 33 95 47 71
4 Fuencarral Fuencarral 34 98 44 70
5 Club Fuentelarreyna B Club 34 90 48 69
6 Valdeluz Valdeluz 34 85 62 60
7 Juventud Sanse B Juventud 34 77 68 60
8 Fomento Alumni CD Fomento 33 83 78 53
9 Masriver Masriver 34 109 71 51
10 CD Olimpico de Hortaleza Olimpico 34 83 78 46
11 C.D. Pedrezuela C.D. 34 50 57 43
12 Oña Sanchinarro B Oña 34 54 82 39
13 Spartac de Manoteras B Spartac 33 73 83 35
14 Santa Elena Santa Elena 30 50 66 31
15 Club San Agustin B Club Agustin 34 67 101 31
16 Carranza B Carranza B 31 39 143 18
17 Jarama Race B Jarama Race 34 57 112 17
18 Olympic Madrid Football Clu Olympic 33 24 140 9
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Club San Agustin Club Agustin 30 107 39 77
2 Alonso Cano Alonso Cano 30 104 58 68
3 Inter del Pilar Inter Pilar 29 80 58 55
4 Celtic Castilla CF B Celtic 29 86 66 51
5 CB Lujan CB Lujan 29 78 80 47
6 Deportivo Mirasierra Deportivo 30 50 47 47
7 Masriver Masriver 30 81 64 45
8 Virgen de Mirasierra Virgen 30 75 68 41
9 Valdeluz Valdeluz 29 77 79 40
10 CD Boca CD Boca 30 66 93 34
11 Santa Elena Santa Elena 30 60 79 33
12 Rayo del Pilar Rayo Pilar 30 50 73 33
13 Fundacion B Fundacion B 30 55 79 33
14 Club Fuentelarreyna B Club 30 61 77 27
15 Fomento Alumni CD Fomento 30 53 74 25
16 Lacoma Lacoma 30 72 121 25
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Atletico Alcobendas Atletico 30 76 15 82
2 Jarama Race Jarama Race 30 105 35 71
3 Villa Buitrago del Lozoya Villa 29 120 65 68
4 Conde Orgaz Conde Orgaz 30 88 62 58
5 Aldovea Aldovea 30 72 52 50
6 Sporting Hortaleza C Sporting 29 70 51 50
7 Spartac de Manoteras Spartac 29 74 62 41
8 Escuder San Pascual B Escuder 30 52 63 39
9 Los Carmenes Carmenes 30 65 79 37
10 Atletico Chopera Alcobendas Atletico 30 55 79 36
11 Liceo Sport Liceo Sport 29 54 57 35
12 Juventud Sanse B Juventud 30 56 60 35
13 La Cabrera La Cabrera 30 40 67 27
14 C.D. Pedrezuela C.D. 30 43 100 21
15 CF Valdeolmos Valdeolmos 30 31 108 15
16 Sporting Seis de Diciembre Sporting 26 33 79 11

  USO DE MEMORIA  
6,167,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4356
Total Execution Time  0.4376
  CADENA URL  
/tercera_madrid2024/grupo3/historico
  GET DATOS  
$_GET['/tercera_madrid2024/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0252  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 = 3 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=3 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=693 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 693 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (974404,950677,780808,746018,305610) ORDER BY n.cover_points DESC, update_date DESC
0.0124  SELECT id,name,alias,stepParent FROM categories WHERE parentId=693 ORDER BY order_id ASC
0.0126  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 = 74659 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 693 AND group_code = 3 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0128  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 = 74659 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 = 69394 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.0132  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 = 64205 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.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 = 60018 AND t.round = 19 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 `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 = 51523 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 = 45250 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 = 39838 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 = 34301 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 `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 = 16855 AND t.round = 30 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 `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 = 4034 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 14:06:46' 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 14:06:46' 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 14:06:46' 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 14:06:46' 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 = 74659 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74659 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 = 74659 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74659 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 = 74659 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74659 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  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 = 74659 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