4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ouanaminthe
TEMPORADA 2023/2024
APERTURA HAITÍ GRUPO 1
Equipo PJ GF GC Puntos
TEMPORADA 2020/2021
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Don Bosco Don Bosco 8 14 5 16
2 Mirebalais Mirebalais 9 8 5 15
3 Rivartibonitienne Rivartibonit 9 8 5 15
4 Ouanaminthe Ouanaminthe 9 7 7 13
5 Arcahaie Arcahaie 6 7 1 12
6 Cavaly Cavaly 6 9 4 12
7 FICA du Cap-Haïtien FICA 9 5 4 12
8 Tempête Tempête 8 7 8 12
9 Capoise Capoise 9 6 5 11
10 Triomphe Liancourt Triomphe 8 8 6 10
11 Real Du Cap Real Du Cap 9 10 11 10
12 Violette Violette 9 7 8 10
13 Racing des Gonaives Racing 9 4 7 10
14 America des Cayes America 7 7 7 8
15 Juventus FC Juventus FC 8 5 8 8
16 Baltimore Baltimore 8 6 9 6
17 Racing Club Haïtien Racing Club 8 8 16 6
18 Cosmopolites Cosmopolites 7 3 13 4
TEMPORADA 2019/2020
APERTURA HAITÍ
Equipo PJ GF GC Puntos
1 Baltimore Baltimore 4 5 0 10
2 Cavaly Cavaly 4 7 3 10
3 Don Bosco Don Bosco 4 6 2 7
4 Capoise Capoise 4 4 2 6
5 Real Du Cap Real Du Cap 4 4 3 6
6 Triomphe Liancourt Triomphe 4 4 3 6
7 Rivartibonitienne Rivartibonit 4 2 2 6
8 FICA du Cap-Haïtien FICA 4 2 3 6
9 Juventus FC Juventus FC 4 3 3 5
10 Violette Violette 4 3 3 5
11 Arcahaie Arcahaie 4 2 3 5
12 Cosmopolites Cosmopolites 4 2 3 5
13 Mirebalais Mirebalais 4 1 2 5
14 America des Cayes America 4 3 4 4
15 Ouanaminthe Ouanaminthe 4 1 4 4
16 Racing des Gonaives Racing 4 1 5 4
17 Racing Club Haïtien Racing Club 4 1 3 3
18 Tempête Tempête 4 2 5 3
TEMPORADA 2018/2019
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Don Bosco Don Bosco 4 8 3 12
2 Cavaly Cavaly 5 9 3 10
3 Tempête Tempête 4 6 2 10
4 Violette Violette 4 4 2 9
5 Baltimore Baltimore 5 2 0 9
6 Capoise Capoise 5 4 2 8
7 Ouanaminthe Ouanaminthe 5 5 4 8
8 Triomphe Liancourt Triomphe 5 3 3 7
9 Mirebalais Mirebalais 5 3 1 6
10 America des Cayes America 5 8 11 6
11 FICA du Cap-Haïtien FICA 5 4 5 5
12 Arcahaie Arcahaie 5 1 3 4
13 Racing des Gonaives Racing 5 3 9 4
14 Cosmopolites Cosmopolites 5 3 7 3
15 Real Du Cap Real Du Cap 5 1 4 2
16 Racing Club Haïtien Racing Club 4 1 6 0
TEMPORADA 2017/2018
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Arcahaie Arcahaie 15 16 6 35
2 Tempête Tempête 15 12 7 24
3 Don Bosco Don Bosco 15 20 18 24
4 FICA du Cap-Haïtien FICA 15 20 13 23
5 Real Du Cap Real Du Cap 15 17 11 23
6 Baltimore Baltimore 15 11 11 22
7 Cosmopolites Cosmopolites 15 11 19 22
8 Ouanaminthe Ouanaminthe 15 10 8 21
9 Mirebalais Mirebalais 15 11 12 21
10 Racing Club Haïtien Racing Club 15 16 12 20
11 Cavaly Cavaly 15 16 14 20
12 Racing des Gonaives Racing 15 13 11 19
13 Capoise Capoise 15 12 16 18
14 AS Sud-Est AS Sud-Est 15 16 22 18
15 Valencia de Leogane Valencia 15 7 17 13
16 Petit Goave Petit Goave 15 6 17 9
TEMPORADA 2016/2017
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Mirebalais Mirebalais 15 28 10 31
2 Don Bosco Don Bosco 15 18 7 29
3 Real Du Cap Real Du Cap 15 15 8 27
4 Racing des Gonaives Racing 14 15 7 24
5 FICA du Cap-Haïtien FICA 15 10 6 24
6 Capoise Capoise 15 16 17 22
7 Baltimore Baltimore 15 10 9 20
8 Eclair des Gonaïves Eclair 15 15 13 20
9 Cavaly Cavaly 15 13 14 18
10 Racing Club Haïtien Racing Club 15 7 12 17
11 Ouanaminthe Ouanaminthe 15 12 18 16
12 Petit Goave Petit Goave 15 12 13 16
13 Tempête Tempête 15 10 13 16
14 America des Cayes America 15 14 22 16
15 AS Sud-Est AS Sud-Est 15 7 21 12
16 Juventus FC Juventus FC 14 5 17 10
TEMPORADA 2015/2016
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 FICA du Cap-Haïtien FICA 17 20 8 29
2 Ouanaminthe Ouanaminthe 16 19 9 29
3 Capoise Capoise 17 10 10 27
4 Real Du Cap Real Du Cap 16 20 14 24
5 America des Cayes America 15 12 6 22
6 Violette Violette 17 14 12 21
7 Petit Goave Petit Goave 16 10 14 21
8 Aigle Noir Aigle Noir 16 11 9 20
9 Mirebalais Mirebalais 16 11 10 20
10 Racing des Gonaives Racing 16 9 11 20
11 Cavaly Cavaly 16 14 16 19
12 Don Bosco Don Bosco 15 9 11 19
13 Baltimore Baltimore 16 9 10 18
14 Inter de Grand-Goâve Inter 13 9 13 18
15 Racing Club Haïtien Racing Club 16 15 17 17
16 Juventus FC Juventus FC 15 23 26 16
17 Tempête Tempête 16 8 17 16
18 Roulado Roulado 15 7 17 14
TEMPORADA 2014/2015
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 FICA du Cap-Haïtien FICA 16 27 13 34
2 Cavaly Cavaly 16 17 8 29
3 Baltimore Baltimore 16 16 8 29
4 Racing Club Haïtien Racing Club 16 21 15 28
5 Don Bosco Don Bosco 16 21 12 26
6 Violette Violette 15 18 13 26
7 Capoise Capoise 16 18 14 26
8 Valencia de Leogane Valencia 16 19 14 24
9 Mirebalais Mirebalais 16 13 13 20
10 Aigle Noir Aigle Noir 16 14 13 19
11 Roulado Roulado 16 12 19 19
12 America des Cayes America 16 19 19 18
13 PNH FC PNH FC 16 12 16 18
14 Petit Goave Petit Goave 15 9 14 18
15 Racing des Gonaives Racing 16 15 23 18
16 Inter de Grand-Goâve Inter 15 11 11 17
17 Ouanaminthe Ouanaminthe 16 14 22 16
18 Tempête Tempête 15 12 20 16
19 Racine Racine 16 10 22 16
20 US LaJeune US LaJeune 16 10 19 13

  USO DE MEMORIA  
