4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alzola
TEMPORADA 2023/2024
1ª REGIONAL MADRID GRUPO 4
Equipo PJ GF GC Puntos
1 Alzola Alzola 0 0 0 0
2 Atl. Trabenco Zarzaquemada Atl. 0 0 0 0
3 Atlético Valdeiglesias Atlético 0 0 0 0
4 EF At. Casarrubuelos Casarrubuelo 0 0 0 0
5 CD Griñón CD Griñón 0 0 0 0
6 Cultural Deportiva Miraflor Cultural 0 0 0 0
7 EF Carabanchel Carabanchel 0 0 0 0
8 Humanes Humanes 0 0 0 0
9 Los Yébenes San Bruno B Yébenes 0 0 0 0
10 Lucero-Linces Lucero-Lince 0 0 0 0
11 CD Lugo Fuenlabrada Lugo 0 0 0 0
12 Madrid Rio Madrid Rio 0 0 0 0
13 Moraleja de Enmedio Moraleja 0 0 0 0
14 N. P. Bonita de Carabanchel Bonita 0 0 0 0
15 Navalcarnero B Navalcarnero 0 0 0 0
16 Orcasitas Orcasitas 0 0 0 0
17 UD Móstoles Balompié Móstoles 0 0 0 0
18 Union Deportiva Usera Union 0 0 0 0
TEMPORADA 2022/2023
1ª REGIONAL MADRID GRUPO 3
Equipo PJ GF GC Puntos
1 Sitio de Aranjuez Sitio 34 79 39 70
2 Unión Valdebernardo Unión 34 85 54 70
3 Arganda Arganda 34 84 48 69
4 Union Deportiva Usera Union 34 62 47 54
5 UD Ciempozuelos Ciempozuelos 34 55 41 54
6 Alzola Alzola 34 55 61 48
7 Ciudad de Pinto Ciudad Pinto 34 49 49 46
8 Inter de Valdemoro Inter 34 56 57 44
9 EF Arganda EF Arganda 34 39 42 44
10 Tajamar Tajamar 34 47 51 43
11 Orcasitas Orcasitas 34 50 55 43
12 EMF Valdemoro Valdemoro 34 54 52 42
13 Mejoreño Mejoreño 34 56 71 41
14 Santa Maria del Pilar Santa Maria 34 54 75 41
15 Elida Olimpia A Elida 34 38 37 40
16 Roma CF Roma CF 34 38 55 37
17 Seccion Deportiva del Pozo Seccion 34 41 67 31
18 EMF Villarejo Villarejo 34 39 80 19
TEMPORADA 2019/2020
2ª REGIONAL MADRID GRUPO 6
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
TEMPORADA 2018/2019
2ª REGIONAL MADRID GRUPO 6
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
TEMPORADA 2017/2018
2ª REGIONAL MADRID GRUPO 7
Equipo PJ GF GC Puntos
1 Colonia Moscardo B Colonia 34 75 39 73
2 Union Deportiva Usera Union 34 80 39 71
3 Los Yébenes San Bruno B Yébenes 33 73 36 70
4 Alzola Alzola 33 79 42 63
5 La Mutual Juan XXIII Mutual Juan 34 51 38 59
6 San Viator San Viator 34 63 51 56
7 Betis San Isidro B Betis Isidro 34 42 46 48
8 Orcasitas Orcasitas 34 62 63 46
9 Campamento Campamento 34 56 58 46
10 EF Carabanchel Carabanchel 34 55 59 42
11 Pasillo Verde Arganzuela Pasillo 34 49 68 42
12 CD Atocha CD Atocha 34 55 70 41
13 Grupo Cero Grupo Cero 34 57 76 38
14 Cantera Cantera 34 43 62 35
15 Buenavista Castilla Buenavista 34 58 81 35
16 Rojo y Blanco Rojo Blanco 34 62 74 34
17 Bercial 2009 Bercial 2009 34 52 74 29
18 Villaverde San Andres B Villaverde 34 37 73 27
TEMPORADA 2016/2017
2ª REGIONAL MADRID GRUPO 5
Equipo PJ GF GC Puntos
1 Ciudad de Getafe SC Ciudad 34 99 20 87
2 Seccion Deportiva del Pozo Seccion 34 79 39 65
3 Nuevas Palomeras Nuevas 33 84 52 64
4 Colonia Moscardo B Colonia 34 63 38 58
5 Adepo-Palomeras Adepo-Palome 33 67 49 58
6 San Viator San Viator 34 70 50 56
7 La Mancha La Mancha 34 73 51 55
8 Grupo Cero Grupo Cero 33 72 60 54
9 ADC San Fermín Fermín 33 65 52 52
10 Alzola Alzola 32 59 47 51
11 Pasillo Verde Arganzuela Pasillo 34 62 64 43
12 Buenavista Castilla Buenavista 34 60 70 42
13 La Chimenea B Chimenea 33 64 94 38
14 Elida Olimpia A Elida 34 39 77 34
15 Orcasitas Orcasitas 34 38 70 32
16 El Norte El Norte 34 60 103 31
17 Vallecas B Vallecas B 34 42 97 25
18 CD Plata CD Plata 33 46 109 19
TEMPORADA 2015/2016
2ª REGIONAL MADRID GRUPO 6
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
TEMPORADA 2014/2015
3ª REGIONAL MADRID GRUPO 8
Equipo PJ GF GC Puntos
1 CD Plata CD Plata 32 92 43 74
2 Pasillo Verde Arganzuela Pasillo 32 99 52 72
3 Alzola Alzola 32 68 38 66
4 San Viator San Viator 32 74 51 59
5 Los Rosales Los Rosales 32 63 49 52
6 CD Union Huaral Union Huaral 32 81 77 51
7 CD Atocha CD Atocha 32 47 45 51
8 Balonbetica Balonbetica 32 90 75 47
9 Sertec El Rastro Sertec 32 61 63 47
10 Union Manzanares Union 32 80 77 42
11 CD Batan CD Batan 32 58 67 40
12 Balonmano Villaverde Balonmano 32 80 88 37
13 Gigantes B Gigantes B 32 53 68 36
14 Alcotan Alcotan 32 64 82 29
15 San Cristobal de los Ángele Cristobal 32 52 80 29
16 EF Usera EF Usera 32 37 66 29
17 La Mancha B La Mancha B 32 45 123 15

  USO DE MEMORIA  
5,865,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.5241
Total Execution Time  0.5259
  CADENA URL  
/historico/Alzola
  GET DATOS  
$_GET['/historico/Alzola']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0134  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Alzola' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=19130 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=19130 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19130 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=690 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 690 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 (973908,950677,939069,907708,889402) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '19130' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '19130' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '19130' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73666 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=19130 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73666) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73666 AND teamId = 19130
0.0142  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73666 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '19130' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19130' and rp.type = 4
0.0126  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '19130' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73666 WHERE rp.league_id = 73666 AND rp.teamId = 19130 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73666 WHERE rp.league_id = 73666 AND rp.teamId = 19130 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73666 WHERE rp.league_id = 73666 AND rp.teamId = 19130 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 19130 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73666 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0253  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 = 68741 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.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 `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.0145  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.0151  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 = 39801 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 34113 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 = 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.0137  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 = 4039 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73666 ORDER BY nameShow LIMIT 100