4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Algorfa
TEMPORADA 2023/2024
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 CD Montesinos A Montesinos 27 53 28 59
2 Guardamar Soccer Guardamar 27 61 26 53
3 Cox Cox 27 51 25 52
4 Sax Sax 27 51 40 50
5 UD Aspe UD Aspe 27 42 24 49
6 Eldense C Eldense C 26 44 32 47
7 Sp. Albatera Albatera 27 55 37 46
8 Algorfa Algorfa 27 49 35 45
9 Monovar A Monovar A 27 46 44 42
10 Elche Dream Elche Dream 27 43 41 40
11 Rafal Rafal 26 41 40 33
12 San Miguel CF Miguel 27 38 55 22
13 Peñaraval Peñaraval 27 28 65 20
14 Sporting Dolores Sporting 27 28 54 17
15 Algueña Cf Algueña Cf 27 27 63 17
16 UD La Coca Aspense A Coca Aspense 27 24 72 11
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 SC Torrevieja CF Torrevieja 30 109 21 75
2 Pinoso Pinoso 30 63 23 71
3 S. Fulgencio Fulgencio 30 51 17 68
4 UE Crevillent Crevillent 30 73 37 67
5 UD Aspe UD Aspe 30 52 37 58
6 CD Montesinos A Montesinos 30 60 40 53
7 Elche Dream Elche Dream 29 61 77 42
8 Cox Cox 30 49 46 41
9 Il-Licitana Raval A Il-Licitana 30 51 52 39
10 Algorfa Algorfa 30 52 60 38
11 Sax Sax 30 53 63 29
12 Rafal Rafal 30 39 71 24
13 Algueña Cf Algueña Cf 29 32 68 21
14 San Miguel CF Miguel 30 37 77 19
15 Sporting Dolores Sporting 30 33 71 18
16 UD La Coca Aspense A Coca Aspense 30 33 88 14
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 9
Equipo PJ GF GC Puntos
1 Atlético Catral Atlético 28 76 26 68
2 SC Torrevieja CF Torrevieja 28 72 35 58
3 Pinoso Pinoso 28 47 51 46
4 CD Montesinos A Montesinos 28 47 36 45
5 S. Fulgencio Fulgencio 28 46 26 44
6 Cox Cox 28 47 33 43
7 Algueña Cf Algueña Cf 28 48 39 40
8 Rafal Rafal 28 41 40 40
9 Algorfa Algorfa 28 44 41 36
10 Sporting Dolores Sporting 28 48 47 36
11 San Miguel CF Miguel 28 36 61 31
12 Benijofar Benijofar 28 35 52 26
13 Sp. Albatera Albatera 28 38 57 25
14 CFP Orihuela Deportiva Orihuela 28 42 80 20
15 Orihuela B Orihuela B 28 31 74 19
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 8
Equipo PJ GF GC Puntos
1 Rafal Rafal 30 57 34 57
2 Jove Espanyol B Jove 30 60 35 54
3 Atlético Catral Atlético 30 50 34 54
4 H. Nieves H. Nieves 30 49 38 54
5 Carrús UD Ilicitana Carrús 30 63 24 53
6 Aspe UD Aspe UD 30 51 46 45
7 SC Torrevieja CF Torrevieja 30 47 51 43
8 Albaterense Albaterense 30 53 40 42
9 Redovan Redovan 30 40 36 40
10 Coca de Aspe Coca Aspe 30 45 43 39
11 Santa Pola Santa Pola 30 38 35 38
12 Algorfa Algorfa 30 45 52 32
13 Orihuela B Orihuela B 29 40 55 31
14 Sp. Saladar Sp. Saladar 29 47 73 29
15 S. Fulgencio Fulgencio 30 37 68 24
16 Alicante Rvo. A Alicante 30 25 83 17

  USO DE MEMORIA  
5,370,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4796
Total Execution Time  0.4808
  CADENA URL  
/historico/Algorfa-Cf-Senior
  GET DATOS  
$_GET['/historico/Algorfa-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0134  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 = 'Algorfa-Cf-Senior' 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=46443 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=46443 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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 = 73812
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46443 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1137 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1137 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0131  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1115864,973799,932798,909788,909342) ORDER BY n.cover_points DESC, update_date DESC
0.0127  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 = '46443' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '46443' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '46443' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 73812 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=46443 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73812) 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 = 73812 AND teamId = 46443
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 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 = 73812 AND t.round = 28 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 = '46443' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '46443' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 73812 WHERE rp.league_id = 73812 AND rp.teamId = 46443 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.0129  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 = 73812 WHERE rp.league_id = 73812 AND rp.teamId = 46443 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 73812 WHERE rp.league_id = 73812 AND rp.teamId = 46443 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 46443 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 = 73812 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.0130  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 = 69376 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 = 64340 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 `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.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 `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.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 `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 = 7091 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 73812 ORDER BY nameShow LIMIT 100