4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Numancia B
TEMPORADA 2023/2024
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CF Briviesca Briviesca 28 59 19 57
2 CD Villamuriel Villamuriel 28 46 25 53
3 Turégano Turégano 28 54 37 49
4 Vista Alegre CD Vista Alegre 28 37 25 45
5 Villarcayo Nela Villarcayo 28 36 27 44
6 CD San José José 28 48 36 44
7 Numancia B Numancia B 28 38 30 42
8 SC Uxama SC Uxama 28 35 40 41
9 Calasanz de Soria Calasanz 28 41 34 39
10 Racing Lermeño CF Racing 28 24 34 39
11 Cebrereña Cebrereña 28 37 41 36
12 UP Palencia UP Palencia 28 25 28 33
13 Belorado Belorado 28 41 60 31
14 Unami CP Unami CP 28 32 45 25
15 Deportivo Arenas Deportivo 28 29 44 25
16 Carejas Paredes Carejas 28 16 73 11
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Arandina Arandina 30 55 18 68
2 Atl. Astorga Atl. Astorga 30 54 27 61
3 Salamanca UDS Salamanca 30 38 26 53
4 Real Ávila Real Ávila 30 40 26 50
5 Atlético Tordesillas Atlético 30 30 24 50
6 SD Almazán SD Almazán 30 36 32 47
7 La Virgen del Camino Virgen 30 36 33 45
8 Ponferradina B Ponferradina 30 37 32 39
9 Mirandés B Mirandés B 30 41 38 38
10 Atl. Bembibre Atl. 30 35 40 35
11 Becerril Becerril 30 34 46 35
12 Palencia CF Palencia CF 30 42 42 34
13 Júpiter Leonés Júpiter 30 22 33 33
14 UD Santa Marta Santa Marta 30 31 59 28
15 Unami CP Unami CP 30 20 52 24
16 Numancia B Numancia B 30 28 51 20
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Guijuelo Guijuelo 32 61 16 75
2 SD Almazán SD Almazán 32 51 28 64
3 Real Ávila Real Ávila 32 45 25 58
4 Mirandés B Mirandés B 32 36 24 55
5 Atlético Tordesillas Atlético 32 37 28 54
6 Júpiter Leonés Júpiter 32 55 37 54
7 Arandina Arandina 32 39 22 53
8 Palencia CF Palencia CF 32 45 36 47
9 Atl. Astorga Atl. Astorga 32 33 37 42
10 Atl. Bembibre Atl. 32 32 40 40
11 La Virgen del Camino Virgen 32 28 34 39
12 Numancia B Numancia B 32 40 48 36
13 UD Santa Marta Santa Marta 32 37 49 35
14 Ribert Ribert 32 34 49 32
15 Salamanca UDS B Salamanca 32 22 51 30
16 Ciudad Rodrigo Ciudad 32 29 65 20
17 DiocesÁvila - UCAV DiocesÁvila 32 21 56 19
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Palencia Cristo Atlético Palencia 20 29 11 44
2 Atl. Astorga Atl. Astorga 20 26 11 35
3 Júpiter Leonés Júpiter 20 25 18 35
4 La Virgen del Camino Virgen 20 22 18 31
5 Atlético Tordesillas Atlético 20 21 22 26
6 Atl. Bembibre Atl. 20 17 20 26
7 La Bañeza La Bañeza 20 23 23 25
8 Salamanca UDS B Salamanca 20 17 26 22
9 UD Santa Marta Santa Marta 20 14 17 21
10 Peñaranda Bracamonte Peñaranda 20 13 28 16
11 Becerril Becerril 20 10 23 15
12 Gimnástica Segoviana Gimnástica 22 54 10 57
13 Burgos CF B Burgos CF B 22 33 15 40
14 Numancia B Numancia B 22 40 34 39
15 Arandina Arandina 22 41 31 36
16 Mirandés B Mirandés B 22 30 21 33
17 Real Ávila Real Ávila 22 25 23 31
18 SD Almazán SD Almazán 22 26 31 31
19 DiocesÁvila - UCAV DiocesÁvila 22 19 42 23
20 CD La Granja Granja 22 24 30 22
21 Real Burgos CF Real Burgos 22 18 37 19
22 Cebrereña Cebrereña 22 18 36 19
23 CD Burgalés Burgalés 22 17 35 17
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Zamora Zamora 28 63 15 73
2 Gimnástica Segoviana Gimnástica 29 57 20 70
3 Arandina Arandina 28 44 17 59
4 Numancia B Numancia B 28 51 18 57
5 Burgos CF B Burgos CF B 29 45 21 55
6 Palencia Cristo Atlético Palencia 28 40 18 51
7 Atl. Astorga Atl. Astorga 28 46 26 50
8 Real Ávila Real Ávila 28 35 28 44
9 Salamanca UDS B Salamanca 29 37 39 42
10 SD Almazán SD Almazán 29 36 40 38
11 Real Burgos CF Real Burgos 29 36 39 36
12 Júpiter Leonés Júpiter 29 40 50 35
13 CD Burgalés Burgalés 29 26 33 34
14 UD Santa Marta Santa Marta 29 24 32 32
15 Becerril Becerril 28 30 46 32
16 La Virgen del Camino Virgen 29 33 54 30
17 Atlético Tordesillas Atlético 28 27 40 25
18 La Bañeza La Bañeza 29 20 56 21
19 Mirandés B Mirandés B 29 24 54 20
20 Atl. Bembibre Atl. 28 17 40 19
21 CD La Granja Granja 29 25 70 16
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Zamora Zamora 38 94 22 90
2 Gimnástica Segoviana Gimnástica 38 77 24 87
3 Arandina Arandina 38 71 16 83
4 Numancia B Numancia B 38 69 25 80
5 Atl. Astorga Atl. Astorga 38 86 35 77
6 Real Ávila Real Ávila 38 53 32 68
7 Palencia Cristo Atlético Palencia 38 61 55 58
8 Júpiter Leonés Júpiter 38 57 47 57
9 La Virgen del Camino Virgen 38 41 55 54
10 Burgos CF B Burgos CF B 38 42 43 54
11 Atlético Tordesillas Atlético 38 41 45 53
12 SD Almazán SD Almazán 38 49 56 49
13 UD Santa Marta Santa Marta 38 36 58 37
14 Atl. Bembibre Atl. 38 27 46 35
15 La Bañeza La Bañeza 38 38 72 34
16 CD Burgalés Burgalés 38 36 59 32
17 CD La Granja Granja 38 35 81 28
18 CF Briviesca Briviesca 38 28 68 27
19 Cebrereña Cebrereña 38 29 65 25
20 SC Uxama SC Uxama 38 24 90 16
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Unionistas CF Unionistas 38 72 34 80
2 Arandina Arandina 38 79 26 77
3 Palencia Cristo Atlético Palencia 38 69 38 74
4 Salamanca UDS Salamanca 38 74 35 74
5 Atl. Astorga Atl. Astorga 38 66 34 73
6 Atlético Tordesillas Atlético 38 66 40 72
7 La Bañeza La Bañeza 38 53 52 68
8 Numancia B Numancia B 38 55 30 66
9 Zamora Zamora 38 51 41 58
10 Real Ávila Real Ávila 38 50 49 52
11 La Virgen del Camino Virgen 38 41 54 42
12 Cebrereña Cebrereña 38 55 66 42
13 Atl. Bembibre Atl. 38 40 61 38
14 SD Almazán SD Almazán 38 38 51 38
15 CD Burgalés Burgalés 38 44 56 37
16 Burgos CF B Burgos CF B 38 38 61 35
17 SC Uxama SC Uxama 38 39 61 33
18 Real Burgos CF Real Burgos 38 31 82 32
19 Becerril Becerril 38 42 73 32
20 CD San José José 38 26 85 18
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Gimnástica Segoviana Gimnástica 38 97 22 91
2 Atl. Astorga Atl. Astorga 38 83 37 80
3 Unionistas CF Unionistas 38 77 29 78
4 Palencia Cristo Atlético Palencia 38 73 35 76
5 SD Almazán SD Almazán 38 69 47 68
6 Zamora Zamora 38 51 42 60
7 Real Ávila Real Ávila 38 65 55 54
8 Numancia B Numancia B 38 55 55 53
9 La Virgen del Camino Virgen 38 56 56 50
10 Atl. Bembibre Atl. 38 42 51 48
11 CD Burgalés Burgalés 38 53 53 48
12 La Bañeza La Bañeza 38 49 52 47
13 CD San José José 38 39 68 45
14 Atlético Tordesillas Atlético 38 53 70 44
15 Burgos CF B Burgos CF B 38 39 55 43
16 Cebrereña Cebrereña 38 38 55 41
17 SC Uxama SC Uxama 38 37 45 41
18 CD Villamuriel Villamuriel 38 35 49 37
19 Mirandés B Mirandés B 38 26 49 37
20 CD Villaralbo Villaralbo 38 27 139 13
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Zamora Zamora 38 75 29 84
2 Gimnástica Segoviana Gimnástica 38 74 32 77
3 CD Palencia Balompié Palencia 38 64 26 75
4 CD Villaralbo Villaralbo 38 52 26 71
5 La Bañeza La Bañeza 38 53 30 70
6 La Virgen del Camino Virgen 38 55 52 62
7 Atlético Tordesillas Atlético 38 52 53 54
8 Atl. Bembibre Atl. 38 48 44 53
9 SC Uxama SC Uxama 38 37 53 51
10 Numancia B Numancia B 38 51 43 50
11 SD Almazán SD Almazán 38 50 53 49
12 Cebrereña Cebrereña 38 55 61 46
13 CD Villamuriel Villamuriel 38 38 47 46
14 CD Burgalés Burgalés 38 37 41 46
15 Burgos CF B Burgos CF B 38 33 50 43
16 Palencia Cristo Atlético Palencia 38 40 63 40
17 Mirandés B Mirandés B 38 39 67 36
18 Ciudad Rodrigo Ciudad 38 38 68 36
19 UD Santa Marta Santa Marta 38 37 57 36
20 Becerril Becerril 38 34 67 25
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Arandina Arandina 38 63 29 74
2 Numancia B Numancia B 38 65 28 66
3 CD Palencia Balompié Palencia 38 62 36 65
4 Gimnástica Segoviana Gimnástica 38 46 31 64
5 Atl. Bembibre Atl. 38 62 29 64
6 SD Almazán SD Almazán 38 54 42 62
7 Becerril Becerril 38 56 53 59
8 La Virgen del Camino Virgen 38 50 46 57
9 Salamanca UDS Salamanca 38 60 47 55
10 Mirandés B Mirandés B 38 44 44 54
11 La Bañeza La Bañeza 38 42 41 52
12 CD Burgalés Burgalés 38 40 44 52
13 CD Villaralbo Villaralbo 38 36 47 47
14 Atlético Tordesillas Atlético 38 44 62 47
15 Palencia Cristo Atlético Palencia 38 40 45 45
16 Burgos CF B Burgos CF B 38 38 63 42
17 Cebrereña Cebrereña 38 37 55 41
18 CD La Granja Granja 38 33 61 37
19 Real Ávila Real Ávila 38 37 51 33
20 CD Villa de Simancas Villa 38 38 93 23
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Real Valladolid Promesas Real 38 71 30 83
2 Atl. Astorga Atl. Astorga 38 68 32 77
3 Arandina Arandina 38 60 31 75
4 Real Ávila Real Ávila 38 65 35 69
5 Numancia B Numancia B 38 57 42 64
6 Gimnástica Segoviana Gimnástica 38 58 47 62
7 SD Almazán SD Almazán 38 45 35 61
8 CD Burgalés Burgalés 38 51 44 59
9 Salamanca UDS Salamanca 38 52 54 54
10 La Virgen del Camino Virgen 38 59 64 46
11 CD La Granja Granja 38 46 52 46
12 Atl. Bembibre Atl. 38 48 47 45
13 La Bañeza La Bañeza 38 55 66 44
14 Cebrereña Cebrereña 38 50 66 42
15 Atlético Tordesillas Atlético 38 40 57 42
16 Palencia Cristo Atlético Palencia 38 45 60 41
17 Becerril Becerril 38 38 58 40
18 Unami CP Unami CP 38 50 64 40
19 UD Santa Marta Santa Marta 38 31 64 31
20 Racing Lermeño CF Racing 38 26 67 20
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Burgos Burgos 38 80 19 90
2 Cultural Leonesa Cultural 38 70 25 82
3 Arandina Arandina 38 65 22 82
4 Gimnástica Segoviana Gimnástica 38 80 38 75
5 Real Valladolid Promesas Real 38 68 25 73
6 CD La Granja Granja 38 50 36 69
7 Atl. Astorga Atl. Astorga 38 60 41 68
8 Atl. Bembibre Atl. 38 55 43 59
9 La Virgen del Camino Virgen 38 51 51 57
10 Real Ávila Real Ávila 38 47 46 55
11 Numancia B Numancia B 38 51 56 53
12 Palencia Cristo Atlético Palencia 38 35 46 43
13 SD Almazán SD Almazán 38 36 55 43
14 Unami CP Unami CP 38 39 67 38
15 Salamanca B Salamanca B 38 27 48 36
16 Racing Lermeño CF Racing 38 35 63 34
17 UD Santa Marta Santa Marta 38 25 50 32
18 Palencia Palencia 38 32 67 32
19 CD Villaralbo Villaralbo 38 24 65 32
20 CD Cuéllar Balompié Cuéllar 38 20 87 9
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Real Valladolid Promesas Real 38 76 42 79
2 Real Ávila Real Ávila 38 79 43 78
3 Cultural Leonesa Cultural 38 75 37 76
4 CD Villaralbo Villaralbo 38 72 38 73
5 Atl. Bembibre Atl. 38 72 33 72
6 Atl. Astorga Atl. Astorga 38 76 36 70
7 Iscar Iscar 38 51 61 59
8 La Virgen del Camino Virgen 38 60 51 58
9 Numancia B Numancia B 38 59 60 51
10 SD Almazán SD Almazán 38 40 54 49
11 Palencia Cristo Atlético Palencia 38 54 54 48
12 Racing Lermeño CF Racing 38 41 62 48
13 CD La Granja Granja 38 41 42 46
14 Atlético Tordesillas Atlético 38 43 61 45
15 Salamanca B Salamanca B 38 45 56 42
16 Burgos CF B Burgos CF B 38 44 53 40
17 Cd Aguilar Cd Aguilar 38 45 62 38
18 CD Huracán Z Huracán 38 45 74 36
19 Béjar Industrial Béjar 38 46 77 35
20 Ponferradina B Ponferradina 38 31 99 12
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Burgos Burgos 38 75 23 84
2 CD Villaralbo Villaralbo 38 83 35 83
3 Gimnástica Segoviana Gimnástica 38 68 26 81
4 Arandina Arandina 38 61 26 78
5 Real Valladolid Promesas Real 38 67 25 69
6 SD Almazán SD Almazán 38 53 49 55
7 Real Ávila Real Ávila 38 48 44 55
8 Iscar Iscar 38 48 62 53
9 Numancia B Numancia B 38 56 47 53
10 CD Huracán Z Huracán 38 30 37 51
11 Atl. Bembibre Atl. 38 55 46 50
12 Atl. Astorga Atl. Astorga 38 39 44 50
13 Cd Aguilar Cd Aguilar 38 41 60 48
14 Ponferradina B Ponferradina 38 45 49 42
15 Palencia Cristo Atlético Palencia 38 27 43 38
16 Atlético Tordesillas Atlético 38 33 65 35
17 Racing Lermeño CF Racing 38 28 61 32
18 Cebrereña Cebrereña 38 42 92 30
19 UD Santa Marta Santa Marta 38 36 68 29
20 Venta De Baños Venta Baños 38 30 63 26
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Burgos Burgos 38 62 18 90
2 Real Valladolid Promesas Real 38 85 26 85
3 Arandina Arandina 38 60 25 72
4 Real Ávila Real Ávila 38 58 36 69
5 CD Huracán Z Huracán 38 64 35 68
6 CD Villaralbo Villaralbo 38 61 33 63
7 Atl. Bembibre Atl. 38 58 47 60
8 Gimnástica Segoviana Gimnástica 38 59 39 56
9 Atl. Astorga Atl. Astorga 38 42 55 50
10 Numancia B Numancia B 38 44 56 50
11 Iscar Iscar 38 50 60 49
12 SD Almazán SD Almazán 38 41 49 46
13 Racing Lermeño CF Racing 38 48 62 45
14 Atlético Tordesillas Atlético 38 33 47 43
15 Venta De Baños Venta Baños 38 33 75 42
16 Santa Marta Santa Marta 38 40 64 38
17 Cd Aguilar Cd Aguilar 38 39 56 35
18 Salamanca B Salamanca B 38 34 57 34
19 La Granja La Granja 38 39 65 28
20 Júpiter Leonés Júpiter 38 35 80 27
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Palencia Palencia 38 83 22 90
2 Mirandés Mirandés 38 89 24 86
3 Burgos Burgos 38 71 18 81
4 Real Ávila Real Ávila 38 77 35 79
5 Arandina Arandina 38 70 41 77
6 Atl. Bembibre Atl. 38 59 38 61
7 CD Huracán Z Huracán 38 61 46 60
8 Gimnástica Segoviana Gimnástica 38 49 49 58
9 Cd Aguilar Cd Aguilar 38 43 43 49
10 Salamanca UDS Salamanca 38 48 50 46
11 Iscar Iscar 38 50 65 45
12 Santa Marta Santa Marta 38 43 61 45
13 Numancia B Numancia B 38 38 50 42
14 La Granja La Granja 38 37 50 39
15 Atl. Astorga Atl. Astorga 38 41 63 39
16 SD Almazán SD Almazán 38 34 61 38
17 Júpiter Leonés Júpiter 38 35 80 33
18 Becerril Becerril 38 28 62 31
19 Norma Norma 38 35 70 28
20 Cebrereña Cebrereña 38 38 101 25
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Mirandés Mirandés 38 82 20 95
2 Gimnástica Segoviana Gimnástica 38 75 28 74
3 Real Ávila Real Ávila 38 70 33 72
4 Arandina Arandina 38 54 38 63
5 Atl. Bembibre Atl. 38 40 31 61
6 Salamanca UDS Salamanca 38 60 50 58
7 Norma Norma 38 40 41 55
8 CD Huracán Z Huracán 38 44 36 54
9 Numancia B Numancia B 38 45 51 53
10 Santa Marta Santa Marta 38 43 46 51
11 SD Almazán SD Almazán 38 49 53 51
12 Iscar Iscar 38 45 45 48
13 Júpiter Leonés Júpiter 38 46 56 48
14 La Granja La Granja 38 42 45 43
15 Becerril Becerril 38 44 57 40
16 Ponferradina B Ponferradina 38 40 64 39
17 CD Laguna CD Laguna 38 36 57 38
18 Palencia Cristo Atlético Palencia 38 39 66 37
19 Burgos CF B Burgos CF B 38 33 50 37
20 Hullera Vl Hullera Vl 38 21 81 19
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Mirandés Mirandés 38 63 26 84
2 Gimnástica Segoviana Gimnástica 38 67 31 76
3 Numancia B Numancia B 38 55 30 73
4 Real Ávila Real Ávila 38 54 30 72
5 CD Huracán Z Huracán 38 49 37 67
6 Arandina Arandina 38 63 41 63
7 Norma Norma 38 46 35 60
8 Atl. Bembibre Atl. 38 54 35 59
9 Becerril Becerril 38 46 45 58
10 CD Laguna CD Laguna 38 49 40 55
11 La Granja La Granja 38 39 43 50
12 Salamanca B Salamanca B 38 43 42 49
13 Ponferradina B Ponferradina 38 42 58 43
14 Burgos CF B Burgos CF B 38 31 44 38
15 Júpiter Leonés Júpiter 38 35 49 38
16 Iscar Iscar 38 36 55 36
17 Hullera Hullera 38 33 54 35
18 Universidad de Valladolid Universidad 38 50 75 31
19 Benavente Benavente 38 34 60 29
20 La Bañeza La Bañeza 38 15 74 11
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Gimnástica Segoviana Gimnástica 38 89 16 97
2 Mirandés Mirandés 38 76 20 89
3 Guijuelo Guijuelo 38 76 33 83
4 CD Huracán Z Huracán 38 66 31 78
5 Atl. Bembibre Atl. 38 68 38 69
6 Norma San Leonardo Norma 38 52 42 63
7 Real Ávila Real Ávila 38 52 46 61
8 Júpiter Leonés Júpiter 38 49 48 54
9 Arandina Arandina 38 52 38 53
10 Salamanca B Salamanca B 38 53 51 51
11 Numancia B Numancia B 38 53 63 49
12 Hullera Hullera 38 44 61 48
13 Iscar Iscar 38 37 40 45
14 Universidad de Valladolid Universidad 38 39 63 39
15 Becerril Becerril 38 47 65 38
16 La Bañeza La Bañeza 38 30 54 37
17 Benavente Benavente 38 39 66 35
18 Atlético Tordesillas Atlético 38 42 83 31
19 Cebrereña Cebrereña 38 32 75 20
20 SD Almazán SD Almazán 38 25 88 18
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Promesas Ponferrada Promesas 38 69 22 81
2 Gimnástica Segoviana Gimnástica 38 77 31 80
3 Real Ávila Real Ávila 38 71 26 77
4 Real Valladolid Promesas Real 38 57 31 74
5 Arandina Arandina 38 53 30 69
6 Salamanca B Salamanca B 38 55 39 65
7 Numancia B Numancia B 38 63 53 61
8 Norma San Leonardo Norma 38 55 41 60
9 Júpiter Leonés Júpiter 38 56 54 56
10 CD Huracán Z Huracán 38 49 39 55
11 Hullera Hullera 38 33 38 47
12 Benavente Benavente 38 53 58 47
13 Becerril Becerril 38 46 61 45
14 Iscar Iscar 38 35 40 44
15 Atlético Tordesillas Atlético 38 47 55 43
16 SD Almazán SD Almazán 38 42 65 41
17 La Bañeza La Bañeza 38 39 50 37
18 Gimnástica Medinense Gimnástica 38 51 88 36
19 Palencia Cristo Atlético Palencia 38 31 91 16
20 Racing Lermeño CF Racing 38 20 90 11

  USO DE MEMORIA  
8,075,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1607
Total Execution Time  0.1619
  CADENA URL  
/historico/Numancia-B
  GET DATOS  
$_GET['/historico/Numancia-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0027  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 = 'Numancia-B' 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.0018  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=1833 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1833 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1833 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1833 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (78982,93130,95403,351767,637063) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '1833' 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 = '1833' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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=1833 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73528,67982,67320) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67982 AND teamId = 1833
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73528 AND teamId = 1833
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 1833
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 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 = 73528 AND t.round = 28 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 = '1833' 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 = '1833' 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 = '1833' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1833' and rp.type = 4
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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 1833 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.0034  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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 1833 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 1833 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 1833 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 = 73528 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.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 = 67982 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.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 `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 = 62392 AND t.round = 34 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 = 58587 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.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 `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 = 50276 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 `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 = 44396 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 `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 = 39032 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 `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 = 33358 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 `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 = 15449 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 = 3910 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 `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 = 2558 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 = 1948 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 `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 = 1404 AND t.round = 42 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 `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 = 1139 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 `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 = 838 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 `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 = 138 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 `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15 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 `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 = 93 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22120 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 `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 = 22101 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC