4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1990/1991
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 38 89 18 69
2 Porto Porto 38 77 22 67
3 Sporting CP Sporting CP 38 58 23 56
4 Boavista Boavista 38 53 46 41
5 SC Salgueiros Salgueiros 38 32 48 36
6 Beira Mar SC Beira 38 40 49 36
7 Sporting Braga Sporting 38 42 45 34
8 Chaves Chaves 38 49 52 34
9 Vitória Guimarães Vitória 38 31 40 34
10 Marítimo Marítimo 38 37 48 34
11 Farense Farense 38 46 47 34
12 União Madeira União 38 30 51 33
13 Gil Vicente Gil Vicente 38 34 46 33
14 Famalicão Famalicão 38 33 41 33
15 Penafiel Penafiel 38 34 51 33
16 Tirsense Tirsense 38 39 50 33
17 Vitória Setúbal Vitória 38 53 53 32
18 Estrela Amadora Estrela 38 37 46 32
19 Os Belenenses Belenenses 38 27 38 29
20 Nacional Nacional 38 33 60 27
TEMPORADA 1989/1990
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 72 16 59
2 Benfica Benfica 34 76 18 55
3 Sporting CP Sporting CP 34 42 24 46
4 Vitória Guimarães Vitória 34 46 28 45
5 Chaves Chaves 34 38 38 38
6 Os Belenenses Belenenses 34 32 33 36
7 Vitória Setúbal Vitória 34 39 34 36
8 Boavista Boavista 34 49 36 34
9 Tirsense Tirsense 34 21 32 30
10 Marítimo Marítimo 34 25 38 29
11 Beira Mar SC Beira 34 22 39 29
12 Sporting Braga Sporting 34 32 41 28
13 Estrela Amadora Estrela 34 35 34 28
14 Nacional Nacional 34 34 46 28
15 Penafiel Penafiel 34 24 50 26
16 União Madeira União 34 24 45 24
17 Portimonense Portimonense 34 30 57 21
18 Feirense Feirense 34 25 57 20
TEMPORADA 1988/1989
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 38 60 15 63
2 Porto Porto 38 52 17 56
3 Boavista Boavista 38 56 29 49
4 Sporting CP Sporting CP 38 50 33 45
5 Vitória Setúbal Vitória 38 44 37 42
6 Os Belenenses Belenenses 38 44 35 40
7 Sporting Braga Sporting 38 42 37 40
8 Estrela Amadora Estrela 38 33 41 39
9 Vitória Guimarães Vitória 38 39 33 38
10 Nacional Nacional 38 43 49 36
11 Portimonense Portimonense 38 33 37 35
12 Marítimo Marítimo 38 40 41 35
13 Chaves Chaves 38 37 41 34
14 Penafiel Penafiel 38 32 39 33
15 Beira Mar SC Beira 38 29 36 33
16 Fafe Fafe 38 29 47 32
17 Espinho Espinho 38 45 57 32
18 Farense Farense 38 34 51 31
19 Leixões Leixões 38 29 46 28
20 Academico Viseu Academico 38 20 70 19
TEMPORADA 1987/1988
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 38 88 15 66
2 Benfica Benfica 38 59 25 51
3 Os Belenenses Belenenses 38 52 38 48
4 Sporting CP Sporting CP 38 62 41 47
5 Boavista Boavista 38 42 25 46
6 Espinho Espinho 38 42 38 40
7 Chaves Chaves 38 51 31 40
8 Vitória Setúbal Vitória 38 56 43 40
9 Marítimo Marítimo 38 36 37 39
10 Penafiel Penafiel 38 36 45 38
11 Sporting Braga Sporting 38 32 42 34
12 Farense Farense 38 36 50 34
13 Portimonense Portimonense 38 35 50 34
14 Vitória Guimarães Vitória 38 48 50 33
15 O Elvas O Elvas 38 35 40 33
16 Académica Académica 38 32 42 33
17 Varzim Varzim 38 31 52 30
18 Rio Ave Rio Ave 38 29 67 28
19 SC Salgueiros Salgueiros 38 31 62 25
20 SC Covilha SC Covilha 38 30 70 21
TEMPORADA 1986/1987
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 51 23 49
2 Porto Porto 30 67 22 46
3 Vitória Guimarães Vitória 30 45 22 41
4 Sporting CP Sporting CP 30 52 28 38
5 Chaves Chaves 30 39 38 33
6 Os Belenenses Belenenses 30 52 40 30
7 Varzim Varzim 30 24 29 29
8 Boavista Boavista 30 34 36 27
9 Sporting Braga Sporting 30 32 34 26
10 Académica Académica 30 22 34 26
11 Portimonense Portimonense 30 27 47 26
12 Marítimo Marítimo 30 34 49 25
13 Rio Ave Rio Ave 30 33 40 25
14 SC Salgueiros Salgueiros 30 22 40 24
15 Farense Farense 30 33 47 21
16 O Elvas O Elvas 30 16 54 14
TEMPORADA 1985/1986
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 64 20 49
2 Benfica Benfica 30 54 13 47
3 Sporting CP Sporting CP 30 64 20 46
4 Vitória Guimarães Vitória 30 51 29 40
5 Boavista Boavista 30 44 29 36
6 Chaves Chaves 30 28 38 29
7 Portimonense Portimonense 30 29 32 28
8 Os Belenenses Belenenses 30 27 30 28
9 Sporting Braga Sporting 30 34 47 26
10 Académica Académica 30 28 38 25
11 SC Salgueiros Salgueiros 30 21 37 25
12 Marítimo Marítimo 30 26 50 22
13 Desportivo Aves Desportivo 30 25 42 22
14 Vitória Setúbal Vitória 30 32 42 22
15 Penafiel Penafiel 30 16 38 18
16 SC Covilha SC Covilha 30 23 61 17
TEMPORADA 1984/1985
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 78 13 55
2 Sporting CP Sporting CP 30 72 26 47
3 Benfica Benfica 30 65 28 43
4 Boavista Boavista 30 37 26 37
5 Portimonense Portimonense 30 51 41 36
6 Os Belenenses Belenenses 30 40 46 30
7 Académica Académica 30 45 47 29
8 Sporting Braga Sporting 30 46 43 28
9 Vitória Guimarães Vitória 30 33 39 25
10 Penafiel Penafiel 30 25 42 25
11 Vitória Setúbal Vitória 30 35 50 25
12 SC Salgueiros Salgueiros 30 40 56 23
13 Rio Ave Rio Ave 30 27 43 23
14 Farense Farense 30 21 49 22
15 Varzim Varzim 30 23 49 17
16 Vizela Vizela 30 31 71 15
TEMPORADA 1983/1984
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 86 22 52
2 Porto Porto 30 65 9 49
3 Sporting CP Sporting CP 30 58 24 42
4 Sporting Braga Sporting 30 40 32 37
5 Vitória Setúbal Vitória 30 43 28 34
6 Vitória Guimarães Vitória 30 41 41 31
7 Boavista Boavista 30 36 31 31
8 Varzim Varzim 30 32 39 29
9 Rio Ave Rio Ave 30 35 35 29
10 Portimonense Portimonense 30 27 37 26
11 SC Salgueiros Salgueiros 30 23 41 21
12 Farense Farense 30 29 54 21
13 Penafiel Penafiel 30 18 55 21
14 Estoril Estoril 30 22 51 21
15 RD Agueda RD Agueda 30 25 55 19
16 Espinho Espinho 30 19 45 17
TEMPORADA 1982/1983
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 67 13 51
2 Porto Porto 30 73 18 47
3 Sporting CP Sporting CP 30 48 25 42
4 Vitória Guimarães Vitória 30 35 24 32
5 Boavista Boavista 30 32 38 30
6 Sporting Braga Sporting 30 41 43 29
7 Vitória Setúbal Vitória 30 29 33 29
8 Rio Ave Rio Ave 30 43 45 29
9 Portimonense Portimonense 30 35 31 29
10 SC Salgueiros Salgueiros 30 26 36 27
11 Estoril Estoril 30 26 39 26
12 Varzim Varzim 30 23 39 26
13 Espinho Espinho 30 23 37 25
14 Marítimo Marítimo 30 26 38 25
15 Amora FC Amora FC 30 23 55 18
16 Ginásio de Alcobaça Ginásio 30 20 56 15
TEMPORADA 1981/1982
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 30 66 26 46
2 Benfica Benfica 30 60 22 44
3 Porto Porto 30 46 17 43
4 Vitória Guimarães Vitória 30 42 22 38
5 Rio Ave Rio Ave 30 26 31 34
6 Portimonense Portimonense 30 35 24 32
7 Sporting Braga Sporting 30 34 42 30
8 Vitória Setúbal Vitória 30 30 35 28
9 Boavista Boavista 30 36 37 26
10 Espinho Espinho 30 32 42 25
11 Amora FC Amora FC 30 29 37 24
12 Estoril Estoril 30 30 41 24
13 Penafiel Penafiel 30 20 37 23
14 Academico Viseu Academico 30 24 52 23
15 Os Belenenses Belenenses 30 28 48 20
16 União de Leiria União 30 25 50 20
TEMPORADA 1980/1981
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 72 14 50
2 Porto Porto 30 53 18 48
3 Sporting CP Sporting CP 30 48 28 37
4 Boavista Boavista 30 36 25 36
5 Vitória Guimarães Vitória 30 38 30 31
6 Sporting Braga Sporting 30 34 39 30
7 Vitória Setúbal Vitória 30 30 30 29
8 Portimonense Portimonense 30 34 37 28
9 Espinho Espinho 30 25 35 27
10 Penafiel Penafiel 30 27 38 27
11 Os Belenenses Belenenses 30 24 39 26
12 Amora FC Amora FC 30 38 51 25
13 Academico Viseu Academico 30 24 40 25
14 Varzim Varzim 30 27 31 24
15 Marítimo Marítimo 30 33 46 23
16 Académica Académica 30 16 58 14
TEMPORADA 1979/1980
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 30 67 17 52
2 Porto Porto 30 59 9 50
3 Benfica Benfica 30 79 21 45
4 Boavista Boavista 30 44 30 37
5 Os Belenenses Belenenses 30 33 38 34
6 Vitória Guimarães Vitória 30 42 38 32
7 Espinho Espinho 30 29 42 28
8 Portimonense Portimonense 30 32 49 26
9 Sporting Braga Sporting 30 34 40 26
10 Varzim Varzim 30 37 45 26
11 Marítimo Marítimo 30 25 37 26
12 Vitória Setúbal Vitória 30 29 41 23
13 União de Leiria União 30 26 49 21
14 Estoril Estoril 30 18 37 21
15 Beira Mar SC Beira 30 24 46 20
16 Rio Ave Rio Ave 30 22 61 13
TEMPORADA 1978/1979
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 70 19 50
2 Benfica Benfica 30 75 21 49
3 Sporting CP Sporting CP 30 46 22 42
4 Sporting Braga Sporting 30 49 35 37
5 Varzim Varzim 30 30 29 32
6 Vitória Guimarães Vitória 30 44 38 31
7 Vitória Setúbal Vitória 30 38 38 31
8 Os Belenenses Belenenses 30 47 43 29
9 Boavista Boavista 30 36 40 27
10 Marítimo Marítimo 30 36 37 27
11 Estoril Estoril 30 24 42 26
12 Beira Mar SC Beira 30 44 56 24
13 Famalicão Famalicão 30 30 45 24
14 FC Barreirense Barreirense 30 24 45 22
15 Académica Académica 30 20 41 18
16 Academico Viseu Academico 30 13 75 11
TEMPORADA 1977/1978
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 81 21 51
2 Benfica Benfica 30 56 11 51
3 Sporting CP Sporting CP 30 63 30 42
4 Sporting Braga Sporting 30 42 27 38
5 Os Belenenses Belenenses 30 25 21 36
6 Vitória Guimarães Vitória 30 33 28 31
7 Boavista Boavista 30 36 38 28
8 Académica Académica 30 41 49 26
9 Vitória Setúbal Vitória 30 29 40 26
10 Varzim Varzim 30 26 38 25
11 Estoril Estoril 30 25 36 25
12 Marítimo Marítimo 30 22 45 23
13 Portimonense Portimonense 30 29 39 23
14 Espinho Espinho 30 30 52 22
15 Riopele GD Riopele GD 30 23 51 21
16 Feirense Feirense 30 24 59 12
TEMPORADA 1976/1977
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 67 24 51
2 Sporting CP Sporting CP 30 59 26 42
3 Porto Porto 30 72 27 41
4 Boavista Boavista 30 41 33 34
5 Académica Académica 30 29 25 34
6 Vitória Setúbal Vitória 30 47 46 32
7 Varzim Varzim 30 36 36 31
8 Sporting Braga Sporting 30 36 36 29
9 Vitória Guimarães Vitória 30 39 38 26
10 Os Belenenses Belenenses 30 29 40 26
11 Estoril Estoril 30 26 36 25
12 Portimonense Portimonense 30 34 46 25
13 Beira Mar SC Beira 30 33 57 23
14 Montijo CD Montijo CD 30 30 47 23
15 Leixões Leixões 30 15 31 23
16 Atlético CP Atlético 30 23 68 15
TEMPORADA 1975/1976
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 94 20 50
2 Boavista Boavista 30 65 23 48
3 Os Belenenses Belenenses 30 45 28 40
4 Porto Porto 30 73 33 39
5 Sporting CP Sporting CP 30 56 30 39
6 Vitória Guimarães Vitória 30 49 32 36
7 Sporting Braga Sporting 30 35 43 28
8 Estoril Estoril 30 31 45 28
9 Vitória Setúbal Vitória 30 39 42 26
10 Académica Académica 30 32 47 23
11 Atlético CP Atlético 30 25 51 22
12 Leixões Leixões 30 30 65 22
13 Beira Mar SC Beira 30 28 47 21
14 Uniao Tomar Uniao Tomar 30 32 61 21
15 Farense Farense 30 33 65 19
16 Fabril Barreiro Fabril 30 15 50 18
TEMPORADA 1969/1970
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 61 17 46
2 Benfica Benfica 26 58 14 38
3 Vitória Setúbal Vitória 26 58 26 36
4 FC Barreirense Barreirense 26 42 33 28
5 Vitória Guimarães Vitória 26 38 36 28
6 Varzim Varzim 26 31 26 28
7 Os Belenenses Belenenses 26 23 34 23
8 Fabril Barreiro Fabril 26 24 38 23
9 Porto Porto 26 30 37 22
10 Académica Académica 26 42 46 22
11 Leixões Leixões 26 33 47 21
12 Boavista Boavista 26 35 61 18
13 Sporting Braga Sporting 26 25 52 17
14 Uniao Tomar Uniao Tomar 26 20 53 14
TEMPORADA 1968/1969
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 49 17 39
2 Porto Porto 26 39 23 37
3 Vitória Guimarães Vitória 26 46 17 36
4 Vitória Setúbal Vitória 26 45 20 35
5 Sporting CP Sporting CP 26 35 20 30
6 Académica Académica 26 48 32 30
7 Fabril Barreiro Fabril 26 32 30 27
8 Os Belenenses Belenenses 26 31 33 26
9 Varzim Varzim 26 32 49 22
10 Uniao Tomar Uniao Tomar 26 27 47 21
11 Leixões Leixões 26 21 30 21
12 Sporting Braga Sporting 26 20 47 19
13 Atlético CP Atlético 26 26 49 12
14 AD Sanjoanense Sanjoanense 26 15 52 9
TEMPORADA 1967/1968
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 75 19 41
2 Sporting CP Sporting CP 26 48 24 37
3 Porto Porto 26 60 24 36
4 Académica Académica 26 53 24 35
5 Vitória Setúbal Vitória 26 43 20 34
6 Vitória Guimarães Vitória 26 31 34 27
7 Os Belenenses Belenenses 26 38 40 25
8 Leixões Leixões 26 29 39 24
9 Sporting Braga Sporting 26 29 48 21
10 AD Sanjoanense Sanjoanense 26 22 40 21
11 Fabril Barreiro Fabril 26 28 37 21
12 Varzim Varzim 26 27 50 17
13 Tirsense Tirsense 26 17 53 15
14 FC Barreirense Barreirense 26 24 72 10
TEMPORADA 1966/1967
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 64 19 43
2 Académica Académica 26 50 18 40
3 Porto Porto 26 56 22 39
4 Sporting CP Sporting CP 26 36 24 30
5 Vitória Setúbal Vitória 26 27 25 27
6 Vitória Guimarães Vitória 26 35 40 26
7 Leixões Leixões 26 23 29 24
8 Fabril Barreiro Fabril 26 27 43 23
9 Sporting Braga Sporting 26 33 33 23
10 Varzim Varzim 26 29 42 22
11 Os Belenenses Belenenses 26 26 34 20
12 AD Sanjoanense Sanjoanense 26 23 39 19
13 Atlético CP Atlético 26 29 55 14
14 Beira Mar SC Beira 26 23 58 14

  USO DE MEMORIA  
7,843,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2000
Total Execution Time  0.2013
  CADENA URL  
/historico/Sporting-Braga/1991
  GET DATOS  
$_GET['/historico/Sporting-Braga/1991']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0144  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 = 'Sporting-Braga' AND l.year = 1991 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.0020  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=2386 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=2386 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=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 22920
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 2
0.0035  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2386 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (439,579,886,1200,3042) ORDER BY n.cover_points DESC, update_date DESC
0.0110  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 = '2386' AND l.year = 1991 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '2386' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 5758 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 = 22920 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0092  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=2386 AND l.year in (1990,1991,1992) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (22920,5759) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 5759 AND teamId = 2386
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 22920 AND teamId = 2386
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 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 = 5758 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '2386' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2386' and rp.type = 4
0.0021  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 = '2386' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040  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 events1991 e ON e.player_id = p.id AND e.league_id = 5758 WHERE rp.league_id = 5758 AND rp.teamId = 2386 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.0048  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 events1991 e ON e.player_id = p.id AND e.league_id = 5758 WHERE rp.league_id = 5758 AND rp.teamId = 2386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 events1991 e ON e.player_id = p.id AND e.league_id = 5758 WHERE rp.league_id = 5758 AND rp.teamId = 2386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 2386 AND l.year <= 1991 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 5757 AND t.round = 34 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 `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 = 5756 AND t.round = 38 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 = 5755 AND t.round = 38 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 `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 = 5754 AND t.round = 30 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 `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 = 5753 AND t.round = 30 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 `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 = 5752 AND t.round = 30 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 `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 = 5751 AND t.round = 30 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 `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 = 5750 AND t.round = 30 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 `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 = 5749 AND t.round = 30 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 `tables1981` 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 = 5748 AND t.round = 30 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 `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 = 5747 AND t.round = 30 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 `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 = 5746 AND t.round = 30 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 = 5745 AND t.round = 30 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 `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 = 5744 AND t.round = 30 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 `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 = 5743 AND t.round = 30 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 `tables1970` 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 = 5737 AND t.round = 26 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 `tables1969` 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 = 5736 AND t.round = 26 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 `tables1968` 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 = 5735 AND t.round = 26 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 `tables1967` 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 = 5734 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 5758 ORDER BY nameShow LIMIT 100