4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Criciúma

Criciúma

Entrenador: Cláudio Tencati

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Athletico Paranaense Athletico 5 7 3 10
2 Bahía Bahía 5 8 6 10
3 Atl. Mineiro Atl. Mineiro 5 9 3 9
4 Botafogo Botafogo 5 11 6 9
5 RB Bragantino Bragantino 5 7 5 9
6 Palmeiras Palmeiras 5 3 1 8
7 Flamengo Flamengo 5 5 5 8
8 São Paulo São Paulo 5 8 5 7
9 Internacional Internaciona 4 4 3 7
10 Cruzeiro Cruzeiro 4 7 7 7
11 Fortaleza EC Fortaleza 4 4 3 6
12 Grêmio Grêmio 4 4 3 6
13 Criciúma Criciúma 3 6 2 5
14 Corinthians Corinthians 5 3 3 5
15 EC Juventude Juventude 4 5 7 5
16 Fluminense Fluminense 5 7 10 5
17 Vasco da Gama Vasco Gama 5 4 10 3
18 Vitória Vitória 4 4 9 1
19 Atlético GO Atlético 4 2 7 1
20 Cuiabá Cuiabá 4 0 10 0
TEMPORADA 2022/2023
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Vitória Vitória 38 50 31 72
2 EC Juventude Juventude 38 42 31 65
3 Criciúma Criciúma 38 45 33 64
4 Atlético GO Atlético 38 56 45 64
5 Novorizontino Novorizontin 38 48 30 63
6 Mirassol Mirassol 38 42 31 63
7 Sport Recife Sport Recife 38 59 40 63
8 Vila Nova Vila Nova 38 49 30 61
9 CRB CRB 38 45 39 57
10 Guaraní Guaraní 38 42 33 57
11 Ceará Ceará 38 40 45 50
12 Botafogo SP Botafogo SP 38 25 42 47
13 Avaí Avaí 38 31 48 44
14 Ituano Ituano 38 33 38 42
15 Ponte Preta Ponte Preta 38 24 35 42
16 Chapecoense Chapecoense 38 38 43 40
17 Sampaio Correa Sampaio 38 31 43 39
18 Tombense Tombense 38 37 50 37
19 Londrina Londrina 38 31 58 31
20 ABC ABC 38 28 51 28
TEMPORADA 2021/2022
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Cruzeiro Cruzeiro 38 57 26 78
2 Grêmio Grêmio 38 50 26 65
3 Bahía Bahía 38 43 29 62
4 Vasco da Gama Vasco Gama 38 48 36 62
5 Sampaio Correa Sampaio 38 48 42 58
6 Ituano Ituano 38 42 34 57
7 Sport Recife Sport Recife 38 37 31 57
8 Criciúma Criciúma 38 43 31 56
9 Londrina Londrina 38 36 37 53
10 Guaraní Guaraní 38 33 36 51
11 CRB CRB 38 35 43 50
12 Ponte Preta Ponte Preta 38 34 36 49
13 Vila Nova Vila Nova 38 28 31 47
14 Chapecoense Chapecoense 38 37 39 45
15 Tombense Tombense 38 38 47 45
16 Novorizontino Novorizontin 38 44 49 44
17 CSA CSA 38 29 37 42
18 Brusque Brusque 38 21 38 34
19 Operário PR Operário 38 31 53 34
20 Náutico Náutico 38 32 65 30
TEMPORADA 2020/2021
SERIE C - BRASIL GRUPO 3
Equipo PJ GF GC Puntos
1 Ituano Ituano 6 11 5 13
2 Criciúma Criciúma 6 3 1 9
3 Botafogo PB Botafogo PB 6 3 4 8
4 Paysandu Paysandu 6 2 9 2
5 Tombense Tombense 6 8 6 11
6 Novorizontino Novorizontin 6 7 10 9
7 Manaus Manaus 6 10 8 6
8 Ypiranga FC Ypiranga FC 6 6 7 6
TEMPORADA 2019/2020
SERIE C - BRASIL GRUPO 2
Equipo PJ GF GC Puntos
1 Ypiranga FC Ypiranga FC 18 31 26 31
2 Londrina Londrina 18 20 16 29
3 Ituano Ituano 18 28 20 29
4 Brusque Brusque 18 23 26 29
5 Tombense Tombense 18 21 18 27
6 Volta Redonda Volta 18 31 23 23
7 EC São José São José 18 15 23 20
8 Criciúma Criciúma 18 20 25 19
9 São Bento São Bento 18 13 19 17
10 Boa EC Boa EC 18 17 23 15
TEMPORADA 2018/2019
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 RB Bragantino Bragantino 38 64 27 75
2 Sport Recife Sport Recife 38 49 29 68
3 Coritiba Coritiba 38 48 34 66
4 Atlético GO Atlético 38 44 29 62
5 América Mineiro América 38 42 34 61
6 Paraná Paraná 38 34 33 56
7 CRB CRB 38 44 43 55
8 Cuiabá Cuiabá 38 42 40 52
9 Botafogo SP Botafogo SP 38 38 38 50
10 Operário PR Operário 38 32 40 50
11 Ponte Preta Ponte Preta 38 41 39 47
12 Vitória Vitória 38 42 48 45
13 Guaraní Guaraní 38 27 37 44
14 Brasil de Pelotas Brasil 38 31 47 44
15 Oeste Oeste 38 41 49 41
16 Figueirense Figueirense 38 31 38 41
17 Londrina Londrina 38 37 53 39
18 São Bento São Bento 38 46 54 39
19 Criciúma Criciúma 38 30 38 39
20 Vila Nova Vila Nova 38 27 40 39
TEMPORADA 2017/2018
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 38 54 33 71
2 CSA CSA 38 51 37 62
3 Avaí Avaí 38 50 32 61
4 Goiás EC Goiás EC 38 54 50 60
5 Ponte Preta Ponte Preta 38 42 30 60
6 Atlético GO Atlético 38 57 51 59
7 Vila Nova Vila Nova 38 41 36 57
8 Londrina Londrina 38 45 42 55
9 Guaraní Guaraní 38 44 39 54
10 Coritiba Coritiba 38 40 44 52
11 Brasil de Pelotas Brasil 38 36 35 50
12 CRB CRB 38 35 39 48
13 São Bento São Bento 38 41 41 47
14 Criciúma Criciúma 38 45 49 47
15 Figueirense Figueirense 38 48 51 46
16 Oeste Oeste 38 36 40 46
17 Paysandu Paysandu 38 42 53 43
18 Sampaio Correa Sampaio 38 32 47 38
19 EC Juventude Juventude 38 27 48 35
20 Boa EC Boa EC 38 26 49 30
TEMPORADA 2016/2017
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 América Mineiro América 38 46 25 73
2 Internacional Internaciona 38 54 26 71
3 Ceará Ceará 38 46 32 67
4 Paraná Paraná 38 49 28 64
5 Londrina Londrina 38 56 46 62
6 Oeste Oeste 38 43 31 59
7 Vila Nova Vila Nova 38 38 30 58
8 Brasil de Pelotas Brasil 38 43 50 51
9 EC Juventude Juventude 38 35 38 51
10 Boa EC Boa EC 38 40 42 50
11 Paysandu Paysandu 38 41 41 48
12 Figueirense Figueirense 38 44 49 48
13 Criciúma Criciúma 38 41 46 48
14 Goiás EC Goiás EC 38 35 46 45
15 CRB CRB 38 35 50 45
16 Guaraní Guaraní 38 36 46 44
17 Luverdense Luverdense 38 38 40 44
18 Santa Cruz Santa Cruz 38 43 54 37
19 ABC ABC 38 28 49 34
20 Náutico Náutico 38 29 51 32
TEMPORADA 2015/2016
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Atlético GO Atlético 38 60 35 76
2 Avaí Avaí 38 45 34 66
3 Vasco da Gama Vasco Gama 38 54 41 65
4 Bahía Bahía 38 57 34 63
5 Náutico Náutico 38 55 43 60
6 Londrina Londrina 38 40 29 60
7 CRB CRB 38 57 54 58
8 Criciúma Criciúma 38 49 46 56
9 Luverdense Luverdense 38 43 39 55
10 Ceará Ceará 38 49 47 54
11 Brasil de Pelotas Brasil 38 40 38 54
12 Vila Nova Vila Nova 38 54 52 53
13 Goiás EC Goiás EC 38 49 48 50
14 Paysandu Paysandu 38 40 44 49
15 Paraná Paraná 38 39 55 41
16 Oeste Oeste 38 32 46 41
17 Joinville Joinville 38 32 42 40
18 Tupi Tupi 38 40 56 33
19 RB Bragantino Bragantino 38 30 54 32
20 Sampaio Correa Sampaio 38 29 57 27
TEMPORADA 2014/2015
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Botafogo Botafogo 38 60 30 72
2 Santa Cruz Santa Cruz 38 63 43 67
3 Vitória Vitória 38 58 40 66
4 América Mineiro América 38 55 39 65
5 Náutico Náutico 38 49 42 63
6 RB Bragantino Bragantino 38 56 56 60
7 Paysandu Paysandu 38 49 40 60
8 Sampaio Correa Sampaio 38 51 43 58
9 Bahía Bahía 38 48 41 58
10 Luverdense Luverdense 38 46 40 54
11 CRB CRB 38 47 45 54
12 Criciúma Criciúma 38 36 41 49
13 Paraná Paraná 38 39 43 47
14 Atlético GO Atlético 38 36 46 46
15 Ceará Ceará 38 42 50 45
16 Oeste Oeste 38 37 45 44
17 Macaé Esporte Macaé 38 46 54 43
18 ABC ABC 38 41 64 32
19 Boa EC Boa EC 38 34 54 31
20 Mogi Mirim Mogi Mirim 38 32 69 23
TEMPORADA 2013/2014
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Cruzeiro Cruzeiro 38 67 38 80
2 São Paulo São Paulo 38 59 40 70
3 Internacional Internaciona 38 53 41 69
4 Corinthians Corinthians 38 49 31 69
5 Atl. Mineiro Atl. Mineiro 38 51 38 62
6 Fluminense Fluminense 38 61 42 61
7 Grêmio Grêmio 38 36 24 61
8 Athletico Paranaense Athletico 38 43 42 54
9 Santos FC Santos FC 38 42 35 53
10 Flamengo Flamengo 38 46 47 52
11 Sport Recife Sport Recife 38 36 46 52
12 Goiás EC Goiás EC 38 38 40 47
13 Figueirense Figueirense 38 37 47 47
14 Coritiba Coritiba 38 42 45 47
15 Chapecoense Chapecoense 38 39 44 43
16 Palmeiras Palmeiras 38 34 59 40
17 Vitória Vitória 38 37 54 38
18 Bahía Bahía 38 31 43 37
19 Botafogo Botafogo 38 31 48 34
20 Criciúma Criciúma 38 28 56 32
TEMPORADA 2012/2013
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Cruzeiro Cruzeiro 38 77 37 76
2 Grêmio Grêmio 38 42 35 65
3 Athletico Paranaense Athletico 38 65 49 64
4 Botafogo Botafogo 38 55 41 61
5 Vitória Vitória 38 59 53 59
6 Goiás EC Goiás EC 38 48 44 59
7 Santos FC Santos FC 38 51 38 57
8 Atl. Mineiro Atl. Mineiro 38 49 38 57
9 São Paulo São Paulo 38 39 40 50
10 Corinthians Corinthians 38 27 22 50
11 Flamengo Flamengo 38 43 46 49
12 Portuguesa Portuguesa 38 50 46 48
13 Coritiba Coritiba 38 42 45 48
14 Bahía Bahía 38 37 45 48
15 Internacional Internaciona 38 51 52 48
16 Criciúma Criciúma 38 49 63 46
17 Fluminense Fluminense 38 43 47 46
18 Vasco da Gama Vasco Gama 38 50 61 44
19 Ponte Preta Ponte Preta 38 37 55 37
20 Náutico Náutico 38 22 79 20
TEMPORADA 2011/2012
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Goiás EC Goiás EC 38 75 37 78
2 Criciúma Criciúma 38 78 57 73
3 Athletico Paranaense Athletico 38 65 37 71
4 Vitória Vitória 38 59 43 71
5 São Caetano São Caetano 38 58 38 71
6 Joinville Joinville 38 58 40 60
7 Avaí Avaí 38 44 42 59
8 América Mineiro América 38 63 58 55
9 América RN América RN 38 60 61 54
10 Paraná Paraná 38 50 47 52
11 Ceará Ceará 38 51 52 47
12 ABC ABC 38 50 52 45
13 ASA Arapiraquense Arapiraquens 38 48 56 44
14 RB Bragantino Bragantino 38 45 53 44
15 Boa EC Boa EC 38 51 63 44
16 Guaratinguetá Guaratinguet 38 41 63 43
17 CRB CRB 38 47 67 42
18 Guaraní Guaraní 38 36 47 41
19 Ipatinga FC Ipatinga FC 38 38 73 31
20 Grêmio Barueri Grêmio 38 38 69 30
TEMPORADA 2010/2011
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Portuguesa Portuguesa 38 82 38 81
2 Náutico Náutico 38 51 41 64
3 Ponte Preta Ponte Preta 38 63 45 63
4 Sport Recife Sport Recife 38 62 44 61
5 Vitória Vitória 38 61 48 60
6 RB Bragantino Bragantino 38 65 53 58
7 Boa EC Boa EC 38 44 40 57
8 Guaratinguetá Guaratinguet 38 40 45 56
9 Grêmio Barueri Grêmio 38 48 53 53
10 ABC ABC 38 52 53 53
11 Goiás EC Goiás EC 38 51 57 52
12 Guaraní Guaraní 38 51 48 52
13 Paraná Paraná 38 48 44 52
14 Criciúma Criciúma 38 43 43 51
15 São Caetano São Caetano 38 57 51 51
16 ASA Arapiraquense Arapiraquens 38 44 54 48
17 Icasa Icasa 38 52 55 47
18 Vila Nova Vila Nova 38 34 53 32
19 Salgueiro Salgueiro 38 32 63 29
20 Duque de Caxias Duque Caxias 38 32 84 17
TEMPORADA 2009/2010
SERIE C - BRASIL
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 8 15 9 14
2 Aguia de Maraba Aguia Maraba 8 11 7 12
3 Fortaleza EC Fortaleza 8 9 7 12
4 Rio Branco Acre Branco Acre 8 12 17 10
5 São Raimundo AM São 8 8 15 3
6 ABC ABC 8 11 6 12
7 Salgueiro Salgueiro 8 11 12 11
8 CRB CRB 8 8 11 11
9 Campinense Campinense 8 7 7 10
10 Alecrim Alecrim 8 9 10 10
11 Boa EC Boa EC 8 9 4 15
12 Macaé Esporte Macaé 8 12 8 14
13 Luverdense Luverdense 8 12 10 12
14 Marília Marília 8 7 12 6
15 Gama Gama 8 5 11 5
16 Criciúma Criciúma 8 7 4 12
17 Chapecoense Chapecoense 8 9 9 11
18 Caxias do Sul Caxias 8 6 6 10
19 Brasil de Pelotas Brasil 8 4 5 10
20 EC Juventude Juventude 8 6 8 8
TEMPORADA 2008/2009
SERIE C - BRASIL
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 8 15 12 12
2 Paysandu Paysandu 8 11 12 12
3 Aguia de Maraba Aguia Maraba 8 12 12 11
4 Luverdense Luverdense 8 8 9 11
5 Sampaio Correa Sampaio 8 10 11 9
6 Icasa Icasa 8 15 4 17
7 ASA Arapiraquense Arapiraquens 8 13 7 16
8 Salgueiro Salgueiro 8 8 12 13
9 CRB CRB 8 8 12 6
10 Confiança Confiança 8 9 18 6
11 América Mineiro América 8 12 6 16
12 Guaratinguetá Guaratinguet 8 15 12 15
13 Boa EC Boa EC 8 13 8 11
14 Gama Gama 8 11 14 8
15 Mixto Mixto 8 8 19 7
16 Caxias do Sul Caxias 8 10 6 16
17 Brasil de Pelotas Brasil 8 12 9 16
18 Marília Marília 8 14 8 15
19 Criciúma Criciúma 8 6 12 7
20 Marcílio Dias Marcílio 8 12 19 3
TEMPORADA 2007/2008
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Corinthians Corinthians 38 79 29 85
2 Santo André Santo André 38 71 45 68
3 Avaí Avaí 38 71 40 67
4 Grêmio Barueri Grêmio 38 58 55 63
5 Ponte Preta Ponte Preta 38 54 46 58
6 Vila Nova Vila Nova 38 57 55 58
7 RB Bragantino Bragantino 38 47 41 57
8 EC Juventude Juventude 38 51 48 56
9 São Caetano São Caetano 38 61 55 54
10 Bahía Bahía 38 47 65 52
11 Paraná Paraná 38 49 54 49
12 Ceará Ceará 38 52 50 49
13 ABC ABC 38 55 57 48
14 Brasiliense Brasiliense 38 56 64 47
15 América RN América RN 38 46 51 46
16 Fortaleza EC Fortaleza 38 56 56 45
17 Marília Marília 38 47 60 45
18 Criciúma Criciúma 38 40 54 41
19 Gama Gama 38 37 72 35
20 CRB CRB 38 35 72 24
TEMPORADA 2006/2007
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Coritiba Coritiba 38 54 41 69
2 Ipatinga FC Ipatinga FC 38 60 41 67
3 Portuguesa Portuguesa 38 63 46 63
4 Vitória Vitória 38 68 50 59
5 Fortaleza EC Fortaleza 38 51 46 56
6 Marília Marília 38 66 61 53
7 Criciúma Criciúma 38 51 44 53
8 CRB CRB 38 54 62 53
9 Brasiliense Brasiliense 38 57 53 53
10 São Caetano São Caetano 38 45 39 53
11 Ponte Preta Ponte Preta 38 58 55 52
12 Gama Gama 38 53 56 51
13 Grêmio Barueri Grêmio 38 57 71 51
14 Santo André Santo André 38 51 50 51
15 Avaí Avaí 38 52 55 51
16 Ceará Ceará 38 58 58 50
17 Paulista Paulista 38 58 61 45
18 Santa Cruz Santa Cruz 38 47 65 42
19 Remo Remo 38 53 69 36
20 Ituano Ituano 38 41 74 33
TEMPORADA 2005/2006
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Tuna Luso Tuna Luso 4 9 4 10
2 Rio Negro AM Negro 4 7 8 4
3 ADESG ADESG 4 3 7 3
4 Fast Clube Fast Clube 6 7 3 13
5 Ananindeua Ananindeua 6 12 8 10
6 Amapá Clube Amapá Clube 6 7 11 5
7 São Raimundo RR São 6 5 9 5
8 Operário MT Operário 6 8 6 9
9 Mixto Mixto 6 6 6 9
10 Araguaína Araguaína 6 6 8 7
11 SC Ulbra SC Ulbra 6 7 7 0
12 Ríver Ríver 6 12 4 13
13 Maranhão Maranhão 6 8 6 10
14 Imperatriz Imperatriz 6 6 4 8
15 Flamengo PI Flamengo PI 6 3 15 2
16 Icasa Icasa 6 13 7 12
17 CA Porto CA Porto 6 10 8 11
18 Baraunas Baraunas 6 8 12 5
19 Botafogo PB Botafogo PB 6 8 12 4
20 Ferroviário Ferroviário 6 9 9 10
21 Treze Treze 6 7 5 9
22 Potiguar Mossoró Potiguar 6 6 3 8
23 Ypiranga PE Ypiranga PE 6 6 11 0
24 Bahía Bahía 6 12 7 13
25 Confiança Confiança 6 8 7 9
26 CSA CSA 6 8 10 5
27 Colo Colo BA Colo Colo 6 8 12 5
28 Vitória Vitória 6 10 5 11
29 Coruripe Coruripe 6 9 7 11
30 Olímpico Pirambú Olímpico 6 7 8 7
31 Ipitanga Ipitanga 6 5 11 4
32 Jataiense Jataiense 6 12 6 12
33 Anapolina Anapolina 6 13 6 10
34 Luziânia Luziânia 6 5 15 4
35 Coxim Coxim 6 4 7 0
36 Boa EC Boa EC 6 8 2 13
37 Atlético GO Atlético 6 6 6 8
38 Chapadão Chapadão 6 3 5 7
39 Ceilândia Ceilândia 6 5 9 0
40 América Mineiro América 6 10 4 15
41 Grêmio Barueri Grêmio 6 7 4 13
42 Vitória ES Vitória ES 6 5 9 4
43 América RJ América RJ 6 4 9 2
44 Americano Americano 6 9 5 14
45 Ipatinga FC Ipatinga FC 6 6 4 10
46 CA Juventus CA Juventus 6 7 9 4
47 Estrela do Norte Estrela 6 5 9 0
48 Cabofriense Cabofriense 6 10 6 11
49 Rio Branco SP Branco 6 13 8 10
50 Madureira RJ Madureira 6 8 7 7
51 União Barbarense União 6 5 15 6
52 J. Malucelli Malucelli 6 8 4 10
53 Noroeste Noroeste 6 5 4 9
54 Campo Mourão Campo 6 4 5 7
55 América SP América SP 6 3 7 5
56 Joinville Joinville 6 8 4 11
57 Canoas SC Canoas SC 6 7 5 10
58 Caxias do Sul Caxias 6 8 7 7
59 Rio Branco PR Branco 6 3 10 4
60 Brasil de Pelotas Brasil 6 10 8 15
61 Criciúma Criciúma 6 20 9 13
62 Novo Hamburgo Novo 6 7 14 7
63 Marcílio Dias Marcílio 6 7 13 0

  USO DE MEMORIA  
