4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA LOWLAND ESCOCIA
Equipo PJ GF GC Puntos
1 East Kilbride East 34 96 43 81
2 Hearts II Hearts II 34 92 43 69
3 Bo'ness United Bo'ness 34 72 50 67
4 Cumbernauld Colts Cumbernauld 34 70 43 65
5 Tranent Juniors FC Tranent 34 69 42 60
6 Celtic II Celtic II 34 80 47 59
7 Civil Service Strollers Civil 34 51 48 56
8 Linlithgow Rose Linlithgow 34 63 43 50
9 Albion Rovers Albion 34 43 36 46
10 Cowdenbeath Cowdenbeath 34 55 56 46
11 Stirling University Stirling 34 50 53 46
12 Caledonian Braves Caledonian 34 47 43 45
13 Berwick Rangers Berwick 34 42 48 42
14 East Stirlingshire East 34 58 68 40
15 Broomhill FC Broomhill 34 56 59 39
16 Gala Fairydean Rovers Gala 34 45 87 32
17 Gretna 2008 Gretna 2008 34 26 114 12
18 AFC Edinburgh University Edinburgh 34 40 132 9
TEMPORADA 2022/2023
LIGA LOWLAND ESCOCIA
Equipo PJ GF GC Puntos
1 Spartans Spartans 36 78 31 79
2 Rangers FC II Rangers 36 98 57 77
3 Celtic II Celtic II 36 96 45 76
4 Stirling University Stirling 36 82 45 71
5 Tranent Juniors FC Tranent 36 74 44 65
6 East Kilbride East 36 81 53 64
7 Berwick Rangers Berwick 36 61 51 61
8 Civil Service Strollers Civil 36 63 45 58
9 Bo'ness United Bo'ness 36 71 51 54
10 Caledonian Braves Caledonian 36 79 67 51
11 Broomhill FC Broomhill 36 73 73 51
12 Gala Fairydean Rovers Gala 36 63 74 49
13 Hearts II Hearts II 36 75 59 48
14 Cumbernauld Colts Cumbernauld 36 62 59 46
15 Cowdenbeath Cowdenbeath 36 46 50 36
16 East Stirlingshire East 36 41 74 33
17 Gretna 2008 Gretna 2008 36 39 91 26
18 AFC Edinburgh University Edinburgh 36 31 127 16
19 Dalbeattie Star Dalbeattie 36 27 144 8
TEMPORADA 2021/2022
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Kelty Hearts Kelty Hearts 36 68 28 81
2 Forfar Athletic Forfar 36 57 36 60
3 Annan Athletic Annan 36 64 51 59
4 Edinburgh City Edinburgh 36 43 49 52
5 Stenhousemuir Stenhousemui 36 47 46 49
6 Stranraer Stranraer 36 50 54 47
7 Stirling Albion Stirling 36 41 46 42
8 Albion Rovers Albion 36 37 58 39
9 Elgin City Elgin City 36 33 51 37
10 Cowdenbeath Cowdenbeath 36 28 49 29
TEMPORADA 2020/2021
LEAGUE TWO ESCOCIA GRUPO 3
Equipo PJ GF GC Puntos
1 Cowdenbeath Cowdenbeath 4 5 3 7
2 Albion Rovers Albion 4 3 3 7
3 Annan Athletic Annan 4 5 3 5
4 Brechin City Brechin City 4 3 5 4
5 Stenhousemuir Stenhousemui 4 2 4 4
TEMPORADA 2019/2020
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Cove Rangers Cove Rangers 28 76 34 68
2 Edinburgh City Edinburgh 27 49 28 55
3 Elgin City Elgin City 28 48 34 43
4 Cowdenbeath Cowdenbeath 27 37 35 41
5 Queen's Park Queen's Park 28 37 35 40
6 Stirling Albion Stirling 28 34 35 36
7 Annan Athletic Annan 27 33 54 31
8 Stenhousemuir Stenhousemui 28 32 48 29
9 Albion Rovers Albion 26 37 51 24
10 Brechin City Brechin City 27 31 60 17
TEMPORADA 2018/2019
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Peterhead Peterhead 35 65 27 79
2 Clyde Clyde 36 63 35 74
3 Edinburgh City Edinburgh 36 58 31 67
4 Annan Athletic Annan 36 70 39 66
5 Stirling Albion Stirling 36 44 45 47
6 Cowdenbeath Cowdenbeath 35 46 45 43
7 Queen's Park Queen's Park 36 44 47 43
8 Elgin City Elgin City 36 52 67 43
9 Albion Rovers Albion 35 31 71 24
10 Berwick Rangers Berwick 35 25 91 16
TEMPORADA 2017/2018
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Montrose Montrose 36 60 35 77
2 Peterhead Peterhead 36 79 39 76
3 Stirling Albion Stirling 36 61 52 55
4 Stenhousemuir Stenhousemui 36 56 47 54
5 Clyde Clyde 36 52 50 51
6 Elgin City Elgin City 36 54 61 49
7 Annan Athletic Annan 36 49 41 47
8 Berwick Rangers Berwick 36 31 59 37
9 Edinburgh City Edinburgh 36 37 62 30
10 Cowdenbeath Cowdenbeath 36 23 56 22
TEMPORADA 2016/2017
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Arbroath Arbroath 36 63 36 66
2 Forfar Athletic Forfar 36 69 49 64
3 Annan Athletic Annan 36 61 58 58
4 Montrose Montrose 36 44 53 52
5 Elgin City Elgin City 36 67 47 51
6 Stirling Albion Stirling 36 50 59 47
7 Edinburgh City Edinburgh 36 38 45 43
8 Berwick Rangers Berwick 36 50 65 40
9 Clyde Clyde 36 49 64 38
10 Cowdenbeath Cowdenbeath 36 40 55 35
TEMPORADA 2015/2016
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Dunfermline Athletic FC Dunfermline 36 83 30 79
2 Ayr United Ayr United 36 65 47 61
3 Peterhead Peterhead 36 72 47 59
4 Stranraer Stranraer 36 43 49 51
5 Airdrieonians Airdrieonian 36 48 50 49
6 Albion Rovers Albion 36 40 44 49
7 Brechin City Brechin City 36 47 59 42
8 Stenhousemuir Stenhousemui 36 46 80 40
9 Cowdenbeath Cowdenbeath 36 46 72 39
10 Forfar Athletic Forfar 36 48 60 34
TEMPORADA 2014/2015
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Heart of Midlothian Heart 36 96 26 91
2 Hibernian FC Hibernian 36 70 32 70
3 Rangers FC Rangers FC 36 69 39 67
4 Queen of the South Queen South 36 58 41 60
5 Falkirk Falkirk 36 48 48 53
6 Raith Rovers Raith Rovers 36 42 65 43
7 Dumbarton Dumbarton 36 36 79 34
8 Livingston Livingston 36 41 53 32
9 Alloa Athletic Alloa 36 34 56 27
10 Cowdenbeath Cowdenbeath 36 31 86 25
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
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Cowdenbeath Cowdenbeath 36 68 29 71
2 Arbroath Arbroath 36 76 51 63
3 Dumbarton Dumbarton 36 61 61 58
4 Airdrieonians Airdrieonian 36 68 60 52
5 Stenhousemuir Stenhousemui 36 54 49 51
6 East Fife East Fife 36 55 57 48
7 Forfar Athletic Forfar 36 59 72 42
8 Brechin City Brechin City 36 47 62 41
9 Albion Rovers Albion 36 43 66 37
10 Stirling Albion Stirling 36 46 70 34
TEMPORADA 2010/2011
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
TEMPORADA 2009/2010
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Stirling Albion Stirling 36 68 48 65
2 Alloa Athletic Alloa 36 49 35 65
3 Cowdenbeath Cowdenbeath 36 60 41 59
4 Brechin City Brechin City 36 50 45 54
5 Peterhead Peterhead 36 45 49 51
6 Dumbarton Dumbarton 36 49 58 48
7 East Fife East Fife 36 46 53 41
8 Stenhousemuir Stenhousemui 36 38 42 40
9 Arbroath Arbroath 36 41 55 40
10 Clyde Clyde 36 37 57 31
TEMPORADA 2008/2009
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Dumbarton Dumbarton 36 65 36 67
2 Cowdenbeath Cowdenbeath 36 48 34 63
3 East Stirlingshire East 36 57 50 61
4 Stenhousemuir Stenhousemui 36 55 46 56
5 Montrose Montrose 36 47 48 54
6 Forfar Athletic Forfar 36 53 51 51
7 Annan Athletic Annan 36 56 45 50
8 Albion Rovers Albion 36 39 47 39
9 Berwick Rangers Berwick 36 46 61 37
10 Elgin City Elgin City 36 31 79 26
TEMPORADA 2007/2008
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Ross County FC Ross County 36 78 44 73
2 Airdrieonians Airdrieonian 36 64 34 66
3 Raith Rovers Raith Rovers 36 60 50 60
4 Alloa Athletic Alloa 36 57 56 56
5 Peterhead Peterhead 36 65 54 55
6 Brechin City Brechin City 36 63 48 52
7 Ayr United Ayr United 36 51 62 46
8 Queen's Park Queen's Park 36 48 51 44
9 Cowdenbeath Cowdenbeath 36 47 73 37
10 Berwick Rangers Berwick 36 40 101 16
TEMPORADA 2006/2007
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Greenock Morton Greenock 36 76 32 77
2 Stirling Albion Stirling 36 67 39 69
3 Raith Rovers Raith Rovers 36 50 33 62
4 Brechin City Brechin City 36 61 45 60
5 Ayr United Ayr United 36 46 47 50
6 Cowdenbeath Cowdenbeath 36 59 56 45
7 Alloa Athletic Alloa 36 47 70 42
8 Peterhead Peterhead 36 60 62 41
9 Stranraer Stranraer 36 45 74 39
10 Forfar Athletic Forfar 36 37 90 19
TEMPORADA 2005/2006
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Cowdenbeath Cowdenbeath 36 81 34 76
2 Berwick Rangers Berwick 36 54 27 76
3 Stenhousemuir Stenhousemui 36 78 38 73
4 Arbroath Arbroath 36 57 47 55
5 Elgin City Elgin City 36 55 58 52
6 Queen's Park Queen's Park 36 47 42 51
7 East Fife East Fife 36 48 64 43
8 Albion Rovers Albion 36 39 60 29
9 Montrose Montrose 36 31 59 28
10 East Stirlingshire East 36 28 89 23

  USO DE MEMORIA  
7,239,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.7471
Total Execution Time  0.7488
  CADENA URL  
/historico/Cowdenbeath
  GET DATOS  
$_GET['/historico/Cowdenbeath']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3004 AND type_rel = 2
0.0150  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3004 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0146  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 (320642) ORDER BY n.cover_points DESC, update_date DESC
0.0305  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 = '3004' ORDER BY l.year DESC,cat.coefficient DESC
0.0159  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 = '3004' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 72464 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0163  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=3004 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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,72464,72126,71432,68154) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 72464 AND teamId = 3004
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 3004
0.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 72126 AND teamId = 3004
0.0168  SELECT count(id) as num_players from rel_players WHERE league_id = 68154 AND teamId = 3004
0.0181  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3004
0.0151  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 = '3004' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3004' and rp.type = 4
0.0154  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 = '3004' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0217  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 = 72464 WHERE rp.league_id = 72464 AND rp.teamId = 3004 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.0276  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 = 72464 WHERE rp.league_id = 72464 AND rp.teamId = 3004 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0175  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 = 72464 WHERE rp.league_id = 72464 AND rp.teamId = 3004 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 3004 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68337 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 63086 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.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 = 57748 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.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 = 62240 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 `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 = 43927 AND t.round = 36 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 = 38778 AND t.round = 36 ORDER BY team.conference 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 `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 = 33318 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 15716 AND t.round = 36 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 `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 = 4198 AND t.round = 36 ORDER BY team.conference 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 `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.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 = 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.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 `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 = 1626 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 1087 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 `tables2010` 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 = 2602 AND t.round = 36 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 `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 = 1627 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 `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 = 633 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 `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 = 634 AND t.round = 36 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 `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 = 645 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC