4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2020/2021
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 34 65 20 85
2 Porto Porto 34 74 29 80
3 Benfica Benfica 34 69 27 76
4 Sporting Braga Sporting 34 53 33 64
5 Paços de Ferreira Paços 34 40 41 53
6 CD Santa Clara Santa Clara 34 44 36 46
7 Vitória Guimarães Vitória 34 37 44 43
8 Moreirense Moreirense 34 37 43 43
9 Famalicão Famalicão 34 40 48 40
10 Belenenses SAD Belenenses 34 25 35 40
11 Gil Vicente Gil Vicente 34 33 42 39
12 Tondela Tondela 34 36 57 36
13 Boavista Boavista 34 39 49 36
14 Portimonense Portimonense 34 34 41 35
15 Marítimo Marítimo 34 27 47 35
16 Rio Ave Rio Ave 34 25 40 34
17 Farense Farense 34 31 48 31
18 Nacional Nacional 34 30 59 25
TEMPORADA 2019/2020
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 74 22 82
2 Benfica Benfica 34 71 26 77
3 Sporting Braga Sporting 34 61 40 60
4 Sporting CP Sporting CP 34 49 34 60
5 Rio Ave Rio Ave 34 48 36 55
6 Famalicão Famalicão 34 53 51 54
7 Vitória Guimarães Vitória 34 53 38 50
8 Moreirense Moreirense 34 42 44 43
9 CD Santa Clara Santa Clara 34 36 41 43
10 Gil Vicente Gil Vicente 34 40 44 43
11 Marítimo Marítimo 34 34 42 39
12 Boavista Boavista 34 28 39 39
13 Paços de Ferreira Paços 34 36 52 39
14 Tondela Tondela 34 30 44 36
15 Belenenses SAD Belenenses 34 27 54 35
16 Vitória Setúbal Vitória 34 27 43 34
17 Portimonense Portimonense 34 30 45 33
18 Desportivo Aves Desportivo 34 24 68 17
TEMPORADA 2018/2019
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 103 31 87
2 Porto Porto 34 74 20 85
3 Sporting CP Sporting CP 34 72 33 74
4 Sporting Braga Sporting 34 56 37 67
5 Vitória Guimarães Vitória 34 46 34 52
6 Moreirense Moreirense 34 39 44 52
7 Rio Ave Rio Ave 34 50 52 45
8 Boavista Boavista 34 34 40 44
9 Belenenses SAD Belenenses 34 42 51 43
10 CD Santa Clara Santa Clara 34 43 45 42
11 Marítimo Marítimo 34 26 44 39
12 Portimonense Portimonense 34 44 59 39
13 Vitória Setúbal Vitória 34 28 39 36
14 Desportivo Aves Desportivo 34 35 49 36
15 Tondela Tondela 34 40 54 35
16 Chaves Chaves 34 34 57 32
17 Nacional Nacional 34 33 73 28
18 Feirense Feirense 34 27 64 20
TEMPORADA 2017/2018
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 82 18 88
2 Benfica Benfica 34 80 22 81
3 Sporting CP Sporting CP 34 63 24 78
4 Sporting Braga Sporting 34 74 29 75
5 Rio Ave Rio Ave 34 40 42 51
6 Chaves Chaves 34 47 55 47
7 Marítimo Marítimo 34 36 49 47
8 Boavista Boavista 34 35 44 45
9 Vitória Guimarães Vitória 34 45 56 43
10 Portimonense Portimonense 34 52 60 38
11 Tondela Tondela 34 41 50 38
12 Os Belenenses Belenenses 34 33 46 37
13 Desportivo Aves Desportivo 34 36 51 34
14 Vitória Setúbal Vitória 34 39 62 32
15 Moreirense Moreirense 34 29 50 32
16 Feirense Feirense 34 32 48 31
17 Paços de Ferreira Paços 34 33 59 30
18 Estoril Estoril 34 29 61 30
TEMPORADA 2016/2017
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 72 18 82
2 Porto Porto 34 71 19 76
3 Sporting CP Sporting CP 34 68 36 70
4 Vitória Guimarães Vitória 34 50 39 62
5 Sporting Braga Sporting 34 51 36 54
6 Marítimo Marítimo 34 34 32 50
7 Rio Ave Rio Ave 34 41 39 49
8 Feirense Feirense 34 31 45 48
9 Boavista Boavista 34 33 36 43
10 Estoril Estoril 34 36 42 38
11 Chaves Chaves 34 35 42 38
12 Vitória Setúbal Vitória 34 30 39 38
13 Paços de Ferreira Paços 34 32 45 36
14 Os Belenenses Belenenses 34 27 45 36
15 Moreirense Moreirense 34 33 48 33
16 Tondela Tondela 34 29 52 32
17 Arouca Arouca 34 33 57 32
18 Nacional Nacional 34 22 58 21
TEMPORADA 2015/2016
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 88 22 88
2 Sporting CP Sporting CP 34 79 21 86
3 Porto Porto 34 67 30 73
4 Sporting Braga Sporting 34 54 35 58
5 Arouca Arouca 34 47 38 54
6 Rio Ave Rio Ave 34 44 44 50
7 Paços de Ferreira Paços 34 43 42 49
8 Estoril Estoril 34 40 41 47
9 Os Belenenses Belenenses 34 44 66 41
10 Vitória Guimarães Vitória 34 45 53 40
11 Nacional Nacional 34 40 56 38
12 Moreirense Moreirense 34 38 54 36
13 Marítimo Marítimo 34 45 63 35
14 Boavista Boavista 34 24 41 33
15 Vitória Setúbal Vitória 34 40 61 30
16 Tondela Tondela 34 34 54 30
17 União Madeira União 34 27 50 29
18 Académica Académica 34 32 60 25
TEMPORADA 2014/2015
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 86 16 85
2 Porto Porto 34 74 13 82
3 Sporting CP Sporting CP 34 67 29 76
4 Sporting Braga Sporting 34 55 28 58
5 Vitória Guimarães Vitória 34 50 35 55
6 Os Belenenses Belenenses 34 34 35 48
7 Nacional Nacional 34 45 46 47
8 Paços de Ferreira Paços 34 40 45 47
9 Marítimo Marítimo 34 46 45 44
10 Rio Ave Rio Ave 34 38 42 43
11 Moreirense Moreirense 34 33 42 43
12 Estoril Estoril 34 38 56 40
13 Boavista Boavista 34 27 50 34
14 Vitória Setúbal Vitória 34 24 56 29
15 Académica Académica 34 26 46 29
16 Arouca Arouca 34 26 50 28
17 Gil Vicente Gil Vicente 34 25 60 23
18 Penafiel Penafiel 34 29 69 22
TEMPORADA 2013/2014
CAMPEONATO DE PORTUGAL GRUPO 3
Equipo PJ GF GC Puntos
1 Boavista Boavista 18 40 12 45
2 SC Freamunde Freamunde 18 39 18 38
3 Gondomar Gondomar 18 25 14 34
4 Amarante Amarante 18 29 21 27
5 Salgueiros 08 Salgueiros 18 21 22 25
6 Camacha Camacha 18 23 25 21
7 Coimbrões Coimbrões 18 22 29 18
8 Sousense Sousense 18 18 25 18
9 Perafita Perafita 18 16 38 12
10 Vila Flor Vila Flor 18 20 49 7
TEMPORADA 2012/2013
CAMPEONATO DE PORTUGAL GRUPO 2
Equipo PJ GF GC Puntos
1 Chaves Chaves 30 43 21 58
2 Ribeirão Ribeirão 30 43 24 55
3 Mirandela Mirandela 30 41 29 53
4 Vizela Vizela 30 41 29 51
5 Tirsense Tirsense 30 35 32 45
6 Os Limianos Os Limianos 30 33 30 45
7 Famalicão Famalicão 30 42 35 43
8 Varzim Varzim 30 31 26 40
9 Fafe Fafe 30 37 33 40
10 Boavista Boavista 30 44 40 38
11 Gondomar Gondomar 30 25 27 33
12 Amarante Amarante 30 30 33 33
13 Länk Vilaverdense Länk 30 22 36 33
14 Joane Joane 30 27 48 28
15 Infesta Infesta 30 30 51 25
16 Padroense Padroense 30 23 53 21
TEMPORADA 2011/2012
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Tondela Tondela 30 49 22 63
2 Espinho Espinho 30 50 32 62
3 Operário Operário 30 34 26 52
4 Boavista Boavista 30 43 31 50
5 Amarante Amarante 30 48 30 49
6 São João Ver São João 30 43 46 49
7 Gondomar Gondomar 30 27 31 44
8 Cinfães Cinfães 30 35 40 43
9 Coimbrões Coimbrões 30 30 31 42
10 Anadia Anadia 30 45 42 40
11 Padroense Padroense 30 47 50 39
12 Aliados Lordelo Aliados 30 41 40 37
13 Oliveira Bairro Oliveira 30 34 50 28
14 Angrense Angrense 30 36 49 23
15 USC Paredes USC Paredes 30 30 50 23
16 Madalena FC Madalena FC 30 32 54 21
TEMPORADA 2008/2009
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Olhanense Olhanense 30 52 32 58
2 União de Leiria União 30 46 29 54
3 CD Santa Clara Santa Clara 30 45 32 52
4 Estoril Estoril 30 41 37 44
5 Feirense Feirense 30 37 34 42
6 SC Freamunde Freamunde 30 32 35 41
7 SC Covilha SC Covilha 30 42 42 40
8 Varzim Varzim 30 29 35 39
9 Gil Vicente Gil Vicente 30 36 37 38
10 Vizela Vizela 30 28 33 37
11 Desportivo Aves Desportivo 30 30 36 36
12 Beira Mar SC Beira 30 32 32 35
13 Portimonense Portimonense 30 29 35 35
14 UD Oliveirense Oliveirense 30 25 33 32
15 Boavista Boavista 30 28 44 32
16 Gondomar Gondomar 30 29 35 30
TEMPORADA 2007/2008
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 60 13 75
2 Sporting CP Sporting CP 30 46 28 55
3 Vitória Guimarães Vitória 30 35 31 53
4 Benfica Benfica 30 45 21 52
5 Marítimo Marítimo 30 39 28 46
6 Vitória Setúbal Vitória 30 37 33 45
7 Sporting Braga Sporting 30 32 34 41
8 Os Belenenses Belenenses 30 35 33 40
9 Boavista Boavista 30 32 41 36
10 Nacional Nacional 30 23 28 35
11 Naval Naval 30 26 45 34
12 Académica Académica 30 31 38 32
13 Estrela Amadora Estrela 30 29 41 31
14 Leixões Leixões 30 27 37 26
15 Paços de Ferreira Paços 30 31 49 25
16 União de Leiria União 30 25 53 16
TEMPORADA 2006/2007
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 65 20 69
2 Sporting CP Sporting CP 30 54 15 68
3 Benfica Benfica 30 55 20 67
4 Sporting Braga Sporting 30 35 30 50
5 Os Belenenses Belenenses 30 36 29 49
6 Paços de Ferreira Paços 30 31 36 42
7 União de Leiria União 30 25 27 41
8 Nacional Nacional 30 41 38 39
9 Estrela Amadora Estrela 30 23 36 35
10 Boavista Boavista 30 32 34 35
11 Marítimo Marítimo 30 30 44 32
12 Naval Naval 30 28 37 32
13 Académica Académica 30 28 46 26
14 Vitória Setúbal Vitória 30 21 45 24
15 Beira Mar SC Beira 30 28 55 23
16 Desportivo Aves Desportivo 30 22 42 22
TEMPORADA 2005/2006
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 54 16 79
2 Sporting CP Sporting CP 34 50 24 72
3 Benfica Benfica 34 51 29 67
4 Sporting Braga Sporting 34 38 22 58
5 Nacional Nacional 34 40 32 52
6 Boavista Boavista 34 37 29 50
7 União de Leiria União 34 44 42 47
8 Vitória Setúbal Vitória 34 28 33 46
9 Estrela Amadora Estrela 34 31 33 45
10 Marítimo Marítimo 34 38 37 44
11 Paços de Ferreira Paços 34 38 49 42
12 Gil Vicente Gil Vicente 34 37 42 40
13 Naval Naval 34 35 48 39
14 Académica Académica 34 37 48 39
15 Os Belenenses Belenenses 34 40 42 39
16 Rio Ave Rio Ave 34 34 53 34
17 Vitória Guimarães Vitória 34 28 41 34
18 Penafiel Penafiel 34 21 61 15
TEMPORADA 2004/2005
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 51 31 65
2 Porto Porto 34 39 26 62
3 Sporting CP Sporting CP 34 66 36 61
4 Sporting Braga Sporting 34 45 28 58
5 Vitória Guimarães Vitória 34 38 29 54
6 Boavista Boavista 34 39 43 50
7 Marítimo Marítimo 34 39 32 49
8 Rio Ave Rio Ave 34 35 35 47
9 Os Belenenses Belenenses 34 38 34 46
10 Vitória Setúbal Vitória 34 46 45 44
11 Penafiel Penafiel 34 39 53 43
12 Nacional Nacional 34 46 48 41
13 Gil Vicente Gil Vicente 34 34 40 40
14 Académica Académica 34 29 41 38
15 União de Leiria União 34 29 36 38
16 Moreirense Moreirense 34 30 43 34
17 Estoril Estoril 34 38 55 30
18 Beira Mar SC Beira 34 30 56 30
TEMPORADA 2003/2004
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 63 19 82
2 Benfica Benfica 34 62 28 74
3 Sporting CP Sporting CP 34 60 33 73
4 Nacional Nacional 34 56 35 56
5 Sporting Braga Sporting 34 36 38 54
6 Marítimo Marítimo 34 35 33 48
7 Rio Ave Rio Ave 34 42 37 48
8 Boavista Boavista 34 32 31 47
9 Moreirense Moreirense 34 33 33 46
10 União de Leiria União 34 43 45 45
11 Beira Mar SC Beira 34 36 45 41
12 Gil Vicente Gil Vicente 34 43 40 40
13 Académica Académica 34 40 42 38
14 Vitória Guimarães Vitória 34 31 40 37
15 Os Belenenses Belenenses 34 35 54 35
16 FC Alverca FC Alverca 34 33 49 35
17 Paços de Ferreira Paços 34 27 53 28
18 Estrela Amadora Estrela 34 22 74 17
TEMPORADA 2002/2003
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 73 26 86
2 Benfica Benfica 34 74 27 75
3 Sporting CP Sporting CP 34 52 38 59
4 Vitória Guimarães Vitória 34 47 46 50
5 União de Leiria União 34 49 47 49
6 Paços de Ferreira Paços 34 40 47 45
7 Marítimo Marítimo 34 36 48 44
8 Gil Vicente Gil Vicente 34 42 53 44
9 Os Belenenses Belenenses 34 47 48 43
10 Boavista Boavista 34 32 31 43
11 Nacional Nacional 34 40 46 40
12 Moreirense Moreirense 34 42 46 39
13 Beira Mar SC Beira 34 43 50 39
14 Sporting Braga Sporting 34 34 47 38
15 Académica Académica 34 38 48 37
16 Varzim Varzim 34 38 51 36
17 CD Santa Clara Santa Clara 34 39 54 35
18 Vitória Setúbal Vitória 34 40 53 31
TEMPORADA 2001/2002
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 34 74 25 75
2 Boavista Boavista 34 53 20 70
3 Porto Porto 34 66 34 68
4 Benfica Benfica 34 66 37 63
5 Os Belenenses Belenenses 34 54 44 57
6 Marítimo Marítimo 34 48 35 56
7 União de Leiria União 34 52 35 55
8 Paços de Ferreira Paços 34 41 44 46
9 Vitória Guimarães Vitória 34 35 41 42
10 Sporting Braga Sporting 34 43 43 42
11 Beira Mar SC Beira 34 48 56 39
12 Gil Vicente Gil Vicente 34 42 56 38
13 Vitória Setúbal Vitória 34 40 46 38
14 CD Santa Clara Santa Clara 34 32 46 37
15 Varzim Varzim 34 27 55 32
16 SC Salgueiros Salgueiros 34 29 71 30
17 Farense Farense 34 29 63 28
18 FC Alverca FC Alverca 34 39 67 27
TEMPORADA 2000/2001
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Boavista Boavista 34 63 22 77
2 Porto Porto 34 73 27 76
3 Sporting CP Sporting CP 34 56 37 62
4 Sporting Braga Sporting 34 58 48 57
5 União de Leiria União 34 46 41 56
6 Benfica Benfica 34 54 44 54
7 Os Belenenses Belenenses 34 43 36 52
8 Beira Mar SC Beira 34 45 49 49
9 Paços de Ferreira Paços 34 47 39 48
10 SC Salgueiros Salgueiros 34 41 55 43
11 Marítimo Marítimo 34 34 37 43
12 FC Alverca FC Alverca 34 45 52 43
13 Farense Farense 34 37 47 39
14 Gil Vicente Gil Vicente 34 34 41 37
15 Vitória Guimarães Vitória 34 41 49 36
16 Campomaiorense Campomaioren 34 29 58 32
17 Desportivo Aves Desportivo 34 31 68 22
18 Estrela Amadora Estrela 34 30 57 19
TEMPORADA 1999/2000
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 34 57 22 77
2 Porto Porto 34 66 26 73
3 Benfica Benfica 34 58 33 69
4 Boavista Boavista 34 40 31 55
5 Gil Vicente Gil Vicente 34 48 34 53
6 Marítimo Marítimo 34 42 36 50
7 Vitória Guimarães Vitória 34 48 43 48
8 Estrela Amadora Estrela 34 40 35 45
9 Sporting Braga Sporting 34 44 45 43
10 União de Leiria União 34 31 35 42
11 FC Alverca FC Alverca 34 39 48 41
12 Os Belenenses Belenenses 34 36 38 40
13 Campomaiorense Campomaioren 34 31 51 36
14 Farense Farense 34 35 60 35
15 SC Salgueiros Salgueiros 34 30 49 34
16 Vitória Setúbal Vitória 34 25 49 33
17 Rio Ave Rio Ave 34 34 54 33
18 CD Santa Clara Santa Clara 34 35 50 31

  USO DE MEMORIA  
