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

Navarro

Entrenador: Davo Sánchez Rivas

Temporada 2023/2024
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
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Urraca CF Urraca CF 38 61 25 74
2 UD Gijón Industrial Gijón 38 58 27 73
3 SD Lenense Proinastur Lenense 38 53 30 70
4 Barcia CF Barcia CF 38 46 33 62
5 Atlético de Lugones Atlético 38 51 30 62
6 TSK Roces TSK Roces 38 36 28 62
7 Llaranes CF Llaranes CF 38 48 43 61
8 Astur Astur 38 38 35 54
9 Candás CF Candás CF 38 48 49 53
10 Navarro Navarro 38 44 47 52
11 Berrón Berrón 38 43 43 51
12 Andés Andés 38 47 42 48
13 EI San Martín Martín 38 37 40 45
14 Mosconia Mosconia 38 30 36 44
15 Colloto Colloto 38 38 51 44
16 Vallobin CD Vallobin CD 38 41 45 44
17 Universidad Oviedo Universidad 38 45 57 41
18 Tineo Tineo 38 31 48 36
19 UP Langreo B Langreo 38 41 88 30
20 Lealtad Villaviciosa B Lealtad 38 15 54 21
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Oviedo Vetusta Real Oviedo 38 75 39 75
2 Sporting Atlético Sporting 38 71 25 74
3 Lealtad Villaviciosa Lealtad 38 55 27 71
4 Llanes Llanes 38 50 36 64
5 Caudal Deportivo Caudal 38 55 37 64
6 CD Colunga CD Colunga 38 51 32 61
7 L´Entregu CF L´Entregu 38 48 39 57
8 CD Praviano CD Praviano 38 51 44 56
9 CD Tuilla CD Tuilla 38 53 59 53
10 CD Covadonga Covadonga 38 48 44 51
11 Luarca CF Luarca CF 38 36 52 49
12 Real Titánico Real 38 43 44 48
13 UD Gijón Industrial Gijón 38 43 52 47
14 Urraca CF Urraca CF 38 31 35 47
15 EI San Martín Martín 38 44 48 47
16 SD Lenense Proinastur Lenense 38 39 48 46
17 TSK Roces TSK Roces 38 40 62 36
18 Navarro Navarro 38 29 55 33
19 UP Langreo B Langreo 38 36 80 26
20 Mosconia Mosconia 38 30 70 24
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
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Lealtad Villaviciosa Lealtad 28 44 12 62
2 UD Llanera UD Llanera 28 48 26 59
3 CD Covadonga Covadonga 28 65 33 57
4 Caudal Deportivo Caudal 28 54 21 56
5 CD Tuilla CD Tuilla 28 42 25 55
6 Llanes Llanes 28 47 30 48
7 Urraca CF Urraca CF 28 34 25 43
8 UD Gijón Industrial Gijón 28 42 36 39
9 L´Entregu CF L´Entregu 28 26 36 34
10 Condal Condal 28 29 37 32
11 CD Praviano CD Praviano 28 37 42 32
12 Mosconia Mosconia 28 29 33 31
13 Navarro Navarro 28 26 35 31
14 SD Lenense Proinastur Lenense 28 28 48 29
15 UC Ceares UC Ceares 28 28 37 27
16 Real Avilés Industrial Real Avilés 28 34 50 25
17 Vallobin CD Vallobin CD 28 19 32 25
18 EI San Martín Martín 28 26 49 24
19 CD Colunga CD Colunga 28 25 53 23
20 Club Siero Club Siero 28 25 48 20
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
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 UD San Claudio Claudio 38 70 37 78
2 Madalena Madalena 38 71 38 74
3 Universidad Oviedo Universidad 38 69 32 71
4 Ribadesella Ribadesella 38 67 56 66
5 Vallobin CD Vallobin CD 38 43 27 62
6 SD Lenense Proinastur Lenense 38 51 42 59
7 Astur Astur 38 46 39 57
8 Club Asturias de Blimea Club 37 51 56 50
9 Nalón CF Nalón CF 37 45 51 50
10 Urraca CF Urraca CF 38 36 40 49
11 Andés Andés 38 41 46 48
12 Tineo Tineo 38 42 44 48
13 Navarro Navarro 38 52 51 46
14 Candás CF Candás CF 38 37 41 46
15 Real Titánico Real 37 44 50 46
16 Ribadedeva Ribadedeva 37 48 63 43
17 CD Turón CD Turón 38 43 69 42
18 Unión Comercial Unión 38 48 60 40
19 CD Rayo Carbayín Rayo 38 50 66 38
20 CD Manuel Rubio Manuel Rubio 38 40 86 25
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
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Tuilla CD Tuilla 38 70 35 81
2 Universidad Oviedo Universidad 38 59 28 75
3 CD Covadonga Covadonga 38 58 30 72
4 Langreo Langreo 38 54 22 71
5 Real Oviedo Vetusta Real Oviedo 38 51 47 61
6 Lealtad Villaviciosa Lealtad 38 48 42 54
7 L´Entregu CF L´Entregu 38 42 39 54
8 Condal Condal 38 49 41 54
9 Cudillero CD Cudillero 38 46 40 53
10 Luarca CF Luarca CF 38 42 43 51
11 CD Praviano CD Praviano 38 37 50 50
12 UC Ceares UC Ceares 38 43 48 48
13 Urraca CF Urraca CF 38 55 57 45
14 Atlético de Lugones Atlético 38 42 48 43
15 Real Tapia CF Real Tapia 38 34 43 43
16 UD Gijón Industrial Gijón 38 35 42 43
17 Candás CF Candás CF 38 37 56 42
18 Llanes Llanes 38 36 45 42
19 Navia CF Navia CF 38 35 73 28
20 Navarro Navarro 38 26 70 18
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 90 21 91
2 Real Avilés Industrial Real Avilés 38 84 27 89
3 Langreo Langreo 38 60 30 70
4 CD Tuilla CD Tuilla 38 50 35 66
5 Condal Condal 38 48 37 62
6 Candás CF Candás CF 38 51 41 61
7 Luarca CF Luarca CF 38 36 40 56
8 Universidad Oviedo Universidad 38 58 53 56
9 Llanes Llanes 38 46 40 55
10 Cudillero CD Cudillero 38 53 39 55
11 CD Covadonga Covadonga 38 66 54 53
12 Navia CF Navia CF 38 36 55 46
13 UD Gijón Industrial Gijón 38 35 51 45
14 Lealtad Villaviciosa Lealtad 38 41 62 44
15 Navarro Navarro 38 44 60 42
16 UC Ceares UC Ceares 38 40 62 40
17 Real Oviedo Vetusta Real Oviedo 38 40 55 40
18 Nalón Olloniego Nalón 38 42 71 37
19 Pumarín CF Pumarín CF 38 31 51 37
20 Colloto Colloto 38 31 98 12
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Marino de Luanco Marino 38 79 30 84
2 Universidad Oviedo Universidad 38 73 31 79
3 Langreo Langreo 38 67 30 77
4 CD Tuilla CD Tuilla 38 83 51 75
5 Candás CF Candás CF 38 60 38 69
6 Condal Condal 38 57 42 61
7 Navia CF Navia CF 38 60 49 60
8 Real Oviedo Vetusta Real Oviedo 38 77 53 58
9 Navarro Navarro 38 44 54 55
10 Real Avilés Industrial Real Avilés 38 40 38 55
11 Cudillero CD Cudillero 38 39 54 43
12 Lealtad Villaviciosa Lealtad 38 40 49 41
13 Luarca CF Luarca CF 38 38 53 41
14 Llanes Llanes 38 54 72 41
15 UC Ceares UC Ceares 38 39 56 39
16 Nalón Olloniego Nalón 38 60 82 38
17 UD Gijón Industrial Gijón 38 34 50 37
18 Andés Andés 38 35 68 37
19 Ribadesella Ribadesella 38 36 76 32
20 CD Praviano CD Praviano 38 33 72 21
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 73 27 83
2 Marino de Luanco Marino 38 73 36 80
3 Universidad Oviedo Universidad 38 81 38 76
4 Llanes Llanes 38 68 38 70
5 Langreo Langreo 38 59 35 66
6 Ribadesella Ribadesella 38 63 44 65
7 CD Tuilla CD Tuilla 38 74 56 64
8 Candás CF Candás CF 38 49 32 59
9 Real Avilés Industrial Real Avilés 38 48 41 58
10 Lealtad Villaviciosa Lealtad 38 51 45 57
11 Navarro Navarro 38 49 57 45
12 Condal Condal 38 36 59 44
13 UC Ceares UC Ceares 38 39 59 44
14 Cudillero CD Cudillero 38 42 63 40
15 Gijón Ind. Gijón Ind. 38 37 65 39
16 CD Praviano CD Praviano 38 31 51 38
17 Luarca CF Luarca CF 38 31 53 36
18 Colloto Colloto 38 34 60 35
19 CD Covadonga Covadonga 38 35 61 33
20 Astur Astur 38 30 83 21
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 38 100 14 103
2 Universidad Oviedo Universidad 38 68 44 73
3 Candás CF Candás CF 38 58 37 70
4 Llanes Llanes 38 59 41 69
5 Langreo Langreo 38 63 39 60
6 CD Tuilla CD Tuilla 38 50 43 58
7 Caudal Deportivo Caudal 38 45 35 53
8 Gijón Ind. Gijón Ind. 38 46 65 51
9 Cudillero CD Cudillero 38 53 54 46
10 Lealtad Villaviciosa Lealtad 38 45 49 45
11 Real Avilés Industrial Real Avilés 38 45 44 43
12 Condal Condal 38 43 65 43
13 CD Covadonga Covadonga 38 43 62 43
14 Ribadesella Ribadesella 38 48 60 42
15 UC Ceares UC Ceares 38 45 57 42
16 Navarro Navarro 38 43 59 42
17 Astur Astur 38 49 70 41
18 Nalón Olloniego Nalón 38 49 69 38
19 Club Siero Club Siero 38 38 61 36
20 Mosconia Mosconia 38 57 79 34
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 37 77 25 85
2 Sporting Atlético Sporting 38 74 43 72
3 Cudillero CD Cudillero 39 59 34 71
4 Langreo Langreo 38 59 37 70
5 Universidad Oviedo Universidad 38 72 42 70
6 CD Tuilla CD Tuilla 38 62 44 67
7 Caudal Deportivo Caudal 38 68 47 65
8 Lealtad Villaviciosa Lealtad 38 46 37 62
9 Ribadesella Ribadesella 38 54 43 59
10 Llanes Llanes 38 50 39 55
11 Real Avilés Industrial Real Avilés 38 49 46 54
12 UC Ceares UC Ceares 38 53 55 50
13 Navarro Navarro 38 33 42 47
14 Club Siero Club Siero 38 59 67 42
15 Astur Astur 38 43 79 36
16 Candás CF Candás CF 38 45 71 36
17 Condal Condal 38 38 58 34
18 Real Tapia CF Real Tapia 38 40 70 33
19 Club Hispano Club Hispano 38 31 89 20
20 Colloto Colloto 38 37 81 17
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 58 27 83
2 Lealtad Villaviciosa Lealtad 38 70 34 80
3 Langreo Langreo 38 61 30 74
4 Sporting Atlético Sporting 38 70 37 71
5 CD Tuilla CD Tuilla 38 61 42 71
6 Real Avilés Industrial Real Avilés 38 52 34 61
7 Ribadesella Ribadesella 38 57 39 59
8 Cudillero CD Cudillero 38 50 41 49
9 UC Ceares UC Ceares 38 48 58 48
10 Club Siero Club Siero 38 43 41 47
11 Condal Condal 38 50 51 46
12 Navarro Navarro 38 32 40 42
13 Llanes Llanes 38 37 52 42
14 Astur Astur 38 49 70 40
15 Club Hispano Club Hispano 38 41 64 40
16 CD Covadonga Covadonga 38 48 58 39
17 Gijón Ind. Gijón Ind. 38 42 67 38
18 CD Praviano CD Praviano 38 39 56 37
19 Mosconia Mosconia 38 44 65 35
20 San Martín San Martín 38 41 87 29
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Universidad Oviedo Universidad 38 74 28 80
2 Langreo Langreo 38 57 33 76
3 Ribadesella Ribadesella 38 59 32 72
4 Lealtad Villaviciosa Lealtad 38 70 32 71
5 Caudal Deportivo Caudal 38 53 32 65
6 Astur Astur 38 49 37 64
7 Real Avilés Industrial Real Avilés 38 48 43 57
8 Sporting Atlético Sporting 38 40 37 53
9 Club Siero Club Siero 38 47 46 51
10 Navarro Navarro 38 37 37 50
11 Mosconia Mosconia 38 42 42 50
12 CD Covadonga Covadonga 38 45 46 49
13 UD Gijón Industrial Gijón 38 47 44 48
14 Condal Condal 38 40 53 47
15 CD Tuilla CD Tuilla 38 32 53 44
16 Club Hispano Club Hispano 38 40 60 40
17 UC Ceares UC Ceares 38 37 51 38
18 Real Tapia CF Real Tapia 38 43 48 35
19 Berrón Berrón 38 38 60 34
20 Real Titánico Real 38 28 112 10
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 38 72 30 80
2 Ribadesella Ribadesella 38 68 45 79
3 Mosconia Mosconia 38 61 35 73
4 Langreo Langreo 38 61 29 72
5 Sporting Atlético Sporting 38 71 31 70
6 Real Avilés Industrial Real Avilés 38 54 40 64
7 Caudal Deportivo Caudal 38 63 46 61
8 Universidad Oviedo Universidad 38 63 44 60
9 Astur Astur 38 65 50 54
10 Club Siero Club Siero 38 47 45 53
11 UC Ceares UC Ceares 38 49 52 53
12 Lealtad Villaviciosa Lealtad 38 51 49 51
13 Real Titánico Real 38 54 60 49
14 UD Gijón Industrial Gijón 38 39 65 44
15 Club Hispano Club Hispano 38 34 67 43
16 Berrón Berrón 38 36 54 40
17 Navarro Navarro 38 44 69 40
18 Llanes Llanes 38 40 59 38
19 San Martín San Martín 38 34 70 23
20 Andés Andés 38 22 88 12

  USO DE MEMORIA  
8,330,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1242
Total Execution Time  0.1254
  CADENA URL  
/historico/Navarro
  GET DATOS  
$_GET['/historico/Navarro']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1784 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=72 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 72 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 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 (865740,698945,420684,366243,365678) ORDER BY n.cover_points DESC, update_date 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 = '1784' 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 = 73524 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = '1784' 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 = '1784' 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 = '1784' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 = 1784 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  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.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 `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 = 68760 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.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 `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 = 62386 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 `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 = 58580 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.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 = 50270 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.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 = 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.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 `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 = 39192 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.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 = 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.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1943 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 1399 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 `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 = 1113 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 834 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 `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 = 132 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 `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 = 87 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 `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 = 22114 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 `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 = 22095 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC