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

Academico Viseu

Entrenador: Gil Oliveira

Temporada 2019/2020
TEMPORADA 2019/2020
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Nacional Nacional 24 36 16 50
2 Farense Farense 24 35 22 48
3 Feirense Feirense 24 27 18 42
4 Estoril Estoril 24 35 26 39
5 Mafra Mafra 24 33 24 39
6 Varzim Varzim 24 32 31 37
7 Académica Académica 24 34 26 35
8 Academico Viseu Academico 24 21 24 34
9 Leixões Leixões 24 23 22 33
10 UD Oliveirense Oliveirense 24 36 31 32
11 SC Covilha SC Covilha 24 29 27 32
12 Chaves Chaves 24 26 26 32
13 Porto II Porto II 24 35 36 29
14 Penafiel Penafiel 24 23 24 28
15 Benfica II Benfica II 24 31 35 28
16 Vilafranquense Vilafranquen 24 27 45 24
17 Cova Piedade Cova Piedade 24 20 42 17
18 Casa Pia AC Casa Pia AC 24 19 47 11
TEMPORADA 2018/2019
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Paços de Ferreira Paços 34 50 21 74
2 Famalicão Famalicão 34 57 34 69
3 Estoril Estoril 34 49 42 54
4 Benfica II Benfica II 34 47 42 52
5 Académica Académica 34 36 37 51
6 SC Covilha SC Covilha 34 42 37 49
7 Penafiel Penafiel 34 49 48 45
8 Leixões Leixões 34 35 36 45
9 Porto II Porto II 34 41 42 44
10 Farense Farense 34 39 35 43
11 Academico Viseu Academico 34 49 54 43
12 UD Oliveirense Oliveirense 34 44 49 43
13 Cova Piedade Cova Piedade 34 25 42 42
14 Mafra Mafra 34 40 44 41
15 Varzim Varzim 34 25 37 41
16 Arouca Arouca 34 40 45 40
17 Sporting Braga II Sporting 34 38 45 37
18 Vitória SC B Vitória 34 41 57 31
TEMPORADA 2017/2018
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Nacional Nacional 38 72 45 71
2 CD Santa Clara Santa Clara 38 55 40 66
3 Academico Viseu Academico 38 50 40 64
4 Académica Académica 38 59 40 63
5 Penafiel Penafiel 38 55 43 62
6 Arouca Arouca 38 42 37 59
7 Porto II Porto II 38 50 55 58
8 Leixões Leixões 38 50 43 56
9 Cova Piedade Cova Piedade 38 42 45 51
10 Varzim Varzim 38 41 41 50
11 Vitória SC B Vitória 38 44 49 50
12 UD Oliveirense Oliveirense 38 45 47 49
13 Benfica II Benfica II 38 54 60 49
14 Famalicão Famalicão 38 46 49 48
15 SC Covilha SC Covilha 38 32 41 47
16 Sporting Braga II Sporting 38 44 48 44
17 União Madeira União 38 44 53 44
18 Sporting CP II Sporting 38 46 65 42
19 Gil Vicente Gil Vicente 38 29 45 36
20 Real Sport Clube Real Sport. 38 47 61 32
TEMPORADA 2016/2017
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Portimonense Portimonense 42 70 39 83
2 Desportivo Aves Desportivo 42 62 38 81
3 União Madeira União 42 52 43 64
4 Benfica II Benfica II 42 56 58 63
5 Penafiel Penafiel 42 56 55 63
6 Académica Académica 42 42 35 62
7 Sporting Braga II Sporting 42 64 50 62
8 SC Covilha SC Covilha 42 51 41 62
9 Varzim Varzim 42 45 48 61
10 CD Santa Clara Santa Clara 42 44 42 60
11 Vitória SC B Vitória 42 54 50 60
12 Porto II Porto II 42 52 49 60
13 Gil Vicente Gil Vicente 42 47 49 56
14 Sporting CP II Sporting 42 64 62 55
15 Famalicão Famalicão 42 47 50 53
16 Cova Piedade Cova Piedade 42 45 59 53
17 Academico Viseu Academico 42 49 54 52
18 Leixões Leixões 42 44 48 46
19 Vizela Vizela 42 39 49 46
20 Fafe Fafe 42 52 65 45
21 SC Freamunde Freamunde 42 39 52 40
22 Olhanense Olhanense 42 45 83 28
TEMPORADA 2015/2016
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Porto II Porto II 46 84 52 86
2 Chaves Chaves 46 60 39 81
3 Feirense Feirense 46 54 38 78
4 Portimonense Portimonense 46 57 45 78
5 SC Freamunde Freamunde 46 52 36 74
6 Famalicão Famalicão 46 64 51 72
7 Olhanense Olhanense 46 42 39 69
8 Desportivo Aves Desportivo 46 58 48 67
9 Varzim Varzim 46 51 48 65
10 Sporting CP II Sporting 46 61 59 65
11 Gil Vicente Gil Vicente 46 58 56 62
12 Penafiel Penafiel 46 49 46 61
13 Vitória SC B Vitória 46 60 67 60
14 SC Covilha SC Covilha 46 45 48 58
15 CD Santa Clara Santa Clara 46 49 52 57
16 Sporting Braga II Sporting 46 47 54 57
17 Academico Viseu Academico 46 46 60 56
18 Benfica II Benfica II 46 58 64 55
19 Leixões Leixões 46 45 56 55
20 Mafra Mafra 46 37 40 54
21 Farense Farense 46 49 55 54
22 Atlético CP Atlético 46 49 56 51
23 Oriental Lisboa Oriental 46 47 67 41
24 UD Oliveirense Oliveirense 46 42 88 29
TEMPORADA 2014/2015
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Tondela Tondela 46 67 51 81
2 SC Covilha SC Covilha 46 78 46 80
3 União Madeira União 46 69 39 80
4 Chaves Chaves 46 68 45 80
5 Sporting CP II Sporting 46 66 57 78
6 Benfica II Benfica II 46 81 60 77
7 Feirense Feirense 46 61 51 75
8 SC Freamunde Freamunde 46 48 32 71
9 Vitória SC B Vitória 46 71 57 65
10 Beira Mar SC Beira 46 52 48 63
11 Academico Viseu Academico 46 55 56 62
12 Farense Farense 46 51 54 62
13 Porto II Porto II 46 66 64 61
14 Portimonense Portimonense 46 56 62 60
15 Oriental Lisboa Oriental 46 47 59 58
16 Olhanense Olhanense 46 51 56 55
17 UD Oliveirense Oliveirense 46 50 67 55
18 Desportivo Aves Desportivo 46 52 58 53
19 CD Santa Clara Santa Clara 46 33 42 51
20 Sporting Braga II Sporting 46 48 62 51
21 Leixões Leixões 46 53 67 50
22 Atlético CP Atlético 46 56 70 47
23 Marítimo II Marítimo 46 37 67 41
24 Trofense Trofense 46 35 81 36
TEMPORADA 2013/2014
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Moreirense Moreirense 42 65 25 79
2 Porto II Porto II 42 59 42 77
3 Penafiel Penafiel 42 47 24 73
4 Desportivo Aves Desportivo 42 46 35 71
5 Benfica II Benfica II 42 77 56 70
6 Sporting CP II Sporting 42 61 50 70
7 Portimonense Portimonense 42 58 48 67
8 Chaves Chaves 42 58 56 67
9 Tondela Tondela 42 41 38 59
10 Farense Farense 42 45 44 57
11 Academico Viseu Academico 42 43 43 54
12 Beira Mar SC Beira 42 45 48 54
13 União Madeira União 42 50 46 52
14 Feirense Feirense 42 41 46 50
15 CD Santa Clara Santa Clara 42 38 46 48
16 SC Covilha SC Covilha 42 34 50 48
17 Leixões Leixões 42 42 57 47
18 UD Oliveirense Oliveirense 42 56 76 47
19 Trofense Trofense 42 36 61 47
20 Sporting Braga II Sporting 42 47 60 44
21 Marítimo II Marítimo 42 39 57 43
22 Atlético CP Atlético 42 34 54 40
TEMPORADA 2012/2013
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Academico Viseu Academico 30 47 21 58
2 Cinfães Cinfães 30 50 31 53
3 Operário Operário 30 44 33 48
4 Espinho Espinho 30 36 32 48
5 Benfica Castelo Branco Benfica 30 44 33 46
6 Pampilhosa Pampilhosa 30 42 38 46
7 Sousense Sousense 30 37 34 41
8 São João Ver São João 30 35 39 40
9 Anadia Anadia 30 31 38 40
10 Coimbrões Coimbrões 30 35 41 37
11 AD Nogueirense Nogueirense 30 34 39 36
12 Tourizense Tourizense 30 27 31 35
13 Cesarense Cesarense 30 28 35 34
14 Bustelo Bustelo 30 32 41 31
15 Lusitânia Lusitânia 30 38 50 29
16 Tocha Tocha 30 24 48 20
TEMPORADA 2011/2012
III DIVISAO PORTUGAL GRUPO 4
Equipo PJ GF GC Puntos
1 Bustelo Bustelo 22 43 25 39
2 Avanca Avanca 22 41 23 39
3 Academico Viseu Academico 22 31 21 38
4 Sampedrense Sampedrense 22 34 27 38
5 Alba Alba 22 32 16 37
6 AD Nogueirense Nogueirense 22 39 27 36
7 Penalva Castelo Penalva 22 28 27 36
8 Oliveira de Frades Oliveira 22 27 30 29
9 AD Sanjoanense Sanjoanense 22 29 34 29
10 Oliveira Hospital Oliveira 22 26 31 27
11 Canas de Senhorim Canas 22 20 55 9
12 Valecambrense Valecambrens 22 24 58 6
TEMPORADA 1997/1998
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 União de Leiria União 34 73 32 70
2 Beira Mar SC Beira 34 41 26 64
3 FC Alverca FC Alverca 34 64 35 62
4 Gil Vicente Gil Vicente 34 44 23 60
5 Penafiel Penafiel 34 63 48 59
6 Feirense Feirense 34 39 39 49
7 Estoril Estoril 34 40 39 46
8 FC Maia FC Maia 34 50 47 45
9 FC Felgueiras Felgueiras 34 38 42 45
10 Espinho Espinho 34 45 43 44
11 Moreirense Moreirense 34 48 53 42
12 Paços de Ferreira Paços 34 34 39 41
13 União Madeira União 34 36 48 41
14 Uniao Lamas Uniao Lamas 34 37 55 40
15 Desportivo Aves Desportivo 34 48 64 38
16 Academico Viseu Academico 34 30 45 33
17 Torreense Torreense 34 31 62 30
18 Nacional Nacional 34 37 58 27
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 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 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

  USO DE MEMORIA  
