4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FMD Zafra
TEMPORADA 2023/2024
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Badajoz B Badajoz 23 63 39 50
2 FMD Zafra FMD Zafra 24 59 34 49
3 Cpvo Alburquerque Cpvo 23 52 33 45
4 Puebla de la Calzada Puebla 23 46 22 43
5 UC La Estrella Estrella 23 47 30 43
6 AP Santa Isabel Santa Isabel 24 52 46 39
7 Jerez CF Jerez CF 23 69 48 38
8 Hispanolusa Hispanolusa 24 58 49 35
9 Flecha Negra B Flecha Negra 23 58 42 32
10 Don Bosco B Don Bosco B 23 49 52 29
11 CD Guadiana CD Guadiana 23 38 51 25
12 Gevora Gevora 24 41 56 25
13 Cpvo Gran Maestre Cpvo Gran M. 22 30 46 19
14 AD Llerenense Llerenense 23 22 76 14
15 CPvo. Oliva CPvo. Oliva 23 32 92 11
TEMPORADA 2022/2023
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Olivenza Sub 19 Olivenza 26 58 15 57
2 Hispanolusa Hispanolusa 26 72 34 54
3 UD Fuente de Cantos Sub 19 Fuente 26 76 32 53
4 FMD Zafra FMD Zafra 26 48 28 45
5 CD Guadiana CD Guadiana 26 54 37 44
6 CD Valdelacalzada Sub 19 Valdelacalza 26 44 52 42
7 AD Llerenense Llerenense 26 45 47 38
8 Don Bosco B Don Bosco B 26 54 61 36
9 UC La Estrella Estrella 26 40 37 35
10 CP Flecha Negra Sub 19 Flecha Negra 26 53 50 32
11 Gevora Gevora 26 39 51 27
12 Cpvo Alburquerque Cpvo 26 46 53 24
13 San Roque CD Roque 26 42 61 24
14 Talarrubias Talarrubias 26 38 151 1
TEMPORADA 2021/2022
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Gimnastico Don Benito A Gimnastico 24 66 24 56
2 FMD Zafra FMD Zafra 24 52 35 42
3 Talarrubias A Talarrubias 23 45 39 42
4 UD Fuente de Cantos Sub 19 Fuente 24 48 29 40
5 CP Flecha Negra Sub 19 Flecha Negra 24 68 52 40
6 Gevora A Gevora A 23 57 41 40
7 CD Santa Amalia Sub 19 Santa Amalia 24 34 33 36
8 Alburquerque A Alburquerque 24 39 35 32
9 Uc La Estrella A Estrella 24 40 51 31
10 Polideportivo Guareña A Polideportiv 24 55 54 28
11 Guadiana A Guadiana A 24 38 54 23
12 Campanario A Campanario 24 23 85 13
13 Puebla de la Calzada Puebla 24 34 67 12
TEMPORADA 2020/2021
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Cruz Villanovense Sub 19 B Cruz 22 82 14 60
2 Villafranca Sub 19 Villafranca 22 41 30 47
3 UD Fuente de Cantos Sub 19 Fuente 22 47 33 45
4 Don Benito Sub 19 Benito 22 49 28 40
5 FMD Zafra FMD Zafra 22 45 23 36
6 UC La Estrella Estrella 22 45 39 31
7 Alburquerque A Alburquerque 22 35 39 27
8 Campanario A Campanario 22 30 62 25
9 CP Flecha Negra Sub 19 Flecha Negra 22 37 34 22
10 Valverdeño A Valverdeño 22 31 62 22
11 Gevora A Gevora A 22 30 61 16
12 Gran Maestre A Gran Maestre 22 26 73 12
TEMPORADA 2019/2020
2ª EXTREMADURA JUVENIL GRUPO 5
Equipo PJ GF GC Puntos
1 Uc La Estrella A Estrella 20 58 19 47
2 FMD Zafra FMD Zafra 19 53 13 45
3 UD Fuente de Cantos Sub 19 Fuente 19 59 30 43
4 Fornacense A Fornacense 20 61 27 39
5 Ap Colegio San Jose Colegio Jose 19 61 32 38
6 AD Llerenense Llerenense 20 51 25 38
7 E.MF Azuaga E.MF Azuaga 20 41 36 31
8 Alconchel Alconchel 19 44 37 25
9 CPvo. Oliva CPvo. Oliva 20 43 47 24
10 Monesterio A Monesterio 20 37 45 21
11 Bienvenida Bienvenida 20 38 66 16
12 Alfar-Salvatierra A Alfar-Salvat 19 22 76 11
13 Hernando de Soto A Hernando 19 19 87 9
14 Ribereña Ribereña 20 23 70 7
TEMPORADA 2018/2019
2ª EXTREMADURA JUVENIL GRUPO 5
Equipo PJ GF GC Puntos
1 Gran Maestre A Gran Maestre 22 62 17 56
2 FMD Zafra FMD Zafra 22 50 26 45
3 Villafranca Sub 19 Villafranca 22 60 31 42
4 Vadesa A Vadesa A 22 63 27 41
5 Alconchel Alconchel 22 52 38 38
6 Llerenense A Llerenense 22 54 35 37
7 Tenis Azuaga A Tenis Azuaga 22 49 40 31
8 Frexnense A Frexnense A 22 41 45 30
9 Uc La Estrella A Estrella 22 33 46 25
10 Colegio San Jose A Colegio Jose 22 26 83 16
11 Bienvenida A Bienvenida 22 21 77 6
12 Almendralejo C Almendralejo 22 17 63 5
13 Aceuchal A Aceuchal A 0 0 0 0
TEMPORADA 2017/2018
2ª EXTREMADURA JUVENIL GRUPO 6
Equipo PJ GF GC Puntos
1 Fornacense A Fornacense 18 52 27 38
2 FMD Zafra FMD Zafra 18 41 11 37
3 Alconchel A Alconchel A 18 38 26 30
4 Gran Maestre A Gran Maestre 18 44 39 28
5 Monesterio A Monesterio 18 29 34 22
6 Frexnense A Frexnense A 18 28 41 20
7 Llerenense A Llerenense 18 29 50 13
8 Oliva A Oliva A 18 29 62 12

  USO DE MEMORIA  
5,158,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1025
Total Execution Time  0.1047
  CADENA URL  
/historico/Fmd-Zafra-A-Juvenil
  GET DATOS  
$_GET['/historico/Fmd-Zafra-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0031  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 = 'Fmd-Zafra-A-Juvenil' 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.0019  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=103462 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=103462 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 74715
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103462 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=836 AND type_rel = 3
0.0021  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 = '103462' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '103462' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '103462' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74715 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=103462 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (74715) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74715 AND teamId = 103462
0.0019  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 = 74715 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '103462' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  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 = '103462' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 103462 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_base` 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 = 74715 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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_base` 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 = 70126 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.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_base` 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 = 66169 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.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 `tables2021_base` 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 = 59834 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 `tables2020_base` 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 = 52684 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.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 `tables2019_base` 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 = 45842 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_base` 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 = 40038 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC