4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fundación AIFI
TEMPORADA 2023/2024
APERTURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 CS Marítimo Marítimo 8 10 5 14
2 Atlético La Cruz Atlético 8 10 7 14
3 Dynamo Puerto La Cruz Dynamo 7 8 6 11
4 Academia Anzoátegui Academia 7 6 6 11
5 Deportivo Miranda Deportivo 8 4 4 10
6 Fundación AIFI Fundación 8 5 8 9
7 Nueva Esparta FC Nueva 8 5 6 7
8 Bolivar SC Bolivar SC 8 4 10 6
9 Yaracuyanos Yaracuyanos 8 12 5 17
10 Héroes de Falcón Héroes 7 9 5 11
11 Atlético El Vigía FC Atlético 7 15 14 10
12 Trujillanos Trujillanos 7 7 6 10
13 Real Frontera FC Real 7 7 9 8
14 Aragua FC Aragua FC 8 9 11 7
15 Ureña Ureña 7 11 16 6
16 Academia Rey Academia 7 5 9 5
TEMPORADA 2022/2023
CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 CS Marítimo Marítimo 14 23 16 25
2 Dynamo Puerto La Cruz Dynamo 14 21 18 22
3 Bolivar SC Bolivar SC 14 19 12 21
4 Fundación AIFI Fundación 14 14 13 20
5 Academia Anzoátegui Academia 14 13 12 16
6 Deportivo Miranda Deportivo 14 15 17 16
7 Nueva Esparta FC Nueva 14 9 13 13
8 Atlético La Cruz Atlético 14 12 25 13
9 Ureña Ureña 13 19 7 25
10 Yaracuyanos Yaracuyanos 14 17 10 23
11 Titanes FC Titanes FC 14 18 15 23
12 Atlético El Vigía FC Atlético 14 18 12 22
13 Héroes de Falcón Héroes 14 20 17 21
14 Trujillanos Trujillanos 14 14 14 18
15 Real Frontera FC Real 13 16 23 15
16 Academia Rey Academia 14 12 36 2
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN VENEZUELA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético La Cruz Atlético 18 22 11 34
2 Yaracuyanos Yaracuyanos 18 28 18 34
3 Academia Anzoátegui Academia 18 30 16 30
4 Angostura Angostura 18 23 18 27
5 Deportivo Miranda Deportivo 18 15 13 25
6 Bolivar SC Bolivar SC 18 20 21 25
7 Fundación AIFI Fundación 18 18 21 22
8 Nueva Esparta FC Nueva 18 14 20 21
9 Libertador Libertador 18 13 23 15
10 Dynamo Puerto La Cruz Dynamo 18 12 34 10
11 Titanes FC Titanes FC 18 28 16 35
12 Rayo Zuliano Rayo Zuliano 18 37 22 31
13 Ureña Ureña 18 16 21 29
14 Héroes de Falcón Héroes 18 21 18 26
15 Academia Rey Academia 18 21 19 26
16 Real Frontera FC Real 18 18 16 25
17 Trujillanos Trujillanos 18 20 15 24
18 Atlético El Vigía FC Atlético 18 20 19 21
19 ULA Mérida ULA Mérida 18 19 28 18
20 Llaneros de Guanare Llaneros 18 10 36 9
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Atlético La Cruz Atlético 14 22 10 28
2 Libertador Libertador 14 21 7 26
3 Bolivar SC Bolivar SC 14 15 7 26
4 Deportivo Miranda Deportivo 14 17 11 22
5 Fundación AIFI Fundación 14 18 20 20
6 Angostura Angostura 14 20 14 17
7 Dynamo Puerto La Cruz Dynamo 14 22 25 14
8 AC Minervén Minervén 14 9 50 1
9 Ureña Ureña 18 31 18 34
10 Academia Rey Academia 18 30 12 32
11 Titanes FC Titanes FC 18 27 16 31
12 ULA Mérida ULA Mérida 18 25 14 28
13 Real Frontera FC Real 18 25 21 28
14 Yaracuy Yaracuy 18 23 20 27
15 Atlético El Vigía FC Atlético 18 24 21 25
16 Rayo Zuliano Rayo Zuliano 18 11 14 22
17 Deportivo JBL del Zulia Deportivo 18 9 31 8
18 Llaneros de Guanare Llaneros 18 15 53 7
TEMPORADA 2019/2020
CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Ureña Ureña 10 16 7 23
2 Inter De Barinas Inter 10 21 12 20
3 ULA Mérida ULA Mérida 10 16 16 15
4 Atlético El Vigía FC Atlético 10 14 16 11
5 Deportivo JBL del Zulia Deportivo 10 12 16 11
6 Real Frontera FC Real 10 12 24 4
7 Llaneros de Guanare Llaneros 10 14 8 21
8 UCV UCV 10 10 4 19
9 Yaracuy Yaracuy 10 10 9 13
10 Academia Rey Academia 10 7 8 12
11 Angostura Angostura 10 6 9 8
12 Fundación AIFI Fundación 10 6 15 5
TEMPORADA 2018/2019
CLAUSURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Atl. Furrial Atl. Furrial 10 16 8 20
2 Yaracuyanos Yaracuyanos 10 18 8 19
3 Deportivo Miranda Deportivo 10 12 11 17
4 Yaracuy Yaracuy 10 14 12 16
5 Libertador Libertador 10 7 14 7
6 Gran Valencia Gran 10 10 24 7
7 Titanes FC Titanes FC 12 25 17 26
8 Atlético El Vigía FC Atlético 12 25 12 24
9 Inter De Barinas Inter 12 23 19 21
10 Real Frontera FC Real 12 22 19 17
11 Deportivo JBL del Zulia Deportivo 12 33 31 14
12 ULA Mérida ULA Mérida 12 19 28 10
13 Ureña Ureña 12 8 29 5
14 Angostura Angostura 12 26 11 25
15 Petroleros de Anzoátegui Petroleros 12 20 10 25
16 UCV UCV 12 14 8 22
17 Fundación AIFI Fundación 12 14 18 16
18 Ciudad Vinotinto Ciudad 12 8 13 10
19 Dynamo Puerto La Cruz Dynamo 12 9 20 9
20 Chicó de Guayana Chicó 12 10 21 8

  USO DE MEMORIA  
5,463,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1067
Total Execution Time  0.1079
  CADENA URL  
/historico/Fundacion-Aifi-Guyana
  GET DATOS  
$_GET['/historico/Fundacion-Aifi-Guyana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
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 = 'Fundacion-Aifi-Guyana' 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=119648 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=119648 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 = 75625
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119648 AND type_rel = 2
0.0023  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 = '119648' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '119648' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 75625 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=119648 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 (75625,74258) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75625 AND teamId = 119648
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74258 AND teamId = 119648
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 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 = 75625 AND t.round = 8 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 = '119648' 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 = '119648' 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 = '119648' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 = 75625 WHERE rp.league_id = 75625 AND rp.teamId = 119648 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.0027  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 = 75625 WHERE rp.league_id = 75625 AND rp.teamId = 119648 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 75625 WHERE rp.league_id = 75625 AND rp.teamId = 119648 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 119648 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75625 AND t.round = 8 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 `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 = 71250 AND t.round = 14 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 `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 = 72919 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `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 = 67091 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 62639 AND t.round = 9 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 = 63309 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 55451 AND t.round = 14 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 `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 = 59975 AND t.round = 10 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 `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 = 48931 AND t.round = 14 ORDER BY team.conference 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 `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 = 50191 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 75625 ORDER BY nameShow LIMIT 100