4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gorgos
TEMPORADA 2023/2024
SEGUNDA FFCV GRUPO 6
Equipo PJ GF GC Puntos
1 CF Llutxent CF Llutxent 28 60 22 68
2 Portuarios Portuarios 28 57 25 61
3 Safor CF Gandia Safor Gandia 27 63 23 57
4 Gorgos Gorgos 28 62 31 53
5 Orba Orba 27 49 26 52
6 Simat Simat 27 60 43 46
7 UD Oliva UD Oliva 27 45 31 43
8 Bellreguard Bellreguard 28 46 46 38
9 Real de Gandia Real Gandia 27 31 45 31
10 Beniopa Beniopa 28 39 44 31
11 UE Benifairó Benifairó 27 37 55 28
12 FB Teulada Moraira Teulada 27 37 51 27
13 CD Olímpic B Olímpic 27 36 57 25
14 Pedreguer Pedreguer 27 32 54 25
15 Montaverner Montaverner 27 34 58 23
16 Racing Rafelcofer Racing 28 22 99 8
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 6
Equipo PJ GF GC Puntos
1 Beniganim CF Beniganim 30 89 20 81
2 Pego Pego 30 61 34 64
3 Contestano Contestano 30 64 32 58
4 Orba Orba 30 68 39 56
5 Portuarios Portuarios 30 48 35 49
6 Simat Simat 30 55 46 48
7 UD Oliva UD Oliva 30 47 40 43
8 L'Alcudia de Crespins L'Alcudia 30 40 44 43
9 Gorgos Gorgos 30 48 49 41
10 UE Benifairó Benifairó 30 44 48 40
11 Bellreguard Bellreguard 30 34 51 35
12 Ontinyent 1931 B Ontinyent 30 45 58 33
13 Pedreguer Pedreguer 30 39 55 30
14 Montaverner Montaverner 30 37 64 20
15 Real de Gandia Real Gandia 30 28 64 20
16 Racing Rafelcofer Racing 30 34 102 13
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 UD Altea UD Altea 28 65 36 59
2 CF Cullera CF Cullera 28 59 34 59
3 Polop Polop 28 56 31 49
4 Gorgos Gorgos 28 55 46 46
5 Pego Pego 28 37 35 39
6 Alfaz del Pi Alfaz 28 43 44 37
7 Bellreguard Bellreguard 28 37 41 37
8 Racing Rafelcofer Racing 28 47 47 36
9 UD Oliva UD Oliva 28 40 43 35
10 Benissa Benissa 28 47 44 34
11 Portuarios Portuarios 28 36 42 34
12 Real de Gandia Real Gandia 28 33 48 34
13 Xeraco Xeraco 28 38 53 27
14 Daimus A Daimus A 28 37 62 27
15 CF Benitachell Benitachell 28 33 57 26
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 17
Equipo PJ GF GC Puntos
1 La Font D'encarros Font 6 14 1 18
2 CF Cullera CF Cullera 6 14 5 11
3 Benissa Benissa 6 8 13 7
4 Gorgos Gorgos 6 5 7 6
5 UD Oliva UD Oliva 6 8 11 6
6 Simat Simat 6 9 13 5
7 UE Benifairó Benifairó 6 9 17 4
TEMPORADA 2019/2020
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 Calpe Calpe 23 65 24 54
2 La Nucia B La Nucia B 24 55 25 53
3 Novelda UCF Novelda UCF 23 37 19 45
4 UD Aspe UD Aspe 23 36 29 41
5 UD Altea UD Altea 24 47 33 39
6 Betis Florida Betis 24 36 37 34
7 Gorgos Gorgos 24 46 44 31
8 Racing de San Gabriel Racing 24 32 40 31
9 El Campello El Campello 24 44 36 30
10 Alicante City Alicante 24 48 56 30
11 Salesianos Alicante Salesianos 24 43 54 28
12 Mutxamel Mutxamel 23 34 49 27
13 Atletico Jonense Atletico 24 46 53 25
14 Polop Polop 24 27 40 25
15 Benissa Benissa 24 35 51 23
16 UD Ondarense Ondarense 24 19 60 11
TEMPORADA 2018/2019
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 CF Benidorm CF Benidorm 28 54 27 63
2 Pedreguer Pedreguer 28 62 21 61
3 La Nucia B La Nucia B 28 69 25 59
4 UD Altea UD Altea 28 65 36 58
5 Il-Licitana Raval A Il-Licitana 28 55 35 47
6 El Campello El Campello 28 45 36 44
7 Mutxamel Mutxamel 28 50 45 41
8 Caramanchel A Caramanchel 28 32 47 34
9 Gorgos Gorgos 28 49 59 33
10 San Gabriel A Gabriel 28 45 50 32
11 Benissa Benissa 28 36 47 32
12 Polop Polop 28 35 57 26
13 UD Ondarense Ondarense 28 33 55 22
14 Mediterraneo CF Mediterraneo 28 40 69 19
15 Coca de Aspe Coca Aspe 28 25 86 10
16 Novelda B Novelda B 0 0 0 0
TEMPORADA 2017/2018
SEGUNDA FFCV GRUPO 7
Equipo PJ GF GC Puntos
1 Pego Pego 30 85 22 75
2 Rafelcofer Rafelcofer 30 57 31 68
3 UD Oliva UD Oliva 30 60 47 49
4 UD Altea UD Altea 30 52 39 49
5 El Campello El Campello 30 43 37 45
6 Gorgos Gorgos 30 52 54 44
7 Real de Gandia Real Gandia 30 50 55 42
8 Mutxamel Mutxamel 30 54 50 40
9 Pedreguer Pedreguer 30 50 59 37
10 UD Ondarense Ondarense 29 36 55 36
11 Benissa Benissa 30 36 57 36
12 Alginet B Alginet B 30 53 68 35
13 Orba Orba 30 43 52 33
14 Polop Polop 29 45 57 31
15 Benirredra Benirredra 30 55 77 30
16 Xeraco Xeraco 30 44 55 28
TEMPORADA 2016/2017
TERCERA FFCV GRUPO 12
Equipo PJ GF GC Puntos
1 Gorgos Gorgos 27 74 35 63
2 Benirredra Benirredra 26 79 35 62
3 Daimus A Daimus A 28 69 31 61
4 CF Gandia CF Gandia 28 64 29 52
5 Ath. La Vall Ath. Vall 27 75 39 49
6 Gandia A Gandia A 27 62 39 46
7 Rotova A Rotova A 28 65 55 40
8 El Verger El Verger 28 35 44 39
9 Villalonga Villalonga 27 56 51 38
10 UE Benifairó Benifairó 27 42 75 30
11 Javea B Javea B 27 35 54 28
12 Simat Simat 27 56 59 27
13 CD Conde CD Conde 27 35 58 23
14 Miramar Miramar 27 26 86 13
15 CF Benitachell Benitachell 25 16 99 4
TEMPORADA 2015/2016
TERCERA FFCV GRUPO 13
Equipo PJ GF GC Puntos
1 CFI Alicante Alicante 30 129 22 86
2 San Gabriel A Gabriel 30 110 31 77
3 Alfaz del Pi Alfaz 30 82 40 66
4 CF San Gabriel Gabriel 30 112 42 62
5 Sffcv Benidorm B Sffcv 30 93 36 62
6 Atletico Jonense Atletico 30 103 52 59
7 Oranje A Oranje A 30 75 69 49
8 Gorgos Gorgos 30 66 62 42
9 Xixona E. Xixona E. 30 60 69 39
10 Plaza de Argel A Plaza Argel 30 49 87 36
11 Jove Español San Vicente B Jove 30 52 72 33
12 Maristas A. Maristas A. 30 49 92 26
13 Inter San Blas de Alicante Inter Blas. 30 46 102 25
14 T. Moraira T. Moraira 30 44 89 19
15 Moraira Moraira 30 36 127 14
16 Obrera A Obrera A 30 39 153 4
TEMPORADA 2014/2015
TERCERA FFCV GRUPO 13
Equipo PJ GF GC Puntos
1 Pedreguer Pedreguer 26 114 20 69
2 Orba Orba 28 70 31 67
3 Sp. Benidorm Benidorm 27 82 34 56
4 CFI Alicante Alicante 26 74 23 54
5 Javea B Javea B 27 71 37 50
6 Villajoyosa C Villajoyosa 27 83 34 47
7 Alfaz del Pi Alfaz 27 53 38 46
8 Moraira Moraira 26 49 35 43
9 Altea B Altea B 28 33 57 34
10 El Campello B Campello 28 45 56 31
11 Gorgos Gorgos 27 36 57 23
12 T. Moraira T. Moraira 27 23 83 21
13 Xixona E. Xixona E. 27 39 86 20
14 Alicante Rvo. B Alicante 26 25 103 8
15 D. Relleu D. Relleu 27 11 114 6

  USO DE MEMORIA  
5,829,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1411
Total Execution Time  0.1423
  CADENA URL  
/historico/Gorgos-Cf-Senior
  GET DATOS  
$_GET['/historico/Gorgos-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0030  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 = 'Gorgos-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.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=47628 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=47628 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046  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 = 73810
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=47628 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1137 AND type_rel = 3
0.0022  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.0024  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.0040  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 = '47628' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '47628' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '47628' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 73810 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=47628 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (73810) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73810 AND teamId = 47628
0.0037  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 = 73810 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031  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 = '47628' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '47628' and rp.type = 4
0.0032  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 = '47628' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 73810 WHERE rp.league_id = 73810 AND rp.teamId = 47628 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.0028  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 = 73810 WHERE rp.league_id = 73810 AND rp.teamId = 47628 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 73810 WHERE rp.league_id = 73810 AND rp.teamId = 47628 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0048  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 = 47628 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0043  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 = 73810 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.0037  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 = 69374 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.0038  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 = 64338 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.0038  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 = 59531 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.0037  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 = 62455 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.0044  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 = 51332 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.0042  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 = 45236 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 39367 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 35315 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 16890 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 7124 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 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 = 73810 ORDER BY nameShow LIMIT 100