4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Goleta
TEMPORADA 2023/2024
1ª REGIONAL CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Arucas B Arucas B 31 89 31 73
2 Atalaya Atalaya 32 82 40 70
3 Los Nidillos Nidillos 31 59 32 66
4 Real Sporting San José Real 32 74 38 64
5 Agaete Agaete 31 65 34 62
6 UD Barrial UD Barrial 31 46 43 48
7 San Isidro San Isidro 31 57 44 44
8 CD Guiniguada Guiniguada 31 50 40 44
9 CD Goleta CD Goleta 31 42 48 43
10 Firgas Firgas 31 64 59 41
11 UD Artenara UD Artenara 31 71 71 40
12 Inter del Pilar CF Inter Pilar 31 51 64 39
13 Unión Costa Bañaderos Unión Costa 31 45 65 37
14 UD San Antonio Antonio 30 69 73 35
15 Galdar Galdar 32 44 65 34
16 CD Cardones CD Cardones 31 54 73 31
17 Guayarmina Guayarmina 31 43 82 30
18 Panadería Pulido B Panadería 30 40 67 28
19 Atlético Isleta Atlético 31 11 87 10
TEMPORADA 2022/2023
PREFERENTE CANARIAS GRUPO 4
Equipo PJ GF GC Puntos
1 Unión Viera Unión Viera 30 48 19 64
2 Herbania Herbania 30 55 14 63
3 CD Valleseco Valleseco 30 44 26 60
4 Breñamen Las Playitas Breñamen 30 45 22 57
5 Playas de Sotavento Playas 30 51 36 55
6 El Cotillo El Cotillo 30 52 25 54
7 Arguineguín Arguineguín 30 48 36 49
8 CD Becerril CD Becerril 30 46 34 45
9 Doramas Doramas 30 48 49 41
10 Universitario FC Universitari 30 38 35 39
11 UD Balos UD Balos 30 32 39 36
12 Juan Grande Juan Grande 30 44 56 32
13 CD Goleta CD Goleta 30 38 57 32
14 RC Victoria RC Victoria 30 20 64 15
15 Tarajalejo Tarajalejo 30 19 77 7
16 CF Pedro Hidalgo Pedro 30 18 57 0
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Maspalomas Maspalomas 26 50 22 54
2 RC Victoria RC Victoria 26 54 26 49
3 Tahiche Tahiche 26 46 32 48
4 CD Goleta CD Goleta 26 30 25 47
5 Sporting Tías Sporting 26 46 27 46
6 San Bartolomé CF Bartolomé 26 55 20 45
7 CD Becerril CD Becerril 26 37 44 35
8 CD Ingenio CD Ingenio 26 36 43 34
9 Arguineguín Arguineguín 26 30 33 32
10 UD Balos UD Balos 26 30 33 32
11 Telde Telde 26 33 40 31
12 San Pedro Mártir Pedro 26 30 43 27
13 UD Artenara UD Artenara 26 26 71 12
14 CD Cardones CD Cardones 26 22 66 7
TEMPORADA 2020/2021
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Herbania Herbania 18 40 10 43
2 El Cotillo El Cotillo 18 41 11 42
3 CD Goleta CD Goleta 18 36 24 32
4 Breñamen Las Playitas Breñamen 19 34 25 31
5 RC Victoria RC Victoria 18 31 19 29
6 UD Teror UD Teror 17 35 24 29
7 UD Balos UD Balos 18 23 18 29
8 Arguineguín Arguineguín 18 24 33 25
9 Maspalomas Maspalomas 18 23 25 24
10 CD Ingenio CD Ingenio 18 20 22 19
11 CF Pedro Hidalgo Pedro 18 23 33 18
12 Valsequillo Valsequillo 18 14 29 15
13 Castillo CF Castillo CF 18 16 55 10
14 Agaete Agaete 18 13 45 8
TEMPORADA 2014/2015
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 UD San Fernando Fernando 26 53 17 60
2 Unión Puerto Unión 23 54 16 47
3 UD Las Palmas C Palmas 23 50 16 46
4 UD San Antonio Antonio 25 39 34 40
5 UD Guía UD Guía 26 51 34 39
6 UD Teror UD Teror 26 36 40 35
7 Panadería Pulido Panadería 25 35 32 34
8 Tahiche Tahiche 23 28 30 33
9 Union Marina Union Marina 24 42 41 32
10 Vecindario Vecindario 24 28 31 31
11 San Pedro Mártir Pedro 26 31 51 30
12 Hesperides Hesperides 26 39 46 29
13 Doramas Doramas 25 27 39 28
14 Acodetti CF Acodetti CF 26 30 47 28
15 CD Goleta CD Goleta 25 28 40 25
16 UD Los Vélez Vélez 26 21 39 24
17 UD Balos UD Balos 25 28 46 23
18 AD Huracán AD Huracán 24 32 53 19
TEMPORADA 2013/2014
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Arucas Arucas 32 67 29 67
2 Real Sporting San José Real 32 53 25 67
3 UD Teror UD Teror 32 58 40 59
4 UD Las Palmas C Palmas 32 59 34 58
5 UD San Antonio Antonio 32 47 27 57
6 SD Villaverde Norte Villaverde 32 60 56 54
7 UD Guía UD Guía 32 55 42 43
8 UD San Fernando Fernando 32 60 59 41
9 Acodetti CF Acodetti CF 32 53 55 39
10 San Pedro Mártir Pedro 32 51 50 37
11 Unión Puerto Unión 32 37 51 36
12 CF Polígono de Arinaga Polígono 32 37 48 34
13 UD Balos UD Balos 32 37 49 34
14 CD Goleta CD Goleta 32 43 68 33
15 Arguineguín Arguineguín 32 39 66 33
16 UD Los Vélez Vélez 32 38 68 32
17 CF Pedro Hidalgo Pedro 32 39 66 31

  USO DE MEMORIA  
5,430,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0916
Total Execution Time  0.0928
  CADENA URL  
/historico/Cd-Goleta
  GET DATOS  
$_GET['/historico/Cd-Goleta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0027  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 = 'Cd-Goleta' 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=12000 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=12000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 73640
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12000 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 3
0.0020  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 = '12000' 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 = '12000' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '12000' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73640 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=12000 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73640,68937) 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 = 68937 AND teamId = 12000
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73640 AND teamId = 12000
0.0025  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 = 73640 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '12000' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12000' and rp.type = 4
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 = '12000' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 73640 WHERE rp.league_id = 73640 AND rp.teamId = 12000 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 = 73640 WHERE rp.league_id = 73640 AND rp.teamId = 12000 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 = 73640 WHERE rp.league_id = 73640 AND rp.teamId = 12000 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 12000 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73640 AND t.round = 33 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 `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 = 68937 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.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 `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 = 64494 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.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 `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 = 59643 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.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 `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 = 4537 AND t.round = 34 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 `tables2014` 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 = 2686 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC