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 80 26 79
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 44 54 42
TEMPORADA 2022/2023
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 38 114 34 99
2 Rangers FC Rangers FC 38 93 37 92
3 Aberdeen Aberdeen 38 56 60 57
4 Heart of Midlothian Heart 38 63 57 54
5 Hibernian FC Hibernian 38 57 59 52
6 St. Mirren St. Mirren 38 43 61 46
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
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
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 St. Mirren St. Mirren 36 63 36 74
2 Livingston Livingston 36 56 37 62
3 Dundee United Dundee 36 52 42 61
4 Dunfermline Athletic FC Dunfermline 36 60 35 59
5 Inverness CT Inverness 36 53 37 57
6 Queen of the South Queen South 36 59 53 52
7 Greenock Morton Greenock 36 47 40 50
8 Falkirk Falkirk 36 45 49 47
9 Dumbarton Dumbarton 36 27 63 30
10 Brechin City Brechin City 36 20 90 4
TEMPORADA 2016/2017
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Hibernian FC Hibernian 36 59 25 71
2 Falkirk Falkirk 36 58 40 60
3 Dundee United Dundee 36 50 42 57
4 Greenock Morton Greenock 36 44 41 52
5 Dunfermline Athletic FC Dunfermline 36 46 43 48
6 Queen of the South Queen South 36 46 52 43
7 St. Mirren St. Mirren 36 52 56 39
8 Dumbarton Dumbarton 36 46 56 39
9 Raith Rovers Raith Rovers 36 35 52 39
10 Ayr United Ayr United 36 33 62 33
TEMPORADA 2015/2016
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 88 34 81
2 Falkirk Falkirk 36 61 34 70
3 Hibernian FC Hibernian 36 59 34 70
4 Raith Rovers Raith Rovers 36 52 46 62
5 Greenock Morton Greenock 36 39 42 43
6 St. Mirren St. Mirren 36 44 53 42
7 Queen of the South Queen South 36 46 56 42
8 Dumbarton Dumbarton 36 35 66 37
9 Livingston Livingston 36 37 51 31
10 Alloa Athletic Alloa 36 22 67 21
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
LIGA ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ross County FC Ross County 5 6 6 40
2 St. Mirren St. Mirren 5 5 3 39
3 Kilmarnock Kilmarnock 5 4 9 39
4 Partick Thistle Partick 5 10 8 38
5 Hibernian FC Hibernian 5 2 7 35
6 Heart of Midlothian Heart 5 12 6 23
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,584,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6170
Total Execution Time  0.6184
  CADENA URL  
/historico/St-Mirren
  GET DATOS  
$_GET['/historico/St-Mirren']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2416 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2416 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (65507,97498,111668,112800,148592) ORDER BY n.cover_points DESC, update_date DESC
0.0167  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 = '2416' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = 73404 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0159  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=2416 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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,73407,73404,71432) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 75868 AND teamId = 2416
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 2416
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 73407 AND teamId = 2416
0.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2416
0.0147  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 = 2416 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.0151  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 = 2416 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 2416 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162  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 = 2416 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 = 67765 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.0148  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 = 71550 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.0150  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.0147  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.0148  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 = 56950 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.0147  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.0148  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 = 49877 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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.0147  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.0149  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 = 38698 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 33316 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15405 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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.0147  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.0149  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 = 2455 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 10328 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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.0147  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