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

Fortaleza EC

Entrenador: Juan Vojvoda

Temporada 2020/2021
TEMPORADA 2020/2021
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Atl. Mineiro Atl. Mineiro 38 67 34 84
2 Flamengo Flamengo 38 69 36 71
3 Palmeiras Palmeiras 38 58 43 66
4 Fortaleza EC Fortaleza 38 44 45 58
5 Corinthians Corinthians 38 40 36 57
6 RB Bragantino Bragantino 38 55 46 56
7 Fluminense Fluminense 38 38 38 54
8 América Mineiro América 38 41 37 53
9 Atlético GO Atlético 38 33 36 53
10 Santos FC Santos FC 38 35 40 50
11 Ceará Ceará 38 39 38 50
12 Internacional Internaciona 38 44 42 48
13 São Paulo São Paulo 38 31 39 48
14 Athletico Paranaense Athletico 38 41 45 47
15 Cuiabá Cuiabá 38 34 37 47
16 EC Juventude Juventude 38 36 44 46
17 Grêmio Grêmio 38 44 51 43
18 Bahía Bahía 38 42 51 43
19 Sport Recife Sport Recife 38 24 37 38
20 Chapecoense Chapecoense 38 27 67 15
TEMPORADA 2019/2020
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Flamengo Flamengo 38 68 48 71
2 Internacional Internaciona 38 61 35 70
3 Atl. Mineiro Atl. Mineiro 38 64 45 68
4 São Paulo São Paulo 38 59 41 66
5 Fluminense Fluminense 38 55 42 64
6 Grêmio Grêmio 38 53 40 59
7 Palmeiras Palmeiras 38 51 37 58
8 Santos FC Santos FC 38 52 51 54
9 Athletico Paranaense Athletico 38 38 36 53
10 RB Bragantino Bragantino 38 50 40 53
11 Ceará Ceará 38 54 51 52
12 Corinthians Corinthians 38 45 45 51
13 Atlético GO Atlético 38 40 45 50
14 Bahía Bahía 38 48 59 44
15 Sport Recife Sport Recife 38 31 50 42
16 Fortaleza EC Fortaleza 38 34 44 41
17 Vasco da Gama Vasco Gama 38 37 56 41
18 Goiás EC Goiás EC 38 41 63 37
19 Coritiba Coritiba 38 31 54 31
20 Botafogo Botafogo 38 32 62 27
TEMPORADA 2018/2019
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Flamengo Flamengo 38 86 37 90
2 Santos FC Santos FC 38 60 33 74
3 Palmeiras Palmeiras 38 61 32 74
4 Grêmio Grêmio 38 64 39 65
5 Athletico Paranaense Athletico 38 51 32 64
6 São Paulo São Paulo 38 39 30 63
7 Internacional Internaciona 38 44 39 57
8 Corinthians Corinthians 38 42 34 56
9 Fortaleza EC Fortaleza 38 50 49 53
10 Goiás EC Goiás EC 38 46 64 52
11 Bahía Bahía 38 44 43 49
12 Vasco da Gama Vasco Gama 38 39 45 49
13 Atl. Mineiro Atl. Mineiro 38 45 49 48
14 Fluminense Fluminense 38 38 46 46
15 Botafogo Botafogo 38 31 45 43
16 Ceará Ceará 38 36 41 39
17 Cruzeiro Cruzeiro 38 27 46 36
18 CSA CSA 38 24 58 32
19 Chapecoense Chapecoense 38 31 52 32
20 Avaí Avaí 38 18 62 20
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 C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Sampaio Correa Sampaio 18 24 20 32
2 CSA CSA 18 21 12 32
3 Fortaleza EC Fortaleza 18 20 15 27
4 Confiança Confiança 18 23 25 25
5 Salgueiro Salgueiro 18 19 16 24
6 Cuiabá Cuiabá 18 17 17 23
7 Remo Remo 18 19 21 22
8 Botafogo PB Botafogo PB 18 18 21 21
9 Moto Club MA Moto Club 18 18 20 20
10 ASA Arapiraquense Arapiraquens 18 11 23 13
TEMPORADA 2015/2016
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 26 17 30
2 ABC ABC 18 24 15 30
3 Botafogo PB Botafogo PB 18 19 13 28
4 ASA Arapiraquense Arapiraquens 18 16 15 26
5 Remo Remo 18 21 20 25
6 Confiança Confiança 18 22 26 22
7 Cuiabá Cuiabá 18 19 17 22
8 Salgueiro Salgueiro 18 13 18 21
9 América RN América RN 18 17 23 20
10 Ríver Ríver 18 13 26 13
TEMPORADA 2014/2015
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 30 14 36
2 ASA Arapiraquense Arapiraquens 18 24 17 35
3 Vila Nova Vila Nova 18 24 13 33
4 Confiança Confiança 18 25 16 31
5 América RN América RN 18 23 17 29
6 Botafogo PB Botafogo PB 18 25 30 23
7 Salgueiro Salgueiro 18 17 20 19
8 Cuiabá Cuiabá 18 20 25 19
9 Aguia de Maraba Aguia Maraba 18 19 28 15
10 Icasa Icasa 18 15 42 7
TEMPORADA 2013/2014
SERIE C - BRASIL
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 23 11 35
2 CRB CRB 18 23 17 27
3 Salgueiro Salgueiro 18 20 22 27
4 Paysandu Paysandu 18 21 17 26
5 ASA Arapiraquense Arapiraquens 18 23 22 25
6 Botafogo PB Botafogo PB 18 20 19 25
7 Cuiabá Cuiabá 18 19 19 23
8 Aguia de Maraba Aguia Maraba 18 21 25 20
9 Treze Treze 18 19 25 19
10 CRAC CRAC 18 14 26 10
11 Tupi Tupi 18 30 13 34
12 Mogi Mirim Mogi Mirim 18 22 24 31
13 Madureira RJ Madureira 18 20 17 26
14 Macaé Esporte Macaé 18 15 17 26
15 Guaratinguetá Guaratinguet 18 32 18 25
16 EC Juventude Juventude 18 16 14 25
17 Guaraní Guaraní 18 14 15 24
18 Caxias do Sul Caxias 18 17 20 22
19 São Caetano São Caetano 18 13 19 21
20 Duque de Caxias Duque Caxias 18 10 32 7
TEMPORADA 2012/2013
SERIE C - BRASIL
Equipo PJ GF GC Puntos
1 Santa Cruz Santa Cruz 19 31 18 34
2 Sampaio Correa Sampaio 19 32 17 32
3 Fortaleza EC Fortaleza 19 36 21 31
4 Luverdense Luverdense 19 27 20 31
5 Aguia de Maraba Aguia Maraba 19 30 24 31
6 Brasiliense Brasiliense 19 19 19 30
7 Treze Treze 19 26 33 30
8 CRB CRB 19 21 15 29
9 Cuiabá Cuiabá 19 29 20 27
10 Baraunas Baraunas 19 15 41 13
11 Rio Branco Acre Branco Acre 20 8 46 6
12 Macaé Esporte Macaé 17 27 19 31
13 Caxias do Sul Caxias 17 17 14 29
14 Mogi Mirim Mogi Mirim 17 22 16 27
15 Vila Nova Vila Nova 17 19 13 26
16 Ipatinga FC Ipatinga FC 17 19 16 25
17 Guaraní Guaraní 17 14 12 23
18 Madureira RJ Madureira 17 17 15 19
19 Duque de Caxias Duque Caxias 17 18 22 16
20 CRAC CRAC 17 11 19 16
21 Grêmio Barueri Grêmio 17 18 36 14
TEMPORADA 2011/2012
SERIE C - BRASIL
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 28 11 39
2 Luverdense Luverdense 18 32 26 34
3 Paysandu Paysandu 18 26 19 24
4 Icasa Icasa 18 18 19 24
5 Santa Cruz Santa Cruz 18 26 22 22
6 Treze Treze 18 24 33 22
7 Aguia de Maraba Aguia Maraba 18 22 32 22
8 Cuiabá Cuiabá 18 20 21 20
9 Salgueiro Salgueiro 18 25 29 20
10 Guarany de Sobral Guarany 18 21 30 14
11 Macaé Esporte Macaé 18 33 17 32
12 Chapecoense Chapecoense 18 24 12 29
13 Oeste Oeste 18 22 19 29
14 Duque de Caxias Duque Caxias 18 22 23 29
15 Caxias do Sul Caxias 18 23 26 27
16 Vila Nova Vila Nova 18 27 26 23
17 Brasiliense Brasiliense 18 25 29 23
18 Madureira RJ Madureira 18 17 21 23
19 Santo André Santo André 18 14 22 18
20 Tupi Tupi 18 13 25 14
TEMPORADA 2010/2011
SERIE C - BRASIL
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 8 12 10 16
2 Paysandu Paysandu 8 13 7 14
3 Luverdense Luverdense 8 11 6 13
4 Aguia de Maraba Aguia Maraba 8 11 8 13
5 Araguaína Araguaína 8 3 19 1
6 América RN América RN 8 16 8 16
7 CRB CRB 8 7 13 11
8 Guarany de Sobral Guarany 8 9 9 9
9 Fortaleza EC Fortaleza 8 11 12 9
10 Campinense Campinense 8 7 8 9
11 Ipatinga FC Ipatinga FC 8 15 8 18
12 Brasiliense Brasiliense 8 8 5 13
13 Madureira RJ Madureira 8 7 8 10
14 Macaé Esporte Macaé 8 14 17 8
15 Marília Marília 8 11 17 8
16 Chapecoense Chapecoense 8 13 7 16
17 Joinville Joinville 8 17 11 15
18 Caxias do Sul Caxias 8 11 14 8
19 Santo André Santo André 8 8 13 8
20 Brasil de Pelotas Brasil 8 11 15 2
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 B - BRASIL
Equipo PJ GF GC Puntos
1 Vasco da Gama Vasco Gama 38 58 29 76
2 Guaraní Guaraní 38 55 51 69
3 Ceará Ceará 38 54 34 68
4 Atlético GO Atlético 38 73 53 65
5 Portuguesa Portuguesa 38 53 45 62
6 Figueirense Figueirense 38 64 51 60
7 São Caetano São Caetano 38 52 38 54
8 Duque de Caxias Duque Caxias 38 55 55 54
9 RB Bragantino Bragantino 38 52 51 53
10 Paraná Paraná 38 51 56 53
11 Ponte Preta Ponte Preta 38 62 55 52
12 Bahía Bahía 38 52 53 51
13 Vila Nova Vila Nova 38 42 59 49
14 Brasiliense Brasiliense 38 45 56 48
15 Ipatinga FC Ipatinga FC 38 43 50 48
16 América RN América RN 38 49 61 46
17 EC Juventude Juventude 38 46 50 44
18 Fortaleza EC Fortaleza 38 56 64 38
19 Campinense Campinense 38 54 79 37
20 ABC ABC 38 40 66 35
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
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 São Paulo São Paulo 38 66 32 78
2 Internacional Internaciona 38 52 36 69
3 Grêmio Grêmio 38 64 45 67
4 Santos FC Santos FC 38 58 36 64
5 Paraná Paraná 38 56 49 60
6 Vasco da Gama Vasco Gama 38 57 50 59
7 Figueirense Figueirense 38 52 44 57
8 Goiás EC Goiás EC 38 63 49 55
9 Corinthians Corinthians 38 41 46 53
10 Cruzeiro Cruzeiro 38 52 45 53
11 Flamengo Flamengo 38 44 48 52
12 Botafogo Botafogo 38 52 50 51
13 Athletico Paranaense Athletico 38 61 62 48
14 EC Juventude Juventude 38 44 54 47
15 Fluminense Fluminense 38 48 58 45
16 Palmeiras Palmeiras 38 58 70 44
17 Ponte Preta Ponte Preta 38 45 65 39
18 Fortaleza EC Fortaleza 38 39 62 38
19 São Caetano São Caetano 38 37 53 36
20 Santa Cruz Santa Cruz 38 41 76 28
TEMPORADA 2004/2005
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Corinthians Corinthians 42 87 59 81
2 Internacional Internaciona 42 72 49 78
3 Goiás EC Goiás EC 42 68 51 74
4 Palmeiras Palmeiras 42 81 65 70
5 Fluminense Fluminense 42 79 70 68
6 Athletico Paranaense Athletico 42 76 67 61
7 Paraná Paraná 42 59 51 61
8 Cruzeiro Cruzeiro 42 73 72 60
9 Botafogo Botafogo 42 57 56 59
10 Santos FC Santos FC 42 68 71 59
11 São Paulo São Paulo 42 77 67 58
12 Flamengo Flamengo 42 56 60 55
13 EC Juventude Juventude 42 66 72 55
14 Fortaleza EC Fortaleza 42 58 64 55
15 Vasco da Gama Vasco Gama 42 75 86 54
16 Figueirense Figueirense 42 65 72 53
17 São Caetano São Caetano 42 54 60 52
18 Ponte Preta Ponte Preta 42 63 80 51
19 Coritiba Coritiba 42 51 60 49
20 Atl. Mineiro Atl. Mineiro 42 54 59 47
21 Brasiliense Brasiliense 42 49 68 42
22 Paysandu Paysandu 42 63 92 41
TEMPORADA 2003/2004
SERIE B - BRASIL GRUPO 3
Equipo PJ GF GC Puntos
1 Brasiliense Brasiliense 6 8 5 12
2 Fortaleza EC Fortaleza 6 4 4 8
3 Avaí Avaí 6 4 5 8
4 Bahía Bahía 6 7 9 5

  USO DE MEMORIA  
