4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fuenlabrada de los Montes
TEMPORADA 2023/2024
2ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 CP Valdivia CP Valdivia 24 67 28 56
2 Cd Talarrubias Talarrubias 24 59 30 51
3 San Bartolome A Bartolome 24 54 20 49
4 Fuenlabrada de los Montes Fuenlabrada 24 60 33 48
5 Sp Herrera Sp Herrera 24 56 25 47
6 Athletic Valle A Athletic 24 53 44 42
7 Torviscal Torviscal 24 47 30 40
8 Sporting Malpartida A Sporting 24 61 65 28
9 Siruela A Siruela A 24 42 57 27
10 Esparragosa de Lares A Esparragosa 24 31 59 19
11 Ilipense-Zalamea S. Ilipense-Zal 24 34 79 14
12 Orellana Costa Dulce A Orellana 24 33 68 13
13 Zurbarán Zurbarán 24 27 86 10
TEMPORADA 2022/2023
2ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 Olympic Peleño Olympic 23 85 11 62
2 Athletic Valle A Athletic 24 63 29 50
3 Sp Herrera Sp Herrera 24 69 34 45
4 Torviscal Torviscal 24 49 34 44
5 CD La Haba CD La Haba 24 57 45 44
6 Orellana Costa Dulce A Orellana 24 35 33 39
7 Cd Talarrubias Talarrubias 24 35 42 34
8 Sporting Malpartida A Sporting 23 45 47 32
9 San Bartolome A Bartolome 24 42 52 30
10 Fuenlabrada de los Montes Fuenlabrada 24 45 45 25
11 Siruela A Siruela A 24 30 80 16
12 Esparragosa de Lares A Esparragosa 24 23 89 11
13 Zurbarán Zurbarán 24 23 60 9
TEMPORADA 2021/2022
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Quintana CD Quintana 18 80 8 54
2 Olympic Peleño Olympic 18 40 23 38
3 Sp Herrera Sp Herrera 18 41 22 33
4 Orellana Costa Dulce A Orellana 18 28 29 32
5 Athletic Valle A Athletic 18 33 36 21
6 Cd Talarrubias Talarrubias 18 27 43 20
7 Sporting Malpartida A Sporting 18 34 57 19
8 San Bartolome A Bartolome 18 25 49 16
9 Fuenlabrada de los Montes Fuenlabrada 18 27 43 15
10 Siruela A Siruela A 18 18 43 11
11 Esparragosa de Lares A Esparragosa 0 0 0 0
12 Pedrusco de Garbayuela Pedrusco 0 0 0 0
TEMPORADA 2019/2020
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Monterrubio CD Monterrubio 24 88 23 61
2 Cabeza Del Buey Cabeza Buey 24 70 17 54
3 Cd Talarrubias Talarrubias 24 70 29 51
4 CD Quintana CD Quintana 24 58 29 49
5 Fuenlabrada de los Montes Fuenlabrada 24 63 47 49
6 Athletic Valle A Athletic 23 66 38 46
7 Sporting Malpartida A Sporting 24 73 51 37
8 San Bartolome A Bartolome 24 44 40 35
9 Orellana Costa Dulce A Orellana 24 42 34 34
10 Sp Herrera Sp Herrera 24 53 38 33
11 Esparragosa de Lares A Esparragosa 24 51 62 29
12 Puebla De Alcocer Puebla 24 45 79 19
13 Siruela A Siruela A 24 21 47 17
14 Pedrusco de Garbayuela Pedrusco 24 28 72 14
15 Logrosán Cf Logrosán 24 23 101 5
16 Valdecaballeros A Valdecaballe 23 8 96 3
TEMPORADA 2018/2019
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Sp Herrera Sp Herrera 29 64 41 62
2 CD Quintana CD Quintana 30 80 29 58
3 Esparragosa de Lares A Esparragosa 30 71 47 57
4 Cabeza Del Buey Cabeza Buey 30 92 43 56
5 Monterrubio CD Monterrubio 30 77 49 55
6 Sporting Malpartida A Sporting 30 68 42 54
7 Cd Talarrubias Talarrubias 30 72 40 53
8 Siruela A Siruela A 30 52 41 49
9 Castuera Subastacar B Castuera 29 56 42 47
10 Fuenlabrada de los Montes Fuenlabrada 30 93 64 43
11 San Bartolome A Bartolome 29 50 68 31
12 Puebla De Alcocer Puebla 30 72 85 29
13 Pedrusco de Garbayuela Pedrusco 29 45 72 28
14 Valdecaballeros A Valdecaballe 30 36 100 18
15 Casas De Don Pedro A Casas Pedro 28 19 116 13
16 Castilblanco A Castilblanco 30 14 82 10
TEMPORADA 2017/2018
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 San Bartolome A Bartolome 25 57 24 61
2 Fuenlabrada de los Montes Fuenlabrada 26 82 34 60
3 Castuera Subastacar B Castuera 26 77 46 47
4 Sp Herrera Sp Herrera 26 64 36 47
5 Cabeza Del Buey Cabeza Buey 26 56 37 43
6 Sporting Malpartida A Sporting 26 60 51 42
7 Valdecaballeros A Valdecaballe 26 37 55 37
8 Siruela A Siruela A 26 51 51 35
9 Cd Talarrubias Talarrubias 25 51 52 34
10 Esparragosa de Lares A Esparragosa 26 49 59 33
11 Puebla De Alcocer Puebla 26 37 57 28
12 Pedrusco de Garbayuela Pedrusco 26 44 66 27
13 Casas De Don Pedro A Casas Pedro 26 28 74 14
14 Castilblanco A Castilblanco 26 28 79 11
TEMPORADA 2016/2017
2ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Torviscal Torviscal 30 82 26 74
2 Sp Herrera Sp Herrera 30 92 22 73
3 UD La Cruz Villanovense Cruz 30 82 26 69
4 Fuenlabrada de los Montes Fuenlabrada 30 72 34 62
5 Gimnástico Don Benito Gimnástico 30 72 41 56
6 San Bartolome A Bartolome 30 59 39 56
7 CP Rena CP Rena 30 94 78 51
8 Logrosán Cf Logrosán 30 60 52 48
9 Valdehornillo Valdehornill 29 51 46 42
10 Siruela A Siruela A 30 47 69 38
11 Puebla De Alcocer Puebla 30 47 86 31
12 Orellana Costa Dulce A Orellana 30 39 69 27
13 Pedrusco de Garbayuela Pedrusco 30 50 109 18
14 Casas De Don Pedro A Casas Pedro 30 34 77 17
15 Esparragosa de Lares A Esparragosa 29 29 77 14
16 Valdecaballeros A Valdecaballe 30 30 89 11
TEMPORADA 2015/2016
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Plus Ultra A Plus Ultra 22 67 13 56
2 Esparragosa de Lares A Esparragosa 21 53 19 51
3 Siruela A Siruela A 22 51 29 45
4 Orellana Costa Dulce A Orellana 22 42 22 44
5 Fuenlabrada de los Montes Fuenlabrada 22 45 24 40
6 Cabeza Del Buey Cabeza Buey 22 40 27 38
7 Logrosán Cf Logrosán 22 51 38 32
8 Pedrusco de Garbayuela Pedrusco 22 25 64 19
9 Valdecaballeros A Valdecaballe 22 26 51 18
10 Casas De Don Pedro A Casas Pedro 22 21 58 15
11 Castilblanco A Castilblanco 21 11 45 11
12 Puebla De Alcocer Puebla 22 17 59 10
TEMPORADA 2014/2015
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Valdehornillo Valdehornill 30 80 23 70
2 CD Quintana CD Quintana 30 102 38 68
3 Plus Ultra A Plus Ultra 30 77 37 67
4 Zurbarán Zurbarán 30 76 29 61
5 Esparragosa de Lares A Esparragosa 30 67 34 58
6 Fuenlabrada de los Montes Fuenlabrada 30 81 51 57
7 Logrosán Cf Logrosán 30 60 43 51
8 Monterrubio CD Monterrubio 30 69 52 47
9 Orellana Costa Dulce A Orellana 30 52 57 42
10 Sporting Malpartida A Sporting 30 55 75 35
11 San Bartolome A Bartolome 30 55 67 34
12 Siruela A Siruela A 30 58 85 29
13 Castilblanco A Castilblanco 30 36 81 25
14 Valdecaballeros A Valdecaballe 30 42 98 25
15 Zoriteño A Zoriteño A 30 29 73 18
16 Pedrusco de Garbayuela Pedrusco 30 26 122 4

  USO DE MEMORIA  
5,689,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0966
Total Execution Time  0.0978
  CADENA URL  
/historico/Fuenlabrada-De-Los-Montes
  GET DATOS  
$_GET['/historico/Fuenlabrada-De-Los-Montes']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0034  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 = 'Fuenlabrada-De-Los-Montes' 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.0018  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=30060 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=30060 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73798
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30060 AND type_rel = 2
0.0025  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 = '30060' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '30060' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = 73798 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=30060 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73798) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73798 AND teamId = 30060
0.0021  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 = '30060' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30060' and rp.type = 4
0.0022  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 = '30060' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 73798 WHERE rp.league_id = 73798 AND rp.teamId = 30060 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.0035  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 = 73798 WHERE rp.league_id = 73798 AND rp.teamId = 30060 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 73798 WHERE rp.league_id = 73798 AND rp.teamId = 30060 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 30060 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73798 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 69357 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 63834 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 51342 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 45373 AND t.round = 30 ORDER BY team.conference 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 `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 = 39813 AND t.round = 26 ORDER BY team.conference 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 `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 = 37077 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 16783 AND t.round = 22 ORDER BY team.conference 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 `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 = 5200 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC