4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Falkirk Falkirk 35 94 26 89
2 Hamilton Academical Hamilton 35 69 27 71
3 Alloa Athletic Alloa 35 58 53 55
4 Montrose Montrose 35 55 55 50
5 Cove Rangers Cove Rangers 35 55 62 46
6 Kelty Hearts Kelty Hearts 35 47 59 44
7 Queen of the South Queen South 35 44 50 41
8 Annan Athletic Annan 35 54 67 38
9 Stirling Albion Stirling 35 38 57 38
10 Edinburgh City Edinburgh 35 37 95 8
TEMPORADA 2022/2023
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Dundee Dundee 36 66 40 63
2 Ayr United Ayr United 36 61 43 58
3 Queen's Park Queen's Park 36 63 52 58
4 Partick Thistle Partick 36 65 45 57
5 Greenock Morton Greenock 36 53 43 57
6 Inverness CT Inverness 36 52 47 55
7 Raith Rovers Raith Rovers 36 46 49 43
8 Arbroath Arbroath 36 29 47 34
9 Hamilton Academical Hamilton 36 31 63 31
10 Cove Rangers Cove Rangers 36 38 75 31
TEMPORADA 2021/2022
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Kilmarnock Kilmarnock 36 50 27 67
2 Arbroath Arbroath 36 54 28 65
3 Inverness CT Inverness 36 53 34 59
4 Partick Thistle Partick 36 46 40 52
5 Raith Rovers Raith Rovers 36 44 44 50
6 Hamilton Academical Hamilton 36 38 53 42
7 Greenock Morton Greenock 36 36 47 40
8 Ayr United Ayr United 36 39 52 39
9 Dunfermline Athletic FC Dunfermline 36 36 53 35
10 Queen of the South Queen South 36 36 54 33
TEMPORADA 2020/2021
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Motherwell Motherwell 38 39 55 45
2 St. Mirren St. Mirren 38 36 47 44
3 Dundee United Dundee 38 32 50 44
4 Ross County FC Ross County 38 35 66 39
5 Kilmarnock Kilmarnock 38 43 54 36
6 Hamilton Academical Hamilton 38 36 66 32
TEMPORADA 2019/2020
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 30 89 19 80
2 Rangers FC Rangers FC 29 64 19 67
3 Motherwell Motherwell 30 41 38 46
4 Aberdeen Aberdeen 30 40 36 45
5 Livingston Livingston 30 41 39 39
6 Hibernian FC Hibernian 30 42 49 37
7 St. Johnstone Johnstone 29 28 46 36
8 Kilmarnock Kilmarnock 30 31 41 33
9 St. Mirren St. Mirren 30 24 41 29
10 Ross County FC Ross County 30 29 60 29
11 Hamilton Academical Hamilton 30 30 50 27
12 Heart of Midlothian Heart 30 31 52 23
TEMPORADA 2018/2019
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 St. Johnstone Johnstone 5 6 4 52
2 Motherwell Motherwell 5 9 9 51
3 Livingston Livingston 5 7 11 44
4 Hamilton Academical Hamilton 5 7 6 33
5 St. Mirren St. Mirren 5 10 5 32
6 Dundee Dundee 5 6 10 21
TEMPORADA 2017/2018
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Motherwell Motherwell 5 7 6 48
2 St. Johnstone Johnstone 5 10 6 46
3 Dundee Dundee 5 5 4 39
4 Partick Thistle Partick 5 5 4 33
5 Hamilton Academical Hamilton 5 4 8 33
6 Ross County FC Ross County 5 2 5 29
TEMPORADA 2016/2017
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ross County FC Ross County 5 11 4 46
2 Kilmarnock Kilmarnock 5 6 7 41
3 Motherwell Motherwell 5 8 8 38
4 Dundee Dundee 5 5 9 37
5 Hamilton Academical Hamilton 5 7 8 35
6 Inverness CT Inverness 5 8 9 34
TEMPORADA 2015/2016
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 78 25 76
2 Aberdeen Aberdeen 33 56 36 68
3 Heart of Midlothian Heart 33 54 33 60
4 Motherwell Motherwell 33 41 49 44
5 St. Johnstone Johnstone 33 48 51 43
6 Ross County FC Ross County 33 48 55 43
7 Dundee Dundee 33 48 49 41
8 Partick Thistle Partick 33 32 39 41
9 Inverness CT Inverness 33 40 43 40
10 Hamilton Academical Hamilton 33 36 55 36
11 Kilmarnock Kilmarnock 33 33 54 32
12 Dundee United Dundee 33 33 58 24
TEMPORADA 2014/2015
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Hamilton Academical Hamilton 5 8 5 53
2 Partick Thistle Partick 5 7 6 46
3 Ross County FC Ross County 5 7 7 44
4 Kilmarnock Kilmarnock 5 9 13 41
5 Motherwell Motherwell 5 5 6 36
6 St. Mirren St. Mirren 5 8 7 30
TEMPORADA 2013/2014
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Dundee Dundee 36 54 26 69
2 Hamilton Academical Hamilton 36 68 41 67
3 Falkirk Falkirk 36 59 33 66
4 Queen of the South Queen South 36 53 39 55
5 Dumbarton Dumbarton 36 65 64 51
6 Livingston Livingston 36 51 56 46
7 Raith Rovers Raith Rovers 36 48 61 42
8 Alloa Athletic Alloa 36 34 51 40
9 Cowdenbeath Cowdenbeath 36 50 72 40
10 Greenock Morton Greenock 36 32 71 26
TEMPORADA 2012/2013
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Partick Thistle Partick 36 76 28 78
2 Greenock Morton Greenock 36 73 47 67
3 Falkirk Falkirk 36 52 48 53
4 Livingston Livingston 36 58 56 52
5 Hamilton Academical Hamilton 36 52 45 51
6 Raith Rovers Raith Rovers 36 45 48 46
7 Dumbarton Dumbarton 36 58 83 43
8 Cowdenbeath Cowdenbeath 36 51 65 36
9 Dunfermline Athletic FC Dunfermline 36 62 59 34
10 Airdrieonians Airdrieonian 36 41 89 22
TEMPORADA 2011/2012
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Ross County FC Ross County 36 72 32 79
2 Dundee Dundee 36 53 43 55
3 Falkirk Falkirk 36 53 48 52
4 Hamilton Academical Hamilton 36 55 56 49
5 Livingston Livingston 36 56 54 48
6 Partick Thistle Partick 36 50 39 47
7 Raith Rovers Raith Rovers 36 46 49 44
8 Greenock Morton Greenock 36 40 55 42
9 Ayr United Ayr United 36 44 67 38
10 Queen of the South Queen South 36 38 64 32
TEMPORADA 2010/2011
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Inverness CT Inverness 5 8 2 53
2 St. Johnstone Johnstone 5 5 4 44
3 Aberdeen Aberdeen 5 5 5 38
4 Hibernian FC Hibernian 5 3 9 37
5 St. Mirren St. Mirren 5 2 3 33
6 Hamilton Academical Hamilton 5 4 4 26

  USO DE MEMORIA  
6,977,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.6653
Total Execution Time  0.6668
  CADENA URL  
/historico/Hamilton-Acade
  GET DATOS  
$_GET['/historico/Hamilton-Acade']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0299  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 = 72459
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6493 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6493 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  SELECT /*35 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 (21382,39385,43155,92006,112274) ORDER BY n.cover_points DESC, update_date DESC
0.0143  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 = '6493' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 72459 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160  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=6493 AND l.year in (2023,2024,2025) 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 (73404,72523,72459,72126,71642,71432,67941) 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 = 67941 AND teamId = 6493
0.0166  SELECT count(id) as num_players from rel_players WHERE league_id = 72459 AND teamId = 6493
0.0187  SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 6493
0.0207  SELECT count(id) as num_players from rel_players WHERE league_id = 72523 AND teamId = 6493
0.0174  SELECT count(id) as num_players from rel_players WHERE league_id = 72126 AND teamId = 6493
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 71642 AND teamId = 6493
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6493
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 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 = 72459 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '6493' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6493' and rp.type = 4
0.0127  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 = '6493' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0150  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 = 72459 WHERE rp.league_id = 72459 AND rp.teamId = 6493 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.0142  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 = 72459 WHERE rp.league_id = 72459 AND rp.teamId = 6493 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 72459 WHERE rp.league_id = 72459 AND rp.teamId = 6493 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 6493 AND l.year <= 2024 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 `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 = 72459 AND t.round = 35 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 `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 = 67941 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 63083 AND t.round = 36 ORDER BY team.conference ASC,t.position 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 `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 = 61890 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `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 = 49541 AND t.round = 5 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 `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 = 43281 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 38282 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 23881 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 12926 AND t.round = 5 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 = 2456 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 2025 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 1625 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 10325 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC