4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del I'Gara
TEMPORADA 2023/2024
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 CD San Miguel Miguel 28 68 28 67
2 Tenerife C Tenerife C 28 63 22 64
3 AU Güímar AU Güímar 28 58 21 61
4 CD Laguna CD Laguna 28 57 32 53
5 CD Águilas CD Águilas 28 50 34 46
6 Las Zocas Las Zocas 28 42 32 43
7 I'Gara I'Gara 28 39 42 41
8 San Lorenzo Constancia Lorenzo 28 45 41 37
9 CD Marino B CD Marino B 28 47 44 35
10 CD Bahía de Santiago Bahía 28 45 48 33
11 Juventud Laguna Juventud 28 43 60 28
12 Guargacho Guargacho 28 35 59 28
13 Atlético San Juan Atlético 28 37 66 18
14 Chincanayro Chincanayro 28 24 82 17
15 CD Furia Arona Furia Arona 28 31 73 13
TEMPORADA 2022/2023
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 CD Buzanada CD Buzanada 36 138 24 96
2 AU Güímar AU Güímar 36 101 25 90
3 Tenerife C Tenerife C 36 109 37 79
4 CD Laguna CD Laguna 36 101 28 79
5 CD San Miguel Miguel 36 81 58 69
6 I'Gara I'Gara 36 68 45 59
7 CD Águilas CD Águilas 36 69 56 58
8 CD Marino B CD Marino B 36 80 60 57
9 Las Zocas Las Zocas 36 68 48 55
10 CD Furia Arona Furia Arona 36 54 56 47
11 CD Bahía de Santiago Bahía 36 52 57 44
12 Chincanayro Chincanayro 36 58 89 41
13 Atlético San Juan Atlético 36 54 81 40
14 San Lorenzo Constancia Lorenzo 36 41 58 35
15 Fañabé Fañabé 36 44 78 34
16 CD Candela CD Candela 36 40 76 32
17 CD San Andrés Andrés 36 33 78 30
18 Real Unión de Tenerife Real Unión 36 21 106 15
19 CD Ofra CD Ofra 36 19 171 6
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 5
Equipo PJ GF GC Puntos
1 Tenerife C Tenerife C 22 54 25 48
2 Ibarra Ibarra 22 51 26 45
3 AU Güímar AU Güímar 22 47 23 43
4 CD Águilas CD Águilas 22 39 31 38
5 I'Gara I'Gara 22 47 42 33
6 CD San Miguel Miguel 22 35 29 32
7 San Lorenzo Constancia Lorenzo 22 28 38 24
8 CD Furia Arona Furia Arona 22 24 38 23
9 CD Marino B CD Marino B 22 34 44 21
10 CD Bahía de Santiago Bahía 22 19 34 21
11 At. Granadilla Granadilla 22 33 44 17
12 Santos Reyes Santos Reyes 22 20 57 17
TEMPORADA 2020/2021
PREFERENTE CANARIAS GRUPO 4
Equipo PJ GF GC Puntos
1 Las Zocas Las Zocas 12 21 5 28
2 CD Candela CD Candela 16 25 18 28
3 Tenerife C Tenerife C 14 30 18 24
4 CD Marino B CD Marino B 13 22 19 20
5 CD Águilas CD Águilas 12 18 23 17
6 Atlético San Juan Atlético 7 6 7 12
7 San Lorenzo Constancia Lorenzo 7 5 4 11
8 CD San Miguel Miguel 7 13 7 9
9 Santos Reyes Santos Reyes 7 9 11 9
10 CD San Andrés Andrés 12 8 26 9
11 Real Unión de Tenerife Real Unión 6 11 10 8
12 At. Granadilla Granadilla 7 4 8 5
13 Raqui San Isidro Raqui Isidro 7 7 13 4
14 I'Gara I'Gara 7 7 17 3
TEMPORADA 2018/2019
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Vera Vera 34 67 35 75
2 Atletico Victoria Atletico 34 72 24 71
3 UD Cruz Santa Cruz Santa 34 57 29 66
4 San Lorenzo Constancia Lorenzo 34 59 43 58
5 Atlético San Juan Atlético 34 62 60 54
6 UD Icodense UD Icodense 34 57 54 52
7 AD Añaza AD Añaza 34 61 58 51
8 Puerto Cruz Puerto Cruz 34 63 43 50
9 Orotava Orotava 34 66 47 49
10 Unión Tejina Unión 34 69 55 49
11 At. Granadilla Granadilla 34 52 49 47
12 CD Águilas CD Águilas 34 55 54 47
13 CD Guancha CD Guancha 34 46 50 44
14 CD Marino B CD Marino B 34 52 58 42
15 La Florida La Florida 34 39 46 31
16 I'Gara I'Gara 34 52 92 28
17 Cd Arguijón Arguijón 34 30 89 21
18 Ud Valle Frontera Valle 34 25 98 17
TEMPORADA 2015/2016
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 CD Buzanada CD Buzanada 36 75 33 78
2 Atlético Tacoronte Atlético 36 87 46 72
3 San Lorenzo Constancia Lorenzo 36 69 42 72
4 Charco del Pino Charco Pino 36 76 39 70
5 CD Laguna CD Laguna 36 69 31 67
6 CD Los Ángeles Ángeles 36 91 52 62
7 UD Gomera UD Gomera 36 68 50 55
8 CD Águilas CD Águilas 36 55 47 54
9 UD Icodense UD Icodense 36 63 55 53
10 Orotava Orotava 36 60 52 53
11 Raqui San Isidro Raqui Isidro 36 60 60 47
12 CD San Andrés Andrés 36 50 45 47
13 Juventud Laguna Juventud 36 53 61 46
14 Zamorano Esperanza Zamorano 36 50 52 45
15 CD Valeriana Valeriana 36 43 60 43
16 Atletico Victoria Atletico 36 47 61 42
17 Atlético San Juan Atlético 36 38 108 20
18 I'Gara I'Gara 36 32 126 17
19 Guargacho Guargacho 36 41 107 15
TEMPORADA 2014/2015
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 CD Buzanada CD Buzanada 36 62 27 71
2 Raqui San Isidro Raqui Isidro 36 75 49 71
3 UD Cruz Santa Cruz Santa 36 55 38 65
4 UD Gomera UD Gomera 36 40 25 59
5 Charco del Pino Charco Pino 36 48 41 55
6 San Lorenzo Constancia Lorenzo 36 73 65 54
7 Atlético Tacoronte Atlético 36 44 39 52
8 Orotava Orotava 36 49 48 48
9 Águilas Águilas 36 46 49 48
10 AU Güímar AU Güímar 36 72 66 47
11 Atlético San Juan Atlético 36 64 56 46
12 CD San Andrés Andrés 36 51 55 46
13 I'Gara I'Gara 36 49 51 45
14 UD Icodense UD Icodense 36 53 67 45
15 Realejos Realejos 36 40 48 42
16 CD Valle Guerra Valle Guerra 36 42 60 40
17 UD Hidalgo UD Hidalgo 36 50 63 35
18 Cd Arguijón Arguijón 36 35 59 30
19 Ud Valle Frontera Valle 36 37 79 29
TEMPORADA 2008/2009
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Charco del Pino Charco Pino 30 56 23 66
2 CD San Andrés Andrés 31 64 29 60
3 Vera Vera 31 55 33 59
4 Tenerife C Tenerife C 31 39 18 56
5 San Andrés y Sauces Andrés 31 53 35 56
6 Raqui San Isidro Raqui Isidro 30 64 35 55
7 Atletico Victoria Atletico 32 53 38 55
8 Ibarra Ibarra 31 40 35 45
9 Norte Norte 30 40 37 45
10 I'Gara I'Gara 30 38 44 37
11 Breña Alta Breña Alta 30 30 35 35
12 UD Icodense UD Icodense 31 34 47 35
13 Real Unión de Irún Real Unión 31 37 56 34
14 Atlético Barranco Hondo Atlético 30 42 63 27
15 Águilas Atlético Águilas 32 30 61 27
16 Orotava Orotava 30 30 55 26
17 Unión Tejina Unión 31 30 60 26
18 La Palma La Palma 30 24 53 20
19 Puerto Cruz Puerto Cruz 5 9 11 9
20 Atlético Arona Atlético 1 1 1 1
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Orotava Orotava 38 99 44 54
2 Corralejo Corralejo 38 71 31 54
3 Las Palmas At. Palmas 38 66 29 50
4 Tenisca Tenisca 38 56 41 49
5 Gáldar Gáldar 38 65 36 47
6 Ibarra Ibarra 38 61 41 47
7 Estrella Estrella 38 44 43 44
8 Arguineguín Arguineguín 38 74 54 43
9 CD Laguna CD Laguna 38 58 56 43
10 Telde Telde 38 60 42 38
11 Saludeño Saludeño 38 70 57 38
12 UD Gomera UD Gomera 38 33 41 35
13 Vecindario Vecindario 38 43 52 34
14 Atlético Arona Atlético 38 39 71 31
15 UD Icodense UD Icodense 38 41 77 28
16 Real Artesano FC Real 38 32 56 28
17 AU Güímar AU Güímar 38 37 72 28
18 Lanzarote Lanzarote 38 39 56 27
19 Ferreras CF Ferreras CF 38 32 58 23
20 I'Gara I'Gara 38 28 91 19
TEMPORADA 1991/1992
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 86 30 59
2 CD Mensajero Mensajero 38 67 30 51
3 Orotava Orotava 38 69 33 51
4 Gáldar Gáldar 38 52 43 48
5 Telde Telde 38 67 43 46
6 Arguineguín Arguineguín 38 51 53 41
7 Realejos Realejos 38 56 49 40
8 AU Güímar AU Güímar 38 45 42 39
9 Tenisca Tenisca 38 53 60 39
10 Real Artesano FC Real 38 43 53 38
11 Saludeño Saludeño 38 51 48 36
12 Corralejo Corralejo 38 55 52 36
13 Llanos Aridane Llanos 38 49 47 34
14 Ibarra Ibarra 38 36 41 33
15 Vecindario Vecindario 38 39 62 33
16 CD Laguna CD Laguna 38 44 52 32
17 Unión Tejina Unión 38 35 51 30
18 UD Icodense UD Icodense 38 37 59 26
19 I'Gara I'Gara 38 31 74 25
20 Ferreras CF Ferreras CF 38 32 76 23
TEMPORADA 1990/1991
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Realejos Realejos 38 70 17 57
2 CD Mensajero Mensajero 37 49 21 50
3 Corralejo Corralejo 38 63 36 48
4 Maspalomas Maspalomas 38 73 43 47
5 CD Laguna CD Laguna 38 74 41 46
6 Ferreras CF Ferreras CF 38 65 49 43
7 Arguineguín Arguineguín 38 48 37 43
8 Llanos Aridane Llanos 38 50 48 40
9 Unión Tejina Unión 38 47 40 39
10 Vecindario Vecindario 38 35 49 38
11 Tenisca Tenisca 38 45 46 38
12 I'Gara I'Gara 38 31 50 37
13 Ibarra Ibarra 38 53 53 35
14 AU Güímar AU Güímar 38 27 45 32
15 Saludeño Saludeño 38 29 45 31
16 Orotava Orotava 37 38 51 30
17 CD Águilas CD Águilas 38 39 61 29
18 Puerto Cruz Puerto Cruz 38 26 62 26
19 Arucas Arucas 37 30 58 24
20 U.D. Las Torres U.D. Torres 37 32 72 23
TEMPORADA 1989/1990
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 77 29 53
2 Corralejo Corralejo 38 47 27 46
3 Puerto Cruz Puerto Cruz 38 69 51 46
4 Ibarra Ibarra 38 65 53 43
5 I'Gara I'Gara 38 64 50 41
6 Orotava Orotava 38 54 48 41
7 Vecindario Vecindario 38 42 42 41
8 Arguineguín Arguineguín 38 47 42 40
9 Ferreras CF Ferreras CF 38 55 40 39
10 Llanos Aridane Llanos 38 47 46 38
11 CD Laguna CD Laguna 38 57 58 38
12 CD Mensajero Mensajero 38 63 50 38
13 Tenisca Tenisca 38 46 55 37
14 CD Águilas CD Águilas 38 37 62 35
15 Torres De La Alameda Torres 38 43 58 35
16 Unión Tejina Unión 38 46 52 34
17 At. Paso At. Paso 38 37 46 33
18 UD Gomera UD Gomera 38 40 70 28
19 UD Icodense UD Icodense 38 33 60 27
20 Real Artesano FC Real 38 31 61 27

  USO DE MEMORIA  
6,425,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0855
Total Execution Time  0.0868
  CADENA URL  
/historico/I-Gara
  GET DATOS  
$_GET['/historico/I-Gara']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0044  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 = 73544
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1400 AND type_rel = 2
0.0021  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 = '1400' 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 = 73544 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=1400 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 (73544) 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 = 73544 AND teamId = 1400
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 = 1400 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73544 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 `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 = 68790 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 64498 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 59646 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.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 `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 = 44766 AND t.round = 34 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 = 16711 AND t.round = 38 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 = 4084 AND t.round = 38 ORDER BY team.conference 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 `tables2009` 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 = 313 AND t.round = 34 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 `tables1994` 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 = 21912 AND t.round = 38 ORDER BY team.conference 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 `tables1992` 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 = 21870 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 `tables1991` 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 = 21847 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 `tables1990` 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 = 21826 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC