4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del EFB La Roda
TEMPORADA 2023/2024
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Pedroñeras Pedroñeras 30 42 16 62
2 Valdepeñas Valdepeñas 30 53 28 61
3 Manzanares CF Manzanares 31 44 26 60
4 UD Almansa UD Almansa 31 62 30 59
5 Motilla CF Motilla CF 31 52 30 56
6 Atlético Teresiano Atlético 30 49 45 51
7 AD Campillo AD Campillo 30 59 36 50
8 Sporting de Alcazar Sporting 31 46 37 47
9 UD Carrión UD Carrión 31 38 41 45
10 C.F. Almodovar C.F. 30 32 29 44
11 EFB La Roda EFB La Roda 30 41 47 43
12 CD Quintanar de la Orden Quintanar 30 44 39 40
13 La Roda CF La Roda CF 30 41 51 34
14 Patrimonio Almadén CF Patrimonio 30 33 58 30
15 Miguelturreño Miguelturre 30 30 48 27
16 Socuéllamos B Socuéllamos 31 29 53 22
17 C.D. Caudetano C.D. 31 34 77 18
18 UD La Fuente Fuente 31 28 66 13
TEMPORADA 2022/2023
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Albacete Atlético 36 93 21 96
2 Huracan de Balazote Huracan 36 87 20 88
3 AD San Clemente Clemente 36 51 18 81
4 UD Almansa UD Almansa 36 84 37 74
5 CD Pedroñeras Pedroñeras 36 50 26 67
6 Valdepeñas Valdepeñas 36 58 48 60
7 UD La Fuente Fuente 36 57 53 55
8 EFB La Roda EFB La Roda 36 42 48 50
9 AD Campillo AD Campillo 36 42 42 48
10 Atlético Teresiano Atlético 36 44 52 47
11 UD Carrión UD Carrión 36 54 50 45
12 Manzanares CF Manzanares 36 59 60 45
13 Motilla CF Motilla CF 36 41 60 39
14 Miguelturreño Miguelturre 36 43 67 37
15 La Roda CF La Roda CF 36 30 46 34
16 Atlético Ibañés Atlético 36 32 68 32
17 Atco. Pedro Muñoz Atco. Pedro 36 20 60 23
18 Criptanense Criptanense 36 32 63 22
19 Membrilla CF Membrilla 36 19 99 9
TEMPORADA 2021/2022
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 CF La Solana Solana 33 77 30 74
2 Atlético Tomelloso Atlético 34 50 36 63
3 Manzanares CF Manzanares 34 57 27 62
4 CD Pedroñeras Pedroñeras 34 57 37 61
5 Valdepeñas Valdepeñas 34 67 48 57
6 AD Campillo AD Campillo 34 53 42 52
7 UD Carrión UD Carrión 34 59 47 49
8 CD Quintanar de la Orden Quintanar 34 48 34 48
9 Criptanense Criptanense 34 45 34 48
10 Sporting de Alcazar Sporting 34 37 48 45
11 Atlético Ibañés Atlético 34 50 41 44
12 UD La Fuente Fuente 34 59 58 44
13 EFB La Roda EFB La Roda 34 44 47 42
14 CDB Herencia Herencia 34 49 53 40
15 C.F. Almodovar C.F. 34 37 53 37
16 Munera Munera 34 52 76 34
17 C.D. Caudetano C.D. 33 31 98 27
18 Almagro CF Almagro CF 34 26 89 16
TEMPORADA 2020/2021
1ª AUTO. CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 EFB La Roda EFB La Roda 24 47 20 51
2 C.D. Caudetano C.D. 24 43 16 51
3 Deportivo Barrax Deportivo 25 42 29 44
4 Imperial de Bonete Imperial 24 56 31 42
5 Cristo Minglanilla Cristo 24 54 45 40
6 Atletico Jareño Atletico 24 33 35 38
7 Motilla CF Motilla CF 25 41 37 37
8 Casasimarro Casasimarro 24 43 44 32
9 Al-Basit Al-Basit 24 38 43 31
10 U.D. Alpera U.D. Alpera 24 40 47 28
11 Villamalea Villamalea 24 30 38 27
12 Mahora Mahora 24 32 42 27
13 Hellin CF Hellin CF 24 0 72 0
TEMPORADA 2019/2020
1ª AUTO. CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Munera Munera 23 59 20 53
2 Casasimarro Casasimarro 23 33 20 44
3 Atlético Ossa CF Atlético 23 36 27 42
4 EFB La Roda EFB La Roda 23 34 21 38
5 Imperial de Bonete Imperial 23 34 22 38
6 Mahora Mahora 22 32 30 35
7 Almansa B Almansa B 22 32 30 34
8 Hellin CF Hellin CF 23 39 40 33
9 C.D. Caudetano C.D. 23 40 42 29
10 Motilla CF Motilla CF 23 37 41 29
11 Atletico Jareño Atletico 23 25 26 28
12 Al-Basit Al-Basit 23 23 40 26
13 U.D. Alpera U.D. Alpera 23 36 34 25
14 El Bonillo El Bonillo 23 24 39 23
15 Villamalea Villamalea 23 25 42 18
16 Casas de Haro Casas Haro 23 11 46 13
TEMPORADA 2018/2019
1ª AUTO. CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Atletico Jareño Atletico 30 52 29 57
2 Atlético Tarazona Atlético 30 47 26 56
3 Casasimarro Casasimarro 29 58 33 50
4 Motilla CF Motilla CF 30 43 34 47
5 Villamalea Villamalea 30 39 32 46
6 EFB La Roda EFB La Roda 30 41 36 46
7 CD Manchego Provencio Manchego 30 42 44 44
8 Atlético Ossa CF Atlético 29 47 42 40
9 Munera Munera 30 40 41 40
10 Imperial de Bonete Imperial 30 44 47 37
11 Casas de Haro Casas Haro 30 18 36 34
12 El Bonillo El Bonillo 30 30 37 33
13 Al-Basit Al-Basit 30 35 44 32
14 U.D. Alpera U.D. Alpera 30 38 53 32
15 Olimpico Madrigueras Olimpico 30 33 56 29
16 Deportivo Barrax Deportivo 30 43 60 27
TEMPORADA 2017/2018
1ª AUTO. CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Hellin CF Hellin CF 30 70 29 63
2 AD Campillo AD Campillo 30 52 26 62
3 Atlético Tarazona Atlético 30 58 28 59
4 CD Manchego Provencio Manchego 30 49 29 53
5 Villamalea Villamalea 30 46 47 40
6 Motilla CF Motilla CF 30 39 44 40
7 El Bonillo El Bonillo 30 49 56 40
8 Casasimarro Casasimarro 30 45 41 39
9 Munera Munera 30 47 49 38
10 Olimpico Madrigueras Olimpico 30 45 41 36
11 Al-Basit Al-Basit 30 38 42 35
12 EFB La Roda EFB La Roda 30 39 52 35
13 U.D. Alpera U.D. Alpera 30 42 51 34
14 Casas de Haro Casas Haro 30 26 42 34
15 Teatinos Teatinos 30 34 51 33
16 Chinchilla Chinchilla 30 29 80 14
TEMPORADA 2016/2017
1ª AUTO. CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 AD San Clemente Clemente 30 45 21 57
2 Cultural Valdeganga Cultural 30 61 41 57
3 Las Mesas Las Mesas 30 48 36 51
4 Casasimarro Casasimarro 30 68 48 49
5 Atlético Tarazona Atlético 30 54 43 46
6 Olimpico Madrigueras Olimpico 30 45 51 42
7 Ascensores Eninter Los Llan Ascensores 30 34 36 41
8 Al-Basit Al-Basit 30 46 46 40
9 El Bonillo El Bonillo 30 36 39 39
10 EFB La Roda EFB La Roda 30 40 45 38
11 AD Campillo AD Campillo 29 38 46 37
12 Motilla CF Motilla CF 30 30 39 35
13 CD Manchego Provencio Manchego 29 46 51 34
14 CD Mota Del Cuervo Mota Cuervo 30 34 44 33
15 Chinchilla Chinchilla 30 30 49 33
16 Quintanar del Rey B Quintanar 30 33 53 31
TEMPORADA 2015/2016
1ª AUTO. CASTILLA-LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Villamalea Villamalea 29 66 23 62
2 Atletico Jareño Atletico 30 64 33 61
3 Atlético Tarazona Atlético 29 47 29 55
4 Quintanar del Rey B Quintanar 29 54 35 53
5 EFB La Roda EFB La Roda 29 61 39 45
6 Las Mesas Las Mesas 30 49 44 45
7 CD Manchego Provencio Manchego 30 57 47 43
8 Cultural Valdeganga Cultural 29 45 57 37
9 AD San Clemente Clemente 29 47 48 36
10 El Bonillo El Bonillo 30 41 55 35
11 Olimpico Madrigueras Olimpico 29 42 56 35
12 Chinchilla Chinchilla 29 45 55 33
13 CD Mota Del Cuervo Mota Cuervo 29 40 52 33
14 Ibañes B Ibañes B 29 48 50 31
15 Mahora Mahora 30 30 55 26
16 Almendras De La Mancha Almendras 20 20 78 6
TEMPORADA 2014/2015
2ª AUTO. CASTILLA-LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 EFB La Roda EFB La Roda 24 92 19 56
2 Atletico Jareño Atletico 24 57 18 56
3 Almoradiel Almoradiel 24 77 29 54
4 Las Mesas Las Mesas 23 51 16 52
5 El Toboso - Villalcázer Toboso 24 41 33 37
6 Villafranca Villafranca 24 46 44 36
7 Alto Jucar Alto Jucar 24 45 47 34
8 Optense Optense 24 29 63 23
9 Atletico Sisante Atletico 23 33 72 22
10 Ascensores Eninter Los Llan Ascensores 24 29 43 21
11 Casas de Haro Casas Haro 24 25 47 20
12 Deportivo Barrax Deportivo 24 22 63 20
13 Teatinos Teatinos 24 19 72 10

  USO DE MEMORIA  
6,126,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3438
Total Execution Time  0.3450
  CADENA URL  
/historico/La-Roda-Rodacal-Beyem
  GET DATOS  
$_GET['/historico/La-Roda-Rodacal-Beyem']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30536 AND type_rel = 2
0.0108  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 = '30536' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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=30536 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (73526) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 73526 AND teamId = 30536
0.0107  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 = '30536' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0121  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30536' and rp.type = 4
0.0108  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 = '30536' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0119  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 = 73526 WHERE rp.league_id = 73526 AND rp.teamId = 30536 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.0116  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 = 73526 WHERE rp.league_id = 73526 AND rp.teamId = 30536 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 73526 WHERE rp.league_id = 73526 AND rp.teamId = 30536 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 30536 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0213  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 = 68796 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 63675 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.0109  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 = 59882 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.0113  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 = 51319 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.0115  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 = 45377 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119  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 = 39791 AND t.round = 30 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 `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 = 34565 AND t.round = 30 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 = 16789 AND t.round = 30 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 `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 = 5249 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC