4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Altet
TEMPORADA 2023/2024
TERCERA FFCV GRUPO 15
Equipo PJ GF GC Puntos
1 Real Club Ilicitano de Fútb Real Club I. 24 57 16 56
2 Formentera Formentera 25 47 24 51
3 Sp. Saladar Sp. Saladar 24 54 24 50
4 Callosa D. B Callosa 24 59 28 48
5 Bigastro Bigastro 24 59 33 47
6 SC Torrevieja B Torrevieja 24 46 26 37
7 CFP Orihuela Deportiva Orihuela 24 50 47 35
8 Altet Altet 25 41 51 34
9 Redovan B Redovan B 25 40 50 32
10 Benijofar Benijofar 24 42 38 31
11 Santa Pola B Santa Pola 23 42 49 27
12 Costa City B Costa City 24 35 43 27
13 Playas de Orihuela Playas 23 32 43 26
14 Benejuzar Benejuzar 24 33 55 22
15 United Elche A United Elche 25 29 81 14
16 Sporting San Fulgencio B Sporting 24 21 79 4
TEMPORADA 2022/2023
TERCERA FFCV GRUPO 16
Equipo PJ GF GC Puntos
1 Guardamar Soccer Guardamar 29 103 23 78
2 Callosa D. B Callosa 30 79 37 65
3 Sp. Albatera Albatera 29 80 30 63
4 CFP Orihuela Deportiva Orihuela 30 76 45 56
5 Formentera Formentera 30 72 49 53
6 Sp. Saladar Sp. Saladar 29 70 58 51
7 Bigastro Bigastro 30 63 55 47
8 Altet Altet 29 49 54 38
9 Santa Pola B Santa Pola 29 62 60 34
10 Sp. Costablanca Costablanca 30 50 62 32
11 United Elche A United Elche 29 54 71 32
12 Benijofar Benijofar 30 43 67 31
13 S. Fulgencio Fulgencio 30 39 67 29
14 UD Horadada UD Horadada 30 42 80 28
15 Benejuzar Benejuzar 28 43 73 22
16 Crevillente Crevillente 30 27 121 8
TEMPORADA 2021/2022
TERCERA FFCV GRUPO 16
Equipo PJ GF GC Puntos
1 UE Crevillent Crevillent 28 94 16 76
2 Guardamar Soccer Guardamar 28 124 25 69
3 Monovar A Monovar A 28 69 30 58
4 Formentera Formentera 29 78 39 54
5 Athletic Club Torrellano B Athletic 28 91 37 51
6 Sp. Saladar Sp. Saladar 28 54 42 51
7 Altet Altet 27 49 42 42
8 Benejuzar Benejuzar 28 64 56 40
9 UD Horadada UD Horadada 28 64 55 36
10 Bigastro Bigastro 28 43 61 31
11 Redovan B Redovan B 28 42 64 28
12 Callosa D. B Callosa 28 47 81 25
13 Inter Santa Pola Inter Santa 18 30 45 14
14 La Coca Aspense B Coca Aspense 28 31 111 12
15 Elche Dream B Elche Dream 28 24 111 12
16 The Warriors Burnham Warriors 12 10 99 1
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 29
Equipo PJ GF GC Puntos
1 Polop Polop 6 19 4 16
2 Agost Agost 6 10 12 11
3 Alicante City Alicante 6 14 7 10
4 Castalla Castalla 6 8 11 9
5 Mutxamel Mutxamel 6 6 9 8
6 Atletico Sedavi A Atletico 6 6 13 3
7 Altet Altet 6 4 11 1
TEMPORADA 2019/2020
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Santa Pola Cf Santa Pola 24 51 17 51
2 Il-Licitana Raval A Il-Licitana 24 45 23 43
3 San Miguel CF Miguel 24 38 34 42
4 Sax Sax 24 46 36 40
5 Atlético Catral Atlético 24 45 29 39
6 Callosa D. B Callosa 24 31 26 37
7 Rafal Rafal 24 32 29 37
8 Cox Cox 24 32 35 34
9 H. Nieves H. Nieves 24 42 42 32
10 Altet Altet 24 41 44 32
11 Torrevieja Torrevieja 24 26 29 31
12 CFP Orihuela Deportiva Orihuela 24 34 42 29
13 Castalla Castalla 24 56 58 27
14 Algueña Cf Algueña Cf 24 27 40 23
15 S. Fulgencio Fulgencio 24 25 56 16
16 Monovar C.D. Monovar C.D. 24 23 54 16
TEMPORADA 2018/2019
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 AC Torrellano Torrellano 30 74 31 68
2 Murada Murada 30 56 23 67
3 San Miguel CF Miguel 30 50 31 55
4 Santa Pola Cf Santa Pola 30 56 31 54
5 H. Nieves H. Nieves 30 52 45 52
6 Santa Pola Santa Pola 30 69 29 51
7 S. Fulgencio Fulgencio 30 52 57 44
8 Monovar C.D. Monovar C.D. 29 47 47 38
9 Callosa D. B Callosa 30 36 48 35
10 Atlético Catral Atlético 30 43 44 34
11 Altet Altet 30 47 62 34
12 Rafal Rafal 30 43 56 33
13 Dolores Dolores 30 40 59 31
14 Betis Florida Betis 29 44 63 30
15 CD Montesinos A Montesinos 30 37 40 29
16 Monforte Monforte 30 36 116 15
TEMPORADA 2017/2018
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 CF Intercity Intercity 30 85 18 76
2 UD Horadada UD Horadada 30 60 17 66
3 Santa Pola Cf Santa Pola 30 58 30 52
4 CD Montesinos A Montesinos 30 75 54 50
5 San Miguel CF Miguel 30 48 34 50
6 Dolores Dolores 29 42 46 42
7 Atlético Catral Atlético 30 36 41 40
8 Santa Pola Santa Pola 30 57 57 39
9 Rafal Rafal 30 47 44 37
10 Callosa D. B Callosa 30 49 53 37
11 CF San Gabriel Gabriel 29 53 66 37
12 Altet Altet 30 32 51 37
13 H. Nieves H. Nieves 30 48 58 34
14 S. Guardamar CF Guardamar 30 32 49 31
15 Cox Cox 30 31 69 25
16 SC Torrevieja CF Torrevieja 30 26 92 8
TEMPORADA 2016/2017
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Monforte Monforte 30 51 25 61
2 Rafal Rafal 30 64 36 58
3 Pinoso Pinoso 30 57 35 58
4 Santa Pola Santa Pola 30 56 41 50
5 Santa Pola Santa Pola 30 60 43 47
6 Atlético Catral Atlético 30 40 31 45
7 Dolores Dolores 29 48 39 44
8 San Miguel CF Miguel 29 54 39 42
9 UD Horadada UD Horadada 30 35 38 42
10 Algorfa Algorfa 30 40 44 41
11 Altet Altet 30 41 38 40
12 H. Nieves H. Nieves 29 45 50 39
13 SC Torrevieja CF Torrevieja 30 43 64 31
14 Bigastro Bigastro 30 35 44 29
15 AC Torrellano Torrellano 29 39 70 20
16 Sp. Saladar Sp. Saladar 30 32 103 7
TEMPORADA 2015/2016
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Redovan Redovan 30 73 27 71
2 Carrús UD Ilicitana Carrús 30 68 22 70
3 Santa Pola Santa Pola 30 73 43 60
4 Altet Altet 30 52 36 58
5 Aspe UD Aspe UD 30 49 39 51
6 Pinoso Pinoso 30 51 31 45
7 Algorfa Algorfa 30 59 39 45
8 Atlético Catral Atlético 30 55 51 41
9 Bigastro Bigastro 30 47 52 38
10 Santa Pola Santa Pola 30 51 66 37
11 SC Torrevieja CF Torrevieja 30 46 55 33
12 Sp. Saladar Sp. Saladar 30 45 67 30
13 AC Torrellano Torrellano 30 50 58 28
14 Algueña Cf Algueña Cf 30 37 72 21
15 Coca de Aspe Coca Aspe 30 44 87 20
16 Albaterense Albaterense 30 30 85 13
TEMPORADA 2014/2015
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 Calpe Calpe 30 71 24 70
2 UD Oliva UD Oliva 30 71 23 68
3 San Joan San Joan 30 68 18 65
4 Altet Altet 30 67 32 62
5 Rafelcofer Rafelcofer 30 54 34 54
6 Benissa Benissa 30 46 41 53
7 Mutxamel Mutxamel 29 65 34 49
8 Xeraco Xeraco 30 44 46 42
9 C. Benidorm C. Benidorm 30 45 48 42
10 Polop Polop 28 47 44 37
11 UD Altea UD Altea 30 51 57 35
12 Callosa Callosa 30 44 51 29
13 CF Gandia CF Gandia 30 33 89 22
14 Cullera B Cullera B 29 29 68 18
15 UD Ondarense Ondarense 28 23 88 15
16 Finestrat Finestrat 30 25 86 10

  USO DE MEMORIA  
5,858,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0896
Total Execution Time  0.0907
  CADENA URL  
/historico/Cd-Altet-Senior
  GET DATOS  
$_GET['/historico/Cd-Altet-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0041  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 = 73851
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46404 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 = '46404' ORDER BY l.year DESC,cat.coefficient DESC
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 = '46404' 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 = 73851 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=46404 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 (73851) 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 = 73851 AND teamId = 46404
0.0027  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 = 73851 AND t.round = 27 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 = '46404' 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 = '46404' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73851 WHERE rp.league_id = 73851 AND rp.teamId = 46404 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 = 73851 WHERE rp.league_id = 73851 AND rp.teamId = 46404 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0018  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 = 73851 WHERE rp.league_id = 73851 AND rp.teamId = 46404 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 46404 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73851 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.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 `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 = 69419 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.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 `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 = 64359 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.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 = 59533 AND t.round = 13 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 = 62467 AND t.round = 7 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 = 51333 AND t.round = 24 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` 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 = 45237 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 `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 = 39368 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 `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 = 34298 AND t.round = 30 ORDER BY team.conference 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 `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 = 16847 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 `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 = 7090 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 73851 ORDER BY nameShow LIMIT 100