4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FICA du Cap-Haïtien
TEMPORADA 2020/2021
APERTURA HAITÍ
Equipo PJ GF GC Puntos
1 Arcahaie Arcahaie 17 20 10 30
2 Baltimore Baltimore 17 12 5 30
3 Triomphe Liancourt Triomphe 17 17 15 30
4 Capoise Capoise 17 16 12 27
5 Racing Club Haïtien Racing Club 17 17 14 27
6 Violette Violette 17 18 13 25
7 Cavaly Cavaly 17 16 14 25
8 America des Cayes America 17 16 15 25
9 Real Du Cap Real Du Cap 17 21 15 23
10 Tempête Tempête 17 18 15 22
11 Juventus FC Juventus FC 17 12 16 22
12 Rivartibonitienne Rivartibonit 17 15 22 20
13 Don Bosco Don Bosco 17 20 21 19
14 Ouanaminthe Ouanaminthe 17 11 18 18
15 Cosmopolites Cosmopolites 17 13 23 18
16 FICA du Cap-Haïtien FICA 17 17 16 17
17 Racing des Gonaives Racing 17 12 18 16
18 Mirebalais Mirebalais 17 10 19 14
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
TEMPORADA 2010/2011
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Tempête Tempête 14 20 7 31
2 Victory Victory 14 15 6 24
3 Baltimore Baltimore 14 12 9 22
4 Cavaly Cavaly 14 9 9 22
5 Racing Club Haïtien Racing Club 14 20 13 21
6 FICA du Cap-Haïtien FICA 14 10 6 20
7 Carrefour Carrefour 14 13 12 20
8 Aigle Noir Aigle Noir 14 7 9 20
9 Valencia de Leogane Valencia 14 10 7 17
10 Capoise Capoise 14 8 6 17
11 Mirebalais Mirebalais 14 7 9 17
12 Saint-Louis Saint-Louis 14 8 13 17
13 America des Cayes America 14 16 11 16
14 Triomphe Liancourt Triomphe 14 7 20 14
15 Racing des Gonaives Racing 14 8 33 5

  USO DE MEMORIA  
5,821,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1221
Total Execution Time  0.1233
  CADENA URL  
/historico/Fica-Du-Cap-Haitien
  GET DATOS  
$_GET['/historico/Fica-Du-Cap-Haitien']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0023  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 = 'Fica-Du-Cap-Haitien' 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.0053  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 = 'Fica-Du-Cap-Haitien' 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 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=62706 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=62706 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=62706 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=62706 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=62706 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=62706 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=62706 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62706 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1716 AND type_rel = 3
0.0026  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 = '62706' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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=62706 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (61996,58381) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 58381 AND teamId = 62706
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 61996 AND teamId = 62706
0.0024  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 = '62706' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62706' and rp.type = 4
0.0021  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 = '62706' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2021 e ON e.player_id = p.id AND e.league_id = 58381 WHERE rp.league_id = 58381 AND rp.teamId = 62706 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.0024  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 events2021 e ON e.player_id = p.id AND e.league_id = 58381 WHERE rp.league_id = 58381 AND rp.teamId = 62706 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2021 e ON e.player_id = p.id AND e.league_id = 58381 WHERE rp.league_id = 58381 AND rp.teamId = 62706 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 62706 AND l.year <= 2021 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 `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.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 = 58381 AND t.round = 17 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 `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