4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Acodetti CF
TEMPORADA 2021/2022
1ª REGIONAL CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 CF Pedro Hidalgo Pedro 32 125 31 82
2 At. Gran Canaria Gran Canaria 32 124 31 76
3 UD San Antonio Antonio 32 115 41 76
4 Real Sporting San José Real 32 106 34 72
5 Los Nidillos Nidillos 32 88 49 62
6 Club Atlético Fomento Club 32 69 53 52
7 UD Muelle Grande Muelle 32 70 64 52
8 Inter del Pilar CF Inter Pilar 32 109 66 51
9 Acodetti CF Acodetti CF 32 91 72 51
10 Piletas Piletas 32 65 60 42
11 Union Marina Union Marina 32 77 77 40
12 Atlético Isleta Atlético 32 45 74 39
13 UD Almenara UD Almenara 32 58 101 29
14 Calero Calero 32 36 106 24
15 Aregranca Aregranca 32 61 114 21
16 Talleres Canary Talleres 32 27 157 9
17 Street Canarias Street 32 30 166 5
18 Barrio Atlántico Barrio 0 0 0 0
TEMPORADA 2015/2016
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Estrella Estrella 32 90 28 78
2 Panadería Pulido Panadería 32 79 28 73
3 UD San Antonio Antonio 32 76 37 70
4 UD Las Palmas C Palmas 32 66 33 64
5 UD Teror UD Teror 32 59 41 55
6 CD Becerril CD Becerril 32 62 49 53
7 Costa Ayala Costa Ayala 32 64 62 49
8 UD Guía UD Guía 32 59 38 47
9 CF Pedro Hidalgo Pedro 32 53 46 43
10 Haría CF Haría CF 32 45 49 43
11 Union Marina Union Marina 32 51 72 35
12 CD Vallinámar Vallinámar 32 45 61 34
13 UD Balos UD Balos 32 52 78 34
14 Hesperides Hesperides 32 52 74 31
15 San Pedro Mártir Pedro 32 48 81 24
16 Tahiche Tahiche 32 42 91 16
17 Acodetti CF Acodetti CF 32 30 105 15
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
TEMPORADA 2012/2013
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 El Cotillo El Cotillo 34 77 30 73
2 Union Sur Yaiza Union Yaiza 34 59 29 65
3 Arguineguín Arguineguín 34 56 31 65
4 UD San Antonio Antonio 34 73 56 57
5 Real Sporting San José Real 34 49 43 56
6 Ferreras CF Ferreras CF 34 64 57 53
7 Unión Puerto Del Rosario Unión 34 57 42 51
8 Acodetti CF Acodetti CF 34 55 47 48
9 UD Teror UD Teror 34 41 44 46
10 UD Guía UD Guía 34 47 55 46
11 UD Balos UD Balos 34 48 57 45
12 CF Polígono de Arinaga Polígono 34 49 62 45
13 Arucas Arucas 34 61 55 44
14 UD Los Vélez Vélez 34 49 58 44
15 San Bartolomé CF Bartolomé 34 46 55 41
16 CD Vallinámar Vallinámar 34 55 61 39
17 AD Huracán AD Huracán 34 33 73 13
18 Atlético Tiense Atlético 34 22 86 13
TEMPORADA 2011/2012
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Unión Viera Unión Viera 34 66 36 67
2 UD Teror UD Teror 34 72 39 63
3 Acodetti CF Acodetti CF 34 54 35 62
4 Union Sur Yaiza Union Yaiza 34 56 35 61
5 Guía Guía 34 52 39 58
6 San Bartolomé CF Bartolomé 34 47 52 50
7 Unión Puerto Unión 34 53 47 48
8 CD Vallinámar Vallinámar 34 43 39 46
9 Arguineguín Arguineguín 34 47 43 45
10 Gáldar Gáldar 34 64 57 44
11 Ferreras CF Ferreras CF 34 43 50 43
12 AD Huracán AD Huracán 34 55 54 42
13 UD Los Vélez Vélez 34 50 56 42
14 UD Balos UD Balos 34 39 54 42
15 UD Vecindario B Vecindario 34 53 58 40
16 Teguise Teguise 34 40 64 33
17 UD Muelle Grande Muelle 34 37 72 28
18 CD Cruz De Piedra Cruz Piedra 34 39 80 23
TEMPORADA 2010/2011
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Real Sporting San José Real 36 68 26 75
2 Estrella Estrella 36 69 35 73
3 San Pedro Mártir Pedro 36 61 33 73
4 Telde Telde 36 64 39 60
5 Gáldar Gáldar 36 65 58 56
6 CD Vallinámar Vallinámar 36 55 47 53
7 Arguineguín Arguineguín 36 49 50 50
8 Union Sur Yaiza Union Yaiza 36 36 41 49
9 Acodetti CF Acodetti CF 36 58 49 47
10 Universidad LPGC B Universidad 36 52 70 46
11 Unión Viera Unión Viera 36 51 48 45
12 UD Vecindario B Vecindario 36 47 49 45
13 Teguise Teguise 36 35 43 44
14 UD Balos UD Balos 36 39 54 44
15 Valsequillo Valsequillo 36 53 53 43
16 Doramas Doramas 36 37 46 42
17 Sporting Tías Sporting 36 34 52 39
18 Altavista Altavista 36 37 57 32
19 Castillo CF Castillo CF 36 28 88 18

  USO DE MEMORIA  
5,643,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6016
Total Execution Time  0.6035
  CADENA URL  
/historico/Cf-Acodetti
  GET DATOS  
$_GET['/historico/Cf-Acodetti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0135  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 = 'Cf-Acodetti' 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.0156  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 = 'Cf-Acodetti' 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.0126  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=5170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=5170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=5170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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=5170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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=5170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=5170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=5170 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=5170 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=5170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0138  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 = 66025
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5170 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 3
0.0129  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 = '5170' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '5170' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '5170' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = '5170' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 66025 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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=5170 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (66025) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 66025 AND teamId = 5170
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 66025 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 = '5170' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5170' and rp.type = 4
0.0128  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 = '5170' 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 events2022 e ON e.player_id = p.id AND e.league_id = 66025 WHERE rp.league_id = 66025 AND rp.teamId = 5170 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 events2022 e ON e.player_id = p.id AND e.league_id = 66025 WHERE rp.league_id = 66025 AND rp.teamId = 5170 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2022 e ON e.player_id = p.id AND e.league_id = 66025 WHERE rp.league_id = 66025 AND rp.teamId = 5170 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 5170 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 66025 AND t.round = 34 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 `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 = 16710 AND t.round = 34 ORDER BY team.conference 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 `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.0131  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
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 `tables2013` 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 = 1994 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 `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 = 1473 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 `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 = 1214 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 66025 ORDER BY nameShow LIMIT 100