8,076,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.9087
Total Execution Time  0.9104
  CADENA URL  
/historico/Boavista/2021
  GET DATOS  
$_GET['/historico/Boavista/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0165  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 = 'Boavista' AND l.year = 2021 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=513 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=513 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=513 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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=513 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0188  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 = 57339
0.0173  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 = 58721
0.0151  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=513 AND type_rel = 2
0.0169  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 513 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0159  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 (5372,5446,9568,9725,21449) ORDER BY n.cover_points DESC, update_date DESC
0.0155  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 = '513' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0158  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 = '513' 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 = 57339 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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 = 58721 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0168  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=513 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (66201,63795,63295,62807,62752) 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.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 62752 AND teamId = 513
0.0165  SELECT count(id) as num_players from rel_players WHERE league_id = 63795 AND teamId = 513
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 63295 AND teamId = 513
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 66201 AND teamId = 513
0.0244  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 513
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 `tables2021` 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 = 57339 AND t.round = 34 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 = '513' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '513' 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 = '513' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0165  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 events2021 e ON e.player_id = p.id AND e.league_id = 57339 WHERE rp.league_id = 57339 AND rp.teamId = 513 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.0161  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 events2021 e ON e.player_id = p.id AND e.league_id = 57339 WHERE rp.league_id = 57339 AND rp.teamId = 513 AND (e.action = 4 or e.action = 5) 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 events2021 e ON e.player_id = p.id AND e.league_id = 57339 WHERE rp.league_id = 57339 AND rp.teamId = 513 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 513 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2021` 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 = 57339 AND t.round = 34 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 `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 = 49945 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 43558 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 `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 = 38648 AND t.round = 34 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 `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 = 31005 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 `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 = 15394 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 `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 = 3797 AND t.round = 34 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 `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 = 2758 AND t.round = 18 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 `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 = 2171 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 `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 = 1700 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 `tables2009` 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 = 454 AND t.round = 30 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 `tables2008` 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 = 72 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 `tables2007` 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 = 106 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 `tables2006` 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 = 107 AND t.round = 34 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 `tables2005` 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 = 108 AND t.round = 34 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 `tables2004` 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 = 109 AND t.round = 34 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 `tables2003` 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 = 214 AND t.round = 34 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 `tables2002` 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 = 215 AND t.round = 34 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 `tables2001` 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 = 216 AND t.round = 34 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 `tables2000` 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 = 217 AND t.round = 34 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 = 57339 ORDER BY nameShow LIMIT 100