4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Valdesoto
TEMPORADA 2023/2024
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Real Sporting C Real 31 54 14 69
2 EI San Martín Martín 31 45 14 68
3 Astur Astur 31 46 22 58
4 Mosconia Mosconia 30 55 24 57
5 TSK Roces TSK Roces 31 51 40 53
6 Club Siero Club Siero 31 49 34 49
7 Vallobin CD Vallobin CD 30 43 31 49
8 Navarro Navarro 31 35 34 43
9 U.Comercial U.Comercial 31 46 44 41
10 Muros Balompié Muros 31 36 39 41
11 Universidad Oviedo Universidad 31 37 41 39
12 Llaranes CF Llaranes CF 31 32 36 37
13 Andés Andés 31 30 42 37
14 Candás CF Candás CF 31 36 48 35
15 Valdesoto Valdesoto 31 25 36 33
16 La Fresneda Fresneda 31 22 42 32
17 Berrón Berrón 31 24 42 28
18 Club Asturias de Blimea Club 31 30 60 27
19 Atlético de Lugones Atlético 31 38 59 26
20 Colloto Colloto 31 22 54 18
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Covadonga Covadonga 30 53 21 65
2 Sporting Atlético Sporting 30 56 21 64
3 L´Entregu CF L´Entregu 30 42 28 60
4 UD Llanera UD Llanera 30 49 26 55
5 CD Praviano CD Praviano 30 40 23 53
6 Caudal Deportivo Caudal 30 41 21 50
7 Lealtad Villaviciosa Lealtad 30 31 27 43
8 Llanes Llanes 30 36 40 40
9 Real Titánico Real 30 28 44 36
10 CD Colunga CD Colunga 30 35 39 36
11 CD Tuilla CD Tuilla 30 39 52 36
12 UC Ceares UC Ceares 30 35 44 34
13 Luarca CF Luarca CF 30 21 32 30
14 Condal Condal 30 20 42 25
15 Avilés Stadium Avilés 30 25 52 23
16 Valdesoto Valdesoto 30 22 61 14
TEMPORADA 2021/2022
PRIMERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Valdesoto Valdesoto 22 27 11 47
2 Condal Condal 22 31 20 43
3 Berrón Berrón 22 34 21 39
4 Astur Astur 22 31 21 38
5 Vallobin CD Vallobin CD 22 32 21 36
6 Colloto Colloto 22 27 24 33
7 Unión Comercial Unión 22 40 26 33
8 Nalón CF Nalón CF 22 27 32 28
9 Madalena Madalena 22 41 48 23
10 Club Siero Club Siero 22 27 41 20
11 Europa de Nava Europa Nava 22 21 43 16
12 Ribadedeva Ribadedeva 22 15 45 10
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 UC Ceares UC Ceares 20 29 16 44
2 Real Avilés Industrial Real Avilés 20 33 13 40
3 UD Llanera UD Llanera 20 38 28 38
4 Caudal Deportivo Caudal 20 36 18 38
5 UD Gijón Industrial Gijón 20 34 27 27
6 SD Lenense Proinastur Lenense 20 24 27 25
7 CD Praviano CD Praviano 20 23 28 24
8 Navarro Navarro 20 18 26 22
9 Mosconia Mosconia 20 15 28 20
10 Vallobin CD Vallobin CD 20 14 32 17
11 Avilés Stadium Avilés 20 12 33 12
12 L´Entregu CF L´Entregu 18 32 13 40
13 EI San Martín Martín 18 31 21 33
14 Llanes Llanes 18 29 16 32
15 CD Tuilla CD Tuilla 18 25 19 27
16 Real Titánico Real 18 19 25 23
17 Urraca CF Urraca CF 18 9 12 22
18 Condal Condal 18 13 19 22
19 CD Colunga CD Colunga 18 11 17 20
20 Club Siero Club Siero 18 12 23 15
21 Valdesoto Valdesoto 18 10 26 12
TEMPORADA 2019/2020
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Real Titánico Real 28 55 20 69
2 Avilés Stadium Avilés 28 28 12 53
3 Valdesoto Valdesoto 28 39 24 51
4 TSK Roces TSK Roces 28 50 26 50
5 UD San Claudio Claudio 28 44 28 49
6 Podes CF Podes CF 28 41 34 49
7 Astur Astur 28 34 21 44
8 Atlético de Lugones Atlético 28 40 31 41
9 Candás CF Candás CF 28 30 32 36
10 Club Asturias de Blimea Club 28 43 35 34
11 Unión Comercial Unión 28 35 37 34
12 Berrón Berrón 28 28 45 34
13 Colloto Colloto 28 33 41 33
14 Universidad Oviedo Universidad 28 34 34 32
15 La Guía Norte Astur Guía Norte 28 34 41 30
16 Llaranes CF Llaranes CF 28 33 48 29
17 Tineo Tineo 28 22 36 26
18 Nalón CF Nalón CF 28 28 48 26
19 CD Turón CD Turón 28 30 53 26
20 Madalena Madalena 28 28 63 18
TEMPORADA 2018/2019
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Urraca CF Urraca CF 38 58 28 74
2 Vallobin CD Vallobin CD 38 59 33 74
3 Navarro Navarro 38 61 27 73
4 SD Lenense Proinastur Lenense 38 65 36 72
5 Avilés Stadium Avilés 38 52 27 71
6 Real Titánico Real 38 43 28 67
7 Tineo Tineo 38 63 59 56
8 TSK Roces TSK Roces 38 58 46 54
9 Club Asturias de Blimea Club 38 59 61 52
10 Atlético de Lugones Atlético 38 41 43 48
11 Astur Astur 38 45 49 47
12 Candás CF Candás CF 38 47 53 44
13 Colloto Colloto 38 47 59 43
14 Valdesoto Valdesoto 38 47 65 43
15 Berrón Berrón 38 37 59 42
16 CD Turón CD Turón 38 45 65 41
17 Nalón CF Nalón CF 38 46 67 41
18 Andés Andés 38 43 57 39
19 Ribadesella Ribadesella 38 39 62 32
20 Ribadedeva Ribadedeva 38 33 64 31
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Oviedo Vetusta Real Oviedo 38 73 19 82
2 Langreo Langreo 38 89 23 78
3 Marino de Luanco Marino 38 70 21 76
4 Llanes Llanes 38 65 48 75
5 CD Covadonga Covadonga 38 83 46 72
6 UC Ceares UC Ceares 38 46 30 60
7 CD Tuilla CD Tuilla 38 60 41 59
8 CD Praviano CD Praviano 38 45 37 58
9 L´Entregu CF L´Entregu 38 53 50 53
10 EI San Martín Martín 38 41 50 51
11 Mosconia Mosconia 38 39 57 50
12 UD Gijón Industrial Gijón 38 52 55 47
13 Condal Condal 38 39 67 44
14 CD Colunga CD Colunga 38 44 60 42
15 UD Llanera UD Llanera 38 48 65 39
16 Club Siero Club Siero 38 34 70 36
17 Real Avilés Industrial Real Avilés 38 35 64 32
18 Valdesoto Valdesoto 38 27 55 30
19 Atlético de Lugones Atlético 38 22 68 28
20 TSK Roces TSK Roces 38 29 68 24
TEMPORADA 2016/2017
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 TSK Roces TSK Roces 38 58 25 72
2 UD Gijón Industrial Gijón 38 65 33 71
3 EI San Martín Martín 38 63 34 70
4 Valdesoto Valdesoto 38 61 31 69
5 Nalón CF Nalón CF 38 67 37 67
6 CD Rayo Carbayín Rayo 38 46 31 64
7 UD San Claudio Claudio 38 58 56 57
8 Ribadesella Ribadesella 38 76 76 55
9 Unión Comercial Unión 38 50 51 55
10 Andés Andés 38 57 61 48
11 Navarro Navarro 38 44 54 48
12 Astur Astur 38 42 48 47
13 Universidad Oviedo Universidad 38 50 66 47
14 Madalena Madalena 38 59 62 45
15 Ribadedeva Ribadedeva 38 44 51 44
16 Candás CF Candás CF 38 42 61 40
17 CD Turón CD Turón 38 45 69 38
18 Muros Balompié Muros 38 45 82 36
19 Luarca CF Luarca CF 38 44 65 33
20 Berrón Berrón 38 46 69 33
TEMPORADA 2015/2016
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 L´Entregu CF L´Entregu 38 70 30 78
2 UD Llanera UD Llanera 38 69 28 76
3 SD Lenense Proinastur Lenense 38 54 28 76
4 Andés Andés 38 60 38 73
5 EI San Martín Martín 38 61 34 72
6 Navarro Navarro 38 58 27 71
7 Nalón CF Nalón CF 38 63 38 70
8 CD Turón CD Turón 38 57 49 60
9 Valdesoto Valdesoto 38 54 50 58
10 Unión Comercial Unión 38 51 48 50
11 Luarca CF Luarca CF 38 54 60 50
12 Madalena Madalena 38 58 62 48
13 Candás CF Candás CF 38 48 64 46
14 UD San Claudio Claudio 38 46 46 45
15 Universidad Oviedo Universidad 38 34 54 45
16 Berrón Berrón 38 48 59 41
17 CD Rayo Carbayín Rayo 38 47 71 41
18 SCD Campomanes Campomanes 38 35 66 33
19 Real Avilés Cf B Real Avilés 38 26 83 17
20 La Fresneda Fresneda 38 36 94 14
TEMPORADA 2014/2015
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Club Siero Club Siero 38 69 39 69
2 CD Colunga CD Colunga 38 60 39 69
3 Tineo Tineo 38 63 42 68
4 CD Rayo Carbayín Rayo 38 63 47 67
5 Sd Llano 2000 Llano 2000 38 45 23 62
6 EI San Martín Martín 38 59 53 54
7 Valdesoto Valdesoto 38 57 55 53
8 UD Llanera UD Llanera 38 63 61 52
9 Candás CF Candás CF 38 49 48 51
10 CD Turón CD Turón 38 50 50 51
11 SCD Campomanes Campomanes 38 51 56 51
12 UD San Claudio Claudio 38 41 42 50
13 Unión Comercial Unión 38 35 48 50
14 Madalena Madalena 38 52 55 49
15 Luarca CF Luarca CF 38 41 43 48
16 Navarro Navarro 38 42 45 48
17 Real Tapia CF Real Tapia 38 46 58 43
18 Boal CF Boal CF 38 36 56 38
19 Muros Balompié Muros 38 44 62 34
20 CD Raíces CD Raíces 38 36 80 25
TEMPORADA 2013/2014
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 TSK Roces TSK Roces 38 75 32 77
2 Llanes Llanes 38 86 41 76
3 Astur Astur 38 71 38 76
4 Mosconia Mosconia 38 78 38 70
5 CD Colunga CD Colunga 38 68 44 66
6 CD Rayo Carbayín Rayo 38 67 50 61
7 Navarro Navarro 38 47 35 61
8 Valdesoto Valdesoto 38 59 46 55
9 Atlético Siero Atlético 38 56 53 52
10 Sd Llano 2000 Llano 2000 38 46 44 52
11 Tineo Tineo 38 38 47 51
12 UD Llanera UD Llanera 38 58 56 50
13 Muros Balompié Muros 38 56 54 50
14 U.Comercial U.Comercial 38 50 52 49
15 CD Turón CD Turón 38 68 69 47
16 Boal CF Boal CF 38 51 59 46
17 SCD Campomanes Campomanes 38 54 65 45
18 Nalón CF Nalón CF 38 34 54 39
19 Pumarín CF Pumarín CF 38 53 65 31
20 Navia CF Navia CF 38 21 194 3
TEMPORADA 2012/2013
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Real Avilés Cf B Real Avilés 37 69 32 73
2 SD Lenense Proinastur Lenense 37 69 53 71
3 Andés Andés 37 69 43 70
4 Astur Astur 37 60 32 69
5 Muros Balompié Muros 38 83 37 68
6 Pumarín Cf Pumarín Cf 38 57 36 65
7 Valdesoto Valdesoto 38 53 48 60
8 TSK Roces TSK Roces 38 53 37 59
9 Tineo Tineo 38 60 45 59
10 Sd Llano 2000 Llano 2000 38 64 41 57
11 Mosconia Mosconia 38 48 44 55
12 Atlético Siero Atlético 38 51 42 51
13 SCD Campomanes Campomanes 38 53 49 48
14 Unión Comercial Unión 38 54 60 48
15 CD Colunga CD Colunga 38 48 64 46
16 CD Turón CD Turón 38 60 74 45
17 Nalón CF Nalón CF 37 55 63 43
18 Sd Colloto Sd Colloto 37 32 49 43
19 Narcea Narcea 38 31 106 11
20 La Caridad La Caridad 38 27 141 11
TEMPORADA 2011/2012
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 CD Praviano CD Praviano 38 61 35 75
2 Atlético de Lugones Atlético 38 58 25 71
3 L´Entregu CF L´Entregu 38 71 45 70
4 Urraca CF Urraca CF 38 83 58 69
5 Real Tapia CF Real Tapia 38 58 43 66
6 Club Siero Club Siero 38 69 45 62
7 SD Lenense Proinastur Lenense 38 51 55 56
8 Tineo Tineo 38 58 51 53
9 TSK Roces TSK Roces 38 54 46 52
10 Cd Universidad Oviedo B Universidad 38 57 55 51
11 Valdesoto Valdesoto 38 51 46 50
12 U.Comercial U.Comercial 38 60 54 49
13 Real Avilés Industrial B Real Avilés 38 57 58 48
14 La Caridad La Caridad 38 43 52 48
15 Andés Andés 38 44 61 48
16 SCD Campomanes Campomanes 38 54 66 42
17 Narcea Narcea 38 35 52 42
18 Ribadesella Ribadesella 38 52 71 41
19 Deportiva Piloñesa Deportiva 38 37 75 30
20 San Martín San Martín 38 28 88 25
TEMPORADA 2010/2011
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 CD Covadonga Covadonga 38 70 18 91
2 Colloto Colloto 38 74 41 73
3 Pumarín CF Pumarín CF 38 51 23 70
4 Atlético de Lugones Atlético 38 59 39 66
5 Tineo Tineo 38 47 38 66
6 Urraca CF Urraca CF 38 64 62 53
7 Narcea Narcea 38 39 51 53
8 Valdesoto Valdesoto 38 52 52 52
9 La Caridad La Caridad 38 47 48 51
10 SCD Campomanes Campomanes 38 59 51 50
11 Real Avilés Industrial B Real Avilés 38 50 49 50
12 L´Entregu CF L´Entregu 38 50 47 48
13 Club Siero Club Siero 38 49 62 48
14 Universidad de Oviedo B Universidad 38 52 68 46
15 U.Comercial U.Comercial 38 43 59 45
16 San Martín San Martín 38 57 64 44
17 Deportiva Piloñesa Deportiva 38 43 64 44
18 Mosconia Mosconia 38 52 70 42
19 Astur Astur 38 45 62 37
20 UD Llanera UD Llanera 38 37 72 26
TEMPORADA 2009/2010
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Navia CF Navia CF 38 71 43 75
2 Oviedo Vetusta Oviedo 38 52 29 69
3 Nalón Olloniego Nalón 38 77 56 67
4 Andés Andés 38 53 37 63
5 Valdesoto Valdesoto 38 55 49 62
6 Atlético de Lugones Atlético 38 47 31 58
7 Piloñesa Piloñesa 38 58 55 58
8 Narcea Narcea 38 53 52 52
9 U.Comercial U.Comercial 38 61 58 51
10 Tineo Tineo 38 52 62 50
11 La Caridad La Caridad 38 54 61 49
12 San Martín San Martín 38 44 49 48
13 Universidad de Oviedo B Universidad 38 64 70 48
14 Mosconia Mosconia 38 48 65 47
15 L´Entregu CF L´Entregu 38 67 62 46
16 Urraca CF Urraca CF 38 48 60 46
17 Atlético Siero Atlético 38 53 61 45
18 Santiago De Aller Santiago 38 46 57 44
19 Real Tapia CF Real Tapia 38 52 70 36
20 Berrón Berrón 38 42 70 31
TEMPORADA 2008/2009
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 CD Praviano CD Praviano 38 64 24 83
2 Colloto Colloto 38 63 39 73
3 Luarca CF Luarca CF 38 70 43 69
4 Tineo Tineo 38 54 29 67
5 Atlético de Lugones Atlético 38 45 46 66
6 Racing De Sama Racing Sama 38 57 43 62
7 Real Tapia CF Real Tapia 38 59 52 54
8 L´Entregu CF L´Entregu 38 57 53 53
9 San Martín San Martín 38 51 47 53
10 La Caridad La Caridad 38 53 50 53
11 Narcea Narcea 38 61 51 52
12 Andés Andés 38 39 37 52
13 U.Comercial U.Comercial 38 50 62 50
14 Universidad de Oviedo B Universidad 38 59 65 45
15 Urraca CF Urraca CF 38 44 57 45
16 Valdesoto Valdesoto 38 61 66 44
17 Santiago De Aller Santiago 38 42 65 44
18 Atlético Camocha Atlético 38 38 84 33
19 Club Hispano Club Hispano 38 38 64 32
20 CD Salas CD Salas 38 35 63 27
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Langreo Langreo 38 57 24 79
2 Real Avilés Industrial Real Avilés 38 75 26 78
3 Club Siero Club Siero 38 75 34 76
4 Ribadesella Ribadesella 38 62 34 66
5 Pumarín CF Pumarín CF 38 54 46 61
6 San Martín San Martín 38 41 33 60
7 Llanes Llanes 38 53 48 59
8 Colloto Colloto 38 47 41 59
9 Navarro Navarro 38 57 44 59
10 Real Titánico Real 38 46 45 55
11 Lealtad Villaviciosa Lealtad 38 57 56 52
12 Mosconia Mosconia 38 44 50 51
13 Navia CF Navia CF 38 53 58 48
14 Astur Astur 38 42 44 47
15 Narcea Narcea 38 35 49 45
16 Condal Condal 38 39 54 43
17 CD Turón CD Turón 38 35 70 33
18 Piloñesa Piloñesa 38 29 64 25
19 Valdesoto Valdesoto 38 33 80 21
20 San Lazaro SD Lazaro 38 31 65 21
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Marino de Luanco Marino 38 77 28 82
2 Real Oviedo Vetusta Real Oviedo 38 66 28 78
3 Langreo Langreo 38 75 33 76
4 Lealtad Villaviciosa Lealtad 38 69 40 75
5 Astur Astur 38 60 40 60
6 Navia CF Navia CF 38 58 50 59
7 Real Avilés Industrial Real Avilés 38 56 43 56
8 Real Titánico Real 38 50 55 56
9 San Martín San Martín 38 61 47 55
10 CD Turón CD Turón 38 46 50 50
11 Colloto Colloto 38 47 39 47
12 Mosconia Mosconia 38 53 48 47
13 Pumarín CF Pumarín CF 38 37 56 45
14 Valdesoto Valdesoto 38 54 73 44
15 Ribadesella Ribadesella 38 41 64 41
16 CD Trasona CD Trasona 38 36 60 41
17 Deportiva Piloñesa Deportiva 38 48 62 40
18 Llanes Llanes 38 41 69 39
19 CD Tuilla CD Tuilla 38 40 69 37
20 CD Covadonga Covadonga 38 29 90 20
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Titánico Real 38 63 39 78
2 Real Oviedo Vetusta Real Oviedo 38 89 36 75
3 Marino de Luanco Marino 38 67 31 75
4 Caudal Deportivo Caudal 38 66 39 65
5 Mosconia Mosconia 38 43 29 64
6 Universidad Oviedo Universidad 38 48 52 60
7 UD Gijón Industrial Gijón 38 45 38 60
8 Lealtad Villaviciosa Lealtad 38 63 53 58
9 Navia CF Navia CF 38 52 33 57
10 Ribadesella Ribadesella 38 65 57 56
11 San Martín San Martín 38 42 42 53
12 Club Siero Club Siero 38 45 41 53
13 Navarro Navarro 38 46 54 44
14 CD Turón CD Turón 38 34 51 44
15 Club Hispano Club Hispano 38 48 61 42
16 Pumarín CF Pumarín CF 38 44 55 41
17 Colloto Colloto 38 40 66 40
18 Deportiva Piloñesa Deportiva 38 43 62 36
19 Valdesoto Valdesoto 38 30 77 30
20 CD Praviano CD Praviano 38 21 78 15
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 88 22 65
2 Club Siero Club Siero 38 67 19 64
3 Lealtad Villaviciosa Lealtad 38 76 20 62
4 Marino de Luanco Marino 38 75 31 50
5 San Martin del Rey Aurelio Martin 38 54 27 45
6 Deportiva Piloñesa Deportiva 38 50 48 40
7 UD Gijón Industrial Gijón 38 58 59 39
8 Club Hispano Club Hispano 38 44 46 36
9 Real Titánico Real 38 43 53 35
10 SD Lenense Proinastur Lenense 38 37 41 35
11 Ribadesella Ribadesella 38 49 49 35
12 Candás CF Candás CF 38 38 47 35
13 Santiago De Aller Santiago 38 50 54 33
14 CD Turón CD Turón 38 28 45 32
15 Navarro Navarro 38 26 43 31
16 Pumarín CF Pumarín CF 38 40 60 31
17 Navia CF Navia CF 38 34 54 27
18 Berrón Berrón 38 31 64 27
19 Astur Astur 38 25 68 25
20 Valdesoto Valdesoto 38 23 86 13

  USO DE MEMORIA  
8,061,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1665
Total Execution Time  0.1679
  CADENA URL  
/historico/Valdesoto
  GET DATOS  
$_GET['/historico/Valdesoto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2645 AND type_rel = 2
0.0035  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2645 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0029  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 (427710,886617,1223270) ORDER BY n.cover_points DESC, update_date DESC
0.0038  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2645' ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '2645' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0034  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=2645 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0030  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 (73524,67976) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 67976 AND teamId = 2645
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 73524 AND teamId = 2645
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 = '2645' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2645' and rp.type = 4
0.0023  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 = '2645' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 2645 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.0059  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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 2645 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 events2024 e ON e.player_id = p.id AND e.league_id = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 2645 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 2645 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0051  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 = 73524 AND t.round = 32 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 = 67976 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 `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 = 63714 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.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 `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 = 51182 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.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 `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 = 44673 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 `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 = 39026 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 `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 = 34175 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 = 16699 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 `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 = 4081 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 = 2589 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 `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 = 1978 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 `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 = 1453 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 `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 = 1129 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 `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 = 847 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 `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 = 287 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 `tables2002` 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 = 22047 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 `tables2001` 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 = 22031 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 `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 = 21944 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 `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 = 21902 AND t.round = 38 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 = 73524 ORDER BY nameShow LIMIT 100