4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tahiche
TEMPORADA 2023/2024
PREFERENTE CANARIAS GRUPO 3
Equipo PJ GF GC Puntos
1 UD Las Palmas C Palmas 39 116 21 103
2 Unión Viera Unión Viera 39 76 39 78
3 Estrella Estrella 39 79 45 77
4 Playas de Sotavento Playas 38 60 38 67
5 Telde Telde 39 59 53 66
6 El Cotillo El Cotillo 39 67 43 66
7 CD Becerril CD Becerril 39 62 49 60
8 At. Gran Canaria Gran Canaria 39 63 51 59
9 Universitario FC Universitari 39 62 57 58
10 CD Valleseco Valleseco 39 49 49 56
11 UD Balos UD Balos 39 50 47 54
12 Lomo Blanco Lomo Blanco 39 48 46 53
13 Tahiche Tahiche 39 46 49 53
14 Doramas Doramas 39 45 58 53
15 Guía Guía 38 53 66 47
16 Tinajo Tinajo 39 52 68 45
17 Arguineguín Arguineguín 39 49 69 45
18 Breñamen Las Playitas Breñamen 38 45 67 43
19 Costa Ayala Costa Ayala 39 45 59 41
20 Marítima Marítima 39 45 65 40
21 Sporting Tías Sporting 39 47 64 39
22 CD Ingenio CD Ingenio 38 36 59 35
23 Maspalomas Maspalomas 39 34 69 28
24 San Nicolás Nicolás 39 45 102 28
TEMPORADA 2022/2023
PREFERENTE CANARIAS GRUPO 3
Equipo PJ GF GC Puntos
1 UD Las Palmas C Palmas 28 102 15 75
2 San Bartolomé CF Bartolomé 28 63 34 57
3 Lomo Blanco Lomo Blanco 28 36 35 46
4 UD Teror UD Teror 28 36 30 45
5 Tinajo Tinajo 28 38 34 41
6 UD Guía UD Guía 28 44 39 40
7 Sporting Tías Sporting 28 44 41 40
8 Tahiche Tahiche 28 41 45 39
9 Maspalomas Maspalomas 28 36 33 37
10 CD Ingenio CD Ingenio 28 36 48 36
11 Vecindario Vecindario 28 41 48 34
12 UD San Fernando B Fernando 28 35 49 33
13 Real Sporting San José Real 28 40 46 29
14 Agaete Agaete 28 27 63 22
15 Guayarmina Guayarmina 28 26 85 19
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 2
Equipo PJ GF GC Puntos
1 Union Sur Yaiza Union Yaiza 18 49 14 41
2 San Pedro Mártir Pedro 17 34 18 33
3 Costa Ayala Costa Ayala 17 32 19 29
4 Tahiche Tahiche 18 36 30 29
5 Estrella Estrella 17 29 21 28
6 CD Becerril CD Becerril 17 28 23 26
7 Las Longueras Longueras 17 30 36 25
8 San Bartolomé CF Bartolomé 17 29 23 24
9 Doramas Doramas 17 21 27 21
10 CD Valleseco Valleseco 17 21 27 17
11 Unión Carrizal Unión 17 28 29 16
12 UD San Antonio Antonio 17 16 29 14
13 Tablero Tablero 17 14 37 12
14 SD San Isidro Isidro 17 12 46 10
TEMPORADA 2019/2020
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 UD Guía UD Guía 25 46 14 62
2 Arucas Arucas 26 59 24 58
3 San Pedro Mártir Pedro 26 60 33 51
4 Estrella Estrella 26 59 37 49
5 UD Teror UD Teror 26 54 30 44
6 El Cotillo El Cotillo 25 38 22 44
7 CF Pedro Hidalgo Pedro 27 60 49 41
8 Union Sur Yaiza Union Yaiza 26 38 35 39
9 RC Victoria RC Victoria 27 48 51 38
10 Costa Ayala Costa Ayala 26 42 47 38
11 Arguineguín Arguineguín 26 29 58 32
12 Doramas Doramas 27 39 44 31
13 Tablero Tablero 26 34 40 30
14 UD San Antonio Antonio 27 36 43 30
15 CD Ingenio CD Ingenio 27 41 55 29
16 CD Becerril CD Becerril 27 25 45 28
17 Maspalomas Maspalomas 27 27 47 24
18 UD Balos UD Balos 27 33 63 23
19 Tahiche Tahiche 26 35 66 11
TEMPORADA 2017/2018
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Tamaraceite Tamaraceite 36 105 29 90
2 Unión Viera Unión Viera 36 90 28 81
3 Arucas Arucas 36 70 34 76
4 UD San Gregorio Gregorio 36 75 47 64
5 Maspalomas Maspalomas 36 62 47 60
6 CD Becerril CD Becerril 36 67 55 60
7 UD San Antonio Antonio 36 69 53 59
8 UD Balos UD Balos 36 66 59 56
9 UD Teror UD Teror 36 72 61 55
10 RC Victoria RC Victoria 36 56 48 51
11 UD Guía UD Guía 36 55 58 42
12 Doramas Doramas 36 45 50 41
13 Union Marina Union Marina 36 45 72 41
14 CF Pedro Hidalgo Pedro 36 55 79 40
15 Tahiche Tahiche 36 44 77 35
16 CD Vecinklubf Vecinklubf 36 41 74 35
17 Cerruda Cerruda 36 51 66 31
18 Telde Telde 36 29 86 17
19 Costa Ayala Costa Ayala 36 39 113 14
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

  USO DE MEMORIA  
5,864,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1119
Total Execution Time  0.1139
  CADENA URL  
/historico/Tahiche
  GET DATOS  
$_GET['/historico/Tahiche']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0033  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 = 'Tahiche' 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=21197 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=21197 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 73545
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=21197 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 80 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1227759,1055368,1019795,1016738,992278) ORDER BY n.cover_points DESC, update_date DESC
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 = '21197' 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 = '21197' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '21197' 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 = 73545 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=21197 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 (73545) 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 = 73545 AND teamId = 21197
0.0041  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 = 73545 AND t.round = 39 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 = '21197' 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 = '21197' 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 = '21197' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73545 WHERE rp.league_id = 73545 AND rp.teamId = 21197 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 = 73545 WHERE rp.league_id = 73545 AND rp.teamId = 21197 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 = 73545 WHERE rp.league_id = 73545 AND rp.teamId = 21197 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 21197 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 73545 AND t.round = 39 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0062  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 = 68936 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.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 `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 = 51277 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.0033  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 = 39649 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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.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 = 4537 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC