4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Enguera
TEMPORADA 2023/2024
SEGUNDA FFCV GRUPO 5
Equipo PJ GF GC Puntos
1 Vall Dels Alcalans Vall Dels A. 28 78 18 78
2 Rafelguaraf Rafelguaraf 27 55 25 57
3 Alcàsser Alcàsser 27 58 27 55
4 Ayorense Ayorense 27 52 32 46
5 Enguera Enguera 27 58 43 44
6 L'Alcudia de Crespins L'Alcudia 28 38 43 38
7 CD Llosa CD Llosa 27 38 40 37
8 Picassent Picassent 27 46 48 35
9 CD Benifaio CD Benifaio 28 44 62 33
10 UD Castellonense B Castellonens 28 38 48 33
11 Balompié Alfafar Balompié 28 38 55 32
12 Almusafes Almusafes 28 39 48 30
13 Moixent C.F. Moixent C.F. 27 42 47 28
14 Carlet Carlet 27 34 47 25
15 Union Benetuser-Fabara B Union 27 40 57 24
16 Racing Xativa A Racing 27 23 81 16
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 5
Equipo PJ GF GC Puntos
1 UE La Mancomunitat Mancomunitat 30 64 39 62
2 Racing D´ Algemesí Racing 29 56 25 60
3 Massanassa C.F. A Massanassa 30 59 25 57
4 Alcàsser Alcàsser 30 62 31 55
5 Picassent Picassent 30 55 36 49
6 Enguera Enguera 29 52 37 48
7 CD Llosa CD Llosa 30 51 32 47
8 Almusafes Almusafes 30 48 44 46
9 UD Castellonense B Castellonens 30 54 55 45
10 Vall Dels Alcalans Vall Dels A. 30 42 42 42
11 C.D. Apolo C.D. Apolo 30 49 60 36
12 Moixent C.F. Moixent C.F. 30 36 49 31
13 Rafelguaraf Rafelguaraf 29 43 56 26
14 Balompié Alfafar Balompié 29 48 85 23
15 CD Benifaio CD Benifaio 30 39 85 23
16 Racing Xativa A Racing 30 35 92 14
TEMPORADA 2021/2022
PRIMERA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 UD Aldaia UD Aldaia 30 48 27 62
2 UD Castellonense Castellonens 30 46 21 57
3 Carcaixent Carcaixent 30 51 36 55
4 L'Alcúdia L'Alcúdia 30 47 23 54
5 UD Quart De Poblet Quart Poblet 30 46 24 54
6 Paiporta Paiporta 30 51 29 48
7 Alberic Alberic 30 41 32 42
8 Juv. Barrio Cristo Juv. Barrio 30 38 39 39
9 San Marcelino Marcelino 30 33 45 38
10 Union Benetuser Union 30 34 36 37
11 Alginet Alginet 30 44 55 35
12 Canals Canals 30 40 45 33
13 Alaquas I Walter A Alaquas 30 35 63 32
14 Enguera Enguera 30 23 47 28
15 Alcàsser Alcàsser 30 26 51 24
16 L'Alcudia de Crespins L'Alcudia 30 32 62 23
TEMPORADA 2020/2021
PRIMERA FFCV GRUPO 4
Equipo PJ GF GC Puntos
1 UD Castellonense Castellonens 28 41 11 60
2 L'Alcúdia L'Alcúdia 28 56 26 56
3 Muro Muro 28 46 29 53
4 Rayo Ibense Rayo Ibense 28 44 24 52
5 SD Sueca SD Sueca 28 34 21 47
6 Carcaixent Carcaixent 28 33 21 44
7 L'Olleria L'Olleria 28 30 33 36
8 Canals Canals 28 28 34 36
9 Alberic Alberic 28 31 28 34
10 Alginet Alginet 28 22 35 31
11 Enguera Enguera 28 27 40 27
12 L'Alcudia de Crespins L'Alcudia 28 29 46 27
13 Promeses Sueca Promeses 28 26 43 25
14 Almusafes Almusafes 28 25 42 24
15 CD Llosa CD Llosa 28 26 65 15
TEMPORADA 2019/2020
PRIMERA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 UD Castellonense Castellonens 26 42 16 60
2 Muro Muro 26 64 28 57
3 Tavernes de la Valldigna Tavernes 26 49 22 52
4 Carcaixent Carcaixent 26 38 19 51
5 Jávea Jávea 26 37 25 48
6 L'Alcúdia L'Alcúdia 26 47 34 43
7 L'Olleria L'Olleria 26 30 27 37
8 Canals Canals 26 33 45 34
9 Dénia Dénia 26 40 38 30
10 Pego Pego 26 35 39 30
11 Pedreguer Pedreguer 26 34 52 29
12 Alginet Alginet 26 22 35 27
13 Portuarios Portuarios 26 34 37 25
14 Racing Rafelcofer Racing 26 23 32 25
15 Enguera Enguera 26 30 43 23
16 Alcàsser Alcàsser 26 31 56 23
17 SD Sueca SD Sueca 26 31 46 20
18 CD Llosa CD Llosa 26 25 51 17
TEMPORADA 2016/2017
SEGUNDA FFCV GRUPO 6
Equipo PJ GF GC Puntos
1 Tous Tous 30 84 17 75
2 Aspe UD Aspe UD 30 68 41 62
3 Enguera Enguera 30 50 33 53
4 Idella A Idella A 30 42 34 49
5 L'Olleria L'Olleria 30 49 41 47
6 CD Chella CD Chella 30 47 47 43
7 Ayorense Ayorense 30 60 53 41
8 Muro B Muro B 30 45 48 41
9 L'Alcúdia Cr. L'Alcúdia 30 35 42 40
10 SB Ontinyent Ontinyent 30 45 54 39
11 Moixent C.F. Moixent C.F. 30 35 35 38
12 Novelda B Novelda B 30 39 56 34
13 Monovar C.D. Monovar C.D. 30 40 51 33
14 Sp. Villena Sp. Villena 30 33 45 33
15 CD Olímpic B Olímpic 30 28 52 26
16 Pobla Llarga Pobla Llarga 30 23 74 17
TEMPORADA 2015/2016
TERCERA FFCV GRUPO 10
Equipo PJ GF GC Puntos
1 Enguera Enguera 34 122 29 81
2 Ayorense Ayorense 34 94 52 74
3 Rafelguaraf Rafelguaraf 34 103 64 72
4 A. Promeses A Promeses 34 99 30 71
5 Carcer Carcer 34 79 40 70
6 Genoves Genoves 34 79 47 66
7 Navarres Navarres 34 91 63 58
8 CD Olímpic B Olímpic 34 71 52 56
9 Canals B Canals B 34 53 62 46
10 La Ribera La Ribera 34 69 83 46
11 Vallada Vallada 34 64 66 45
12 Anna Anna 34 72 86 45
13 L'Alcúdia B L'Alcúdia 34 60 60 40
14 Canalense B Canalense B 34 56 93 29
15 Racing Xativa A Racing 34 44 92 28
16 Albalat Albalat 34 42 111 27
17 Fuente La Higuera A Fuente 34 24 89 20
18 Fenollet Fenollet 34 24 127 3
TEMPORADA 2010/2011
PRIMERA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 CD Llosa CD Llosa 34 69 26 80
2 Muro Muro 34 69 31 75
3 Alberic Alberic 34 52 22 72
4 Alginet Alginet 34 62 32 59
5 Ciudad de Gandía Ciudad 34 57 42 57
6 Canals Canals 34 45 39 56
7 Racing D´ Algemesí Racing 34 49 43 51
8 CD Torrent CD Torrent 34 45 39 51
9 Castellonense Castellonens 34 39 42 48
10 Benigànim Benigànim 34 58 57 44
11 Tavernes Tavernes 34 47 50 44
12 Ontinyent B Ontinyent B 34 52 44 41
13 CF Cullera CF Cullera 34 44 41 39
14 Pego Pego 34 49 61 38
15 Recambios Colón Recambios 34 30 43 38
16 Xirivella Xirivella 34 34 91 23
17 Enguera Enguera 34 24 66 21
18 Guadasuar Guadasuar 34 33 89 15
TEMPORADA 2009/2010
PRIMERA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Alberic Alberic 34 63 27 71
2 Muro Muro 34 76 38 63
3 Ciudad de Gandía Ciudad 34 63 43 63
4 CD Torrent CD Torrent 34 58 35 62
5 Racing D´ Algemesí Racing 34 62 46 60
6 Benigànim Benigànim 34 55 36 59
7 Alginet Alginet 34 51 50 49
8 Recambios Colón Recambios 34 44 40 45
9 CD Llosa CD Llosa 34 48 49 45
10 Tavernes Tavernes 34 56 52 44
11 Enguera Enguera 34 44 38 43
12 Canals Canals 34 45 44 42
13 Pego Pego 34 43 62 42
14 Guadasuar Guadasuar 34 29 34 41
15 Torrent Torrent 34 42 49 40
16 Carlet Carlet 34 42 58 33
17 Benifaio Benifaio 34 35 69 29
18 UD Oliva UD Oliva 34 14 100 6

  USO DE MEMORIA  
5,818,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0907
Total Execution Time  0.0919
  CADENA URL  
/historico/Enguera
  GET DATOS  
$_GET['/historico/Enguera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0028  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 = 'Enguera' 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=4078 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=4078 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4078 AND type_rel = 2
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 = '4078' ORDER BY l.year DESC,cat.coefficient DESC
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 = '4078' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '4078' 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 = 73808 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=4078 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 (73808) 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 WHERE league_id = 73808 AND teamId = 4078
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 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 = 73808 AND t.round = 28 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 = '4078' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '4078' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73808 WHERE rp.league_id = 73808 AND rp.teamId = 4078 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.0019  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 = 73808 WHERE rp.league_id = 73808 AND rp.teamId = 4078 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73808 WHERE rp.league_id = 73808 AND rp.teamId = 4078 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 = 4078 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73808 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `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 = 69373 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 `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 = 63638 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.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 `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 = 58874 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 `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 = 51212 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 `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 = 34296 AND t.round = 30 ORDER BY team.conference 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 `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 = 16887 AND t.round = 34 ORDER BY team.conference 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 `tables2011` 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 = 1202 AND t.round = 34 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 `tables2010` 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 = 896 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 73808 ORDER BY nameShow LIMIT 100