4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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  
5,688,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0751
Total Execution Time  0.0772
  CADENA URL  
/tercera_madrid2020/grupo3/historico
  GET DATOS  
$_GET['/tercera_madrid2020/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=693 ORDER BY order_id ASC
0.0020  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 = 51523 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 693 AND group_code = 3 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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.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 `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.0023  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.0023  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.0023  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.0023  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.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 10:36:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 10:36:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 10:36:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 10:36:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 51523 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51523 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 51523 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51523 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 51523 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51523 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  SELECT *,(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