4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Police FC Police FC 18 39 17 38
2 Port of Spain Port Spain 16 39 18 34
3 Club Sando Club Sando 18 30 21 32
4 Defence Force Defence 17 31 18 31
5 La Horquetta Horquetta 18 36 33 25
6 Point Fortin Point Fortin 18 25 21 23
7 Phoenix Phoenix 16 25 29 22
8 Morvant Caledonia United Morvant 18 26 25 21
9 Prison Service Prison 18 23 34 21
10 Cunupia Cunupia 17 21 26 19
11 Central FC Central FC 18 12 65 2
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Defence Force Defence 22 53 16 56
2 Port of Spain Port Spain 22 63 18 55
3 Club Sando Club Sando 22 43 22 48
4 La Horquetta Horquetta 22 61 31 43
5 Police FC Police FC 22 43 32 39
6 Central FC Central FC 22 38 41 34
7 Point Fortin Point Fortin 22 21 27 25
8 San Juan Jabloteh Juan 22 35 46 22
9 W Connection Connection 22 19 36 22
10 Morvant Caledonia United Morvant 22 24 50 17
11 Prison Service Prison 22 16 61 12
12 Cunupia Cunupia 22 14 50 8
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Defence Force Defence 17 35 17 42
2 La Horquetta Horquetta 17 48 18 35
3 Point Fortin Point Fortin 17 25 23 28
4 W Connection Connection 16 28 20 27
5 Morvant Caledonia United Morvant 17 20 23 24
6 Police FC Police FC 17 29 22 23
7 Club Sando Club Sando 18 28 25 21
8 San Juan Jabloteh Juan 17 21 31 19
9 Central FC Central FC 18 18 34 14
10 Port of Spain Port Spain 17 18 38 13
11 Cunupia Cunupia 17 14 33 12
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 W Connection Connection 18 43 8 37
2 Central FC Central FC 18 42 25 36
3 Club Sando Club Sando 18 44 26 33
4 Police FC Police FC 18 37 21 33
5 Defence Force Defence 18 38 21 30
6 Morvant Caledonia United Morvant 18 36 22 30
7 San Juan Jabloteh Juan 18 29 24 27
8 Point Fortin Point Fortin 18 20 46 11
9 St Ann's Rangers Ann's 18 13 67 10
10 North East Stars North East. 18 16 58 6
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 North East Stars North East. 18 39 15 40
2 W Connection Connection 18 33 19 33
3 Defence Force Defence 18 27 20 31
4 Club Sando Club Sando 18 28 16 30
5 San Juan Jabloteh Juan 18 27 33 26
6 Morvant Caledonia United Morvant 18 19 21 22
7 Point Fortin Point Fortin 18 26 29 21
8 Police FC Police FC 18 29 29 20
9 Central FC Central FC 18 23 37 17
10 St Ann's Rangers Ann's 18 12 44 10
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Central FC Central FC 18 41 14 47
2 W Connection Connection 18 50 13 46
3 San Juan Jabloteh Juan 18 32 23 29
4 Ma Pau Ma Pau 18 33 29 28
5 Club Sando Club Sando 18 33 34 25
6 Defence Force Defence 18 30 30 23
7 Police FC Police FC 18 36 35 20
8 St Ann's Rangers Ann's 18 23 39 17
9 Morvant Caledonia United Morvant 18 19 32 12
10 Point Fortin Point Fortin 18 17 65 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Central FC Central FC 27 68 20 58
2 San Juan Jabloteh Juan 27 51 36 54
3 Defence Force Defence 27 54 23 49
4 W Connection Connection 27 54 25 49
5 North East Stars North East. 27 42 49 44
6 Police FC Police FC 27 57 56 40
7 Club Sando Club Sando 27 36 57 30
8 Point Fortin Point Fortin 27 28 56 22
9 Morvant Caledonia United Morvant 27 28 57 22
10 St Ann's Rangers Ann's 27 26 65 14
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Central FC Central FC 24 63 19 55
2 W Connection Connection 24 47 20 49
3 Defence Force Defence 24 46 31 39
4 North East Stars North East. 24 25 25 34
5 Point Fortin Point Fortin 24 45 43 33
6 San Juan Jabloteh Juan 24 33 41 31
7 Police FC Police FC 24 35 46 30
8 Morvant Caledonia United Morvant 24 31 43 27
9 St Ann's Rangers Ann's 24 21 78 5
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 W Connection Connection 24 51 19 50
2 Central FC Central FC 24 49 21 45
3 Defence Force Defence 24 47 32 45
4 Point Fortin FC Point Fortin 24 37 25 42
5 North East Stars North East. 24 28 17 42
6 Morvant Caledonia United Morvant 24 34 38 28
7 Police FC Police FC 24 30 45 27
8 San Juan Jabloteh Juan 24 23 53 16
9 St. Anns Rangers Anns Rangers 24 19 68 7
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Defence Force Defence 21 52 21 46
2 Morvant Caledonia United Morvant 21 53 27 42
3 W Connection Connection 21 45 19 38
4 North East Stars North East. 21 32 17 38
5 Central FC Central FC 21 31 32 30
6 Police FC Police FC 21 25 43 16
7 St. Anns Rangers Anns Rangers 21 22 49 13
8 T&TEC T&TEC 21 13 65 8
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 W Connection Connection 21 32 20 40
2 T&TEC T&TEC 21 36 19 39
3 Morvant Caledonia United Morvant 21 34 28 38
4 Defence Force Defence 21 32 28 32
5 San Juan Jabloteh Juan 21 29 30 27
6 Police FC Police FC 21 30 47 21
7 North East Stars North East. 21 21 27 20
8 St. Anns Rangers Anns Rangers 21 24 39 17
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Defence Force Defence 19 41 13 44
2 Morvant Caledonia United Morvant 19 33 18 39
3 Joe Public FC Public 19 34 23 38
4 W Connection Connection 19 37 13 34
5 Ma Pau Ma Pau 19 27 17 32
6 San Juan Jabloteh Juan 19 29 14 30
7 North East Stars North East. 19 31 26 28
8 St. Anns Rangers Anns Rangers 19 14 39 10
9 FC South End South 19 12 45 9
10 Police FC Police FC 19 21 57 9
11 Tobago United Tobago 10 10 24 7
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Joe Public FC Public 20 50 24 41
2 Morvant Caledonia United Morvant 20 49 30 40
3 San Juan Jabloteh Juan 20 29 16 39
4 W Connection Connection 20 36 17 34
5 Ma Pau Ma Pau 20 31 21 34
6 Defence Force Defence 20 36 26 32
7 United Petrotrin United 20 32 21 30
8 FC South End South 20 15 36 16
9 St Ann's Rangers Ann's 20 22 46 15
10 Tobago United Tobago 20 17 32 13
11 Police FC Police FC 20 16 64 9
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 W Connection Connection 27 53 18 61
2 San Juan Jabloteh Juan 27 55 23 61
3 Morvant Caledonia United Morvant 27 42 38 41
4 Joe Public FC Public 27 47 36 40
5 North East Stars North East. 27 36 34 40
6 United Petrotrin United 27 34 42 37
7 St Ann's Rangers Ann's 27 50 52 34
8 Defence Force Defence 27 41 47 28
9 Ma Pau Ma Pau 27 33 63 25
10 Tobago United Tobago 27 25 63 13
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 San Juan Jabloteh Juan 27 42 27 55
2 Morvant Caledonia United Morvant 27 43 23 54
3 Joe Public FC Public 27 45 22 49
4 W Connection Connection 27 51 28 44
5 Defence Force Defence 27 40 37 42
6 North East Stars North East. 27 37 25 40
7 United Petrotrin United 27 38 35 35
8 St Ann's Rangers Ann's 27 48 42 32
9 Police FC Police FC 27 29 79 16
10 Tobago United Tobago 27 25 80 11
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Joe Public FC Public 27 51 15 59
2 W Connection Connection 27 51 20 54
3 San Juan Jabloteh Juan 27 48 21 50
4 North East Stars North East. 27 46 34 46
5 Morvant Caledonia United Morvant 27 45 36 46
6 St Ann's Rangers Ann's 27 35 41 37
7 Defence Force Defence 27 33 39 32
8 United Petrotrin United 27 22 34 32
9 Starworld Strikers Starworld 27 26 54 19
10 Tobago United Tobago 27 21 84 3

JUGADORES DESTACADOS

Nombre Goles Equipo
A. Éxilus ht A. Éxilus 1 CUN Cunupia
K. Goddard tt K. Goddard 1 DEF Defence Force
R. Gill tt R. Gill 1 SAN Club Sando
K. Woodley tt K. Woodley 1 CUN Cunupia

  USO DE MEMORIA  
5,885,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5339
Total Execution Time  0.5359
  CADENA URL  
/professional_league_trinidad_y_tobago2024/grupo1/historico
  GET DATOS  
$_GET['/professional_league_trinidad_y_tobago2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0126  SELECT type FROM routes WHERE alias = 'professional_league_trinidad_y_tobago2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'professional_league_trinidad_y_tobago' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=430 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 430 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (808454,4922) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=430 ORDER BY order_id ASC
0.0126  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 = 74685 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 430 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2024` 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 = 74685 AND t.round = 21 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 `tables2023` 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 = 71272 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 51657 AND t.round = 22 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 = 49132 AND t.round = 18 ORDER BY team.conference 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 `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 = 39023 AND t.round = 18 ORDER BY team.conference 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 `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 = 36301 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 15820 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 8364 AND t.round = 27 ORDER BY team.conference 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 `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 = 3312 AND t.round = 27 ORDER BY team.conference 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 `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 = 16136 AND t.round = 21 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 `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 = 16137 AND t.round = 21 ORDER BY team.conference 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 `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 = 16138 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2009` 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 = 16139 AND t.round = 22 ORDER BY team.conference 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 `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 = 16141 AND t.round = 27 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 `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 = 16143 AND t.round = 27 ORDER BY team.conference 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 `tables2006` 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 = 16145 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 16:24:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-07 16:24:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-07 16:24:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-07 16:24:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'professional_league_trinidad_y_tobago' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0130  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 events2024 e ON e.player_id = p.id AND e.league_id = 74685 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74685 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.0127  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 events2024 e ON e.player_id = p.id AND e.league_id = 74685 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74685 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  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 events2024 e ON e.player_id = p.id AND e.league_id = 74685 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74685 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74685 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC