4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Esporles
TEMPORADA 2023/2024
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Cardassar Cardassar 30 55 21 67
2 CD Son Cladera Cladera 30 50 17 58
3 Son Veri Son Veri 30 58 38 54
4 UD Alaró UD Alaró 30 55 34 52
5 Esporles Esporles 30 47 35 50
6 Serverense Serverense 30 46 31 49
7 Atletico Rafal Atletico 30 45 43 49
8 Santa Mónica Santa 30 52 40 47
9 Santa Catalina Atlético Santa 30 42 41 39
10 Murense Murense 30 40 48 35
11 Algaida Algaida 30 43 64 31
12 UE Petra UE Petra 30 38 63 31
13 Espanya Espanya 30 37 43 30
14 Xilvar Xilvar 30 44 64 25
15 Santa Ponsa Santa Ponsa 30 34 61 24
16 Sta Ponsa Talarrubias Ponsa 30 33 76 16
TEMPORADA 2022/2023
PREFERENTE BALEARES GRUPO 6
Equipo PJ GF GC Puntos
1 Calvia Calvia 40 62 61 53
2 Esporles Esporles 40 64 58 53
3 UE Petra UE Petra 40 62 62 52
4 Indep. Camp Redó Indep. Camp 40 77 80 51
5 Murense Murense 40 60 49 50
6 S´Horta S´Horta 40 66 70 50
7 Son Sardina Son Sardina 40 60 88 37
8 CD Génova CD Génova 40 73 128 24
9 Alqueria Alqueria 40 27 104 20
10 Arta Arta 40 44 130 18
TEMPORADA 2021/2022
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Inter Manacor Inter 38 66 36 75
2 CD Sant Jordi Sant Jordi 38 71 39 71
3 Porreres Porreres 38 70 40 70
4 Cardassar Cardassar 38 55 32 69
5 Sineu Sineu 38 66 39 68
6 Recreativo La Victoria Recreativo 38 56 45 63
7 Ferriolense Ferriolense 38 45 42 63
8 UE Alcudia UE Alcudia 38 64 40 62
9 CD Génova CD Génova 38 60 43 61
10 CE Xilvar CE Xilvar 38 51 47 60
11 Santa Catalina Atlético Santa 38 52 41 53
12 UD Alaró UD Alaró 38 64 47 51
13 CD Son Cladera Cladera 38 42 43 48
14 UE Petra UE Petra 38 51 60 45
15 Calvia Calvia 38 49 63 42
16 Arta Arta 37 52 80 38
17 Alqueria Alqueria 37 38 70 35
18 Pla de Na Tesa Tesa 38 52 90 30
19 Son Sardina Son Sardina 38 47 95 26
20 Esporles Esporles 38 37 96 19
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Ibiza I. Pitiusas Ibiza 20 38 11 44
2 Andratx Andratx 20 35 17 44
3 Constància Constància 20 24 14 35
4 Manacor Manacor 20 26 20 34
5 SD Portmany SD Portmany 20 29 26 30
6 UD Collerense Collerense 20 28 26 29
7 Soller Soller 20 21 36 23
8 Cardassar Cardassar 20 20 28 22
9 Felanitx Felanitx 20 29 32 19
10 Ferriolense Ferriolense 20 14 32 13
11 CD Génova CD Génova 20 19 41 11
12 Platges de Calvià Platges 20 31 13 45
13 PE Sant Jordi Sant Jordi 20 33 17 41
14 SD Formentera Formentera 20 36 20 39
15 Mallorca B Mallorca B 20 34 10 38
16 Santanyi Santanyi 20 23 12 35
17 CF Sant Rafel Sant Rafel 20 25 24 22
18 Llosetense Llosetense 20 17 28 22
19 UE Alcudia UE Alcudia 20 17 32 21
20 Santa Catalina Atlético Santa 20 12 30 17
21 Binissalem Binissalem 20 17 24 15
22 Esporles Esporles 20 15 50 7
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Poblense Poblense 26 65 19 70
2 Ibiza I. Pitiusas Ibiza 27 56 15 62
3 Mallorca B Mallorca B 27 61 18 60
4 Felanitx Felanitx 27 46 25 52
5 Platges de Calvià Platges 27 35 22 52
6 Andratx Andratx 27 59 37 50
7 SD Formentera Formentera 27 53 39 49
8 Constància Constància 27 23 24 41
9 CF Sant Rafel Sant Rafel 27 47 33 40
10 Ferriolense Ferriolense 27 32 44 33
11 Soller Soller 27 37 46 32
12 Binissalem Binissalem 26 32 35 31
13 Santanyi Santanyi 27 33 44 29
14 Llosetense Llosetense 27 34 47 29
15 Manacor Manacor 27 26 41 26
16 UE Alcudia UE Alcudia 27 34 52 25
17 SD Portmany SD Portmany 27 22 56 17
18 Santa Catalina Atlético Santa 27 20 52 16
19 UD Collerense Collerense 27 21 60 16
20 Esporles Esporles 27 30 57 14
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Peña Deportiva Peña 40 88 28 98
2 Mallorca B Mallorca B 40 92 31 90
3 Poblense Poblense 40 93 33 86
4 SD Formentera Formentera 40 70 28 85
5 Ibiza I. Pitiusas Ibiza 40 75 28 83
6 Platges de Calvià Platges 40 51 30 72
7 UE Alcudia UE Alcudia 40 66 52 70
8 Santa Catalina Atlético Santa 40 47 54 51
9 CF Sant Rafel Sant Rafel 40 52 48 50
10 Constància Constància 40 40 45 48
11 Felanitx Felanitx 40 58 60 47
12 Llosetense Llosetense 40 41 72 45
13 Binissalem Binissalem 40 37 57 44
14 Soller Soller 40 43 72 44
15 Ferriolense Ferriolense 40 32 52 43
16 Santanyi Santanyi 40 37 54 43
17 Manacor Manacor 40 39 62 37
18 Esporles Esporles 40 41 71 36
19 CD Son Cladera Cladera 40 31 78 35
20 Mercadal Mercadal 40 35 56 33
21 Murense Murense 40 22 79 17
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Mallorca B Mallorca B 38 87 20 93
2 Poblense Poblense 38 101 30 89
3 UD Ibiza UD Ibiza 38 91 17 88
4 Felanitx Felanitx 38 59 41 69
5 Platges de Calvià Platges 38 51 47 58
6 Binissalem Binissalem 38 46 49 58
7 UE Alcudia UE Alcudia 38 42 49 58
8 Constància Constància 38 56 43 56
9 Santa Catalina Atlético Santa 38 51 51 49
10 CD Son Cladera Cladera 38 36 47 48
11 Esporles Esporles 38 36 47 48
12 Manacor Manacor 38 36 52 48
13 CF Sant Rafel Sant Rafel 38 44 60 45
14 Ferriolense Ferriolense 38 42 60 44
15 Llosetense Llosetense 38 40 68 43
16 Mercadal Mercadal 38 43 62 43
17 Santanyi Santanyi 38 46 65 40
18 UD Collerense Collerense 38 43 67 39
19 Serverense Serverense 38 42 65 35
20 UE Petra UE Petra 38 21 73 17
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 SD Formentera Formentera 38 88 19 86
2 Poblense Poblense 38 90 34 79
3 UE Alcudia UE Alcudia 38 55 30 77
4 Peña Deportiva Peña 38 63 35 74
5 Llosetense Llosetense 38 73 42 69
6 CF Sant Rafel Sant Rafel 38 52 28 66
7 Platges de Calvià Platges 38 55 39 62
8 Constància Constància 38 53 49 51
9 Binissalem Binissalem 38 47 38 50
10 Santa Catalina Atlético Santa 38 44 55 50
11 Ciudad de Ibiza Ciudad Ibiza 38 54 55 49
12 Ferriolense Ferriolense 38 54 68 49
13 Felanitx Felanitx 38 39 49 47
14 CD Son Cladera Cladera 38 37 67 41
15 Esporles Esporles 38 40 56 40
16 Mercadal Mercadal 38 44 55 39
17 UD Collerense Collerense 38 50 63 39
18 Rotlet Molinar Rotlet 38 40 98 32
19 Penya Ciutadella Penya 38 34 83 28
20 Campos Campos 38 28 77 21
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Mallorca B Mallorca B 38 79 29 80
2 SD Formentera Formentera 38 69 29 78
3 Peña Deportiva Peña 38 63 32 74
4 Constància Constància 38 58 30 65
5 Poblense Poblense 38 57 30 62
6 UE Alcudia UE Alcudia 38 52 39 61
7 Mercadal Mercadal 38 48 41 61
8 Binissalem Binissalem 38 49 37 60
9 Montuiri Montuiri 38 49 49 57
10 UD Collerense Collerense 38 52 51 55
11 CF Sant Rafel Sant Rafel 38 42 36 53
12 Ferriolense Ferriolense 38 36 42 45
13 Campos Campos 38 47 59 44
14 Penya Ciutadella Penya 38 46 61 43
15 Esporles Esporles 38 36 54 41
16 Rotlet Molinar Rotlet 38 42 70 38
17 Santa Catalina Atlético Santa 38 33 52 37
18 Platges de Calvià Platges 38 27 55 33
19 UD Alaró UD Alaró 38 18 55 22
20 Soller Soller 38 30 82 22
TEMPORADA 2014/2015
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Santa Catalina Atlético Santa 38 81 39 83
2 Rotlet Molinar Rotlet 38 85 40 82
3 Cardassar Cardassar 38 78 36 76
4 Esporles Esporles 38 60 33 73
5 Santanyi Santanyi 38 68 46 63
6 Andratx Andratx 38 61 43 63
7 Ce Campanet Ce Campanet 38 57 49 63
8 At. Santa Eugenia Santa 38 60 50 62
9 Recreativo La Victoria Recreativo 38 65 63 56
10 CD Génova CD Génova 38 61 53 55
11 UE Petra UE Petra 38 52 49 52
12 Serverense Serverense 38 59 71 44
13 Murense Murense 38 49 69 42
14 CD España CD España 38 47 70 40
15 Felanitx Felanitx 38 54 73 37
16 Port de Soller Port Soller 38 41 73 37
17 S´Horta S´Horta 38 48 66 36
18 La Unión CF Unión 38 50 79 36
19 Indep. Camp Redó Indep. Camp 38 42 76 33
20 CE Escolar CE Escolar 38 48 88 30
TEMPORADA 2013/2014
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Soller Soller 38 92 39 85
2 Santa Catalina Atlético Santa 38 81 31 82
3 UD Alaró UD Alaró 38 50 30 67
4 Cardassar Cardassar 38 64 53 64
5 Indep. Camp Redó Indep. Camp 38 77 47 62
6 CD Son Cladera Cladera 38 67 61 60
7 Esporles Esporles 38 44 36 59
8 Andratx Andratx 38 62 44 59
9 Ce Campanet Ce Campanet 38 65 55 58
10 Serverense Serverense 38 74 64 53
11 CD Génova CD Génova 38 59 58 52
12 CD España CD España 38 56 62 51
13 S´Horta S´Horta 38 71 81 51
14 Port de Soller Port Soller 38 48 67 47
15 CE Escolar CE Escolar 38 57 64 46
16 La Unión CF Unión 38 57 75 44
17 Murense Murense 38 38 66 35
18 UD Arenal UD Arenal 38 44 74 31
19 CD Binissalem B Binissalem 38 40 86 28
20 Son Ferrer Son Ferrer 38 37 90 27
TEMPORADA 2011/2012
PREFERENTE BALEARES
Equipo PJ GF GC Puntos
1 Soller Soller 38 99 46 86
2 Andratx Andratx 37 98 38 79
3 CD Génova CD Génova 38 81 59 68
4 S´Horta S´Horta 38 68 47 67
5 Serverense Serverense 37 71 54 66
6 Xilvar Xilvar 38 69 50 63
7 Cd Escolar Cd Escolar 38 73 52 61
8 Cardassar Cardassar 38 65 56 59
9 Murense Murense 38 54 61 57
10 La Unión CF Unión 37 54 47 55
11 Ce Campanet Ce Campanet 38 77 79 54
12 CSD Independiente Independient 37 66 65 51
13 Santa Catalina Atlético Santa 38 52 54 50
14 Sporting Sant Marçal Sporting 38 53 56 46
15 Alaró Alaró 38 55 66 45
16 Esporles Esporles 37 54 82 38
17 Pla De Na Tesa Tesa 37 60 86 34
18 UD Arenal UD Arenal 38 36 70 33
19 Cf Pollença Pollença 38 46 106 27
20 Arta Arta 38 35 92 22
TEMPORADA 2010/2011
PREFERENTE BALEARES
Equipo PJ GF GC Puntos
1 Son Ferrer Son Ferrer 38 66 36 76
2 CD España CD España 38 94 49 73
3 Andratx Andratx 38 73 44 71
4 Platges de Calvià Platges 38 67 42 65
5 La Unión CF Unión 38 55 39 64
6 S´Horta S´Horta 38 66 52 60
7 Murense Murense 38 59 55 59
8 CSD Independiente Independient 38 66 64 58
9 Sporting Sant Marçal Sporting 38 54 52 57
10 Cardassar Cardassar 38 54 61 55
11 Alaró Alaró 38 51 56 52
12 Esporles Esporles 38 62 53 51
13 Serverense Serverense 38 79 86 49
14 Cd Escolar Cd Escolar 38 61 68 48
15 CD Génova CD Génova 38 64 72 48
16 Soller Soller 38 56 71 45
17 Pollensa Pollensa 38 45 68 41
18 Arta Arta 38 52 67 39
19 Ce S´arraco S´arraco 38 40 82 29
20 Calvià Calvià 38 42 89 21
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 38 78 33 81
2 Peña Deportiva Peña 38 62 18 78
3 Constància Constància 38 79 37 74
4 Ferriolense Ferriolense 38 55 38 66
5 Binissalem Binissalem 38 58 45 64
6 Santanyi Santanyi 38 74 36 63
7 UE Alcudia UE Alcudia 38 60 45 60
8 Mercadal Mercadal 38 60 59 55
9 CF Sant Rafel Sant Rafel 38 36 36 55
10 UD Arenal UD Arenal 38 41 58 52
11 Montuiri Montuiri 38 48 51 51
12 CE Ferreries Ferreries 38 49 49 47
13 CE Alaior CE Alaior 38 54 61 47
14 Llosetense Llosetense 38 33 63 42
15 Poblense Poblense 38 49 56 40
16 Campos Campos 38 44 57 40
17 UD Collerense Collerense 38 52 71 37
18 Indep. Camp Redó Indep. Camp 38 32 70 37
19 Esporles Esporles 38 29 68 27
20 Atlètic De Ciutadella Atlètic 38 27 69 22
TEMPORADA 2008/2009
PREFERENTE BALEARES
Equipo PJ GF GC Puntos
1 Esporles Esporles 38 81 39 75
2 Llosetense Llosetense 38 69 35 74
3 UD Collerense Collerense 38 73 49 68
4 Indep. Camp Redó Indep. Camp 38 70 48 66
5 S´Horta S´Horta 38 61 48 63
6 Margaritense Margaritense 38 61 42 62
7 Soller Soller 38 73 58 62
8 Penya Arrabal Penya 38 56 34 61
9 Platges de Calvià Platges 38 68 47 58
10 Murense Murense 38 56 60 52
11 Serverense Serverense 38 47 46 51
12 Génova Génova 38 63 74 47
13 Calvià Calvià 38 56 75 45
14 Xilvar Xilvar 38 51 74 44
15 Cardassar Cardassar 38 56 69 43
16 Felanitx Felanitx 38 40 67 43
17 Pla de Na Tesa Tesa 38 63 90 40
18 Poblense B Poblense B 38 59 72 38
19 La Unión CF Unión 38 50 76 34
20 Atl. Rafal Atl. Rafal 38 41 91 22
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Constància Constància 38 74 25 79
2 Atlético Baleares Atlético 38 61 23 78
3 Soller Soller 38 84 28 76
4 Manacor Manacor 38 52 33 68
5 Poblense Poblense 38 62 35 64
6 Binissalem Binissalem 38 45 34 61
7 Ferriolense Ferriolense 38 50 32 60
8 Peña Deportiva Peña 38 60 42 60
9 Campos Campos 38 59 53 59
10 Sp. Mahonès Mahonès 38 57 54 51
11 Platges de Calvià Platges 38 53 53 45
12 Atlètic De Ciutadella Atlètic 38 44 75 45
13 Pollensa Pollensa 38 38 42 44
14 SD Portmany SD Portmany 38 36 47 40
15 CE Alaior CE Alaior 38 39 62 37
16 CD Cardessar Cardessar 38 27 47 36
17 Andratx Andratx 38 45 72 36
18 Esporles Esporles 38 44 69 36
19 Felanitx Felanitx 38 42 87 30
20 UD Alaró UD Alaró 38 27 86 21
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Soller Soller 38 94 19 84
2 Platges de Calvià Platges 38 84 35 78
3 Atlético Baleares Atlético 38 79 32 78
4 Poblense Poblense 38 74 27 77
5 Constància Constància 38 85 31 76
6 Manacor Manacor 38 80 37 75
7 Campos Campos 38 75 44 71
8 Atlètic De Ciutadella Atlètic 38 64 52 64
9 Ferriolense Ferriolense 38 63 42 62
10 Santa Eulàlia Santa 38 64 49 59
11 Pollensa Pollensa 38 37 56 45
12 SD Portmany SD Portmany 38 37 69 44
13 CD Cardessar Cardessar 38 44 61 44
14 Sp. Mahonès Mahonès 38 52 54 44
15 Esporles Esporles 38 53 69 42
16 CE Alaior CE Alaior 38 47 61 42
17 UD Alaró UD Alaró 38 43 68 39
18 Santanyi Santanyi 38 29 99 17
19 UD Arenal UD Arenal 38 34 113 16
20 Serverense Serverense 38 15 135 6
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Mallorca B Mallorca B 38 99 34 57
2 Atlético Baleares Atlético 38 81 31 55
3 Montuiri Montuiri 38 62 49 53
4 Serverense Serverense 38 55 45 43
5 Platges de Calvià Platges 38 66 48 41
6 Sp. Mahonès Mahonès 38 51 33 40
7 Soller Soller 38 57 48 40
8 Constància Constància 38 66 62 38
9 Poblense Poblense 38 52 51 38
10 UD Arenal UD Arenal 38 39 47 37
11 CD Cardessar Cardessar 38 38 44 37
12 Pollensa Pollensa 38 49 50 36
13 Ferriolense Ferriolense 38 42 47 36
14 Atlètic De Ciutadella Atlètic 38 44 58 35
15 CE Alaior CE Alaior 38 40 58 34
16 SD Ibiza SD Ibiza 38 37 48 33
17 CE Ferreries Ferreries 38 39 51 33
18 Esporles Esporles 38 48 82 26
19 Club Recreativo La Victoria Club 38 29 67 24
20 Calvià Calvià 38 33 74 24
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Manacor Manacor 38 91 38 57
2 Peña Deportiva Peña 38 59 32 53
3 Mallorca B Mallorca B 38 97 39 52
4 Platges de Calvià Platges 38 73 39 52
5 Poblense Poblense 38 51 39 44
6 Ferriolense Ferriolense 38 39 38 43
7 CE Alaior CE Alaior 38 63 50 43
8 Atlético Baleares Atlético 38 58 47 42
9 CE Ferreries Ferreries 38 46 45 40
10 Soller Soller 38 56 48 38
11 Serverense Serverense 38 51 64 37
12 UD Arenal UD Arenal 38 44 51 33
13 CD Cardessar Cardessar 38 42 47 33
14 Atlètic De Ciutadella Atlètic 38 46 61 32
15 Constància Constància 38 49 59 32
16 Esporles Esporles 38 44 62 31
17 SD Portmany SD Portmany 38 37 68 28
18 Porto Cristo Porto Cristo 38 38 66 26
19 Llosetense Llosetense 38 45 71 24
20 Son Roca Son Roca 38 32 97 20

  USO DE MEMORIA  
7,821,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1676
Total Execution Time  0.1688
  CADENA URL  
/historico/Esporles
  GET DATOS  
$_GET['/historico/Esporles']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0031  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 = 'Esporles' 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=1003 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=1003 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044  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 = 73341
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1003 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1003 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 (637063,822157,822387,831531,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '1003' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '1003' 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 = 73341 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=1003 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 (73341) 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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 73341 AND teamId = 1003
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 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 = 73341 AND t.round = 30 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 = '1003' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1003' 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 = '1003' 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 events2024 e ON e.player_id = p.id AND e.league_id = 73341 WHERE rp.league_id = 73341 AND rp.teamId = 1003 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.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 = 73341 WHERE rp.league_id = 73341 AND rp.teamId = 1003 AND (e.action = 4 or e.action = 5) 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 = 73341 WHERE rp.league_id = 73341 AND rp.teamId = 1003 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 1003 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 `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 = 73341 AND t.round = 30 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 `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 = 68763 AND t.round = 30 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 `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 = 71378 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 63634 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 `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 = 58590 AND t.round = 22 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 `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 = 50279 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 44399 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 33361 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 15452 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 4075 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 `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 = 2683 AND t.round = 38 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 `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 = 1471 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 1130 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 832 AND t.round = 38 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 `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 = 293 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 `tables1997` 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 = 21974 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables1996` 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 = 21953 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 `tables1994` 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 = 21911 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 73341 ORDER BY nameShow LIMIT 100