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
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Stirling Albion Stirling 36 67 37 73
2 Dumbarton Dumbarton 36 49 39 62
3 Annan Athletic Annan 36 61 51 51
4 East Fife East Fife 36 54 50 50
5 Forfar Athletic Forfar 36 37 43 48
6 Stenhousemuir Stenhousemui 36 51 55 47
7 Stranraer Stranraer 36 43 57 45
8 Bonnyrigg Rose Bonnyrigg 36 36 47 42
9 Elgin City Elgin City 36 44 62 40
10 Albion Rovers Albion 36 47 48 39
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 ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Ayr United Ayr United 36 92 42 76
2 Raith Rovers Raith Rovers 36 68 32 75
3 Alloa Athletic Alloa 36 56 43 60
4 Arbroath Arbroath 36 70 51 59
5 Stranraer Stranraer 36 58 66 53
6 East Fife East Fife 36 49 67 42
7 Airdrieonians Airdrieonian 36 46 60 41
8 Forfar Athletic Forfar 36 40 65 38
9 Queen's Park Queen's Park 36 42 72 31
10 Albion Rovers Albion 36 57 80 30
TEMPORADA 2016/2017
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Livingston Livingston 36 80 32 81
2 Alloa Athletic Alloa 36 69 44 62
3 Airdrieonians Airdrieonian 36 61 66 52
4 Brechin City Brechin City 36 43 49 50
5 East Fife East Fife 36 41 44 46
6 Queen's Park Queen's Park 36 37 51 46
7 Stranraer Stranraer 36 46 50 44
8 Albion Rovers Albion 36 41 48 42
9 Peterhead Peterhead 36 44 59 40
10 Stenhousemuir Stenhousemui 36 45 64 39
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
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Albion Rovers Albion 36 61 33 71
2 Queen's Park Queen's Park 36 51 34 61
3 Arbroath Arbroath 36 65 46 56
4 East Fife East Fife 36 56 48 53
5 Annan Athletic Annan 36 56 56 50
6 Clyde Clyde 36 40 50 47
7 Elgin City Elgin City 36 55 58 45
8 Berwick Rangers Berwick 36 60 57 43
9 East Stirlingshire East 36 40 66 43
10 Montrose Montrose 36 42 78 33
TEMPORADA 2013/2014
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Peterhead Peterhead 36 74 38 76
2 Annan Athletic Annan 36 69 49 63
3 Stirling Albion Stirling 36 60 50 58
4 Clyde Clyde 36 50 48 57
5 Berwick Rangers Berwick 35 58 49 49
6 Montrose Montrose 35 44 51 46
7 Albion Rovers Albion 36 41 54 44
8 East Stirlingshire East 36 45 59 44
9 Elgin City Elgin City 36 62 73 36
10 Queen's Park Queen's Park 36 36 68 24
TEMPORADA 2012/2013
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Queen of the South Queen South 36 92 23 92
2 Alloa Athletic Alloa 36 62 35 67
3 Brechin City Brechin City 36 72 59 61
4 Forfar Athletic Forfar 36 67 74 54
5 Arbroath Arbroath 36 47 57 52
6 Stenhousemuir Stenhousemui 36 59 59 49
7 Ayr United Ayr United 36 53 65 41
8 Stranraer Stranraer 36 43 71 37
9 East Fife East Fife 36 50 65 32
10 Albion Rovers Albion 36 45 82 24
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
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Arbroath Arbroath 36 80 61 66
2 Albion Rovers Albion 36 56 40 61
3 Queen's Park Queen's Park 36 57 43 59
4 Annan Athletic Annan 36 58 45 59
5 Stranraer Stranraer 36 72 57 57
6 Berwick Rangers Berwick 36 62 56 49
7 Elgin City Elgin City 36 53 63 45
8 Montrose Montrose 36 47 61 37
9 East Stirlingshire East 36 33 62 34
10 Clyde Clyde 36 37 67 32
TEMPORADA 2009/2010
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Livingston Livingston 36 63 25 78
2 Forfar Athletic Forfar 36 59 44 63
3 East Stirlingshire East 36 50 46 61
4 Queen's Park Queen's Park 36 42 42 51
5 Albion Rovers Albion 36 35 35 50
6 Berwick Rangers Berwick 36 46 50 50
7 Stranraer Stranraer 36 48 54 47
8 Annan Athletic Annan 36 41 42 43
9 Elgin City Elgin City 36 46 59 34
10 Montrose Montrose 36 30 63 24
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 TWO ESCOCIA
Equipo PJ GF GC Puntos
1 East Fife East Fife 36 77 24 88
2 Stranraer Stranraer 36 65 43 65
3 Montrose Montrose 36 59 36 59
4 Arbroath Arbroath 36 54 47 52
5 Stenhousemuir Stenhousemui 36 50 59 48
6 Elgin City Elgin City 36 56 68 47
7 Albion Rovers Albion 36 51 68 37
8 Dumbarton Dumbarton 36 31 48 37
9 East Stirlingshire East 36 48 71 34
10 Forfar Athletic Forfar 36 35 62 33
TEMPORADA 2006/2007
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Berwick Rangers Berwick 36 51 29 75
2 Arbroath Arbroath 36 61 33 70
3 Queen's Park Queen's Park 36 57 28 68
4 East Fife East Fife 36 59 37 67
5 Dumbarton Dumbarton 36 52 37 59
6 Albion Rovers Albion 36 56 61 48
7 Stenhousemuir Stenhousemui 36 53 63 44
8 Montrose Montrose 36 42 62 37
9 Elgin City Elgin City 36 39 69 29
10 East Stirlingshire East 36 27 78 21
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,595,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9363
Total Execution Time  0.9375
  CADENA URL  
/historico/Albion-Rovers
  GET DATOS  
$_GET['/historico/Albion-Rovers']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0152  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 = 'Albion-Rovers' 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.0140  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=3009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0156  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 = 72464
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3009 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3009 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130  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 (216462,986341,993054) ORDER BY n.cover_points DESC, update_date DESC
0.0142  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 = '3009' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '3009' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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.0139  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.0158  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=3009 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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,72464,72126,71644,71432,67943) 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.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 67943 AND teamId = 3009
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 72464 AND teamId = 3009
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 3009
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71644 AND teamId = 3009
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 72523 AND teamId = 3009
0.0179  SELECT count(id) as num_players from rel_players WHERE league_id = 72126 AND teamId = 3009
0.0179  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3009
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 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 = 72464 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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 = '3009' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3009' and rp.type = 4
0.0135  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 = '3009' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 = 3009 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.0144  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 = 3009 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 3009 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 3009 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72464 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.0133  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 = 67943 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 = 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.0134  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.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 `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.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 `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 = 50157 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.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 `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.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 `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 = 38777 AND t.round = 36 ORDER BY team.conference 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 `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 = 33317 AND t.round = 36 ORDER BY team.conference 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 `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.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 `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 = 4153 AND t.round = 36 ORDER BY team.conference 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 `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 = 2458 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 2026 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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.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 `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 = 1629 AND t.round = 36 ORDER BY team.conference 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 `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 = 1628 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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.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 `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 = 643 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 644 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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