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 Aravaca C Aravaca C 22 63 27 50
2 CD Universitario Universitari 22 76 27 47
3 Ciringanillos Ciringanillo 21 57 20 47
4 Fundacion B Fundacion B 22 61 31 45
5 CB Ntra Sra de Lujan Ntra Lujan 22 53 31 44
6 Club Fuentelarreyna B Club 22 55 31 41
7 At. del Pilar CF Pilar 21 59 41 38
8 CD Peñagrande Peñagrande 22 60 42 36
9 Fomento Alumni B Fomento 21 51 34 36
10 Majadahonda Afar-4 Majadahonda 22 47 35 35
11 UD Arroyofresno Arroyofresno 21 39 29 34
12 IE University Athletics University 22 63 89 22
13 Sporting de Sarria Sporting 22 32 73 15
14 San Fernando Escolapios Fernando 22 42 87 13
15 CD Boca CD Boca 21 22 100 11
16 Masriver B Masriver B 22 28 61 9
17 Rayo del Pilar Rayo Pilar 21 26 76 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Valdeluz Valdeluz 34 98 39 86
2 Masriver Masriver 34 110 41 77
3 Club Fuentelarreyna B Club 34 101 32 73
4 CD Universitario Universitari 34 99 42 70
5 Celtic Castilla CF B Celtic 34 94 50 70
6 Ciringanillos Ciringanillo 34 89 48 69
7 CD Peñagrande Peñagrande 34 95 53 62
8 Inter del Pilar Inter Pilar 34 79 60 53
9 Aravaca C Aravaca C 34 78 74 50
10 Fundacion B Fundacion B 34 75 72 50
11 IE University Athletics University 34 76 78 46
12 Santa Elena Santa Elena 34 47 82 39
13 Cluny Pozuelo Cluny 34 59 82 36
14 Rayo del Pilar Rayo Pilar 34 50 92 31
15 San Fernando Escolapios Fernando 34 58 114 26
16 D. Fuencarral El Pardo Fuencarral 34 43 135 20
17 CD Boca CD Boca 34 50 124 18
18 Futbol Alcobendas Sport B Futbol 34 18 101 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 K-2 K-2 34 118 34 79
2 Virgen de Mirasierra Virgen 34 93 31 78
3 Unión Zona Norte Unión Zona 34 108 35 76
4 Valdeluz Valdeluz 34 103 58 71
5 CD Universitario Universitari 34 84 44 68
6 Aravaca C Aravaca C 34 84 63 60
7 Club Fuentelarreyna B Club 34 72 49 59
8 Masriver Masriver 34 88 69 57
9 Fomento Alumni CD Fomento 34 82 63 52
10 CB Ntra Sra de Lujan Ntra Lujan 34 55 60 45
11 Fundacion B Fundacion B 34 69 82 43
12 CD Colonia Moscardó C Colonia 34 55 78 34
13 Rayo del Pilar Rayo Pilar 34 54 107 32
14 CD Boca CD Boca 34 65 112 29
15 Ciringanillos Ciringanillo 34 51 84 28
16 CD Peñagrande Peñagrande 34 64 128 25
17 Union America Union 34 42 110 18
18 Santa Elena Santa Elena 34 51 131 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Racing Veracruz Racing 33 150 52 80
2 CD Valdetorres Valdetorres 32 103 38 76
3 Camarma CF B Camarma 32 106 47 67
4 Chorrillo Distrito VIII Chorrillo 33 79 42 66
5 Union Deportiva Jarama 2016 Union 32 120 60 64
6 Algete Algete 34 87 49 64
7 Union Deportiva Camarma Union 33 90 70 58
8 Futuro San Francisco Futuro 33 82 75 55
9 Atlético Los Olivos Atlético 31 70 67 53
10 CF Valdeolmos Valdeolmos 32 79 91 46
11 AD Remar AD Remar 32 68 79 35
12 Atletico La Garena Atletico 31 78 97 33
13 Rayo Ensanche Rayo 32 61 91 33
14 Club Ciudad Henares Club Ciudad 34 53 92 28
15 Sporting Alcalá Sporting 32 67 115 24
16 Futbol Alcalá Futbol 33 49 97 23
17 Espartales Sur Espartales 32 53 124 18
18 Valdeavero Valdeavero 33 48 157 16
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sporting Hortaleza B Sporting 32 108 31 77
2 Los Carmenes Carmenes 34 127 65 77
3 Colegio Miramadrid Colegio 32 65 19 71
4 Conde Orgaz Conde Orgaz 33 128 51 70
5 CD Olimpico de Hortaleza Olimpico 34 72 52 66
6 Liceo Sport Liceo Sport 33 111 34 66
7 Peña Torrejonense S. Isidro Peña 34 95 67 55
8 Olivo de Coslada Olivo 33 60 47 55
9 Club Fuentelarreyna C Club 34 81 74 54
10 Rayo 70 Rayo 70 33 59 64 38
11 Spartac de Manoteras Spartac 34 64 83 36
12 Oña Sanchinarro B Oña 34 82 85 34
13 Belvis At. Belvis At. 34 64 88 33
14 Atletico Chopera Alcobendas Atletico 27 58 72 32
15 La Plata TR82 Plata TR82 33 63 120 30
16 Juventud Torrejon B Juventud 33 54 122 29
17 Espinilla Coslada Espinilla 34 30 124 10
18 Atletico Artilleros Atletico 33 31 154 4
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Alalpardo Alalpardo 32 124 48 78
2 San Isidro Colon Isidro Colon 32 92 33 73
3 Racing Veracruz Racing 32 95 48 70
4 Espartales Sur Espartales 32 76 50 65
5 Belvis At. Belvis At. 32 88 54 61
6 Futbol Alcalá Futbol 32 80 52 51
7 Futuro San Francisco Futuro 31 80 63 51
8 Rayo Ensanche Rayo 31 68 56 51
9 Sporting Alcalá Sporting 32 80 70 47
10 Talamanca B Talamanca B 32 63 67 42
11 Valdeavero Valdeavero 32 54 75 37
12 CD Villa de Ajalvir Villa 31 72 75 35
13 Serracines Serracines 32 72 134 31
14 Olivo de Coslada B Olivo 32 60 95 29
15 Remar AD Remar AD 32 48 90 26
16 Espartanos Espartanos 32 38 113 14
17 Rayo Garena Rayo Garena 31 44 111 13

  USO DE MEMORIA  
5,689,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3271
Total Execution Time  0.3294
  CADENA URL  
/tercera_madrid2020/grupo4/historico
  GET DATOS  
$_GET['/tercera_madrid2020/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0254  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 = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0125  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 = 51524 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 = 4 and tables = 1 AND year <= 2020 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 `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 = 51524 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 = 45251 AND t.round = 34 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 `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 = 34302 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 16856 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 `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 = 4035 AND t.round = 34 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-05-04 14:42:17' 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-05-04 14:42:17' 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-05-04 14:42:17' 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-05-04 14:42:17' 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 events2020 e ON e.player_id = p.id AND e.league_id = 51524 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51524 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 events2020 e ON e.player_id = p.id AND e.league_id = 51524 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51524 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 events2020 e ON e.player_id = p.id AND e.league_id = 51524 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51524 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 = 51524 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