4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Fuente de Cantos

UD Fuente de Cantos

Entrenador: Valentín Flores

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 31 60 13 69
2 CD Coria CD Coria 32 57 19 66
3 CD Azuaga CD Azuaga 32 47 31 58
4 Castuera Castuera 32 45 35 49
5 Villafranca Villafranca 31 41 24 49
6 CF Jaraíz CF Jaraíz 32 48 47 45
7 CD Diocesano Diocesano 32 47 46 45
8 Moralo Moralo 31 47 42 44
9 Calamonte Calamonte 31 37 44 41
10 Olivenza Olivenza 32 31 34 41
11 Arroyo Arroyo 32 33 35 41
12 Jerez Jerez 31 38 46 39
13 Pueblonuevo Pueblonuevo 32 31 43 39
14 Trujillo Trujillo 31 29 36 34
15 CD Don Álvaro Álvaro 32 28 47 31
16 Montehermoso Montehermoso 32 33 54 31
17 Racing Valverdeño Racing 32 30 56 26
18 UD Fuente de Cantos Fuente 32 25 55 24
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 AD Llerenense Llerenense 30 52 22 64
2 CD Azuaga CD Azuaga 30 58 29 62
3 Moralo Moralo 30 52 24 55
4 Olivenza Olivenza 30 46 33 53
5 Jerez Jerez 30 39 25 49
6 Arroyo Arroyo 30 30 31 46
7 Trujillo Trujillo 30 28 28 44
8 Villafranca Villafranca 30 34 33 43
9 Calamonte Calamonte 30 38 33 42
10 UD Fuente de Cantos Fuente 30 23 28 39
11 Pueblonuevo Pueblonuevo 30 36 41 32
12 Montehermoso Montehermoso 30 31 53 31
13 CD Don Álvaro Álvaro 30 27 54 27
14 Miajadas Miajadas 30 23 41 26
15 Plasencia Plasencia 30 31 43 24
16 UC La Estrella Estrella 30 30 60 21
TEMPORADA 2021/2022
1ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 UD Fuente de Cantos Fuente 22 39 15 48
2 UC La Estrella Estrella 22 42 22 48
3 CD Zafra CD Zafra 22 32 19 41
4 CP Gran Maestre Gran Maestre 22 37 15 39
5 CD San Serván Serván 22 40 29 38
6 Usagre Usagre 22 36 29 35
7 CP Oliva CP Oliva 22 22 16 34
8 EMD Solana EMD Solana 22 33 43 22
9 Santa Marta Santa Marta 22 32 48 20
10 Sport Club La Garrovilla Sport Club. 22 27 49 16
11 Monesterio Monesterio 22 29 46 15
12 Atlético Torremejía Atlético 22 27 65 7
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 UD Montijo UD Montijo 20 34 5 49
2 CD Coria CD Coria 20 36 14 45
3 Moralo Moralo 20 28 9 42
4 Extremadura B Extremadura 20 28 17 32
5 Plasencia Plasencia 20 27 14 30
6 EMD Aceuchal Aceuchal 20 22 25 26
7 Calamonte Calamonte 20 23 25 23
8 Chinato Chinato 20 17 32 15
9 Campanario Campanario 20 13 35 15
10 CP Valdivia CP Valdivia 20 14 44 13
11 AD Lobón AD Lobón 20 10 32 12
12 CP Cacereño Cacereño 20 43 9 50
13 CD Diocesano Diocesano 20 37 12 44
14 Jerez Jerez 20 23 16 36
15 Miajadas Miajadas 20 21 19 28
16 Arroyo Arroyo 20 15 24 25
17 CD Azuaga CD Azuaga 20 18 25 23
18 AD Llerenense Llerenense 20 14 26 22
19 Trujillo Trujillo 20 25 28 19
20 Racing Valverdeño Racing 20 13 33 19
21 Olivenza Olivenza 20 20 26 18
22 UD Fuente de Cantos Fuente 20 18 29 16
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Villanovense Villanovense 28 56 19 66
2 CD Coria CD Coria 28 54 23 65
3 CP Cacereño Cacereño 27 63 20 62
4 Extremadura B Extremadura 28 42 27 52
5 Moralo Moralo 28 53 32 52
6 Jerez Jerez 28 35 26 44
7 Trujillo Trujillo 28 39 41 43
8 Arroyo Arroyo 28 33 33 42
9 EMD Aceuchal Aceuchal 27 41 37 41
10 CD Diocesano Diocesano 28 48 34 40
11 CD Azuaga CD Azuaga 28 36 35 39
12 Olivenza Olivenza 28 39 52 37
13 Plasencia Plasencia 28 29 38 35
14 Calamonte Calamonte 28 36 44 34
15 UD Montijo UD Montijo 28 34 40 31
16 Miajadas Miajadas 28 27 46 30
17 UD Fuente de Cantos Fuente 28 29 47 29
18 AD Llerenense Llerenense 28 22 38 23
19 Racing Valverdeño Racing 28 19 56 15
20 CP Valdivia CP Valdivia 28 18 65 7
TEMPORADA 2018/2019
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 UD Fuente de Cantos Fuente 30 69 32 70
2 Campanario Campanario 30 63 30 64
3 CD Zafra CD Zafra 30 63 28 63
4 UC La Estrella Estrella 30 66 38 61
5 Villafranca Villafranca 30 64 31 60
6 Guareña Guareña 30 46 50 46
7 CD Don Álvaro Álvaro 30 67 55 44
8 CD Berlanga CD Berlanga 30 54 59 36
9 CP Gran Maestre Gran Maestre 30 51 45 35
10 Gimnástico Don Benito Gimnástico 30 43 58 35
11 Ilipense-Zalamea S. Ilipense-Zal 30 38 59 34
12 Atlético Torremejía Atlético 30 50 73 32
13 UD Frexnense Frexnense 30 23 46 28
14 UD Fornacense Fornacense 30 35 63 28
15 Sp Ribereña Ribereña 30 34 69 25
16 Emérita Augusta Emérita 30 28 58 22
TEMPORADA 2017/2018
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 AD Llerenense Llerenense 30 75 27 64
2 Villafranca Villafranca 30 71 29 58
3 UD Frexnense Frexnense 30 52 33 57
4 UC La Estrella Estrella 30 63 38 56
5 UD Fuente de Cantos Fuente 30 66 37 55
6 CD San Serván Serván 30 53 38 51
7 Campanario Campanario 30 46 33 49
8 CD Berlanga CD Berlanga 30 63 52 42
9 Sp Ribereña Ribereña 30 44 48 42
10 Guareña Guareña 30 46 55 40
11 Santa Marta Santa Marta 30 49 62 38
12 Atlético Torremejía Atlético 30 42 55 35
13 Ilipense-Zalamea S. Ilipense-Zal 30 48 70 34
14 Monesterio Monesterio 30 44 84 24
15 Usagre Usagre 30 37 73 22
16 CD Quintana CD Quintana 30 23 88 10
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 81 16 92
2 CD Badajoz CD Badajoz 38 90 17 85
3 Jerez Jerez 38 57 26 79
4 CD Azuaga CD Azuaga 38 83 42 74
5 CD Coria CD Coria 38 62 29 72
6 CD Don Benito Benito 38 62 26 68
7 Calamonte Calamonte 38 70 39 62
8 Plasencia Plasencia 38 59 56 59
9 Moralo Moralo 38 57 58 52
10 Olivenza Olivenza 38 44 54 47
11 UD Montijo UD Montijo 38 41 59 43
12 Amanecer Amanecer 38 52 58 43
13 Extremadura B Extremadura 38 49 55 40
14 CP Valdivia CP Valdivia 38 34 63 39
15 Arroyo Arroyo 38 31 64 37
16 Santa Amalia Santa Amalia 38 34 82 36
17 Pueblonuevo Pueblonuevo 38 34 64 35
18 UD Fuente de Cantos Fuente 38 42 69 34
19 Diter Zafra Diter Zafra 38 34 95 24
20 UC La Estrella Estrella 38 34 78 22
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Extremadura Extremadura 38 106 25 90
2 CD Badajoz CD Badajoz 38 90 25 87
3 Arroyo Arroyo 38 78 23 84
4 Jerez Jerez 38 69 24 83
5 CD Don Benito Benito 38 53 39 66
6 CD Azuaga CD Azuaga 38 75 47 64
7 Calamonte Calamonte 38 68 66 62
8 Pueblonuevo Pueblonuevo 38 49 41 57
9 CD Coria CD Coria 38 56 44 55
10 Diter Zafra Diter Zafra 38 45 65 47
11 Atl San José Promesas José 38 39 59 46
12 Moralo Moralo 38 53 58 44
13 UD Fuente de Cantos Fuente 38 46 66 43
14 CP Valdivia CP Valdivia 38 34 63 42
15 Olivenza Olivenza 38 38 61 36
16 Amanecer Amanecer 38 35 66 33
17 Santa Amalia Santa Amalia 38 35 70 31
18 Sanvicenteño Sanvicenteñ 38 36 83 31
19 Valdelacalzada Valdelacalza 38 29 71 27
20 Deportivo Pacense Deportivo 38 42 80 25
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 AD Mérida AD Mérida 38 101 20 98
2 Extremadura Extremadura 38 86 24 87
3 Jerez Jerez 38 70 18 81
4 CD Badajoz CD Badajoz 38 71 31 77
5 CD Coria CD Coria 38 55 40 66
6 Moralo Moralo 38 65 44 65
7 CD Don Benito Benito 38 48 37 64
8 CD Azuaga CD Azuaga 38 44 44 55
9 Pueblonuevo Pueblonuevo 38 50 42 52
10 Santa Amalia Santa Amalia 38 44 50 51
11 Diter Zafra Diter Zafra 38 51 48 50
12 UD Fuente de Cantos Fuente 38 39 61 42
13 Atl San José Promesas José 38 48 75 42
14 Olivenza Olivenza 38 46 69 40
15 CP Valdivia CP Valdivia 38 43 73 37
16 Sanvicenteño Sanvicenteñ 38 34 61 34
17 Deportivo Pacense Deportivo 38 46 93 33
18 Castuera Castuera 38 39 68 33
19 Plasencia Plasencia 38 49 83 27
20 Hernán Cortés Hernán 38 35 83 27
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Villanovense Villanovense 40 77 17 100
2 AD Mérida AD Mérida 40 88 27 94
3 Jerez Jerez 40 77 21 94
4 Deportivo Pacense Deportivo 40 84 17 94
5 CD Coria CD Coria 40 81 35 87
6 Extremadura Extremadura 40 78 36 74
7 CD Don Benito Benito 40 52 35 59
8 Diter Zafra Diter Zafra 40 68 60 53
9 Pueblonuevo Pueblonuevo 40 66 54 53
10 Plasencia Plasencia 40 66 63 52
11 CD Azuaga CD Azuaga 40 68 78 52
12 Atl San José Promesas José 40 48 49 52
13 Olivenza Olivenza 40 38 49 46
14 Hernán Cortés Hernán 40 28 49 46
15 Santa Amalia Santa Amalia 40 43 69 45
16 Castuera Castuera 40 51 68 45
17 UD Fuente de Cantos Fuente 40 48 61 41
18 CP Cacereño B Cacereño 40 32 81 31
19 Miajadas Miajadas 40 42 110 24
20 RCP Valverdeño Valverdeño 40 48 103 20
21 Ciudad de Plasencia Ciudad 40 27 128 9
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Extremadura Extremadura 38 75 14 89
2 Deportivo Pacense Deportivo 38 67 24 80
3 CD Don Benito Benito 38 55 23 79
4 Diter Zafra Diter Zafra 38 57 23 77
5 Jerez Cf Jerez Cf 38 51 37 59
6 AD Mérida AD Mérida 38 47 38 56
7 Ciudad de Plasencia Ciudad 38 50 38 55
8 Plasencia Plasencia 38 55 47 55
9 Santa Amalia Santa Amalia 37 49 51 52
10 CD Coria CD Coria 38 48 49 51
11 Atl San José Promesas José 38 44 58 48
12 Pueblonuevo Pueblonuevo 38 41 60 43
13 Cd Miajadas Cd Miajadas 37 37 53 42
14 RCP Valverdeño Valverdeño 38 40 56 42
15 Hernán Cortés Hernán 38 37 65 41
16 CP Cacereño B Cacereño 38 48 57 40
17 UD Fuente de Cantos Fuente 38 42 68 39
18 Moralo Moralo 38 33 52 38
19 Ef Emérita Augusta Emérita 38 44 77 31
20 CD Valdelacalzada Valdelacalza 38 35 65 28
TEMPORADA 1988/1989
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Mérida CP Mérida CP 80 244 42 142
2 CF Extremadura Extremadura 80 210 34 138
3 CP Cacereño Cacereño 80 178 42 124
4 Puebla Patria Puebla 80 140 90 96
5 Vasco Núñez Vasco 80 154 104 90
6 CD Villanovense Villanovense 80 106 92 88
7 Villafranca Villafranca 80 128 96 88
8 Diter Zafra Diter Zafra 80 112 94 86
9 Moralo Moralo 80 140 112 84
10 UC La Estrella Estrella 80 124 104 82
11 UD Montijo UD Montijo 80 140 122 82
12 CD Badajoz Promesas Badajoz 80 146 132 78
13 Sanvicenteño Sanvicenteñ 80 122 152 76
14 Orellana Orellana 80 102 118 76
15 Malpartida Malpartida 80 112 166 72
16 Peñarroya Pueblonuevo Peñarroya 80 102 134 68
17 Cabezuela Cabezuela 80 108 208 52
18 CD Coria CD Coria 80 72 136 50
19 Racing Valverdeño Racing 80 88 224 46
20 UD Fuente de Cantos Fuente 80 66 242 32
21 Monteresma Atalaya Monteresma 80 48 198 30
TEMPORADA 1987/1988
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 38 84 28 57
2 Mérida CP Mérida CP 38 73 17 57
3 CF Extremadura Extremadura 38 93 20 55
4 Moralo Moralo 38 61 37 52
5 Puebla Patria Puebla 38 66 36 47
6 UD Montijo UD Montijo 38 74 54 47
7 Vasco Núñez Vasco 38 69 53 46
8 CD Badajoz Promesas Badajoz 38 58 56 41
9 Diter Zafra Diter Zafra 38 53 53 41
10 UC La Estrella Estrella 38 54 38 41
11 CD Villanovense Villanovense 38 45 37 39
12 CD Coria CD Coria 38 47 67 35
13 Monteresma Atalaya Monteresma 38 48 69 34
14 Cabezuela Cabezuela 38 52 75 33
15 Sanvicenteño Sanvicenteñ 38 41 51 31
16 UD Fuente de Cantos Fuente 38 46 70 30
17 Peñarroya Pueblonuevo Peñarroya 38 48 82 23
18 Cd La Albuera Albuera 38 23 86 20
19 CD Azuaga CD Azuaga 38 38 93 18
20 EMD Aceuchal Aceuchal 38 18 69 13
TEMPORADA 1986/1987
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 96 8 64
2 CD Badajoz CD Badajoz 38 132 22 62
3 Plasencia Plasencia 38 80 24 56
4 CF Extremadura Extremadura 37 57 26 52
5 Sanvicenteño Sanvicenteñ 38 55 43 47
6 Moralo Moralo 38 58 45 47
7 UD Montijo UD Montijo 38 56 36 44
8 CP Atalaya CP Atalaya 38 55 51 44
9 CD Don Benito Benito 38 64 53 42
10 UC La Estrella Estrella 38 60 57 39
11 Vasco Núñez Vasco 38 48 48 38
12 Mérida CP Mérida CP 38 53 59 37
13 UD Fuente de Cantos Fuente 37 44 65 35
14 Diter Zafra Diter Zafra 38 41 60 30
15 CD Villanovense Villanovense 38 40 72 27
16 Puebla Patria Puebla 38 32 57 25
17 EMD Aceuchal Aceuchal 38 29 73 20
18 CD Azuaga CD Azuaga 38 22 84 19
19 Guareña Guareña 38 39 108 15
20 La Albuera-Faesal Albuera-Faes 38 33 103 15
TEMPORADA 1985/1986
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Badajoz CD Badajoz 38 110 10 68
2 CD Don Benito Benito 38 78 29 58
3 CP Cacereño Cacereño 38 86 27 58
4 UD Montijo UD Montijo 38 61 34 51
5 CF Extremadura Extremadura 38 70 27 51
6 Moralo Moralo 38 64 35 48
7 Mérida CP Mérida CP 38 57 34 48
8 UC La Estrella Estrella 38 60 56 43
9 Diter Zafra Diter Zafra 38 62 49 38
10 Sanvicenteño Sanvicenteñ 38 52 59 35
11 UD Fuente de Cantos Fuente 38 36 53 34
12 EMD Aceuchal Aceuchal 38 47 74 32
13 CD Villanovense Villanovense 38 32 44 32
14 Guareña Guareña 38 55 85 28
15 CD Azuaga CD Azuaga 38 43 73 28
16 Puebla Patria Puebla 38 37 80 27
17 Olivenza Olivenza 38 26 59 25
18 Villafranca Villafranca 38 38 67 25
19 Castuera Castuera 38 27 80 16
20 Calamonte Calamonte 38 37 103 15
TEMPORADA 1984/1985
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Plasencia Plasencia 38 130 19 66
2 CF Extremadura Extremadura 38 86 29 61
3 CP Cacereño Cacereño 38 99 28 58
4 Mérida CP Mérida CP 38 64 33 55
5 Diter Zafra Diter Zafra 38 66 30 50
6 CD Villanovense Villanovense 38 55 32 47
7 UD Montijo UD Montijo 38 48 47 40
8 Moralo Moralo 38 41 39 37
9 CD Don Benito Benito 38 56 47 36
10 UC La Estrella Estrella 38 34 45 36
11 Sanvicenteño Sanvicenteñ 38 35 58 34
12 UD Fuente de Cantos Fuente 38 46 86 30
13 Villafranca Villafranca 38 35 70 28
14 EMD Aceuchal Aceuchal 38 34 65 27
15 CD Azuaga CD Azuaga 38 40 84 27
16 Olivenza Olivenza 38 33 60 27
17 CD Badajoz Promesas Badajoz 38 47 60 27
18 Calamonte Calamonte 38 32 65 25
19 Monteresma Atalaya Monteresma 38 41 90 25
20 Vasco Núñez Vasco 38 55 90 24
TEMPORADA 1983/1984
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Diter Zafra Diter Zafra 38 99 28 59
2 Plasencia Plasencia 38 78 15 58
3 CP Cacereño Cacereño 38 88 25 54
4 CF Extremadura Extremadura 38 74 26 54
5 CD Don Benito Benito 38 74 48 48
6 Mérida CP Mérida CP 38 51 26 47
7 Moralo Moralo 38 53 40 44
8 UD Montijo UD Montijo 38 51 43 41
9 CD Villanovense Villanovense 38 45 33 40
10 Villafranca Villafranca 38 52 58 38
11 UC La Estrella Estrella 38 66 52 36
12 CD Azuaga CD Azuaga 38 37 63 33
13 Olivenza Olivenza 38 45 77 31
14 Calamonte Calamonte 38 51 83 31
15 CD Badajoz Promesas Badajoz 38 50 65 29
16 Sanvicenteño Sanvicenteñ 38 34 70 28
17 UD Fuente de Cantos Fuente 38 35 80 27
18 Puebla Patria Puebla 38 23 63 24
19 CD Quintanar del Rey Quintanar 38 34 92 21
20 AD Llerenense Llerenense 38 26 79 17

  USO DE MEMORIA  
7,674,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1642
Total Execution Time  0.1656
  CADENA URL  
/historico/Ud-Fuente-Cantos
  GET DATOS  
$_GET['/historico/Ud-Fuente-Cantos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0062  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 = 'Ud-Fuente-Cantos' 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.0023  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=9340 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=9340 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9340 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0045  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 = '9340' ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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 = '9340' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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 = '9340' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0040  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=9340 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 (72274,68587) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72274 AND teamId = 9340
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 68587 AND teamId = 9340
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 = '9340' 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 = '9340' and rp.type = 4
0.0022  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 = '9340' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0048  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 9340 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.0040  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 9340 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 9340 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 = 9340 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 63719 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 = 50282 AND t.round = 28 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 = 44630 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 `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 = 39346 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 `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 = 33364 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 `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 = 15456 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 `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 = 3923 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 2563 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 `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 = 1958 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 `tables1989` 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 = 21808 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 `tables1988` 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 = 21789 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 `tables1987` 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 = 21770 AND t.round = 38 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 `tables1986` 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 = 21756 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 `tables1985` 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 = 21742 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 `tables1984` 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 = 21727 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC