4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CF Jaraíz

CF Jaraíz

Entrenador: Dani Baños

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 33 62 13 73
2 CD Coria CD Coria 33 58 19 69
3 CD Azuaga CD Azuaga 33 47 31 59
4 Villafranca Villafranca 33 43 26 52
5 Moralo Moralo 33 53 44 50
6 Castuera Castuera 33 46 37 49
7 CD Diocesano Diocesano 33 47 46 46
8 CF Jaraíz CF Jaraíz 33 48 49 45
9 Calamonte Calamonte 33 38 46 42
10 Jerez Jerez 33 41 49 42
11 Pueblonuevo Pueblonuevo 33 33 43 42
12 Olivenza Olivenza 33 32 38 41
13 Arroyo Arroyo 33 33 37 41
14 Trujillo Trujillo 33 30 36 38
15 Montehermoso Montehermoso 33 33 54 32
16 CD Don Álvaro Álvaro 33 28 48 31
17 Racing Valverdeño Racing 33 31 56 29
18 UD Fuente de Cantos Fuente 33 25 56 24
TEMPORADA 2022/2023
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 CF Jaraíz CF Jaraíz 22 49 13 53
2 Moraleja Moraleja 22 39 34 42
3 Moralo B Moralo B 22 41 26 39
4 Amanecer Amanecer 22 34 23 35
5 Chinato Chinato 22 32 33 35
6 Talayuela Talayuela 22 29 21 31
7 Malpartida Malpartida 22 26 23 27
8 CF Casar de Caceres Sotobos Casar 22 21 31 24
9 Ciudad De Plasencia Ciudad 22 22 37 23
10 Cacereño B Cacereño B 22 23 33 20
11 AD Valdefuentes Valdefuentes 22 24 49 17
12 AD Puente San Francisco Puente 22 14 31 15
TEMPORADA 2021/2022
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Montehermoso Montehermoso 22 50 11 49
2 Moraleja Moraleja 22 56 19 45
3 CF Jaraíz CF Jaraíz 22 44 14 44
4 Amanecer Amanecer 22 39 25 42
5 Talayuela Talayuela 22 29 18 41
6 CF Caceres CF Caceres 22 34 24 31
7 Chinato Chinato 22 28 30 30
8 AD Valdefuentes Valdefuentes 22 35 40 26
9 Ciudad De Plasencia Ciudad 22 25 42 24
10 Malpartida Malpartida 22 22 40 17
11 Piornal Piornal 22 19 60 15
12 Cabezuela Cabezuela 22 15 73 8
TEMPORADA 2020/2021
1ª REGIONAL EXTREMADURA GRUPO 8
Equipo PJ GF GC Puntos
1 CD Gévora CD Gévora 4 9 7 8
2 Hernán Cortés Hernán 4 8 4 7
3 CF Jaraíz CF Jaraíz 4 8 5 7
4 UC La Estrella Estrella 4 6 11 4
5 Valdelacalzada Valdelacalza 4 8 12 1
TEMPORADA 2019/2020
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Chinato Chinato 25 47 24 57
2 Amanecer Amanecer 25 55 17 50
3 Montehermoso Montehermoso 25 38 29 48
4 CD San Serván Serván 25 49 40 46
5 CD Don Álvaro Álvaro 25 61 38 44
6 AD Valdefuentes Valdefuentes 25 68 39 43
7 Guareña Guareña 25 48 40 38
8 Malpartida Malpartida 24 39 30 37
9 Talayuela Talayuela 24 44 38 34
10 Moraleja Moraleja 24 47 42 33
11 CF Jaraíz CF Jaraíz 24 34 45 29
12 Calamonte UD Calamonte 25 37 51 28
13 Atlético Torremejía Atlético 24 29 55 19
14 Las Hurdes CF Hurdes 25 32 64 19
15 CD Zarceño CD Zarceño 25 33 74 17
16 Piornal Piornal 24 16 51 16
TEMPORADA 2018/2019
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 CF Caceres CF Caceres 24 61 23 53
2 CF Jaraíz CF Jaraíz 24 80 21 52
3 Hervas A Hervas A 24 53 29 46
4 Cabezuela Cabezuela 24 52 32 44
5 Atletico Tietar Atletico 24 49 41 40
6 Navalmoral Navalmoral 23 44 35 37
7 Imperio De Alcuescar A Imperio 24 38 50 31
8 Brocense Brocense 24 39 48 28
9 Ad Casar De Cáceres Casar 24 26 37 28
10 Nuevo Plasencia Nuevo 24 45 52 25
11 Cumbreño Cumbreño 23 32 53 24
12 CD Almoharín Almoharín 24 25 50 20
13 Valencia de Alcantara A Valencia 24 20 93 7
TEMPORADA 2017/2018
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Imperio De Alcuescar A Imperio 21 44 25 41
2 Brocense Brocense 22 39 34 39
3 CF Jaraíz CF Jaraíz 22 34 27 38
4 AD Valdefuentes Valdefuentes 22 47 35 36
5 Nuevo Plasencia Nuevo 22 43 29 35
6 Amanecer B Amanecer B 22 41 35 32
7 Cabezuela Cabezuela 22 40 32 31
8 CD Almoharín Almoharín 21 30 31 29
9 Cumbreño Cumbreño 22 38 44 25
10 Navalmoral Navalmoral 22 29 52 21
11 Atletico Tietar Atletico 20 23 46 19
12 Hervas A Hervas A 22 29 47 17
TEMPORADA 2016/2017
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Trujillo Trujillo 30 66 21 72
2 Montehermoso Montehermoso 30 86 33 70
3 CD Diocesano Diocesano 30 83 28 69
4 Ciudad De Plasencia Ciudad 30 60 32 58
5 Miajadas Miajadas 30 52 30 55
6 Hernán Cortés Hernán 30 41 42 46
7 Chinato Chinato 30 47 33 44
8 Talayuela Talayuela 30 51 51 40
9 AD San Jorge Jorge 30 54 62 37
10 Las Hurdes CF Hurdes 29 33 46 37
11 Olympic Peleño Olympic 30 45 58 33
12 Plus Ultra A Plus Ultra 30 51 59 32
13 Moraleja Moraleja 30 30 69 28
14 CF Jaraíz CF Jaraíz 29 32 73 21
15 Amanecer B Amanecer B 30 31 72 19
16 Navalmoral Navalmoral 30 38 91 15
TEMPORADA 2015/2016
PREFERENTE EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 UP Plasencia Plasencia 30 84 29 69
2 Trujillo Trujillo 30 59 25 66
3 CD Diocesano Diocesano 30 57 35 59
4 Ciudad De Plasencia Ciudad 30 45 29 55
5 CD San Serván Serván 30 54 32 52
6 Miajadas Miajadas 30 61 35 49
7 AD San Jorge Jorge 30 59 48 45
8 Arroyo Cp B Arroyo Cp B 30 48 37 45
9 Montehermoso Montehermoso 30 33 47 38
10 Talayuela Talayuela 30 35 51 37
11 Las Hurdes CF Hurdes 30 42 62 34
12 Chinato Chinato 30 40 55 31
13 Alburquerque Alburquerque 30 31 54 29
14 CF Jaraíz CF Jaraíz 30 34 63 27
15 Navalmoral Navalmoral 30 34 60 27
16 CD Ciconia Negra Ciconia 30 26 80 12
TEMPORADA 2014/2015
1ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 CF Jaraíz CF Jaraíz 20 48 18 41
2 Hervas A Hervas A 20 50 29 39
3 Las Hurdes CF Hurdes 20 46 29 38
4 Brocense Brocense 20 43 29 37
5 Piornal Piornal 20 43 26 33
6 Torreorgaz Torreorgaz 20 36 37 28
7 UDA A UDA A 20 44 49 26
8 AD Valdefuentes Valdefuentes 20 34 40 23
9 Losareño A Losareño A 20 43 71 20
10 Peraleda de la Mata Peraleda 20 25 52 16
11 Cabezuela Cabezuela 20 30 62 11
TEMPORADA 2012/2013
PREFERENTE EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Sanvicenteño Sanvicenteñ 30 82 21 71
2 CD Diocesano Diocesano 30 67 35 64
3 Malpartida Malpartida 30 61 28 60
4 Montehermoso Montehermoso 30 50 30 59
5 Cp Alburquerque Alburquerque 30 66 30 58
6 Ad Casar De Cáceres Casar 30 54 30 58
7 Arroyo Cp B Arroyo Cp B 30 57 45 41
8 AD Valdefuentes Valdefuentes 30 39 46 38
9 Trujillo Trujillo 30 38 49 37
10 Cp Amanecer Cp Amanecer 30 40 51 36
11 Chinato Chinato 30 41 53 34
12 CD Ciconia Negra Ciconia 30 34 72 29
13 Moralo B Moralo B 30 35 48 28
14 CF Jaraíz CF Jaraíz 30 35 74 22
15 CD Coria B CD Coria B 30 31 63 20
16 Talayuela Talayuela 30 31 86 12

  USO DE MEMORIA  
6,186,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1030
Total Execution Time  0.1043
  CADENA URL  
/historico/Cf-Jaraiz-Senior
  GET DATOS  
$_GET['/historico/Cf-Jaraiz-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0039  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 = 72676
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11108 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
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 = '11108' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 72274 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=11108 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72676,72274,71439,71432) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72274 AND teamId = 11108
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71439 AND teamId = 11108
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72676 AND teamId = 11108
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11108
0.0020  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 = '11108' 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 = '11108' and rp.type = 4
0.0020  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 = '11108' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 11108 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.0026  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 11108 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 11108 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 11108 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 = 72274 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.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 = 68800 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.0021  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 = 63716 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.0020  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 `tables2021` 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 = 59499 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2021` 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 = 62270 AND t.round = 5 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 `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 = 51306 AND t.round = 25 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 = 45372 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 39812 AND t.round = 22 ORDER BY team.conference 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 `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 = 34427 AND t.round = 30 ORDER BY team.conference 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 `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 = 16716 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 5201 AND t.round = 22 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 `tables2013` 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 = 2200 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC