4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Carib Hurricane
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 2018/2019
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Paradise Paradise 18 48 15 42
2 St. John's St. John's 18 35 13 40
3 Carib Hurricane Carib 18 41 22 35
4 Hard Rock Hard Rock 18 29 28 28
5 Camerhogne Camerhogne 18 22 26 22
6 QPR Grenada QPR Grenada 18 25 34 22
7 Mount Rich Mount Rich 18 24 41 21
8 Grenada Boys Grenada Boys 18 23 29 17
9 Eagles Super Strikers Eagles Super 18 25 38 17
10 Happy Hill Happy Hill 18 20 46 7
TEMPORADA 2017/2018
LIGA GRANADA
Equipo PJ GF GC Puntos
1 Paradise Paradise 18 48 15 42
2 St. John's St. John's 18 35 13 40
3 Carib Hurricane Carib 18 41 22 35
4 Hard Rock Hard Rock 18 29 28 28
5 Camerhogne Camerhogne 18 22 26 22
6 QPR Grenada QPR Grenada 18 25 34 22
7 Mount Rich Mount Rich 18 24 41 21
8 Grenada Boys Grenada Boys 18 23 29 17
9 Eagles Super Strikers Eagles Super 18 25 38 16
10 Happy Hill Happy Hill 18 20 46 6
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 2013/2014
LIGA GRANADA
Equipo PJ GF GC Puntos
1 ASOMS Paradise ASOMS 18 49 15 43
2 Carib Hurricane Carib 18 25 19 33
3 Grenada Boys Grenada Boys 18 28 23 29
4 Hard Rock Hard Rock 18 29 21 27
5 QPR Grenada QPR Grenada 18 31 29 26
6 St. John's St. John's 18 29 33 26
7 Fontenoy United Fontenoy 18 23 29 25
8 Mount Rich Mount Rich 18 30 34 24
9 Happy Hill Happy Hill 18 20 19 22
10 Five Stars Five Stars 18 18 60 2
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,599,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4626
Total Execution Time  0.4638
  CADENA URL  
/historico/Carib-Hurricane
  GET DATOS  
$_GET['/historico/Carib-Hurricane']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5379 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=165 AND type_rel = 3
0.0128  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 = '5379' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139  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 = '5379' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0144  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=5379 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (56393) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 56393 AND teamId = 5379
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 = '5379' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5379' and rp.type = 4
0.0139  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 = '5379' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 events2020 e ON e.player_id = p.id AND e.league_id = 53599 WHERE rp.league_id = 53599 AND rp.teamId = 5379 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.0136  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 events2020 e ON e.player_id = p.id AND e.league_id = 53599 WHERE rp.league_id = 53599 AND rp.teamId = 5379 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 events2020 e ON e.player_id = p.id AND e.league_id = 53599 WHERE rp.league_id = 53599 AND rp.teamId = 5379 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 5379 AND l.year <= 2020 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 `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.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 `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 = 56393 AND t.round = 18 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 = 45024 AND t.round = 18 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 `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.0133  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.0142  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.0142  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 `tables2014` 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 = 12683 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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.0141  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.0144  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.0144  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.0141  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.0142  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