7,450,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7795
Total Execution Time  0.7807
  CADENA URL  
/historico/Academico-Viseu/2020
  GET DATOS  
$_GET['/historico/Academico-Viseu/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0159  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 = 'Academico-Viseu' AND l.year = 2020 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.0145  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=7076 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=7076 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=7076 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=7076 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=7076 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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 = 49946
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7076 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7076 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (40539,41000,42845,49775,50605) ORDER BY n.cover_points DESC, update_date DESC
0.0152  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 = '7076' ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '7076' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0156  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 = '7076' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 49946 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160  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=7076 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (58721,58600,50420,49506) 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.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 58600 AND teamId = 7076
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 58721 AND teamId = 7076
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 50420 AND teamId = 7076
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 7076
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 FROM `tables2020` 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 = 49946 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '7076' 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 = '7076' and rp.type = 4
0.0146  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 = '7076' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 events2020 e ON e.player_id = p.id AND e.league_id = 49946 WHERE rp.league_id = 49946 AND rp.teamId = 7076 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.0158  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 events2020 e ON e.player_id = p.id AND e.league_id = 49946 WHERE rp.league_id = 49946 AND rp.teamId = 7076 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 events2020 e ON e.player_id = p.id AND e.league_id = 49946 WHERE rp.league_id = 49946 AND rp.teamId = 7076 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 7076 AND l.year <= 2020 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 `tables2020` 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 = 49946 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 43587 AND t.round = 34 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 `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38673 AND t.round = 38 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 `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 31022 AND t.round = 42 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 `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15395 AND t.round = 46 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 `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3858 AND t.round = 46 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 `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2504 AND t.round = 42 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 `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2169 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 `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1706 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 `tables1998` 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 = 13411 AND t.round = 34 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 `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.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 `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.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 `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.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 `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.0146  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 = 49946 ORDER BY nameShow LIMIT 100