4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Unión Carrizal
TEMPORADA 2023/2024
1ª REGIONAL CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Vecindario Vecindario 30 107 19 79
2 UD San Fernando B Fernando 30 124 35 73
3 Castillo CF Castillo CF 30 112 26 73
4 Unión Carrizal Unión 30 86 56 53
5 Agüimes CF Agüimes CF 30 68 46 51
6 San Pedro Mártir Pedro 30 78 49 49
7 Las Longueras Longueras 30 71 48 47
8 Tablero Tablero 30 64 46 46
9 Club Atlético Fomento Club 30 77 75 41
10 Juan Grande Juan Grande 30 70 71 39
11 Unión Viera B Unión Viera 30 63 54 36
12 CF Las Majoreras Majoreras 30 50 58 36
13 Cerruda Cerruda 30 61 66 34
14 Las Huesas Las Huesas 30 60 99 30
15 Union Marina Union Marina 30 45 95 30
16 Doramas B Doramas B 30 60 80 29
17 UD Los Vélez Vélez 30 44 68 26
18 Cercado de Espino Cercado 30 17 255 4
TEMPORADA 2022/2023
1ª REGIONAL CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 At. Gran Canaria Gran Canaria 38 127 30 91
2 Telde Telde 38 128 33 89
3 Tablero Tablero 38 101 54 79
4 Las Longueras Longueras 38 127 54 78
5 San Pedro Mártir Pedro 38 102 48 74
6 Castillo CF Castillo CF 38 101 59 72
7 Club Atlético Fomento Club 38 130 77 62
8 Unión Carrizal Unión 38 76 62 61
9 Agüimes CF Agüimes CF 38 89 64 59
10 CF Las Majoreras Majoreras 38 87 85 58
11 Unión Viera B Unión Viera 38 84 72 55
12 Union Marina Union Marina 38 83 80 47
13 Cerruda Cerruda 38 69 77 46
14 Las Huesas Las Huesas 38 76 95 45
15 Cercado de Espino Cercado 38 68 91 41
16 Valsequillo Valsequillo 38 55 65 39
17 Futboltec Futboltec 38 67 119 36
18 Casa Pastores Casa 38 72 115 25
19 Las Rosas Las Rosas 38 54 101 21
20 Calero Calero 38 9 255 0
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Estrella Estrella 28 69 19 66
2 Universitario FC Universitari 28 58 13 66
3 Breñamen Las Playitas Breñamen 28 56 26 56
4 El Cotillo El Cotillo 28 51 22 54
5 Doramas Doramas 28 51 32 53
6 UD Guía UD Guía 28 44 40 42
7 UD Teror UD Teror 28 41 38 37
8 Lomo Blanco Lomo Blanco 28 40 43 32
9 Tarajalejo Tarajalejo 28 35 61 32
10 Vecindario Vecindario 28 37 46 31
11 CD Valleseco Valleseco 28 24 39 30
12 UD Barrial UD Barrial 28 29 52 28
13 Costa Ayala Costa Ayala 28 31 48 26
14 Unión Carrizal Unión 28 29 58 21
15 Las Longueras Longueras 28 30 88 9
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 2001/2002
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Corralejo Corralejo 38 70 33 76
2 Castillo CF Castillo CF 38 63 31 72
3 Villa Santa Brígida Villa Santa 38 50 33 70
4 Telde Telde 38 57 30 69
5 Tenerife B Tenerife B 38 57 39 63
6 Raqui San Isidro Raqui Isidro 38 46 34 61
7 Agaete Agaete 38 59 56 61
8 Las Zocas Las Zocas 38 57 42 55
9 Gáldar Gáldar 38 56 62 48
10 Orientación Marítima Orientación 38 42 43 48
11 CD Laguna CD Laguna 38 35 39 47
12 Ibarra Ibarra 38 52 49 45
13 Las Palmas At. Palmas 38 44 43 45
14 CD La Oliva CD La Oliva 38 48 55 44
15 Tenisca Tenisca 38 43 46 44
16 CD Victoria Tazacorte Victoria 38 47 66 43
17 Esperanza Esperanza 38 47 67 43
18 Unión Carrizal Unión 38 49 62 42
19 Maspalomas Maspalomas 38 37 74 33
20 CD Águilas CD Águilas 38 31 86 20
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Lanzarote Lanzarote 38 78 26 83
2 Tenisca Tenisca 38 66 47 71
3 Las Palmas At. Palmas 38 70 45 70
4 Raqui San Isidro Raqui Isidro 38 62 32 70
5 Castillo CF Castillo CF 38 60 48 70
6 Corralejo Corralejo 38 52 34 64
7 CD La Oliva CD La Oliva 38 67 48 63
8 Gáldar Gáldar 38 52 43 58
9 Tenerife B Tenerife B 38 48 43 54
10 Orientación Marítima Orientación 38 47 54 47
11 Telde Telde 38 34 37 47
12 Ibarra Ibarra 38 46 57 44
13 CD Victoria Tazacorte Victoria 38 42 70 43
14 Las Zocas Las Zocas 38 50 75 43
15 CD Laguna CD Laguna 38 27 36 42
16 Unión Carrizal Unión 38 37 56 41
17 CD La Angostura Angostura 38 46 55 40
18 Orotava Orotava 38 41 59 40
19 Doramas Doramas 38 41 57 37
20 Realejos Realejos 38 37 81 29
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 85 20 82
2 Orotava Orotava 38 54 26 79
3 Lanzarote Lanzarote 38 61 31 73
4 Telde Telde 38 53 25 73
5 Raqui San Isidro Raqui Isidro 38 62 32 72
6 Corralejo Corralejo 38 66 30 71
7 CD La Angostura Angostura 38 52 38 66
8 Gáldar Gáldar 38 66 38 64
9 Vecindario Vecindario 38 53 49 51
10 Tenisca Tenisca 38 53 59 50
11 CD La Oliva CD La Oliva 38 35 47 44
12 Doramas Doramas 38 36 47 43
13 Tenerife B Tenerife B 38 46 55 41
14 Realejos Realejos 38 41 61 40
15 Ibarra Ibarra 38 33 52 39
16 Maspalomas Maspalomas 38 35 48 37
17 CD Victoria Tazacorte Victoria 38 38 65 35
18 Unión Carrizal Unión 38 43 81 34
19 Atlético Arona Atlético 38 25 88 28
20 C.D. Z Esperanza C.D. 38 29 74 27
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Universidad LPGC Universidad 38 84 35 80
2 Corralejo Corralejo 38 76 21 79
3 Las Palmas At. Palmas 38 72 29 79
4 Lanzarote Lanzarote 38 60 26 75
5 Telde Telde 38 54 34 66
6 CD Victoria Tazacorte Victoria 38 51 42 58
7 Raqui San Isidro Raqui Isidro 38 51 43 55
8 Orotava Orotava 38 55 54 51
9 Realejos Realejos 38 50 52 51
10 Vecindario Vecindario 38 39 44 50
11 Ibarra Ibarra 38 52 76 47
12 Doramas Doramas 38 42 45 46
13 Tenerife B Tenerife B 38 44 45 46
14 Tenisca Tenisca 38 45 51 44
15 Maspalomas Maspalomas 38 53 67 42
16 Atlético Arona Atlético 38 40 73 41
17 Unión Carrizal Unión 38 46 73 39
18 UC La Estrella Estrella 38 31 61 36
19 Puerto Cruz Puerto Cruz 38 36 55 35
20 At. Paso At. Paso 38 22 77 22

  USO DE MEMORIA  
5,845,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4701
Total Execution Time  0.4714
  CADENA URL  
/historico/Union-Carrizal
  GET DATOS  
$_GET['/historico/Union-Carrizal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0149  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 = 'Union-Carrizal' 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.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=85055 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=85055 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85055 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 3
0.0128  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 = '85055' ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '85055' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '85055' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=85055 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73641) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73641 AND teamId = 85055
0.0128  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 = '85055' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '85055' and rp.type = 4
0.0136  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 = '85055' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 = 73641 WHERE rp.league_id = 73641 AND rp.teamId = 85055 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.0136  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 = 73641 WHERE rp.league_id = 73641 AND rp.teamId = 85055 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 73641 WHERE rp.league_id = 73641 AND rp.teamId = 85055 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 85055 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0256  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 = 73641 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.0134  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 = 69367 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.0132  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 = 64495 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.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 `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 = 59644 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.0135  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 `tables2002` 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 = 22057 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2001` 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 = 22041 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables1999` 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 = 22009 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1998` 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 = 21993 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC