4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Almenara Atlètic
TEMPORADA 2023/2024
SEGUNDA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Almenara Atlètic Almenara 26 85 27 65
2 Jupiter de Massamagrell A Jupiter 26 70 28 56
3 Soneja B Soneja B 26 59 33 56
4 Meliana Meliana 26 54 30 55
5 Vall de Uxó B Vall Uxó 25 55 21 54
6 Deutsche Schule Valencia A Deutsche 26 56 40 47
7 At. Gilet At. Gilet 26 44 48 38
8 Jerica Jerica 26 37 29 36
9 CD Altura CD Altura 27 37 54 35
10 Saguntino B Saguntino B 27 30 41 28
11 CD Burriana B Burriana 26 31 37 27
12 El Puig El Puig 27 32 62 25
13 Faura Faura 26 35 74 20
14 La Vilavella Vilavella 25 44 73 18
15 FB Sagunto FB Sagunto 27 30 57 17
16 Rafelbuñol Rafelbuñol 26 19 64 14
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Mare Nostrum Puerto Sagunto Mare Nostrum 30 85 22 78
2 Nules Nules 30 77 29 70
3 Quart de Les Valls Quart Valls 30 74 30 65
4 CF Albuixech Albuixech 30 81 37 62
5 Almenara Atlètic Almenara 30 67 44 54
6 Betxi Betxi 30 57 38 49
7 At. Gilet At. Gilet 30 60 61 47
8 Vall de Uxó B Vall Uxó 30 53 45 41
9 FB Sagunto FB Sagunto 30 43 43 38
10 Faura Faura 30 54 74 37
11 Jupiter de Massamagrell A Jupiter 30 51 62 34
12 CD Burriana B Burriana 30 32 65 25
13 La Vilavella Vilavella 30 43 82 25
14 Jerica Jerica 30 31 56 23
15 Rafelbuñol Rafelbuñol 30 45 117 16
16 El Puig El Puig 30 29 77 15
TEMPORADA 2021/2022
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 UD Vall de Uxó Vall Uxó 30 55 24 65
2 CD Burriana CD Burriana 30 52 27 60
3 Soneja Soneja 30 55 23 57
4 Almazora Almazora 30 65 41 54
5 Huracan Moncada Huracan 30 41 33 49
6 L´Alcora L´Alcora 30 48 42 45
7 C.F San Pedro Pedro 30 50 43 44
8 Alqueríes CF Alqueríes 30 37 35 42
9 Onda Onda 30 45 42 40
10 Vinaròs Vinaròs 30 45 50 40
11 Cabanes Cabanes 30 35 44 38
12 CD Roda B CD Roda B 30 52 50 35
13 Ibarsos Ibarsos 30 37 51 33
14 Benicarló Benicarló 30 34 57 27
15 Mare Nostrum Puerto Sagunto Mare Nostrum 30 29 55 22
16 Almenara Atlètic Almenara 30 23 86 12
TEMPORADA 2020/2021
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CD Castellón B Castellón 26 54 22 59
2 UD Vall de Uxó Vall Uxó 26 60 21 55
3 Almazora Almazora 26 41 24 48
4 CD Burriana CD Burriana 26 43 27 47
5 Onda Onda 26 51 37 46
6 C.F San Pedro Pedro 26 33 23 45
7 Almenara Atlètic Almenara 26 44 42 39
8 Soneja Soneja 26 37 38 36
9 Cabanes Cabanes 26 39 38 34
10 L´Alcora L´Alcora 26 34 45 28
11 Alqueríes CF Alqueríes 26 30 44 28
12 Nules Nules 26 33 54 18
13 Villa de Onda Villa Onda 26 33 56 14
14 P. Tornesa P. Tornesa 26 23 84 6
TEMPORADA 2019/2020
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Benicarló Benicarló 26 41 25 50
2 CD Burriana CD Burriana 26 51 27 48
3 CD Castellón B Castellón 26 46 26 48
4 Almazora Almazora 26 38 19 47
5 UD Vall de Uxó Vall Uxó 26 37 19 46
6 Soneja Soneja 26 43 28 45
7 Puzol Puzol 26 50 32 43
8 Alcala Alcala 26 37 33 39
9 C.F San Pedro Pedro 26 36 40 34
10 Onda Onda 26 35 25 33
11 Cabanes Cabanes 26 40 39 32
12 L´Alcora L´Alcora 26 29 34 31
13 Huracan Moncada Huracan 26 36 43 28
14 Manises Manises 26 39 54 28
15 Alqueríes CF Alqueríes 26 25 44 26
16 Almenara Atlètic Almenara 26 24 46 24
17 Nules Nules 26 20 55 16
18 CF Albuixech Albuixech 26 23 61 14
TEMPORADA 2011/2012
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CD Burriana CD Burriana 34 105 28 84
2 Alqueríes CF Alqueríes 34 77 14 83
3 C.F San Pedro Pedro 34 57 45 65
4 Almazora Almazora 34 79 40 63
5 Nules Nules 34 71 43 59
6 UD Vall de Uxó Vall Uxó 34 56 39 57
7 Puçol Puçol 34 76 42 55
8 Onda Onda 34 64 38 55
9 CD Castellón B Castellón 34 67 67 46
10 San Jorge San Jorge 34 34 45 44
11 Benicassim Benicassim 34 71 67 43
12 Vinaròs Vinaròs 34 50 48 41
13 Cd Altura Cd Altura 34 46 68 39
14 Cd Acero B Cd Acero B 34 49 74 39
15 Cd Catí Cd Catí 34 40 65 37
16 Almenara Atlètic Almenara 34 33 104 18
17 Albocacer Cf Albocacer 34 28 102 17
18 Villafamés Villafamés 34 27 101 7
TEMPORADA 2010/2011
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CD Acero CD Acero 34 70 21 77
2 CD Burriana CD Burriana 34 82 35 71
3 Almazora Almazora 34 63 34 62
4 CD Castellón B Castellón 34 66 45 62
5 Benicassim Benicassim 34 61 53 55
6 Almenara Atlètic Almenara 34 58 45 54
7 UD Vall de Uxó Vall Uxó 34 54 46 54
8 San Jorge San Jorge 34 47 43 48
9 Benlloch Benlloch 34 55 52 48
10 Albocacer Cf Albocacer 34 51 43 41
11 Nules Nules 34 54 54 41
12 Onda Onda 34 40 60 39
13 Villafamés Villafamés 34 46 65 37
14 C.F San Pedro Pedro 34 39 67 37
15 Cd Altura Cd Altura 34 51 70 35
16 Alqueríes CF Alqueríes 34 41 63 32
17 L´Alcora L´Alcora 34 29 61 28
18 La Vilavella Vilavella 34 41 91 23
TEMPORADA 2009/2010
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CF Borriol CF Borriol 34 76 40 74
2 At. Saguntino Saguntino 34 62 26 73
3 Benlloch Benlloch 34 53 39 57
4 CD Castellón B Castellón 34 58 37 52
5 Villafamés Villafamés 34 45 39 50
6 Nules Nules 34 52 53 49
7 Benicassim Benicassim 34 42 43 48
8 Almenara Atlètic Almenara 34 57 48 47
9 La Vilavella Vilavella 34 50 50 47
10 CD Burriana CD Burriana 34 48 50 46
11 UD Vall de Uxó Vall Uxó 34 51 56 46
12 CD Acero CD Acero 34 57 51 45
13 Almazora Almazora 34 42 46 44
14 San Jorge San Jorge 34 39 40 43
15 L´Alcora L´Alcora 34 58 61 43
16 Vinaròs Vinaròs 34 53 54 42
17 Benicarló Benicarló 34 37 70 20
18 Pobla Farnals Pobla 34 40 117 16
TEMPORADA 2008/2009
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 CF Borriol CF Borriol 34 76 29 76
2 Benlloch Benlloch 34 63 29 75
3 At. Saguntino Saguntino 34 53 19 71
4 San Jorge San Jorge 34 54 29 69
5 Benicassim Benicassim 34 59 36 62
6 Almenara Atlètic Almenara 34 60 47 51
7 Villafamés Villafamés 34 53 47 46
8 UD Vall de Uxó Vall Uxó 34 48 42 46
9 CD Acero CD Acero 34 56 47 44
10 CD Burriana CD Burriana 34 45 66 43
11 Nules Nules 34 39 38 42
12 Almazora Almazora 34 47 62 42
13 Vinaròs Vinaròs 34 45 63 41
14 La Vilavella Vilavella 34 52 70 40
15 Benicarló Benicarló 34 38 62 36
16 CF Sant Rafel Sant Rafel 34 45 70 28
17 CF San Pedro Pedro 34 33 64 26
18 Estivella Estivella 34 23 69 13
TEMPORADA 2007/2008
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 At. Saguntino Saguntino 34 89 27 80
2 Benicassim Benicassim 34 67 28 71
3 San Jorge San Jorge 33 63 31 68
4 Nules Nules 34 57 31 67
5 CD Acero CD Acero 33 64 33 66
6 Vinaròs Vinaròs 34 64 46 56
7 Almenara Atlètic Almenara 34 49 46 49
8 Estivella Estivella 35 54 54 47
9 Almazora Almazora 34 49 43 46
10 Benicarló Benicarló 34 58 54 45
11 Benlloch Benlloch 35 66 60 43
12 Villafamés Villafamés 34 53 69 39
13 C.F San Pedro Pedro 34 43 68 34
14 UD Vall de Uxó Vall Uxó 34 43 55 33
15 CD Burriana CD Burriana 34 36 54 33
16 L´Alcora L´Alcora 34 49 81 30
17 Traiguera Traiguera 34 35 65 27
18 Orpesa Orpesa 34 18 112 22
TEMPORADA 2006/2007
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Villarreal C Villarreal 34 73 29 68
2 Almazora Almazora 34 67 32 66
3 Benicassim Benicassim 34 46 32 65
4 San Jorge San Jorge 34 70 33 64
5 Orpesa Orpesa 34 43 29 58
6 At. Saguntino Saguntino 34 59 31 57
7 CD Acero CD Acero 34 56 37 55
8 CD Burriana CD Burriana 34 62 38 54
9 Almenara Atlètic Almenara 34 48 42 52
10 Villafamés Villafamés 34 57 52 51
11 UD Vall de Uxó Vall Uxó 34 47 46 44
12 Vinaròs Vinaròs 34 29 46 39
13 C.F San Pedro Pedro 34 37 46 38
14 Benicarló Benicarló 34 37 55 37
15 CF Borriol CF Borriol 34 50 62 36
16 L´Alcora L´Alcora 34 34 53 36
17 Alcala de Xivert Alcala 34 24 98 11
18 San Mateo San Mateo 34 20 98 10

  USO DE MEMORIA  
6,106,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4822
Total Execution Time  0.4833
  CADENA URL  
/historico/Almenara
  GET DATOS  
$_GET['/historico/Almenara']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0132  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 = 'Almenara' 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.0125  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=182 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=182 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 73805
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=182 AND type_rel = 2
0.0128  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 = '182' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '182' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73805 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=182 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73805) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73805 AND teamId = 182
0.0128  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 = 73805 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '182' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '182' and rp.type = 4
0.0126  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 = '182' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  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 = 73805 WHERE rp.league_id = 73805 AND rp.teamId = 182 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.0127  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 = 73805 WHERE rp.league_id = 73805 AND rp.teamId = 182 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73805 WHERE rp.league_id = 73805 AND rp.teamId = 182 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 182 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73805 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 69370 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.0128  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 = 63636 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.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 `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 = 51210 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.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 `tables2012` 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 = 1459 AND t.round = 34 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 `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 = 1200 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 897 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2009` 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 = 326 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2008` 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 = 119 AND t.round = 34 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 `tables2007` 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 = 123 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC