4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
1 jugadores
Baltimore Baltimore
M. Florestal M. Florestal 23 años POR
1 jugadores
Don Bosco Don Bosco
V. Odelus V. Odelus 29 años 184cm 79kg POR
1 jugadores
Racing des Gonaives Racing Gonaives
G. Philippe G. Philippe 39 años MED
3 jugadores
Violette Violette
J. Floréal J. Floréal 22 años POR
S. Saba S. Saba 31 años 180cm 75kg MED
J. Stevenson J. Stevenson 19 años 185cm DEL
1 jugadores
Real Du Cap Real Du Cap
Serge Anthony Lucien Serge Anthony Lucien 24 años MED
6 jugadores
Arcahaie Arcahaie
Wedny Montira Wedny Montira 23 años DEF
M. Sully M. Sully 32 años DEF
Berson Etienne Berson Etienne 23 años DEF
Junior Limage Junior Limage 24 años MED
A. Villière A. Villière 19 años 173cm 59kg MED
J. Pierre Paul J. Pierre Paul 24 años DEL
1 jugadores
Ouanaminthe Ouanaminthe
James Cene James Cene 20 años MED

Clasificación

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

  USO DE MEMORIA  
4,906,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0625
Total Execution Time  0.0644
  CADENA URL  
/clausura_haiti2021/grupo1/jugadores
  GET DATOS  
$_GET['/clausura_haiti2021/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0017  SELECT type FROM routes WHERE alias = 'clausura_haiti2021'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_haiti' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1717 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1717 ORDER BY order_id ASC
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1717 GROUP BY l.categoryId
0.0018  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1717 GROUP BY l.year ORDER BY l.year DESC
0.0019  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 61996 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 61996 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0021  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 61996 AND dt.id IN (15417,15412,15418,15410,62707,15408,57451,15419,57452,15413,62706,85138,110104,62703,119866,110105,85139,138210) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 07:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 07:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 07:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 07:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_haiti' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 61996 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61996 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 61996 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61996 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 61996 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61996 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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