8,503,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1780
Total Execution Time  0.1792
  CADENA URL  
/historico/Criciuma-Ec
  GET DATOS  
$_GET['/historico/Criciuma-Ec']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0032  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 = 'Criciuma-Ec' 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=853 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=853 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=853 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=853 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=853 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 75215
0.0023  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 = 74836
0.0023  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 = 75524
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=853 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 853 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (11246,22157,59651,66476,68645) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '853' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '853' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 74820 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 74836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 75215 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=853 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75524,75215,74820,70806) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74820 AND teamId = 853
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70806 AND teamId = 853
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 75215 AND teamId = 853
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75524 AND teamId = 853
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 74820 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '853' 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 = '853' 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 = '853' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 74820 WHERE rp.league_id = 74820 AND rp.teamId = 853 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.0031  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 = 74820 WHERE rp.league_id = 74820 AND rp.teamId = 853 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 74820 WHERE rp.league_id = 74820 AND rp.teamId = 853 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 853 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70806 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 62012 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 64663 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 55526 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 48487 AND t.round = 38 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 `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 = 42647 AND t.round = 38 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 `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 = 37757 AND t.round = 38 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 `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 = 20238 AND t.round = 38 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 `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 = 3603 AND t.round = 38 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 `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 = 2300 AND t.round = 38 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 `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 = 1624 AND t.round = 38 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 `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 = 1379 AND t.round = 38 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 `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 = 12978 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 12979 AND t.round = 8 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 `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 = 12940 AND t.round = 38 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 `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 = 12941 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 12990 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 74820 ORDER BY nameShow LIMIT 100