8,182,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2076
Total Execution Time  0.2088
  CADENA URL  
/historico/Fortaleza-Ec/2021
  GET DATOS  
$_GET['/historico/Fortaleza-Ec/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0108  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 = 'Fortaleza-Ec' 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.0025  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=1163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=1163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=1163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=1163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=1163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=1163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=1163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0032  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 = 61339
0.0029  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 = 62140
0.0029  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 = 61707
0.0032  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 = 62640
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1163 AND type_rel = 2
0.0041  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1163 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0030  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 (1312650,71346,71744,74539,94873) ORDER BY n.cover_points DESC, update_date DESC
0.0071  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 = '1163' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0064  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 = '1163' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 62640 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 62140 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  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=1163 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (67706,67008,66800,66515,66173,53476) 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.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 66173 AND teamId = 1163
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 67706 AND teamId = 1163
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 53476 AND teamId = 1163
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 66515 AND teamId = 1163
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 67008 AND teamId = 1163
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 66800 AND teamId = 1163
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 = '1163' 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 = '1163' and rp.type = 4
0.0020  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 = '1163' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 61712 WHERE rp.league_id = 61712 AND rp.teamId = 1163 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.0033  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 = 61712 WHERE rp.league_id = 61712 AND rp.teamId = 1163 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 61712 WHERE rp.league_id = 61712 AND rp.teamId = 1163 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 1163 AND l.year <= 2021 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 `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 = 61712 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.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 `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 = 53602 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.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 `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 = 48489 AND t.round = 38 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 `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.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 `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 = 37758 AND t.round = 18 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 `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 = 20239 AND t.round = 18 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 `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 = 11073 AND t.round = 18 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 = 3272 AND t.round = 18 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 `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 = 12973 AND t.round = 19 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 `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 = 12975 AND t.round = 18 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 `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 = 12976 AND t.round = 10 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 `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.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 `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 = 12939 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 `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.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 `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.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 `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 = 435 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 `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 = 436 AND t.round = 42 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 `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 = 12965 AND t.round = 23 ORDER BY team.conference 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 `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 = 12966 AND t.round = 6 ORDER BY team.conference 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 `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 = 12967 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC