4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Dundee United Dundee 35 69 22 72
2 Raith Rovers Raith Rovers 35 53 42 66
3 Partick Thistle Partick 35 62 50 55
4 Airdrieonians Airdrieonian 35 44 42 52
5 Greenock Morton Greenock 35 42 43 45
6 Dunfermline Athletic FC Dunfermline 35 39 44 44
7 Ayr United Ayr United 35 50 58 43
8 Queen's Park Queen's Park 35 46 56 40
9 Inverness CT Inverness 35 37 38 39
10 Arbroath Arbroath 35 35 82 23
Ver
TEMPORADA 2022/2023
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
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Kilmarnock Kilmarnock 36 50 27 67
2 Arbroath Arbroath 36 54 28 65
3 Inverness CT Inverness 36 53 34 59
4 Partick Thistle Partick 36 46 40 52
5 Raith Rovers Raith Rovers 36 44 44 50
6 Hamilton Academical Hamilton 36 38 53 42
7 Greenock Morton Greenock 36 36 47 40
8 Ayr United Ayr United 36 39 52 39
9 Dunfermline Athletic FC Dunfermline 36 36 53 35
10 Queen of the South Queen South 36 36 54 33
Ver
TEMPORADA 2020/2021
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
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

  USO DE MEMORIA  
6,520,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1832
Total Execution Time  0.1853
  CADENA URL  
/first_division2024/grupo1/historico
  GET DATOS  
$_GET['/first_division2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0018  SELECT type FROM routes WHERE alias = 'first_division2024'
0.0044  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0028  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 23 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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.0022  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 = 63083 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.0022  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.0023  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.0023  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.0023  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.0042  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.0034  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.0038  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.0030  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.0025  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.0024  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.0020  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.0024  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 = 1041 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 284 AND t.round = 35 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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.0024  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 = 621 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053  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 = 622 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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.0026  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.0021  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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:43:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 14:43:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 14:43:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:43:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0206  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 events2024 e ON e.player_id = p.id AND e.league_id = 72122 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72122 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.0286  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 events2024 e ON e.player_id = p.id AND e.league_id = 72122 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72122 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0078  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 events2024 e ON e.player_id = p.id AND e.league_id = 72122 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72122 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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 = 72122 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