4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2020
Temporada Siguiente »
Championship Escocia 2020
2019/2020

Championship, scottish championship, segunda escocia, segunda division escocia, segunda escocesa

Championship Escocia 2020

  • Dundee United
  • Inverness CT
  • Dundee
  • Ayr United
  • Dunfermline Athletic FC
  • Arbroath
  • Greenock Morton
  • Alloa Athletic
  • Queen of the South
  • Partick Thistle
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Ross County FC Ross County 36 63 34 71
2 Dundee United Dundee 36 49 40 65
3 Inverness CT Inverness 36 48 40 56
4 Ayr United Ayr United 36 50 38 54
5 Greenock Morton Greenock 36 36 45 46
6 Partick Thistle Partick 36 43 52 43
7 Dunfermline Athletic FC Dunfermline 36 33 40 41
8 Alloa Athletic Alloa 36 39 53 39
9 Queen of the South Queen South 36 41 48 38
10 Falkirk Falkirk 36 37 49 38
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
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
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
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
Ver
TEMPORADA 2012/2013
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
Ver
TEMPORADA 2011/2012
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
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Inverness CT Inverness 36 72 32 73
2 Dundee Dundee 36 48 34 61
3 Dunfermline Athletic FC Dunfermline 36 54 44 58
4 Queen of the South Queen South 36 53 40 56
5 Ross County FC Ross County 36 46 44 56
6 Partick Thistle Partick 36 43 40 48
7 Raith Rovers Raith Rovers 36 36 47 42
8 Greenock Morton Greenock 36 40 65 37
9 Airdrieonians Airdrieonian 36 41 56 33
10 Ayr United Ayr United 36 29 60 31
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 St. Johnstone Johnstone 35 51 35 62
2 Partick Thistle Partick 35 39 34 55
3 Dunfermline Athletic FC Dunfermline 35 51 43 50
4 Greenock Morton Greenock 35 40 38 47
5 Dundee Dundee 35 29 32 47
6 Queen of the South Queen South 35 55 48 46
7 Livingston Livingston 35 54 56 46
8 Ross County FC Ross County 35 40 46 44
9 Airdrieonians Airdrieonian 35 29 39 42
10 Clyde Clyde 35 40 57 38
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Hamilton Academical Hamilton 36 62 27 76
2 Dundee Dundee 36 58 30 69
3 St. Johnstone Johnstone 36 60 45 58
4 Queen of the South Queen South 36 47 43 52
5 Dunfermline Athletic FC Dunfermline 36 36 41 51
6 Partick Thistle Partick 36 40 39 45
7 Livingston Livingston 36 55 66 39
8 Greenock Morton Greenock 36 40 58 37
9 Clyde Clyde 36 40 59 37
10 Stirling Albion Stirling 36 41 71 24
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Gretna Gretna 36 70 40 66
2 St. Johnstone Johnstone 36 65 42 65
3 Dundee Dundee 36 48 42 53
4 Hamilton Academical Hamilton 36 46 47 53
5 Clyde Clyde 36 46 35 47
6 Livingston Livingston 36 41 46 45
7 Partick Thistle Partick 36 47 63 45
8 Queen of the South Queen South 36 34 54 41
9 Airdrieonians Airdrieonian 36 39 50 40
10 Ross County FC Ross County 36 40 57 37
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 St. Mirren St. Mirren 36 52 28 76
2 St. Johnstone Johnstone 36 59 34 66
3 Hamilton Academical Hamilton 36 53 39 59
4 Ross County FC Ross County 36 47 40 56
5 Clyde Clyde 36 54 42 55
6 Airdrieonians Airdrieonian 36 57 43 45
7 Dundee Dundee 36 43 50 43
8 Queen of the South Queen South 36 31 54 33
9 Stranraer Stranraer 36 33 53 29
10 Brechin City Brechin City 36 28 74 17
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Falkirk Falkirk 36 66 30 75
2 St. Mirren St. Mirren 36 41 23 60
3 Clyde Clyde 36 35 29 60
4 Queen of the South Queen South 36 36 38 51
5 Airdrieonians Airdrieonian 36 44 48 50
6 Ross County FC Ross County 36 40 37 47
7 Hamilton Academical Hamilton 36 35 36 47
8 St. Johnstone Johnstone 36 38 39 46
9 Partick Thistle Partick 36 38 52 39
10 Raith Rovers Raith Rovers 36 26 67 16
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Inverness CT Inverness 36 67 33 70
2 Clyde Clyde 36 64 40 69
3 St. Johnstone Johnstone 36 59 45 57
4 Falkirk Falkirk 36 43 37 55
5 Queen of the South Queen South 36 46 48 54
6 Ross County FC Ross County 36 49 41 49
7 St. Mirren St. Mirren 36 39 46 41
8 Raith Rovers Raith Rovers 36 37 57 34
9 Ayr United Ayr United 36 37 58 31
10 Brechin City Brechin City 36 37 73 27
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Falkirk Falkirk 36 80 32 81
2 Clyde Clyde 36 66 37 72
3 St. Johnstone Johnstone 36 49 29 67
4 Inverness CT Inverness 36 74 45 65
5 Queen of the South Queen South 36 45 48 48
6 Ayr United Ayr United 36 34 44 45
7 St. Mirren St. Mirren 36 42 71 37
8 Ross County FC Ross County 36 42 46 35
9 Alloa Athletic Alloa 36 39 72 35
10 Arbroath Arbroath 36 30 77 15
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Partick Thistle Partick 36 61 38 66
2 Airdrieonians Airdrieonian 36 59 40 56
3 Ayr United Ayr United 36 53 44 52
4 Ross County FC Ross County 36 51 43 52
5 Clyde Clyde 36 51 56 49
6 Inverness CT Inverness 36 60 51 48
7 Arbroath Arbroath 36 42 59 48
8 St. Mirren St. Mirren 36 43 53 45
9 Falkirk Falkirk 36 49 73 39
10 Raith Rovers Raith Rovers 36 50 62 35
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Livingston Livingston 36 72 31 76
2 Ayr United Ayr United 36 73 41 69
3 Falkirk Falkirk 36 57 59 56
4 Inverness CT Inverness 36 71 54 54
5 Clyde Clyde 36 44 46 47
6 Ross County FC Ross County 36 48 52 43
7 Raith Rovers Raith Rovers 36 41 55 38
8 Airdrieonians Airdrieonian 36 49 67 38
9 Greenock Morton Greenock 36 34 61 35
10 Alloa Athletic Alloa 36 38 61 32
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 St. Mirren St. Mirren 36 75 39 76
2 Dunfermline Athletic FC Dunfermline 36 66 35 71
3 Falkirk Falkirk 36 67 40 68
4 Livingston Livingston 36 60 45 64
5 Raith Rovers Raith Rovers 36 55 40 59
6 Inverness CT Inverness 36 60 55 49
7 Ayr United Ayr United 36 44 52 38
8 Greenock Morton Greenock 36 45 61 36
9 Airdrieonians Airdrieonian 36 29 69 29
10 Clydebank Clydebank 36 17 82 10
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 Hibernian FC Hibernian 36 84 33 89
2 Falkirk Falkirk 36 60 38 66
3 Ayr United Ayr United 36 66 42 62
4 Airdrieonians Airdrieonian 36 42 43 59
5 St. Mirren St. Mirren 36 42 43 52
6 Greenock Morton Greenock 36 45 41 49
7 Clydebank Clydebank 36 36 38 46
8 Raith Rovers Raith Rovers 36 37 57 35
9 Hamilton Academical Hamilton 36 30 62 28
10 Stranraer Stranraer 36 29 74 17

  USO DE MEMORIA  
6,485,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.5525
Total Execution Time  0.5551
  CADENA URL  
/first_division2020/grupo1/historico
  GET DATOS  
$_GET['/first_division2020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0127  SELECT type FROM routes WHERE alias = 'first_division2020'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'first_division' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  SELECT id,name,alias,stepParent FROM categories WHERE parentId=23 ORDER BY order_id ASC
0.0126  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50139 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 23 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0141  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.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 = 43925 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 `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.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 = 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.0141  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.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 `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.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 `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.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 `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.0127  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.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 = 78 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 `tables2005` 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 = 623 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 `tables2004` 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 = 624 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 `tables2003` 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 = 625 AND t.round = 36 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 `tables2002` 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 = 626 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 `tables2001` 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 = 627 AND t.round = 36 ORDER BY team.conference 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 `tables2000` 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 = 628 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables1999` 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 = 629 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 08:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:16:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'first_division' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0289  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50139 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50139 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0183  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50139 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50139 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0130  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50139 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50139 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(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