4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 34 82 27 81
2 Rangers FC Rangers FC 34 74 24 78
3 Heart of Midlothian Heart 34 46 34 63
4 Kilmarnock Kilmarnock 34 43 34 52
5 St. Mirren St. Mirren 34 39 45 43
6 Dundee Dundee 34 45 56 41
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
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Livingston Livingston 38 41 46 49
2 Hibernian FC Hibernian 38 38 42 45
3 St. Mirren St. Mirren 38 33 51 44
4 Aberdeen Aberdeen 38 41 46 41
5 St. Johnstone Johnstone 38 24 51 35
6 Dundee Dundee 38 34 64 29
TEMPORADA 2020/2021
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Heart of Midlothian Heart 27 63 24 57
2 Dundee Dundee 27 49 40 45
3 Raith Rovers Raith Rovers 27 45 36 43
4 Dunfermline Athletic FC Dunfermline 27 38 34 39
5 Inverness CT Inverness 27 36 31 36
6 Queen of the South Queen South 27 38 51 32
7 Arbroath Arbroath 27 28 34 30
8 Ayr United Ayr United 27 31 37 29
9 Greenock Morton Greenock 27 22 33 29
10 Alloa Athletic Alloa 27 30 60 22
TEMPORADA 2019/2020
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Dundee United Dundee 28 52 22 59
2 Inverness CT Inverness 27 39 32 45
3 Dundee Dundee 27 32 31 41
4 Ayr United Ayr United 27 38 35 40
5 Dunfermline Athletic FC Dunfermline 28 41 36 37
6 Arbroath Arbroath 26 24 26 36
7 Greenock Morton Greenock 28 45 52 36
8 Alloa Athletic Alloa 28 33 43 31
9 Queen of the South Queen South 28 28 40 28
10 Partick Thistle Partick 27 32 47 26
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 3
Equipo PJ GF GC Puntos
1 Inverness CT Inverness 5 14 5 52
2 Dundee Dundee 5 5 8 48
3 Partick Thistle Partick 5 9 11 46
4 Hamilton Academical Hamilton 5 6 8 43
5 Kilmarnock Kilmarnock 5 8 10 36
6 Dundee United Dundee 5 12 12 28
TEMPORADA 2014/2015
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 70 17 79
2 Aberdeen Aberdeen 32 53 28 68
3 Inverness CT Inverness 33 46 34 58
4 Dundee United Dundee 32 53 48 49
5 St. Johnstone Johnstone 33 29 32 48
6 Dundee Dundee 33 45 45 44
7 Hamilton Academical Hamilton 33 42 48 43
8 Partick Thistle Partick 33 41 38 38
9 Kilmarnock Kilmarnock 33 35 46 38
10 Ross County FC Ross County 33 39 56 37
11 Motherwell Motherwell 33 33 57 31
12 St. Mirren St. Mirren 33 22 59 21
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
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Hibernian FC Hibernian 5 9 5 51
2 Aberdeen Aberdeen 5 3 2 48
3 Kilmarnock Kilmarnock 5 5 10 45
4 Heart of Midlothian Heart 5 6 4 44
5 St. Mirren St. Mirren 5 7 9 41
6 Dundee Dundee 5 6 6 30

  USO DE MEMORIA  
6,501,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5504
Total Execution Time  0.5518
  CADENA URL  
/historico/Dundee
  GET DATOS  
$_GET['/historico/Dundee']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0108  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9934 AND type_rel = 2
0.0114  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9934 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0115  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 (3229,31188,31228,35745,53578) ORDER BY n.cover_points DESC, update_date DESC
0.0313  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 = '9934' ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '9934' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0123  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 = 72126 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0200  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=9934 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75868,73404,72126,71432,68154,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.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 75868 AND teamId = 9934
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 67941 AND teamId = 9934
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 9934
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 72126 AND teamId = 9934
0.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 68154 AND teamId = 9934
0.0120  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9934
0.0108  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 = 75868 WHERE rp.league_id = 75868 AND rp.teamId = 9934 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.0108  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 = 75868 WHERE rp.league_id = 75868 AND rp.teamId = 9934 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106  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 = 75868 WHERE rp.league_id = 75868 AND rp.teamId = 9934 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0123  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 = 9934 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72121 AND t.round = 33 ORDER BY team.conference ASC,t.position 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 `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 = 75868 AND t.round = 2 ORDER BY team.conference ASC,t.position 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 `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.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 `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 = 62929 AND t.round = 33 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 `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 = 67303 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.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 `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 = 57741 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 50139 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `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 = 43564 AND t.round = 33 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 `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.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 `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 = 38641 AND t.round = 33 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 = 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.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 `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 = 33312 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0112  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 = 15400 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119  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.0122  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 = 12925 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 4076 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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.0111  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 = 2024 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 10327 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC