4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1947/1948
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 92 40 41
2 Benfica Benfica 26 84 35 41
3 Os Belenenses Belenenses 26 76 30 37
4 Estoril Estoril 26 91 49 36
5 Porto Porto 26 73 42 36
6 Atlético CP Atlético 26 69 62 26
7 Vitória Guimarães Vitória 26 44 56 24
8 O Elvas O Elvas 26 66 63 24
9 Boavista Boavista 26 40 65 20
10 Vitória Setúbal Vitória 26 38 64 19
11 Olhanense Olhanense 26 48 66 17
12 Lusitano VRSA Lusitano 26 29 78 17
13 Sporting Braga Sporting 26 47 69 16
14 Académica Académica 26 35 113 10

  USO DE MEMORIA  
7,203,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7170
Total Execution Time  0.7183
  CADENA URL  
/historico/Sporting-Braga/1976
  GET DATOS  
$_GET['/historico/Sporting-Braga/1976']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0149  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 = 1976 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.0126  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.0126  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.0255  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 = 5743
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 2
0.0172  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.0139  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.0264  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 = 1976 ORDER BY l.year DESC,cat.coefficient DESC
0.0170  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.0127  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 = 5743 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 (1975,1976,1977) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (22939,5744) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 5744 AND teamId = 2386
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 22939 AND teamId = 2386
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2386' and rp.type = 4
0.0127  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.0137  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 events1976 e ON e.player_id = p.id AND e.league_id = 5743 WHERE rp.league_id = 5743 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.0134  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 events1976 e ON e.player_id = p.id AND e.league_id = 5743 WHERE rp.league_id = 5743 AND rp.teamId = 2386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events1976 e ON e.player_id = p.id AND e.league_id = 5743 WHERE rp.league_id = 5743 AND rp.teamId = 2386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 <= 1976 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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.0129  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.0130  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.0130  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.0134  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.0138  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.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 `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.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 `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.0133  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.0132  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.0129  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.0129  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.0128  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.0129  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.0130  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.0129  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.0128  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.0128  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.0129  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
0.0130  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 `tables1948` 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 = 5715 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 5743 ORDER BY nameShow LIMIT 100