4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rangers FC

Rangers FC

Entrenador: Philippe Clement

Temporada 1992/1993
TEMPORADA 1992/1993
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 44 97 35 106
2 Aberdeen Aberdeen 44 87 36 91
3 Celtic Celtic 44 68 41 84
4 Dundee United Dundee 44 56 49 66
5 Heart of Midlothian Heart 44 46 51 59
6 St. Johnstone Johnstone 44 52 66 50
7 Hibernian FC Hibernian 44 54 64 49
8 Partick Thistle Partick 44 50 71 48
9 Motherwell Motherwell 44 46 62 46
10 Dundee Dundee 44 48 68 45
11 Falkirk Falkirk 44 60 86 40
12 Airdrieonians Airdrieonian 44 35 70 35
TEMPORADA 1991/1992
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 44 101 31 105
2 Heart of Midlothian Heart 44 60 37 90
3 Celtic Celtic 44 88 42 88
4 Dundee United Dundee 44 66 50 70
5 Aberdeen Aberdeen 44 55 42 65
6 Hibernian FC Hibernian 44 53 45 65
7 Airdrieonians Airdrieonian 44 50 70 49
8 St. Johnstone Johnstone 44 52 73 49
9 Falkirk Falkirk 44 54 73 47
10 Motherwell Motherwell 44 43 61 44
11 St. Mirren St. Mirren 44 33 73 30
12 Dunfermline Athletic FC Dunfermline 44 22 80 22
TEMPORADA 1990/1991
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 62 23 79
2 Aberdeen Aberdeen 36 62 27 75
3 Celtic Celtic 36 52 38 58
4 Dundee United Dundee 36 41 29 58
5 Heart of Midlothian Heart 36 48 55 49
6 Motherwell Motherwell 36 51 50 45
7 St. Johnstone Johnstone 36 41 54 42
8 Dunfermline Athletic FC Dunfermline 36 38 61 35
9 Hibernian FC Hibernian 36 24 51 31
10 St. Mirren St. Mirren 36 28 59 24
TEMPORADA 1989/1990
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 48 19 71
2 Aberdeen Aberdeen 36 56 33 61
3 Heart of Midlothian Heart 36 54 35 60
4 Dundee United Dundee 36 36 39 46
5 Hibernian FC Hibernian 36 34 41 46
6 Motherwell Motherwell 36 43 47 45
7 Celtic Celtic 36 37 37 44
8 Dunfermline Athletic FC Dunfermline 36 37 50 41
9 St. Mirren St. Mirren 36 28 48 40
10 Dundee Dundee 36 41 65 29
TEMPORADA 1988/1989
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 62 26 82
2 Aberdeen Aberdeen 36 51 25 68
3 Celtic Celtic 36 66 44 67
4 Dundee United Dundee 36 44 26 60
5 Hibernian FC Hibernian 36 37 36 48
6 Heart of Midlothian Heart 36 35 42 40
7 St. Mirren St. Mirren 36 39 55 40
8 Dundee Dundee 36 34 48 37
9 Motherwell Motherwell 36 35 44 34
10 Hamilton Academical Hamilton 36 19 76 20
TEMPORADA 1987/1988
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 44 79 23 103
2 Rangers FC Rangers FC 44 85 34 86
3 Heart of Midlothian Heart 44 74 32 85
4 Aberdeen Aberdeen 44 56 25 80
5 Dundee United Dundee 44 54 47 63
6 Dundee Dundee 44 70 64 58
7 Hibernian FC Hibernian 44 41 42 55
8 Motherwell Motherwell 44 37 56 49
9 St. Mirren St. Mirren 44 41 64 45
10 Falkirk Falkirk 44 41 75 41
11 Dunfermline Athletic FC Dunfermline 44 41 84 34
12 Greenock Morton Greenock 44 27 100 19
TEMPORADA 1986/1987
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 44 85 23 100
2 Celtic Celtic 44 90 41 90
3 Dundee United Dundee 44 66 36 84
4 Aberdeen Aberdeen 44 63 29 79
5 Heart of Midlothian Heart 44 64 43 77
6 Dundee Dundee 44 74 57 66
7 St. Mirren St. Mirren 44 36 51 48
8 Motherwell Motherwell 44 43 64 45
9 Hibernian FC Hibernian 44 44 70 43
10 Falkirk Falkirk 44 31 70 34
11 Clydebank Clydebank 44 35 93 30
12 Hamilton Academical Hamilton 44 39 93 27
TEMPORADA 1985/1986
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 36 67 38 70
2 Heart of Midlothian Heart 36 59 33 70
3 Dundee United Dundee 36 59 31 65
4 Aberdeen Aberdeen 36 62 31 60
5 Dundee Dundee 36 45 51 49
6 Rangers FC Rangers FC 36 53 45 48
7 St. Mirren St. Mirren 36 42 63 44
8 Hibernian FC Hibernian 36 49 63 39
9 Motherwell Motherwell 36 33 66 27
10 Clydebank Clydebank 36 29 77 26
TEMPORADA 1984/1985
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Aberdeen Aberdeen 36 89 26 86
2 Celtic Celtic 36 77 30 74
3 Dundee United Dundee 36 67 33 67
4 St. Mirren St. Mirren 36 51 56 55
5 Dundee Dundee 36 48 50 52
6 Rangers FC Rangers FC 36 47 38 51
7 Heart of Midlothian Heart 36 47 64 44
8 Hibernian FC Hibernian 36 38 61 37
9 Dumbarton Dumbarton 36 29 64 25
10 Greenock Morton Greenock 36 29 100 17
TEMPORADA 1983/1984
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Aberdeen Aberdeen 36 78 21 82
2 Celtic Celtic 36 80 41 71
3 Dundee United Dundee 36 67 39 65
4 Rangers FC Rangers FC 36 53 41 57
5 Heart of Midlothian Heart 36 38 47 46
6 Hibernian FC Hibernian 36 45 55 43
7 St. Mirren St. Mirren 36 55 59 41
8 Dundee Dundee 36 50 74 38
9 St. Johnstone Johnstone 36 36 81 33
10 Motherwell Motherwell 36 31 75 19
TEMPORADA 1982/1983
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Dundee United Dundee 36 90 35 80
2 Celtic Celtic 36 90 36 80
3 Aberdeen Aberdeen 36 76 24 80
4 Rangers FC Rangers FC 36 52 41 51
5 St. Mirren St. Mirren 36 47 51 45
6 Dundee Dundee 36 42 53 38
7 Motherwell Motherwell 36 39 73 38
8 Hibernian FC Hibernian 36 35 51 36
9 Greenock Morton Greenock 36 30 74 26
10 Kilmarnock Kilmarnock 36 28 91 20
TEMPORADA 1981/1982
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 36 79 33 79
2 Aberdeen Aberdeen 36 71 29 76
3 Rangers FC Rangers FC 36 57 45 59
4 Dundee United Dundee 36 61 38 55
5 St. Mirren St. Mirren 36 49 52 51
6 Hibernian FC Hibernian 36 38 40 47
7 Greenock Morton Greenock 36 31 54 39
8 Dundee Dundee 36 46 72 37
9 Partick Thistle Partick 36 35 59 28
10 Airdrieonians Airdrieonian 36 31 76 23
TEMPORADA 1980/1981
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 36 84 37 82
2 Aberdeen Aberdeen 36 61 26 68
3 St. Mirren St. Mirren 36 56 47 62
4 Rangers FC Rangers FC 36 60 32 60
5 Dundee United Dundee 36 66 42 60
6 Partick Thistle Partick 36 32 48 40
7 Airdrieonians Airdrieonian 36 36 55 39
8 Greenock Morton Greenock 36 36 58 38
9 Kilmarnock Kilmarnock 36 23 65 24
10 Heart of Midlothian Heart 36 27 71 24
TEMPORADA 1979/1980
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 35 60 36 65
2 Aberdeen Aberdeen 35 66 35 64
3 St. Mirren St. Mirren 36 56 49 57
4 Rangers FC Rangers FC 36 50 46 52
5 Greenock Morton Greenock 36 51 46 50
6 Dundee United Dundee 36 43 30 49
7 Partick Thistle Partick 36 43 47 47
8 Kilmarnock Kilmarnock 36 36 52 44
9 Dundee Dundee 36 47 73 36
10 Hibernian FC Hibernian 36 29 67 24
TEMPORADA 1978/1979
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 36 61 37 69
2 Rangers FC Rangers FC 36 52 35 63
3 Dundee United Dundee 36 56 37 62
4 Aberdeen Aberdeen 36 59 36 53
5 St. Mirren St. Mirren 36 45 41 51
6 Hibernian FC Hibernian 36 46 47 50
7 Partick Thistle Partick 36 42 39 47
8 Greenock Morton Greenock 36 51 55 46
9 Heart of Midlothian Heart 36 39 71 31
10 Motherwell Motherwell 36 33 86 22
TEMPORADA 1977/1978
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 76 39 79
2 Aberdeen Aberdeen 36 68 29 75
3 Dundee United Dundee 36 42 32 56
4 Hibernian FC Hibernian 36 51 43 52
5 Celtic Celtic 36 63 54 51
6 Partick Thistle Partick 36 52 64 47
7 Motherwell Motherwell 36 45 52 46
8 St. Mirren St. Mirren 36 52 63 41
9 Ayr United Ayr United 36 36 68 33
10 Clydebank Clydebank 36 23 64 25
TEMPORADA 1976/1977
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 36 79 39 78
2 Rangers FC Rangers FC 36 62 37 64
3 Aberdeen Aberdeen 36 56 42 59
4 Dundee United Dundee 36 54 45 57
5 Partick Thistle Partick 36 40 44 46
6 Hibernian FC Hibernian 36 34 35 42
7 Motherwell Motherwell 36 57 60 42
8 Ayr United Ayr United 36 44 68 41
9 Heart of Midlothian Heart 36 49 66 34
10 Kilmarnock Kilmarnock 36 32 71 21
TEMPORADA 1975/1976
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 60 24 77
2 Celtic Celtic 36 71 42 69
3 Hibernian FC Hibernian 36 55 43 61
4 Motherwell Motherwell 36 57 49 56
5 Heart of Midlothian Heart 36 39 45 48
6 Ayr United Ayr United 36 46 59 47
7 Dundee United Dundee 36 46 48 44
8 Aberdeen Aberdeen 36 49 50 43
9 Dundee Dundee 36 49 62 43
10 St. Johnstone Johnstone 36 29 79 14
TEMPORADA 1974/1975
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 34 86 33 81
2 Hibernian FC Hibernian 34 69 37 69
3 Celtic Celtic 34 81 41 65
4 Dundee United Dundee 34 72 43 64
5 Aberdeen Aberdeen 34 66 43 57
6 Dundee Dundee 34 48 42 54
7 Ayr United Ayr United 34 50 61 50
8 Motherwell Motherwell 34 52 57 47
9 Heart of Midlothian Heart 34 47 52 46
10 St. Johnstone Johnstone 34 41 44 45
11 Airdrieonians Airdrieonian 34 43 55 42
12 Partick Thistle Partick 34 48 62 40
13 Kilmarnock Kilmarnock 34 52 68 39
14 Dumbarton Dumbarton 34 44 55 31
15 Dunfermline Athletic FC Dunfermline 34 46 66 30
16 Clyde Clyde 34 40 63 28
17 Greenock Morton Greenock 34 31 62 28
18 Arbroath Arbroath 34 34 66 22
TEMPORADA 1973/1974
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 34 82 27 76
2 Hibernian FC Hibernian 34 75 42 69
3 Rangers FC Rangers FC 34 67 34 69
4 Aberdeen Aberdeen 34 46 26 55
5 Dundee Dundee 34 67 48 55
6 Ayr United Ayr United 34 44 40 53
7 Heart of Midlothian Heart 34 54 43 52
8 Dundee United Dundee 34 55 51 52
9 Motherwell Motherwell 34 45 40 49
10 Dumbarton Dumbarton 34 43 58 40
11 Partick Thistle Partick 34 33 46 37
12 Arbroath Arbroath 34 52 69 37
13 St. Johnstone Johnstone 34 41 60 37
14 Greenock Morton Greenock 34 37 49 34
15 East Fife East Fife 34 26 51 33
16 Clyde Clyde 34 29 65 33
17 Dunfermline Athletic FC Dunfermline 34 43 65 32
18 Falkirk Falkirk 34 33 58 26

  USO DE MEMORIA  
8,024,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2173
Total Execution Time  0.2185
  CADENA URL  
/historico/Glasgow-Rangers-Fc/1993
  GET DATOS  
$_GET['/historico/Glasgow-Rangers-Fc/1993']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (60)  
0.0054  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 = 'Glasgow-Rangers-Fc' AND l.year = 1993 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.0021  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 9698
0.0027  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 = 10967
0.0025  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 = 10357
0.0026  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 = 42342
0.0025  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 = 22538
0.0024  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 = 25562
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1241 AND type_rel = 2
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1241 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (8224,17636,20515,31768,34985) ORDER BY n.cover_points DESC, update_date DESC
0.0045  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 = '1241' AND l.year = 1993 ORDER BY l.year DESC,cat.coefficient DESC
0.0047  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 = '1241' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 42342 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 9698 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 25562 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 22538 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 10357 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0056  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=1241 AND l.year in (1992,1993,1994) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (42342,25570,22539,10967,10367) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 10367 AND teamId = 1241
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 10967 AND teamId = 1241
0.0049  SELECT count(id) as num_players from rel_players WHERE league_id = 42342 AND teamId = 1241
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 22539 AND teamId = 1241
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 25570 AND teamId = 1241
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 FROM `tables1993` 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 = 9698 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 events1993 e ON e.player_id = p.id AND e.league_id = 9698 WHERE rp.league_id = 9698 AND rp.teamId = 1241 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.0022  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 events1993 e ON e.player_id = p.id AND e.league_id = 9698 WHERE rp.league_id = 9698 AND rp.teamId = 1241 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events1993 e ON e.player_id = p.id AND e.league_id = 9698 WHERE rp.league_id = 9698 AND rp.teamId = 1241 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 1241 AND l.year <= 1993 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1993` 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 = 10357 AND t.round = 44 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 `tables1992` 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 = 10367 AND t.round = 44 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 `tables1991` 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 = 10366 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 `tables1990` 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 = 10365 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 `tables1989` 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 = 10364 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 `tables1988` 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 = 10363 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1987` 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 = 10362 AND t.round = 44 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 `tables1986` 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 = 10361 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 `tables1985` 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 = 10360 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052  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 `tables1984` 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 = 10359 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables1983` 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 = 22297 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1982` 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 = 22298 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables1980` 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 = 22300 AND t.round = 10 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 `tables1979` 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 = 22301 AND t.round = 10 ORDER BY team.conference 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 `tables1978` 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 = 22302 AND t.round = 10 ORDER BY team.conference 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 `tables1977` 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 = 22303 AND t.round = 9 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 `tables1976` 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 = 22304 AND t.round = 10 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 `tables1975` 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 = 22305 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC