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 Alzola Alzola 22 55 20 53
2 EF Carabanchel Carabanchel 23 45 25 47
3 CD Villaconejos Villaconejos 23 40 27 40
4 Ciempozuelos Ciempozuelos 22 49 36 38
5 Pasillo Verde Arganzuela Pasillo 23 41 29 37
6 Gigantes Gigantes 23 36 24 37
7 Futbol Sala Chinchon Futbol Sala 23 58 41 35
8 Villaverde San Andres B Villaverde 23 35 26 34
9 Betis San Isidro B Betis Isidro 23 37 34 32
10 RCD Carabanchel B Carabanchel 23 40 38 32
11 Goya Goya 23 55 47 31
12 San Viator San Viator 23 25 36 28
13 CD Morata CD Morata 23 33 40 25
14 Atletico Aluche Atletico 23 50 64 24
15 Sporting San Martin Sporting 23 28 45 21
16 Colmenar Oreja B Colmenar 23 28 53 21
17 Colonia Moscardo B Colonia 23 26 63 17
18 Buenavista Castilla Buenavista 23 25 58 16
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Unión Zona Norte Unión Zona 34 110 35 82
2 Orcasitas Orcasitas 34 77 32 79
3 EF Carabanchel Carabanchel 34 86 40 73
4 Villaverde San Andres B Villaverde 34 97 49 69
5 Seccion Deportiva del Pozo Seccion 34 99 48 68
6 Alzola Alzola 34 89 45 68
7 San Viator San Viator 34 65 56 51
8 Pasillo Verde Arganzuela Pasillo 34 64 60 50
9 La Mancha La Mancha 34 64 73 46
10 Caserio Perales Caserio 34 56 64 44
11 Betis San Isidro B Betis Isidro 34 42 56 40
12 ADC San Fermín Fermín 34 48 77 38
13 Grupo Cero Grupo Cero 34 59 71 36
14 Buenavista Castilla Buenavista 34 62 91 33
15 Ciudad de Leganes Ciudad 34 55 75 32
16 EF Usera EF Usera 34 50 92 32
17 ADC Brunete B Brunete 34 45 93 24
18 CD Miraflor B Miraflor 34 27 138 9
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Leganés C Leganés C 34 113 44 77
2 CD Fortuna B Fortuna 34 88 38 74
3 EMF Valdemoro Valdemoro 34 91 38 69
4 Union Carrascal Union 34 89 51 69
5 Rayo Serranillos Rayo 34 100 64 68
6 Sporting Bazan Sporting 34 70 44 62
7 San Juan Zarzaquemada Juan 34 56 35 61
8 ADCR Lemans ADCR Lemans 34 76 68 50
9 Escuelas Deportivas de Pint Escuelas 34 54 58 50
10 CD Cubas CD Cubas 34 48 67 40
11 Futbol Sala Chinchon Futbol Sala 34 57 58 38
12 Sporting San Martin Sporting 34 39 64 38
13 Atl. Trabenco Zarzaquemada Atl. 34 52 82 38
14 Aranjuez B Aranjuez B 34 39 59 37
15 AD Parla B AD Parla B 34 49 87 29
16 Parque Verde Parque Verde 34 45 76 27
17 Centella Centella 34 63 100 26
18 Seseña CF Seseña CF 34 33 129 13
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 La Meca de Rivas Meca Rivas 33 85 37 77
2 San Martin de la Vega Martin Vega 34 76 34 75
3 Aranjuez B Aranjuez B 34 79 33 72
4 Inter de Valdemoro Inter 33 58 24 71
5 Adpi Rivas B Adpi Rivas 34 66 58 52
6 Futbol Sala Chinchon Futbol Sala 34 70 66 50
7 Parque Sureste Parque 34 52 52 49
8 CD Morata CD Morata 34 61 62 49
9 CF Campo Real Campo Real 34 61 60 47
10 AD Parla B AD Parla B 34 74 64 46
11 EMF Valdemoro Valdemoro 34 69 56 44
12 Escuelas Deportivas de Pint Escuelas 34 51 56 40
13 Villarejo - 69 Villarejo 34 54 67 40
14 Sporting San Martin Sporting 34 41 68 36
15 Inter del Pilar Inter Pilar 34 60 73 35
16 Orusco Orusco 34 75 120 32
17 CD Villaconejos B Villaconejos 33 36 63 26
18 Tajo-Fuentidueña Tajo-Fuentid 33 37 112 10
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Goya Goya 32 102 31 78
2 La Mancha La Mancha 32 88 38 71
3 Racing Villaverde Racing 31 82 42 68
4 Inter de Valdemoro Inter 32 80 55 61
5 Gigantes Gigantes 32 73 44 59
6 ADC San Fermín Fermín 31 44 35 57
7 Ciudad de Getafe SC Ciudad 32 76 49 55
8 Alzola Alzola 31 64 57 48
9 CD Plata CD Plata 32 70 78 43
10 La Academia 2M12 Academia 32 85 94 40
11 Pasillo Verde Arganzuela Pasillo 32 54 75 37
12 La Chimenea B Chimenea 32 57 71 36
13 AD Alhondiga B Alhondiga 31 58 65 33
14 El Norte El Norte 32 74 84 31
15 Buenavista Castilla Buenavista 32 61 88 25
16 Fourgest-Betis Fourgest-Bet 32 48 93 20
17 Aviación Aviación 32 22 139 1
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Grupo Cero Grupo Cero 34 101 24 85
2 Sitio de Aranjuez Sitio 34 106 30 80
3 Fepe Getafe III Fepe Getafe 34 99 40 76
4 Rayo La Cierva Rayo Cierva 34 85 46 70
5 Inter de Valdemoro Inter 34 74 54 65
6 Atletico Club de Socios Atletico 34 80 56 63
7 San Juan Zarzaquemada Juan 34 61 58 44
8 Ancora Aranjuez Ancora 34 56 61 44
9 Parque Verde Parque Verde 34 59 67 43
10 El Norte El Norte 34 86 97 42
11 Sporting San Martin Sporting 34 59 73 40
12 Atl. Trabenco Zarzaquemada Atl. 34 68 95 36
13 Centella Centella 34 61 113 35
14 Eurolega Eurolega 34 51 75 33
15 CD Fortuna B Fortuna 34 44 67 32
16 CD Griñon B Griñon 34 52 74 29
17 El Chuleton-Panades Chuleton-Pan 34 60 109 24
18 Torrejon de la Calzada Torrejon 34 48 111 22

  USO DE MEMORIA  
5,717,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.1068
Total Execution Time  0.1100
  CADENA URL  
/segunda_madrid2020/grupo6/historico
  GET DATOS  
$_GET['/segunda_madrid2020/grupo6/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0071  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_madrid' AND (l.group_code = 6 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=6 DESC LIMIT 1
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 = 51373 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 692 AND group_code = 6 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0034  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 = 51373 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.0028  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 = 45227 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 39207 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 34114 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 16805 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0056  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 = 4025 AND t.round = 34 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-04-27 17:58:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:58:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:58:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:58:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 51373 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51373 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 = 51373 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51373 AND (e.action = 4 or e.action = 5) 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 = 51373 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51373 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0052  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 = 51373 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