4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Chantimelle
TEMPORADA 2019/2020
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Carib Hurricane Carib 18 57 13 47
2 Paradise Paradise 18 54 15 45
3 Camerhogne Camerhogne 18 43 25 31
4 Hard Rock Hard Rock 18 36 30 28
5 QPR Grenada QPR Grenada 18 35 35 28
6 St. John's St. John's 18 39 30 26
7 Mount Rich Mount Rich 18 30 52 19
8 Chantimelle Chantimelle 17 19 50 15
9 SAB Spartans Spartans 18 20 40 12
10 Eagles Super Strikers Eagles Super 17 13 56 3
TEMPORADA 2016/2017
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Carib Hurricane Carib 18 42 15 44
2 Hard Rock Hard Rock 18 27 18 36
3 Paradise Paradise 18 43 21 35
4 St. John's St. John's 18 35 19 31
5 QPR Grenada QPR Grenada 18 36 32 27
6 Eagles Super Strikers Eagles Super 18 31 28 25
7 Grenada Boys Grenada Boys 19 27 32 23
8 Mount Rich Mount Rich 18 29 36 21
9 Chantimelle Chantimelle 19 22 37 19
10 SAB Spartans Spartans 18 17 41 11
11 TAMCC TAMCC 18 15 45 9
TEMPORADA 2015/2016
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Paradise Paradise 18 48 23 44
2 Hard Rock Hard Rock 18 43 19 39
3 St. John's St. John's 18 40 29 33
4 Mount Rich Mount Rich 18 38 30 27
5 Carib Hurricane Carib 18 24 24 24
6 QPR Grenada QPR Grenada 18 35 33 20
7 Chantimelle Chantimelle 18 26 38 17
8 Fontenoy United Fontenoy 18 31 45 16
9 Boca Juniors St. Patrick Boca Juniors 18 26 42 13
10 Gouyave Gouyave 18 19 47 11
TEMPORADA 2014/2015
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Carib Hurricane Carib 18 33 12 38
2 Paradise Paradise 18 38 18 37
3 Boca Juniors St. Patrick Boca Juniors 18 33 20 35
4 St. John's St. John's 18 25 20 31
5 QPR Grenada QPR Grenada 18 38 26 29
6 Chantimelle Chantimelle 18 31 30 29
7 Hard Rock Hard Rock 18 27 26 19
8 Fontenoy United Fontenoy 18 22 38 19
9 Grenada Boys Grenada Boys 18 17 28 18
10 Hampshire Utd Hampshire 18 8 54 3
TEMPORADA 2012/2013
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Hard Rock Hard Rock 18 45 13 46
2 ASOMS Paradise ASOMS 18 54 17 44
3 QPR Grenada QPR Grenada 18 35 24 36
4 Grenada Boys Grenada Boys 18 26 27 29
5 Carib Hurricane Carib 18 32 31 22
6 Happy Hill Happy Hill 18 22 32 20
7 Fontenoy United Fontenoy 18 25 34 19
8 Five Stars Five Stars 18 23 42 16
9 Eagles Super Strikers Eagles Super 18 19 38 15
10 Ball Dogs Ball Dogs 18 15 38 7
TEMPORADA 2011/2012
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Hard Rock Hard Rock 18 36 18 36
2 Paradise Paradise 18 31 16 34
3 Grenada Boys Grenada Boys 18 39 25 33
4 QPR Grenada QPR Grenada 18 26 17 31
5 Carib Hurricane Carib 18 27 21 28
6 Eagles Super Strikers Eagles Super 18 33 30 27
7 Fontenoy United Fontenoy 18 15 24 22
8 Chantimelle Chantimelle 18 27 32 20
9 Police Grenada Police 18 16 31 14
10 Boca Juniors St. Patrick Boca Juniors 18 13 49 5
TEMPORADA 2010/2011
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Hard Rock Hard Rock 18 31 13 39
2 Paradise Paradise 18 49 21 38
3 Grenada Boys Grenada Boys 18 25 13 34
4 QPR Grenada QPR Grenada 18 25 18 28
5 Eagles Super Strikers Eagles Super 18 34 28 27
6 Carib Hurricane Carib 18 29 29 26
7 Chantimelle Chantimelle 18 27 28 23
8 Fontenoy United Fontenoy 18 21 28 21
9 Ball Dogs Ball Dogs 18 21 33 14
10 South Stars South Stars 18 13 64 6
TEMPORADA 2009/2010
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Paradise Paradise 18 39 16 41
2 Carib Hurricane Carib 17 31 11 38
3 Fontenoy United Fontenoy 17 28 26 29
4 Hard Rock Hard Rock 18 28 22 26
5 Eagles Super Strikers Eagles Super 18 23 29 20
6 Grenada Boys Grenada Boys 15 21 23 17
7 Chantimelle Chantimelle 17 22 29 17
8 Ball Dogs Ball Dogs 18 21 32 16
9 South Stars South Stars 15 17 32 15
10 QPR Grenada QPR Grenada 15 12 22 14
TEMPORADA 2007/2008
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Carib Hurricane Carib 18 26 18 37
2 Eagles Super Strikers Eagles Super 18 29 20 34
3 Fontenoy United Fontenoy 18 22 13 31
4 QPR Grenada QPR Grenada 18 27 16 28
5 South Stars South Stars 18 32 30 26
6 Grenada Boys Grenada Boys 18 20 19 26
7 Paradise Paradise 18 31 27 23
8 Ball Dogs Ball Dogs 18 18 29 18
9 Chantimelle Chantimelle 18 18 28 17
10 Willis Youths Willis 18 9 32 8
TEMPORADA 2006/2007
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Paradise Paradise 18 42 18 47
2 Carib Hurricane Carib 18 38 14 36
3 QPR Grenada QPR Grenada 18 38 31 33
4 Grenada Boys Grenada Boys 18 21 23 26
5 South Stars South Stars 18 25 29 25
6 Eagles Super Strikers Eagles Super 18 24 33 19
7 Fontenoy United Fontenoy 18 24 26 18
8 Chantimelle Chantimelle 18 24 29 17
9 Hard Rock Hard Rock 18 30 42 16
10 Police Grenada Police 18 16 37 9

  USO DE MEMORIA  
5,331,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3067
Total Execution Time  0.3080
  CADENA URL  
/historico/Chantimelle/2020
  GET DATOS  
$_GET['/historico/Chantimelle/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0213  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 = 53599
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5383 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=165 AND type_rel = 3
0.0107  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 = '5383' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0110  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 = '5383' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 53599 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=5383 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (53599) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 53599 AND teamId = 5383
0.0107  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 = 5383 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0107  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 = 53599 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.0108  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 = 43884 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 43883 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 28170 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2013` 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 = 3201 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2012` 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 = 1885 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2011` 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 = 1648 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2010` 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 = 1271 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2008` 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 = 28171 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2007` 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 = 28173 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC