4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dunbeholden
TEMPORADA 2023/2024
LIGA JAMAICA
Equipo PJ GF GC Puntos
1 Mount Pleasant Mount 26 37 15 59
2 Cavalier Cavalier 26 48 17 54
3 Tivoli Gardens Tivoli 26 51 23 51
4 Portmore United Portmore 26 37 16 49
5 Arnett Gardens Arnett 26 44 24 49
6 Waterhouse Waterhouse 26 38 22 43
7 Montego Bay United Montego 26 39 29 43
8 Dunbeholden Dunbeholden 26 34 33 37
9 Vere United Vere United 26 27 36 27
10 Humble Lions Humble Lions 26 30 47 25
11 Molynes United Molynes 26 29 55 23
12 Harbour View Harbour View 26 32 39 22
13 Treasure Beach Treasure 26 17 52 13
14 Lime Hall Academy Lime Hall A. 26 14 69 7
TEMPORADA 2022/2023
LIGA JAMAICA
Equipo PJ GF GC Puntos
1 Arnett Gardens Arnett 26 48 21 55
2 Cavalier Cavalier 26 47 22 52
3 Mount Pleasant Mount 26 48 19 46
4 Harbour View Harbour View 26 34 21 44
5 Humble Lions Humble Lions 26 27 15 42
6 Waterhouse Waterhouse 26 27 19 42
7 Dunbeholden Dunbeholden 26 44 31 41
8 Portmore United Portmore 26 29 17 40
9 Molynes United Molynes 26 37 48 30
10 Montego Bay United Montego 26 22 40 26
11 Tivoli Gardens Tivoli 26 29 42 22
12 Vere United Vere United 26 15 32 21
13 Faulkland SC Faulkland 26 23 55 13
14 Chapelton Maroons Chapelton 26 14 62 9
TEMPORADA 2021/2022
LIGA JAMAICA
Equipo PJ GF GC Puntos
1 Waterhouse Waterhouse 22 41 18 49
2 Dunbeholden Dunbeholden 22 31 22 44
3 Arnett Gardens Arnett 22 39 25 42
4 Mount Pleasant Mount 22 38 25 41
5 Cavalier Cavalier 22 28 20 35
6 Harbour View Harbour View 22 26 23 28
7 Humble Lions Humble Lions 22 23 22 28
8 Tivoli Gardens Tivoli 22 29 30 28
9 Vere United Vere United 22 12 21 20
10 Portmore United Portmore 22 15 29 20
11 Molynes United Molynes 22 23 44 15
12 Montego Bay United Montego 22 15 41 12
TEMPORADA 2020/2021
LIGA JAMAICA
Equipo PJ GF GC Puntos
1 Waterhouse Waterhouse 10 18 8 19
2 Cavalier Cavalier 10 16 9 18
3 Mount Pleasant Mount 10 13 10 18
4 Tivoli Gardens Tivoli 10 14 11 17
5 Vere United Vere United 10 9 7 15
6 Harbour View Harbour View 10 12 11 15
7 Dunbeholden Dunbeholden 10 12 16 14
8 Portmore United Portmore 10 11 9 13
9 Arnett Gardens Arnett 10 8 15 8
10 Molynes United Molynes 10 8 16 7
11 Humble Lions Humble Lions 10 10 19 6
12 UWI UWI 0 0 0 0
TEMPORADA 2019/2020
LIGA JAMAICA
Equipo PJ GF GC Puntos
1 Waterhouse Waterhouse 29 50 27 54
2 Mount Pleasant Mount 29 43 22 53
3 Portmore United Portmore 28 38 28 46
4 Humble Lions Humble Lions 28 30 23 46
5 Tivoli Gardens Tivoli 29 39 34 43
6 Dunbeholden Dunbeholden 29 34 30 43
7 Arnett Gardens Arnett 29 40 42 42
8 Cavalier Cavalier 29 41 33 39
9 Harbour View Harbour View 29 28 35 39
10 Molynes United Molynes 29 30 47 29
11 UWI UWI 29 26 51 18
12 Vere United Vere United 29 19 46 18
TEMPORADA 2018/2019
LIGA JAMAICA
Equipo PJ GF GC Puntos
1 Portmore United Portmore 33 53 27 66
2 Waterhouse Waterhouse 33 47 24 62
3 Mount Pleasant Mount 33 32 19 60
4 Cavalier Cavalier 33 38 24 54
5 Arnett Gardens Arnett 33 39 33 48
6 UWI UWI 33 32 31 46
7 Tivoli Gardens Tivoli 33 36 42 39
8 Humble Lions Humble Lions 32 33 38 35
9 Harbour View Harbour View 33 33 48 35
10 Dunbeholden Dunbeholden 33 33 42 33
11 Montego Bay United Montego 33 31 55 30
12 Reno FC Reno FC 32 24 48 24

  USO DE MEMORIA  
5,252,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1094
Total Execution Time  0.1106
  CADENA URL  
/historico/Dunbeholden-Fc
  GET DATOS  
$_GET['/historico/Dunbeholden-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0060  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Dunbeholden-Fc' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0021  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=113161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=113161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0048  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 = 74408
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=113161 AND type_rel = 2
0.0028  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '113161' ORDER BY l.year DESC,cat.coefficient DESC
0.0028  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '113161' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '113161' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 74408 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=113161 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (74408,72178) 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.0051  SELECT count(id) as num_players from rel_players WHERE league_id = 74408 AND teamId = 113161
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72178 AND teamId = 113161
0.0021  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 = '113161' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '113161' and rp.type = 4
0.0023  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 = '113161' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0052  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 events2024 e ON e.player_id = p.id AND e.league_id = 74408 WHERE rp.league_id = 74408 AND rp.teamId = 113161 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.0040  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 events2024 e ON e.player_id = p.id AND e.league_id = 74408 WHERE rp.league_id = 74408 AND rp.teamId = 113161 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 events2024 e ON e.player_id = p.id AND e.league_id = 74408 WHERE rp.league_id = 74408 AND rp.teamId = 113161 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 113161 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 74408 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 70212 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables2022` 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 = 66298 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.0026  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 `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 = 63186 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 50133 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 43887 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC