4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
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
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
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
Ver
TEMPORADA 2012/2013
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
Ver
TEMPORADA 2011/2012
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
Ver
TEMPORADA 2010/2011
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
Ver
TEMPORADA 2009/2010
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
Ver
TEMPORADA 2007/2008
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
Ver
TEMPORADA 2006/2007
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,641,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4184
Total Execution Time  0.4204
  CADENA URL  
/grenada2020/grupo1/historico
  GET DATOS  
$_GET['/grenada2020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0108  SELECT type FROM routes WHERE alias = 'grenada2020'
0.0223  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'grenada' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=165 AND type_rel = 3
0.0108  SELECT id,name,alias,stepParent FROM categories WHERE parentId=165 ORDER BY order_id ASC
0.0105  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 165 GROUP BY l.categoryId
0.0106  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=165 GROUP BY l.year ORDER BY l.year DESC
0.0106  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 = 53599 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 165 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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.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 `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.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 `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.0118  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.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 `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 `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.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 `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.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 `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
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 07:56:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 07:56:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 07:56:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 07:56:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'grenada' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  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 events2020 e ON e.player_id = p.id AND e.league_id = 53599 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53599 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.0107  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 events2020 e ON e.player_id = p.id AND e.league_id = 53599 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53599 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 events2020 e ON e.player_id = p.id AND e.league_id = 53599 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53599 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  SELECT *,(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