TEMPORADA 2023/2024
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 25 75 25 65
2 Benfica Benfica 26 60 21 64
3 Porto Porto 26 50 18 58
4 Sporting Braga Sporting 26 55 34 53
5 Vitória Guimarães Vitória 26 41 27 50
6 Moreirense Moreirense 26 28 27 42
7 Arouca Arouca 26 43 37 34
8 Gil Vicente Gil Vicente 26 35 39 28
9 Famalicão Famalicão 25 24 30 28
10 Boavista Boavista 26 33 51 28
11 Farense Farense 26 34 38 27
12 Casa Pia AC Casa Pia AC 26 23 39 27
13 Estrela da Amadora Estrela 26 26 39 26
14 Estoril Estoril 26 42 49 25
15 Rio Ave Rio Ave 26 26 35 25
16 Portimonense Portimonense 26 24 53 23
17 Vizela Vizela 26 26 52 21
18 Chaves Chaves 26 25 56 19
TEMPORADA 2022/2023
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 82 20 87
2 Porto Porto 34 73 22 85
3 Sporting Braga Sporting 34 75 30 78
4 Sporting CP Sporting CP 34 71 32 74
5 Arouca Arouca 34 36 37 54
6 Vitória Guimarães Vitória 34 34 39 53
7 Chaves Chaves 34 35 40 46
8 Famalicão Famalicão 34 39 47 44
9 Boavista Boavista 34 43 54 44
10 Casa Pia AC Casa Pia AC 34 31 40 41
11 Vizela Vizela 34 34 38 40
12 Rio Ave Rio Ave 34 36 43 40
13 Gil Vicente Gil Vicente 34 32 41 37
14 Estoril Estoril 34 33 49 35
15 Portimonense Portimonense 34 25 48 34
16 Marítimo Marítimo 34 32 63 26
17 Paços de Ferreira Paços 34 26 62 23
18 CD Santa Clara Santa Clara 34 26 58 22
TEMPORADA 2021/2022
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 86 22 91
2 Sporting CP Sporting CP 34 73 23 85
3 Benfica Benfica 34 78 30 74
4 Sporting Braga Sporting 34 52 31 65
5 Gil Vicente Gil Vicente 34 47 42 51
6 Vitória Guimarães Vitória 34 50 41 48
7 CD Santa Clara Santa Clara 34 38 54 40
8 Famalicão Famalicão 34 45 51 39
9 Estoril Estoril 34 36 43 39
10 Marítimo Marítimo 34 39 44 38
11 Paços de Ferreira Paços 34 29 44 38
12 Boavista Boavista 34 39 52 38
13 Portimonense Portimonense 34 31 45 38
14 Vizela Vizela 34 37 58 33
15 Arouca Arouca 34 30 54 31
16 Moreirense Moreirense 34 33 51 29
17 Tondela Tondela 34 41 67 28
18 Belenenses SAD Belenenses 34 23 55 26
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 Portimonense Portimonense 34 44 59 39
12 Marítimo Marítimo 34 26 44 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 Moreirense Moreirense 34 29 50 32
15 Vitória Setúbal Vitória 34 39 62 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 Tondela Tondela 34 34 54 30
16 Vitória Setúbal Vitória 34 40 61 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 Académica Académica 34 26 46 29
15 Vitória Setúbal Vitória 34 24 56 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
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 58 18 74
2 Sporting CP Sporting CP 30 54 20 67
3 Porto Porto 30 57 25 61
4 Estoril Estoril 30 42 26 54
5 Nacional Nacional 30 43 33 45
6 Marítimo Marítimo 30 40 44 41
7 Vitória Setúbal Vitória 30 41 41 39
8 Sporting Braga Sporting 30 39 37 37
9 Académica Académica 30 25 35 37
10 Vitória Guimarães Vitória 30 30 35 35
11 Rio Ave Rio Ave 30 21 35 32
12 Arouca Arouca 30 28 42 31
13 Gil Vicente Gil Vicente 30 23 37 31
14 Os Belenenses Belenenses 30 19 33 28
15 Olhanense Olhanense 30 21 49 24
16 Paços de Ferreira Paços 30 28 59 24
TEMPORADA 2012/2013
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 70 14 78
2 Benfica Benfica 30 77 20 77
3 Paços de Ferreira Paços 30 42 29 54
4 Sporting Braga Sporting 30 60 44 52
5 Estoril Estoril 30 47 37 45
6 Rio Ave Rio Ave 30 35 42 42
7 Sporting CP Sporting CP 30 36 36 42
8 Nacional Nacional 30 45 51 40
9 Vitória Guimarães Vitória 30 36 47 40
10 Marítimo Marítimo 30 34 45 38
11 Académica Académica 30 33 45 28
12 Vitória Setúbal Vitória 30 30 55 26
13 Gil Vicente Gil Vicente 30 31 54 25
14 Olhanense Olhanense 30 26 42 25
15 Moreirense Moreirense 30 30 51 24
16 Beira Mar SC Beira 30 35 55 23
TEMPORADA 2011/2012
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 69 19 75
2 Benfica Benfica 30 66 27 69
3 Sporting Braga Sporting 30 59 29 62
4 Sporting CP Sporting CP 30 47 26 59
5 Marítimo Marítimo 30 41 38 50
6 Vitória Guimarães Vitória 30 40 40 45
7 Nacional Nacional 30 48 50 44
8 Olhanense Olhanense 30 36 38 39
9 Gil Vicente Gil Vicente 30 31 42 34
10 Paços de Ferreira Paços 30 35 53 31
11 Vitória Setúbal Vitória 30 24 49 30
12 Beira Mar SC Beira 30 26 38 29
13 Académica Académica 30 27 38 29
14 Rio Ave Rio Ave 30 33 42 28
15 Feirense Feirense 30 27 49 24
16 União de Leiria União 30 25 56 19
TEMPORADA 2010/2011
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 73 16 84
2 Benfica Benfica 30 61 31 63
3 Sporting CP Sporting CP 30 41 31 48
4 Sporting Braga Sporting 30 45 33 46
5 Vitória Guimarães Vitória 30 36 37 43
6 Nacional Nacional 30 28 31 42
7 Paços de Ferreira Paços 30 35 42 41
8 Rio Ave Rio Ave 30 35 33 38
9 Marítimo Marítimo 30 33 32 35
10 União de Leiria União 30 25 38 35
11 Olhanense Olhanense 30 24 34 34
12 Vitória Setúbal Vitória 30 29 42 34
13 Beira Mar SC Beira 30 32 36 33
14 Académica Académica 30 32 48 30
15 Portimonense Portimonense 30 29 49 25
16 Naval Naval 30 26 51 23
TEMPORADA 2009/2010
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 78 20 76
2 Sporting Braga Sporting 30 48 20 71
3 Porto Porto 30 70 26 68
4 Sporting CP Sporting CP 30 42 26 48
5 Marítimo Marítimo 30 42 43 41
6 Vitória Guimarães Vitória 30 31 34 41
7 Nacional Nacional 30 36 46 39
8 Naval Naval 30 20 35 36
9 União de Leiria União 30 35 41 35
10 Paços de Ferreira Paços 30 32 37 35
11 Académica Académica 30 37 42 33
12 Rio Ave Rio Ave 30 22 33 31
13 Olhanense Olhanense 30 31 46 29
14 Vitória Setúbal Vitória 30 29 57 25
15 Os Belenenses Belenenses 30 23 44 23
16 Leixões Leixões 30 25 51 21
TEMPORADA 2008/2009
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 61 18 70
2 Sporting CP Sporting CP 30 45 20 66
3 Benfica Benfica 30 54 32 59
4 Nacional Nacional 30 47 32 52
5 Sporting Braga Sporting 30 38 21 50
6 Leixões Leixões 30 30 31 45
7 Académica Académica 30 28 32 39
8 Vitória Guimarães Vitória 30 32 36 38
9 Marítimo Marítimo 30 35 36 37
10 Paços de Ferreira Paços 30 37 42 34
11 Estrela Amadora Estrela 30 26 38 34
12 Rio Ave Rio Ave 30 20 35 30
13 Naval Naval 30 25 39 29
14 Vitória Setúbal Vitória 30 21 46 26
15 Os Belenenses Belenenses 30 28 52 24
16 Trofense Trofense 30 25 42 23
TEMPORADA 2007/2008
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 30 60 13 69
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 Os Belenenses Belenenses 30 37 31 43
8 Sporting Braga Sporting 30 32 34 41
9 Boavista Boavista 30 32 41 36
10 Nacional Nacional 30 23 28 35
11 Académica Académica 30 31 38 32
12 Estrela Amadora Estrela 30 29 41 31
13 Naval Naval 30 24 47 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
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
8,842,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2260
Total Execution Time  0.2272
  CADENA URL  
/historico/Sporting-Braga
  GET DATOS  
$_GET['/historico/Sporting-Braga']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (60)  
0.0039  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 = 2024 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.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 72095
0.0024  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 = 72097
0.0024  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 = 74073
0.0022  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 = 74982
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 2
0.0027  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.0021  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.0062  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' ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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.0019  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 = 72095 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  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 = 73859 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 74073 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0064  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (74982,74791,73859,73560,72097,72053,71432,70410) 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.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 72053 AND teamId = 2386
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73859 AND teamId = 2386
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 74791 AND teamId = 2386
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 70410 AND teamId = 2386
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72097 AND teamId = 2386
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 2386
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 74982 AND teamId = 2386
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2386
0.0023  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2386' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2386' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2386' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043  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 events2024 e ON e.player_id = p.id AND e.league_id = 72053 WHERE rp.league_id = 72053 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.0036  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 events2024 e ON e.player_id = p.id AND e.league_id = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 events2024 e ON e.player_id = p.id AND e.league_id = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0049  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 67687 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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 62752 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.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0027  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.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0031  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.0029  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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 2503 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 1931 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 1349 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 1108 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 867 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 152 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0027  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.0028  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.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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