4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1965/1966
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 70 21 42
2 Benfica Benfica 26 73 30 41
3 Porto Porto 26 41 25 34
4 Vitória Guimarães Vitória 26 58 47 33
5 Vitória Setúbal Vitória 26 51 36 29
6 Académica Académica 26 58 48 26
7 Os Belenenses Belenenses 26 28 29 25
8 Varzim Varzim 26 40 38 25
9 Fabril Barreiro Fabril 26 37 46 24
10 Sporting Braga Sporting 26 39 64 21
11 Beira Mar SC Beira 26 31 65 18
12 Leixões Leixões 26 28 39 18
13 Lusitano GC Évora Lusitano 26 27 60 14
14 FC Barreirense Barreirense 26 32 65 14
TEMPORADA 1964/1965
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 88 21 43
2 Porto Porto 26 47 27 37
3 Fabril Barreiro Fabril 26 49 29 35
4 Académica Académica 26 58 40 34
5 Sporting CP Sporting CP 26 39 35 32
6 Vitória Setúbal Vitória 26 61 30 32
7 Vitória Guimarães Vitória 26 44 36 29
8 Os Belenenses Belenenses 26 39 40 26
9 Leixões Leixões 26 50 51 21
10 Sporting Braga Sporting 26 36 51 20
11 Varzim Varzim 26 39 55 20
12 Lusitano GC Évora Lusitano 26 30 51 20
13 Seixal FC Seixal FC 26 16 84 8
14 Torreense Torreense 26 18 64 7
TEMPORADA 1960/1961
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 92 21 46
2 Sporting CP Sporting CP 26 61 19 42
3 Porto Porto 26 51 28 33
4 Vitória Guimarães Vitória 26 48 44 30
5 Os Belenenses Belenenses 26 45 37 28
6 Fabril Barreiro Fabril 26 38 28 26
7 Académica Académica 26 31 29 26
8 Leixões Leixões 26 41 44 23
9 SC Covilha SC Covilha 26 27 55 21
10 Atlético CP Atlético 26 35 57 21
11 Lusitano GC Évora Lusitano 26 29 51 21
12 SC Salgueiros Salgueiros 26 34 64 20
13 Sporting Braga Sporting 26 41 62 19
14 FC Barreirense Barreirense 26 26 60 8
TEMPORADA 1959/1960
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 75 27 45
2 Sporting CP Sporting CP 26 82 21 43
3 Os Belenenses Belenenses 26 58 25 36
4 Porto Porto 26 48 36 30
5 Fabril Barreiro Fabril 26 36 39 25
6 Académica Académica 26 40 41 25
7 Vitória Guimarães Vitória 26 47 43 23
8 Leixões Leixões 26 48 56 23
9 SC Covilha SC Covilha 26 32 49 22
10 Lusitano GC Évora Lusitano 26 32 55 21
11 Atlético CP Atlético 26 34 46 21
12 Sporting Braga Sporting 26 25 39 20
13 Vitória Setúbal Vitória 26 26 52 18
14 Boavista Boavista 26 27 81 12
TEMPORADA 1958/1959
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 26 81 22 41
2 Benfica Benfica 26 78 20 41
3 Os Belenenses Belenenses 26 65 27 38
4 Sporting CP Sporting CP 26 50 28 31
5 Vitória Guimarães Vitória 26 59 55 29
6 Vitória Setúbal Vitória 26 53 64 27
7 Sporting Braga Sporting 26 48 51 24
8 SC Covilha SC Covilha 26 43 65 22
9 Lusitano GC Évora Lusitano 26 40 49 21
10 Académica Académica 26 45 46 21
11 Fabril Barreiro Fabril 26 34 55 21
12 FC Barreirense Barreirense 26 39 62 17
13 Caldas Caldas 26 33 76 16
14 Torreense Torreense 26 23 71 15
TEMPORADA 1957/1958
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 79 21 43
2 Porto Porto 26 64 25 43
3 Benfica Benfica 26 59 23 36
4 Os Belenenses Belenenses 26 54 42 28
5 Sporting Braga Sporting 26 51 52 25
6 Lusitano GC Évora Lusitano 26 37 36 24
7 FC Barreirense Barreirense 26 42 52 24
8 Torreense Torreense 26 30 46 24
9 Académica Académica 26 45 40 24
10 Caldas Caldas 26 30 46 23
11 Vitória Setúbal Vitória 26 37 59 22
12 Fabril Barreiro Fabril 26 40 59 19
13 SC Salgueiros Salgueiros 26 45 65 16
14 Oriental Lisboa Oriental 26 21 68 13
TEMPORADA 1955/1956
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 26 77 20 43
2 Benfica Benfica 26 76 31 43
3 Os Belenenses Belenenses 26 67 25 37
4 Sporting CP Sporting CP 26 54 27 36
5 SC Covilha SC Covilha 26 52 44 29
6 FC Barreirense Barreirense 26 40 60 23
7 Torreense Torreense 26 32 42 22
8 Lusitano GC Évora Lusitano 26 38 55 21
9 Vitória Setúbal Vitória 26 57 64 20
10 Fabril Barreiro Fabril 26 33 58 20
11 Caldas Caldas 26 29 50 19
12 Atlético CP Atlético 26 47 62 19
13 Académica Académica 26 36 52 19
14 Sporting Braga Sporting 26 36 84 13
TEMPORADA 1954/1955
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 61 20 39
2 Os Belenenses Belenenses 26 63 28 39
3 Sporting CP Sporting CP 26 73 27 37
4 Porto Porto 26 51 34 30
5 Sporting Braga Sporting 26 52 42 29
6 Académica Académica 26 53 52 25
7 Fabril Barreiro Fabril 26 45 51 25
8 Vitória Setúbal Vitória 26 37 52 22
9 Atlético CP Atlético 26 42 52 22
10 Lusitano GC Évora Lusitano 26 40 70 21
11 FC Barreirense Barreirense 26 24 38 20
12 SC Covilha SC Covilha 26 32 53 20
13 Boavista Boavista 26 33 71 18
14 Vitória Guimarães Vitória 26 33 49 17
TEMPORADA 1953/1954
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 80 25 43
2 Porto Porto 26 83 35 36
3 Benfica Benfica 26 62 40 32
4 Os Belenenses Belenenses 26 43 39 31
5 Sporting Braga Sporting 26 54 36 28
6 Atlético CP Atlético 26 49 43 28
7 SC Covilha SC Covilha 26 43 39 28
8 Vitória Guimarães Vitória 26 44 64 25
9 FC Barreirense Barreirense 26 34 47 22
10 Lusitano GC Évora Lusitano 26 47 66 21
11 Boavista Boavista 26 29 66 19
12 Vitória Setúbal Vitória 26 51 66 18
13 Académica Académica 26 29 50 18
14 Oriental Lisboa Oriental 26 35 67 15
TEMPORADA 1952/1953
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 77 22 43
2 Benfica Benfica 26 75 27 39
3 Os Belenenses Belenenses 26 60 29 36
4 Porto Porto 26 58 35 36
5 FC Barreirense Barreirense 26 44 40 28
6 Vitória Setúbal Vitória 26 40 33 27
7 Lusitano GC Évora Lusitano 26 31 44 25
8 Vitória Guimarães Vitória 26 28 54 20
9 Boavista Boavista 26 35 54 20
10 SC Covilha SC Covilha 26 38 54 20
11 Académica Académica 26 39 57 19
12 Atlético CP Atlético 26 33 52 19
13 Sporting Braga Sporting 26 37 58 18
14 Estoril Estoril 26 28 64 14
TEMPORADA 1951/1952
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 91 32 41
2 Benfica Benfica 26 76 26 40
3 Porto Porto 26 68 33 36
4 Os Belenenses Belenenses 26 60 28 36
5 Boavista Boavista 26 47 55 25
6 SC Covilha SC Covilha 26 35 52 25
7 Académica Académica 26 39 47 22
8 Sporting Braga Sporting 26 32 49 21
9 Estoril Estoril 26 49 61 21
10 Vitória Guimarães Vitória 26 28 47 21
11 FC Barreirense Barreirense 26 47 65 21
12 Atlético CP Atlético 26 53 48 20
13 Oriental Lisboa Oriental 26 48 72 18
14 SC Salgueiros Salgueiros 26 33 91 17
TEMPORADA 1950/1951
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 91 28 45
2 Porto Porto 26 67 32 34
3 Benfica Benfica 26 81 43 30
4 Atlético CP Atlético 26 62 49 30
5 Oriental Lisboa Oriental 26 37 57 27
6 SC Covilha SC Covilha 26 62 53 26
7 Sporting Braga Sporting 26 42 57 25
8 Académica Académica 26 40 53 24
9 Os Belenenses Belenenses 26 45 48 24
10 Boavista Boavista 26 50 62 23
11 Estoril Estoril 26 53 58 21
12 Vitória Setúbal Vitória 26 31 58 20
13 Vitória Guimarães Vitória 26 40 57 18
14 Olhanense Olhanense 26 31 77 17
TEMPORADA 1949/1950
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 86 33 45
2 Sporting CP Sporting CP 26 91 35 39
3 Atlético CP Atlético 26 53 42 30
4 Os Belenenses Belenenses 26 36 41 27
5 Porto Porto 26 61 52 26
6 SC Covilha SC Covilha 26 55 70 25
7 Académica Académica 26 56 57 24
8 Sporting Braga Sporting 26 52 53 24
9 Olhanense Olhanense 26 48 57 24
10 Vitória Setúbal Vitória 26 50 70 23
11 Vitória Guimarães Vitória 26 45 59 21
12 Estoril Estoril 26 50 59 21
13 O Elvas O Elvas 26 48 65 19
14 Lusitano VRSA Lusitano 26 42 80 16
TEMPORADA 1948/1949
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 100 35 42
2 Benfica Benfica 26 72 34 37
3 Os Belenenses Belenenses 26 68 36 35
4 Porto Porto 26 55 37 33
5 Estoril Estoril 26 76 54 29
6 Vitória Guimarães Vitória 26 47 50 26
7 Olhanense Olhanense 26 51 55 24
8 Sporting Braga Sporting 26 39 54 24
9 O Elvas O Elvas 26 46 61 21
10 Atlético CP Atlético 26 44 68 21
11 SC Covilha SC Covilha 26 50 59 20
12 Vitória Setúbal Vitória 26 39 61 20
13 Lusitano VRSA Lusitano 26 23 52 18
14 Boavista Boavista 26 35 89 14

  USO DE MEMORIA  
7,350,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8474
Total Execution Time  0.8486
  CADENA URL  
/historico/Sporting-Braga/1977
  GET DATOS  
$_GET['/historico/Sporting-Braga/1977']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0239  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 = 1977 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.0147  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.0147  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.0147  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.0297  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 = 5744
0.0155  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 = 22937
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 2
0.0163  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.0151  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.0181  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 = 1977 ORDER BY l.year DESC,cat.coefficient DESC
0.0195  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.0150  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 = 5744 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 22937 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0184  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 (1976,1977,1978) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (22937,5745) 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.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 5745 AND teamId = 2386
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 22937 AND teamId = 2386
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2386' and rp.type = 4
0.0147  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.0184  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 events1977 e ON e.player_id = p.id AND e.league_id = 5744 WHERE rp.league_id = 5744 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.0166  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 events1977 e ON e.player_id = p.id AND e.league_id = 5744 WHERE rp.league_id = 5744 AND rp.teamId = 2386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 events1977 e ON e.player_id = p.id AND e.league_id = 5744 WHERE rp.league_id = 5744 AND rp.teamId = 2386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 <= 1977 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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.0149  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.0148  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.0153  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.0152  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.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0152  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 `tables1966` 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 = 5733 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1965` 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 = 5732 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1961` 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 = 5728 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1960` 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 = 5727 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1959` 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 = 5726 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 `tables1958` 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 = 5725 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 `tables1956` 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 = 5723 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1955` 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 = 5722 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1954` 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 = 5721 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 `tables1953` 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 = 5720 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1952` 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 = 5719 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1951` 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 = 5718 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables1950` 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 = 5717 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1949` 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 = 5716 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC