Liga Escocia 2022  G 1
2021/2022

Temporada Regular

Liga Escocia 2022 G 1

  • Celtic
  • Rangers FC
  • Heart of Midlothian
  • Dundee United
  • Ross County FC
  • Motherwell
  • Hibernian FC
  • Livingston
  • Aberdeen
  • St. Mirren
  • St. Johnstone
  • Dundee
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 78 19 82
2 Rangers FC Rangers FC 33 67 27 76
3 Heart of Midlothian Heart 33 48 33 57
4 Dundee United Dundee 33 31 37 41
5 Ross County FC Ross County 33 45 52 40
6 Motherwell Motherwell 33 38 50 40
7 Hibernian FC Hibernian 33 31 37 38
8 Livingston Livingston 33 35 43 38
9 Aberdeen Aberdeen 33 38 42 36
10 St. Mirren St. Mirren 33 30 50 36
11 St. Johnstone Johnstone 33 21 44 30
12 Dundee Dundee 33 29 57 25
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 78 10 89
2 Celtic Celtic 33 66 24 69
3 Hibernian FC Hibernian 33 44 31 56
4 Aberdeen Aberdeen 33 32 31 49
5 Livingston Livingston 33 40 41 44
6 St. Johnstone Johnstone 33 34 40 40
7 St. Mirren St. Mirren 33 29 40 39
8 Dundee United Dundee 33 29 43 39
9 Motherwell Motherwell 33 32 51 35
10 Hamilton Academical Hamilton 33 33 59 29
11 Ross County FC Ross County 33 26 59 29
12 Kilmarnock Kilmarnock 33 33 47 28
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 71 17 77
2 Rangers FC Rangers FC 33 73 24 66
3 Kilmarnock Kilmarnock 33 46 28 58
4 Aberdeen Aberdeen 33 52 37 58
5 Hibernian FC Hibernian 33 49 34 52
6 Heart of Midlothian Heart 33 38 41 50
7 St. Johnstone Johnstone 33 32 44 44
8 Motherwell Motherwell 33 37 47 43
9 Livingston Livingston 33 35 33 42
10 Hamilton Academical Hamilton 33 21 69 25
11 St. Mirren St. Mirren 33 24 61 21
12 Dundee Dundee 33 25 68 18
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 64 21 75
2 Rangers FC Rangers FC 33 67 38 62
3 Aberdeen Aberdeen 33 50 36 62
4 Hibernian FC Hibernian 33 49 35 59
5 Kilmarnock Kilmarnock 33 45 39 55
6 Heart of Midlothian Heart 33 35 30 46
7 Motherwell Motherwell 33 36 43 38
8 St. Johnstone Johnstone 33 32 47 38
9 Hamilton Academical Hamilton 33 43 60 30
10 Dundee Dundee 33 31 53 30
11 Ross County FC Ross County 33 38 57 26
12 Partick Thistle Partick 33 26 57 25
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 87 22 91
2 Aberdeen Aberdeen 33 63 28 67
3 Rangers FC Rangers FC 33 48 34 58
4 St. Johnstone Johnstone 33 44 40 49
5 Heart of Midlothian Heart 33 51 43 45
6 Partick Thistle Partick 33 35 38 41
7 Kilmarnock Kilmarnock 33 30 49 35
8 Ross County FC Ross County 33 37 54 33
9 Hamilton Academical Hamilton 33 30 48 32
10 Motherwell Motherwell 33 38 61 32
11 Dundee Dundee 33 33 53 30
12 Inverness CT Inverness 33 36 62 25
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 78 25 76
2 Aberdeen Aberdeen 33 56 36 68
3 Heart of Midlothian Heart 33 54 33 60
4 Motherwell Motherwell 33 41 49 44
5 St. Johnstone Johnstone 33 48 51 43
6 Ross County FC Ross County 33 48 55 43
7 Dundee Dundee 33 48 49 41
8 Partick Thistle Partick 33 32 39 41
9 Inverness CT Inverness 33 40 43 40
10 Hamilton Academical Hamilton 33 36 55 36
11 Kilmarnock Kilmarnock 33 33 54 32
12 Dundee United Dundee 33 33 58 24
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 70 17 79
2 Aberdeen Aberdeen 32 53 28 68
3 Inverness CT Inverness 33 46 34 58
4 Dundee United Dundee 32 53 48 49
5 St. Johnstone Johnstone 33 29 32 48
6 Dundee Dundee 33 45 45 44
7 Hamilton Academical Hamilton 33 42 48 43
8 Partick Thistle Partick 33 41 38 38
9 Kilmarnock Kilmarnock 33 35 46 38
10 Ross County FC Ross County 33 39 56 37
11 Motherwell Motherwell 33 33 57 31
12 St. Mirren St. Mirren 33 22 59 21
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 82 16 88
2 Aberdeen Aberdeen 33 47 30 63
3 Motherwell Motherwell 33 55 50 60
4 Dundee United Dundee 33 57 40 54
5 Inverness CT Inverness 33 40 35 52
6 St. Johnstone Johnstone 33 41 34 48
7 Hibernian FC Hibernian 33 29 44 34
8 Kilmarnock Kilmarnock 33 41 57 33
9 Ross County FC Ross County 33 38 57 31
10 St. Mirren St. Mirren 33 34 55 31
11 Partick Thistle Partick 33 37 57 30
12 Heart of Midlothian Heart 33 33 59 28
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 78 30 69
2 Motherwell Motherwell 33 56 43 54
3 Inverness CT Inverness 33 58 49 51
4 St. Johnstone Johnstone 33 39 38 46
5 Ross County FC Ross County 33 42 43 45
6 Dundee United Dundee 33 48 52 44
7 Kilmarnock Kilmarnock 33 47 43 42
8 Aberdeen Aberdeen 33 38 41 41
9 Hibernian FC Hibernian 33 40 47 40
10 Heart of Midlothian Heart 33 34 45 37
11 St. Mirren St. Mirren 33 40 51 36
12 Dundee Dundee 33 22 60 23
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 72 20 81
2 Rangers FC Rangers FC 33 65 25 73
3 Motherwell Motherwell 33 43 38 55
4 St. Johnstone Johnstone 33 42 36 50
5 Dundee United Dundee 33 55 43 49
6 Heart of Midlothian Heart 33 41 32 48
7 Kilmarnock Kilmarnock 33 36 54 37
8 Aberdeen Aberdeen 33 32 38 36
9 St. Mirren St. Mirren 33 32 46 35
10 Inverness CT Inverness 33 36 54 32
11 Hibernian FC Hibernian 33 34 62 27
12 Dunfermline Athletic FC Dunfermline 33 32 72 20
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 72 28 80
2 Celtic Celtic 33 72 21 79
3 Heart of Midlothian Heart 33 47 31 61
4 Dundee United Dundee 33 44 41 52
5 Kilmarnock Kilmarnock 33 47 41 47
6 Motherwell Motherwell 33 36 43 44
7 Inverness CT Inverness 33 44 42 41
8 Hibernian FC Hibernian 33 36 52 36
9 St. Johnstone Johnstone 33 18 39 34
10 Aberdeen Aberdeen 33 34 54 31
11 St. Mirren St. Mirren 33 31 54 28
12 Hamilton Academical Hamilton 33 20 55 19
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 73 22 77
2 Celtic Celtic 33 62 35 66
3 Dundee United Dundee 33 51 39 59
4 Hibernian FC Hibernian 33 47 43 50
5 Motherwell Motherwell 33 39 38 48
6 Heart of Midlothian Heart 33 32 39 44
7 St. Johnstone Johnstone 33 50 54 41
8 Hamilton Academical Hamilton 33 29 43 36
9 Aberdeen Aberdeen 33 31 46 34
10 Kilmarnock Kilmarnock 33 26 44 29
11 St. Mirren St. Mirren 33 32 45 28
12 Falkirk Falkirk 33 30 54 28
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 75 30 74
2 Rangers FC Rangers FC 33 68 26 73
3 Heart of Midlothian Heart 33 37 34 54
4 Dundee United Dundee 33 43 40 49
5 Aberdeen Aberdeen 33 36 33 48
6 Hibernian FC Hibernian 33 38 41 42
7 Motherwell Motherwell 33 36 44 41
8 Kilmarnock Kilmarnock 33 31 43 34
9 St. Mirren St. Mirren 33 28 44 34
10 Hamilton Academical Hamilton 33 26 47 34
11 Inverness CT Inverness 33 32 52 32
12 Falkirk Falkirk 33 32 48 28
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 78 27 79
2 Celtic Celtic 33 75 23 74
3 Motherwell Motherwell 33 43 40 53
4 Dundee United Dundee 33 48 38 50
5 Hibernian FC Hibernian 33 47 38 50
6 Aberdeen Aberdeen 33 43 53 44
7 Falkirk Falkirk 33 40 44 42
8 Heart of Midlothian Heart 33 42 48 42
9 Inverness CT Inverness 33 41 58 36
10 Kilmarnock Kilmarnock 33 34 46 33
11 St. Mirren St. Mirren 33 22 51 33
12 Gretna Gretna 33 29 76 17
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 59 25 78
2 Rangers FC Rangers FC 33 54 25 65
3 Aberdeen Aberdeen 33 46 33 57
4 Heart of Midlothian Heart 33 40 30 54
5 Kilmarnock Kilmarnock 33 43 49 46
6 Hibernian FC Hibernian 33 49 37 44
7 Falkirk Falkirk 33 40 42 40
8 Dundee United Dundee 33 39 53 40
9 Inverness CT Inverness 33 36 45 36
10 Motherwell Motherwell 33 35 49 36
11 St. Mirren St. Mirren 33 24 47 27
12 Dunfermline Athletic FC Dunfermline 33 19 49 23
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 88 31 85
2 Heart of Midlothian Heart 33 64 27 65
3 Rangers FC Rangers FC 33 59 34 62
4 Hibernian FC Hibernian 33 56 45 52
5 Kilmarnock Kilmarnock 33 59 56 51
6 Aberdeen Aberdeen 33 39 36 48
7 Motherwell Motherwell 33 50 55 44
8 Inverness CT Inverness 33 45 38 43
9 Dundee United Dundee 33 39 58 32
10 Falkirk Falkirk 33 31 61 25
11 Dunfermline Athletic FC Dunfermline 33 26 63 23
12 Livingston Livingston 33 20 72 15
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 77 28 83
2 Rangers FC Rangers FC 33 67 17 81
3 Hibernian FC Hibernian 33 56 49 56
4 Aberdeen Aberdeen 33 38 33 52
5 Heart of Midlothian Heart 33 39 33 48
6 Motherwell Motherwell 33 41 41 43
7 Inverness CT Inverness 33 39 42 42
8 Kilmarnock Kilmarnock 33 39 53 36
9 Dundee Dundee 33 34 61 31
10 Dundee United Dundee 33 36 55 28
11 Dunfermline Athletic FC Dunfermline 33 28 54 27
12 Livingston Livingston 33 29 57 27
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 99 20 90
2 Rangers FC Rangers FC 33 66 26 74
3 Heart of Midlothian Heart 33 47 36 55
4 Dunfermline Athletic FC Dunfermline 33 35 43 47
5 Motherwell Motherwell 33 39 37 45
6 Dundee United Dundee 33 39 51 42
7 Hibernian FC Hibernian 33 37 52 38
8 Livingston Livingston 33 38 48 36
9 Dundee Dundee 33 41 55 34
10 Aberdeen Aberdeen 33 38 52 34
11 Kilmarnock Kilmarnock 33 39 68 32
12 Partick Thistle Partick 33 31 61 18
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 86 23 87
2 Celtic Celtic 33 81 22 82
3 Heart of Midlothian Heart 33 55 47 57
4 Kilmarnock Kilmarnock 33 43 46 50
5 Dunfermline Athletic FC Dunfermline 33 48 56 44
6 Dundee Dundee 33 44 48 42
7 Hibernian FC Hibernian 33 46 58 39
8 Aberdeen Aberdeen 33 32 48 37
9 Livingston Livingston 33 41 50 32
10 Partick Thistle Partick 33 29 50 29
11 Dundee United Dundee 33 29 61 25
12 Motherwell Motherwell 33 35 60 24
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 78 15 90
2 Rangers FC Rangers FC 33 75 23 77
3 Aberdeen Aberdeen 33 46 43 51
4 Livingston Livingston 33 40 35 49
5 Dunfermline Athletic FC Dunfermline 33 39 52 43
6 Heart of Midlothian Heart 33 44 46 42
7 Kilmarnock Kilmarnock 33 37 46 42
8 Dundee Dundee 33 35 50 37
9 Dundee United Dundee 33 32 56 35
10 Hibernian FC Hibernian 33 43 51 34
11 Motherwell Motherwell 33 42 61 33
12 St. Johnstone Johnstone 33 23 56 19
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 81 24 88
2 Rangers FC Rangers FC 33 60 31 70
3 Hibernian FC Hibernian 33 52 25 61
4 Kilmarnock Kilmarnock 33 39 44 49
5 Heart of Midlothian Heart 33 52 44 47
6 Dundee Dundee 33 47 41 41
7 Dunfermline Athletic FC Dunfermline 33 32 48 41
8 Motherwell Motherwell 33 37 48 39
9 Aberdeen Aberdeen 33 37 48 36
10 St. Johnstone Johnstone 33 35 48 35
11 Dundee United Dundee 33 30 58 23
12 St. Mirren St. Mirren 33 21 64 19
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,103,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5120
Total Execution Time  0.5140
  CADENA URL  
/escocia2022/grupo1/historico
  GET DATOS  
$_GET['/escocia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0105  SELECT type FROM routes WHERE alias = 'escocia2022'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'escocia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=14 ORDER BY order_id ASC
0.0109  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 = 62929 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 14 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0119  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.0117  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.0112  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 = 38641 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 33312 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 15400 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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.0108  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.0109  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.0110  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 = 1430 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 1086 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 935 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 281 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 74 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 380 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 381 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 382 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121  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 = 383 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 385 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 386 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 05:56:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 05:56:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 05:56:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 05:56:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'escocia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0243  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 events2022 e ON e.player_id = p.id AND e.league_id = 62929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62929 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.0243  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 events2022 e ON e.player_id = p.id AND e.league_id = 62929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62929 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0114  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 events2022 e ON e.player_id = p.id AND e.league_id = 62929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62929 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  SELECT *,(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