5,400,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5050
Total Execution Time  0.5062
  CADENA URL  
/historico/Ouanaminthe
  GET DATOS  
$_GET['/historico/Ouanaminthe']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0136  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 = 'Ouanaminthe' 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.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=62703 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=62703 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62703 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1716 AND type_rel = 3
0.0133  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 = '62703' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '62703' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=62703 AND l.year in (2023,2024,2025) 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 (75610) 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.0142  SELECT count(id) as num_players from rel_players WHERE league_id = 75610 AND teamId = 62703
0.0134  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 = '62703' 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 = '62703' and rp.type = 4
0.0129  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 = '62703' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 62703 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 62703 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 62703 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 62703 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 75610 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.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 = 61996 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.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 `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 = 55535 AND t.round = 4 ORDER BY team.conference ASC,t.position 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 `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 = 49082 AND t.round = 15 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 `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 = 50627 AND t.round = 15 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 `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 = 42857 AND t.round = 15 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 `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 = 45288 AND t.round = 15 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 `tables2017` 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 = 37975 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2017` 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 = 40535 AND t.round = 15 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 `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 = 22213 AND t.round = 17 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 `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 = 36098 AND t.round = 17 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 `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 = 10892 AND t.round = 19 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 = 15713 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 75610 ORDER BY nameShow LIMIT 100