4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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 2011/2012
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Arroyo Arroyo 38 100 22 95
2 Diter Zafra Diter Zafra 38 63 38 81
3 Extremadura Extremadura 38 75 23 78
4 CD Don Benito Benito 38 63 29 78
5 Jerez Jerez 38 56 34 69
6 Miajadas Miajadas 38 52 52 56
7 Deportivo Pacense Deportivo 38 53 49 53
8 Mérida UD Mérida UD 38 42 43 53
9 CD Coria CD Coria 38 49 55 50
10 Ciudad de Plasencia Ciudad 38 45 46 45
11 Valdelacalzada Valdelacalza 38 31 42 45
12 Plasencia Plasencia 38 41 62 45
13 Santa Amalia Santa Amalia 38 53 67 44
14 Hernán Cortés Hernán 38 28 39 42
15 Pueblonuevo Pueblonuevo 38 59 83 41
16 Moralo Moralo 38 32 43 40
17 Atl San José Promesas José 38 60 67 39
18 Sanvicenteño Sanvicenteñ 38 45 77 36
19 Villafranca Villafranca 38 45 74 29
20 Chinato Chinato 38 27 74 20
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Villanovense Villanovense 38 83 30 93
2 Sporting Villanueva Sporting 38 81 24 92
3 Arroyo Arroyo 38 64 37 70
4 Jerez Jerez 38 61 32 64
5 Mérida UD Mérida UD 38 48 32 58
6 Santa Amalia Santa Amalia 38 56 51 56
7 CD Don Benito Benito 38 48 47 56
8 Moralo Moralo 38 47 45 54
9 Miajadas Miajadas 38 38 41 54
10 Sanvicenteño Sanvicenteñ 38 47 39 51
11 Ciudad de Plasencia Ciudad 38 41 47 49
12 Diter Zafra Diter Zafra 38 45 50 49
13 Plasencia Plasencia 38 39 48 47
14 CD Coria CD Coria 38 42 52 47
15 Atl San José Promesas José 38 52 61 44
16 Deportivo Pacense Deportivo 38 53 68 42
17 Valdelacalzada Valdelacalza 38 38 52 39
18 Santa Marta Santa Marta 38 34 58 35
19 Olivenza Olivenza 38 39 72 30
20 Imperio Imperio 38 28 98 18
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Badajoz CD Badajoz 38 109 19 101
2 Jerez Jerez 38 76 14 89
3 Extremadura Extremadura 38 77 26 79
4 Arroyo Arroyo 38 72 43 74
5 Mérida UD Mérida UD 38 55 28 72
6 Sp. Villanueva Promesas Villanueva 38 71 50 67
7 Ciudad de Plasencia Ciudad 38 54 49 57
8 CD Don Benito Benito 38 48 50 53
9 Sanvicenteño Sanvicenteñ 38 47 48 51
10 Imperio Imperio 38 59 56 47
11 Olivenza Olivenza 38 33 45 47
12 Miajadas Miajadas 38 28 42 44
13 Deportivo Pacense Deportivo 38 54 68 43
14 Moralo Moralo 38 40 52 43
15 Valdelacalzada Valdelacalza 38 35 54 40
16 CD Coria CD Coria 38 50 76 34
17 Santa Marta Santa Marta 38 43 69 31
18 Montehermoso Montehermoso 38 31 79 30
19 UC La Estrella Estrella 38 27 84 27
20 Villafranca Villafranca 38 30 87 23
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Cerro de Reyes Cerro Reyes 38 88 27 92
2 CP Cacereño Cacereño 38 90 26 91
3 Villanovense Villanovense 38 64 26 74
4 CD Don Benito Benito 38 47 29 65
5 CD Badajoz CD Badajoz 38 54 38 59
6 Jerez Jerez 38 42 35 54
7 Moralo Moralo 38 44 48 51
8 Valdelacalzada Valdelacalza 38 38 52 50
9 Olivenza Olivenza 38 42 45 49
10 Imperio Imperio 38 41 48 48
11 UC La Estrella Estrella 38 46 46 47
12 Sp. Villanueva Promesas Villanueva 38 37 55 46
13 Deportivo Pacense Deportivo 38 41 49 45
14 Sanvicenteño Sanvicenteñ 38 39 68 43
15 Miajadas Miajadas 38 38 53 42
16 Santa Marta Santa Marta 38 43 63 42
17 Ciudad de Plasencia Ciudad 38 34 53 41
18 Diter Zafra Diter Zafra 38 40 57 39
19 Plasencia Plasencia 38 50 66 35
20 CP Valdivia CP Valdivia 38 30 64 28
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 38 70 18 82
2 Cerro de Reyes Cerro Reyes 38 78 33 78
3 Villanovense Villanovense 38 73 35 74
4 Jerez Jerez 38 58 38 70
5 Plasencia Plasencia 38 58 33 68
6 Diter Zafra Diter Zafra 38 51 27 63
7 Sp. Villanueva Promesas Villanueva 38 44 34 59
8 CD Badajoz CD Badajoz 38 54 39 58
9 CP Cacereño Cacereño 38 48 45 55
10 Moralo Moralo 38 41 55 48
11 Imperio Imperio 38 54 46 47
12 UC La Estrella Estrella 38 36 47 43
13 Olivenza Olivenza 38 32 64 42
14 CP Valdivia CP Valdivia 38 45 59 42
15 Miajadas Miajadas 38 31 46 39
16 Valdelacalzada Valdelacalza 38 42 64 39
17 Sanvicenteño Sanvicenteñ 38 34 75 38
18 Pueblonuevo Pueblonuevo 38 33 51 38
19 Santa Amalia Santa Amalia 38 39 68 36
20 Villafranca Villafranca 38 35 79 27
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Jerez Jerez 38 47 16 82
2 CD Don Benito Benito 38 77 25 82
3 Imperio Imperio 38 67 28 81
4 CP Cacereño Cacereño 38 71 31 75
5 Diter Zafra Diter Zafra 38 57 21 73
6 Sp. Villanueva Promesas Villanueva 38 60 24 67
7 CD Badajoz CD Badajoz 38 50 34 58
8 Miajadas Miajadas 38 62 64 57
9 Extremadura B Extremadura 38 44 39 56
10 Villafranca Villafranca 38 51 49 55
11 UC La Estrella Estrella 38 45 49 48
12 Moralo Moralo 38 42 43 47
13 Plasencia Plasencia 38 48 44 45
14 Santa Amalia Santa Amalia 38 46 58 43
15 Sanvicenteño Sanvicenteñ 38 40 60 43
16 Olivenza Olivenza 38 30 47 41
17 CD Coria CD Coria 38 46 63 38
18 Castuera Castuera 38 30 67 28
19 Monesterio Monesterio 38 19 71 20
20 Moraleja Moraleja 38 38 137 12
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Villanovense Villanovense 40 75 35 90
2 Cerro de Reyes Cerro Reyes 40 93 28 88
3 CD Don Benito Benito 40 86 32 82
4 Sp. Villanueva Promesas Villanueva 40 67 35 81
5 Miajadas Miajadas 40 68 64 65
6 Jerez Jerez 40 61 50 62
7 Imperio Imperio 40 57 49 61
8 Plasencia Plasencia 40 57 55 59
9 CP Cacereño Cacereño 40 54 50 57
10 UC La Estrella Estrella 40 42 51 57
11 Santa Amalia Santa Amalia 40 44 52 51
12 Extremadura B Extremadura 40 56 69 47
13 CD Coria CD Coria 40 57 83 46
14 Villafranca Villafranca 40 46 60 45
15 Moralo Moralo 40 38 54 45
16 Olivenza Olivenza 40 43 62 44
17 Monesterio Monesterio 40 38 58 40
18 Amanecer Amanecer 40 39 56 39
19 Alburquerque Alburquerque 40 46 65 39
20 UD Santa Marta Santa Marta 40 34 67 37
21 CP Valdivia CP Valdivia 40 38 64 31
TEMPORADA 2004/2005
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 52 29 66
2 UB Conquense Conquense 38 43 31 66
3 AgD Ceuta AgD Ceuta 38 38 22 65
4 Lorca Deportiva Lorca 38 61 39 61
5 Marbella FC Marbella FC 38 46 42 59
6 Algeciras CF Algeciras 38 26 25 54
7 CD Badajoz CD Badajoz 38 50 43 53
8 UD Melilla UD Melilla 38 43 37 52
9 Real Jaén Real Jaén 38 35 34 51
10 CF Extremadura Extremadura 38 45 39 50
11 CD Linares CD Linares 38 30 29 50
12 Écija Balompié Écija 38 30 46 50
13 FC Cartagena Cartagena 38 31 30 49
14 Diter Zafra Diter Zafra 38 30 42 49
15 CD Alcalá CD Alcalá 38 37 43 48
16 Talavera CF Talavera CF 38 35 34 46
17 Tomelloso Tomelloso 38 26 41 42
18 CD Don Benito Benito 38 22 36 36
19 Jerez Jerez 38 26 47 36
20 Arenas de Armilla Arenas 38 32 49 28
TEMPORADA 2003/2004
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 38 83 16 87
2 Diter Zafra Diter Zafra 38 67 25 78
3 Plasencia Plasencia 38 63 35 75
4 Cerro de Reyes Cerro Reyes 38 72 28 74
5 CD Badajoz B Badajoz 38 49 29 63
6 Santa Amalia Santa Amalia 38 57 38 62
7 Extremadura B Extremadura 38 60 58 61
8 Villanueva CF Villanueva 38 53 41 59
9 Cacereño B Cacereño B 38 49 51 55
10 Cd Burguillos Burguillos 38 56 57 52
11 CD Coria CD Coria 38 56 69 50
12 Moralo Moralo 38 48 43 47
13 Villafranca Villafranca 38 39 43 47
14 UC La Estrella Estrella 38 29 50 43
15 Amanecer Amanecer 38 33 58 41
16 Arroyo Arroyo 38 37 58 41
17 Monesterio Monesterio 38 38 75 38
18 Alburquerque Alburquerque 38 37 61 34
19 UD Montijo UD Montijo 38 28 61 30
20 Ciudad De Plasencia Ciudad 38 33 91 17
TEMPORADA 2002/2003
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 SP Cerro Reyes Cerro Reyes 38 70 19 92
2 CD Don Benito Benito 38 102 24 88
3 Villanovense Villanovense 38 82 29 84
4 Extremadura B Extremadura 38 68 34 70
5 CD Badajoz B Badajoz 38 62 24 69
6 Plasencia Plasencia 38 62 33 69
7 Alburquerque Alburquerque 38 53 46 53
8 Cd Burguillos Burguillos 38 50 54 51
9 Villafranca Villafranca 38 38 38 51
10 CD Coria CD Coria 38 60 61 47
11 Santa Amalia Santa Amalia 38 46 48 46
12 UC La Estrella Estrella 38 43 56 44
13 Monesterio Monesterio 38 49 70 43
14 UD Montijo UD Montijo 38 38 45 42
15 Ciudad Ciudad 38 45 79 42
16 Arroyo Arroyo 38 42 78 39
17 Valdelacalzada Valdelacalza 38 45 78 34
18 Guadiana Guadiana 38 28 50 30
19 Olivenza Olivenza 38 32 62 24
20 Gran Maestre Gran Maestre 38 28 115 16
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 131 28 101
2 CD Don Benito Benito 38 91 33 84
3 Moralo Moralo 38 98 37 79
4 Villanovense Villanovense 38 78 37 73
5 CD Badajoz B Badajoz 38 58 38 69
6 Plasencia Plasencia 38 67 48 64
7 Villafranca Villafranca 38 58 45 62
8 Cerro de Reyes Cerro Reyes 38 64 48 60
9 Extremadura B Extremadura 38 65 59 50
10 Gran Maestre Gran Maestre 38 50 60 46
11 CD Coria CD Coria 38 49 68 46
12 UD Montijo UD Montijo 38 42 58 44
13 Estrella Estrella 38 49 67 44
14 Monesterio Monesterio 38 51 56 43
15 Santa Amalia Santa Amalia 38 37 71 42
16 Valdelacalzada Valdelacalza 38 41 77 41
17 Alburquerque Alburquerque 38 42 69 37
18 Imperio Imperio 38 39 76 27
19 Moraleja Moraleja 38 36 94 27
20 Calamonte Calamonte 38 29 106 24
TEMPORADA 2000/2001
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 37 37 15 70
2 Xerez CD Xerez CD 37 52 30 66
3 Poli Ejido Poli Ejido 36 40 25 66
4 AgD Ceuta AgD Ceuta 37 52 32 62
5 Dos Hermanas CF Hermanas 37 40 35 52
6 Granada Granada 37 45 41 52
7 Coria CF Coria CF 36 38 37 51
8 UD Melilla UD Melilla 37 36 43 51
9 Almería Almería 37 43 38 49
10 Écija Balompié Écija 37 28 31 47
11 Jerez Jerez 37 37 36 47
12 CD San Fernando Fernando 37 26 26 46
13 Talavera CF Talavera CF 37 31 40 46
14 RB Linense RB Linense 37 45 50 45
15 Motril CF Motril CF 37 32 40 45
16 Algeciras CF Algeciras 37 38 41 44
17 Guadix CF Guadix CF 37 29 46 42
18 CD Linares CD Linares 37 28 38 37
19 CD Don Benito Benito 37 24 42 26
20 Poli Almería Poli 17 12 27 11
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Merida B Merida B 38 77 29 84
2 CD Don Benito Benito 38 76 27 83
3 Villanovense Villanovense 38 75 21 78
4 Plasencia Plasencia 38 75 39 76
5 Cd Burguillos Burguillos 38 53 22 75
6 Diter Zafra Diter Zafra 38 68 30 68
7 CD Coria CD Coria 38 64 42 68
8 Extremadura B Extremadura 38 64 39 61
9 Valdelacalzada Valdelacalza 38 49 41 52
10 Villafranca Villafranca 38 49 45 50
11 Moralo Moralo 38 48 52 48
12 Monesterio Monesterio 38 39 52 48
13 CD Badajoz B Badajoz 38 49 62 44
14 Cacereño B Cacereño B 38 34 73 40
15 Cerro de Reyes Cerro Reyes 38 42 63 39
16 Sanvicenteño Sanvicenteñ 38 39 57 38
17 UC La Estrella Estrella 38 43 64 37
18 Olivenza Olivenza 38 38 69 35
19 Guareña Guareña 38 24 92 22
20 Gran Maestre Gran Maestre 38 28 115 10
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Cd Burguillos Burguillos 38 81 26 85
2 Villafranca Villafranca 38 83 16 84
3 CD Don Benito Benito 38 76 18 83
4 Extremadura B Extremadura 38 61 28 71
5 Valdelacalzada Valdelacalza 38 63 35 71
6 Merida B Merida B 38 67 27 70
7 Diter Zafra Diter Zafra 38 52 25 68
8 CD Badajoz B Badajoz 38 59 37 66
9 CD Coria CD Coria 38 57 55 59
10 Monesterio Monesterio 38 39 36 55
11 Guareña Guareña 38 50 52 50
12 Villanovense Villanovense 37 38 46 49
13 Cacereño B Cacereño B 38 47 74 40
14 Olivenza Olivenza 38 47 68 39
15 UC La Estrella Estrella 38 36 60 38
16 Santa Amalia Santa Amalia 38 36 62 38
17 Castuera Castuera 38 39 69 36
18 Guadiana Guadiana 38 39 90 27
19 Valencia de Alcantara Valencia 38 24 83 20
20 Cabezuela Cabezuela 37 19 106 10
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Jerez Jerez 38 90 25 87
2 Merida B Merida B 38 63 15 81
3 Villafranca Villafranca 38 78 30 77
4 CD Badajoz B Badajoz 38 62 29 75
5 Villanovense Villanovense 38 61 33 66
6 Cd Burguillos Burguillos 38 60 37 64
7 Extremadura B Extremadura 38 60 36 62
8 Diter Zafra Diter Zafra 38 60 51 59
9 CD Coria CD Coria 38 53 56 59
10 CD Don Benito Benito 38 66 46 54
11 Valdelacalzada Valdelacalza 38 57 56 52
12 Olivenza Olivenza 38 43 58 51
13 Estrella Estrella 38 32 54 43
14 Castuera Castuera 38 40 56 42
15 Cacereño B Cacereño B 38 52 75 42
16 Santa Amalia Santa Amalia 38 36 48 39
17 Guadiana Guadiana 38 35 64 34
18 Arroyo Arroyo 38 47 74 31
19 Moraleja Moraleja 38 39 86 26
20 UD Montijo UD Montijo 38 22 127 10
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Moralo Moralo 38 98 29 85
2 Jerez Jerez 38 81 24 84
3 Plasencia Plasencia 38 70 27 80
4 Cd Burguillos Burguillos 38 72 31 76
5 Merida B Merida B 38 72 22 76
6 CD Don Benito Benito 38 60 46 64
7 CD Badajoz B Badajoz 38 44 43 60
8 UC La Estrella Estrella 38 56 37 59
9 Villafranca Villafranca 38 59 40 55
10 Santa Amalia Santa Amalia 38 44 57 50
11 UD Montijo UD Montijo 38 47 58 49
12 Guadiana Guadiana 38 40 62 45
13 Olivenza Olivenza 38 45 60 44
14 Diter Zafra Diter Zafra 38 47 58 44
15 Castuera Castuera 38 43 55 41
16 Villanovense Villanovense 38 40 55 41
17 CD Coria CD Coria 38 34 80 34
18 Miajadas Miajadas 38 29 72 34
19 Guareña Guareña 38 21 75 27
20 UD Frexnense Frexnense 38 23 94 16
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 131 27 93
2 Jerez Cf Jerez Cf 38 124 22 93
3 Moralo Moralo 38 76 31 79
4 Merida B Merida B 38 72 27 77
5 Plasencia Plasencia 38 80 34 70
6 Villafranca Villafranca 38 52 33 65
7 CD Don Benito Benito 38 52 37 62
8 Santa Amalia Santa Amalia 38 50 51 54
9 Guadiana Guadiana 38 47 59 51
10 Cd Burguillos Burguillos 38 46 58 49
11 UC La Estrella Estrella 38 45 62 49
12 CD Badajoz B Badajoz 38 39 42 48
13 CD Coria CD Coria 38 33 49 45
14 Olivenza Olivenza 38 43 65 44
15 UD Frexnense Frexnense 38 49 65 42
16 Castuera Castuera 38 43 61 41
17 Guareña Guareña 38 26 64 33
18 Sanvicenteño Sanvicenteñ 38 27 94 26
19 UD Fornacense Fornacense 38 26 98 21
20 CD Azuaga CD Azuaga 38 24 106 17
TEMPORADA 1994/1995
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 38 92 30 59
2 Jerez Jerez 38 86 27 56
3 CD Badajoz B Badajoz 38 65 15 56
4 Cd Burguillos Burguillos 38 69 33 54
5 Plasencia Plasencia 38 100 31 53
6 Moralo Moralo 38 76 39 53
7 Villafranca Villafranca 38 57 39 49
8 UD Frexnense Frexnense 38 58 37 48
9 Merida B Merida B 38 61 31 46
10 Castuera Castuera 38 62 48 39
11 Malpartida Malpartida 38 63 58 36
12 UC La Estrella Estrella 38 48 51 34
13 CD Coria CD Coria 38 63 81 29
14 Guareña Guareña 38 36 61 29
15 Santa Amalia Santa Amalia 38 34 66 27
16 CD Azuaga CD Azuaga 38 44 78 26
17 UD Fornacense Fornacense 38 40 82 25
18 Trujillo Trujillo 38 37 83 21
19 AD Llerenense Llerenense 38 25 96 17
20 Miajadas Miajadas 38 19 149 3
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Formación Cristiana Extrema Formación 38 128 28 66
2 Plasencia Plasencia 38 105 25 61
3 Merida B Merida B 38 72 34 55
4 CD Don Benito Benito 38 68 27 54
5 Moralo Moralo 38 76 25 52
6 CD Badajoz B Badajoz 38 55 24 49
7 Cd Burguillos Burguillos 38 38 23 49
8 CD Azuaga CD Azuaga 38 43 40 37
9 Castuera Castuera 38 54 56 34
10 AD Llerenense Llerenense 38 45 62 34
11 Villafranca Villafranca 38 41 59 32
12 CD San Serván Serván 38 30 46 30
13 UD Fornacense Fornacense 38 34 52 30
14 UC La Estrella Estrella 38 34 56 29
15 Miajadas Miajadas 38 33 64 28
16 Santa Amalia Santa Amalia 38 43 68 27
17 Malpartida Malpartida 38 43 79 26
18 UD Montijo UD Montijo 38 37 90 24
19 Valdelacalzada Valdelacalza 38 24 83 22
20 Monesterio Monesterio 38 36 98 21

  USO DE MEMORIA  
8,400,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1749
Total Execution Time  0.1762
  CADENA URL  
/historico/Cd-Don-Benito/2013
  GET DATOS  
$_GET['/historico/Cd-Don-Benito/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0030  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 = 'Cd-Don-Benito' AND l.year = 2013 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10095 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=10095 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=10095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1958
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10095 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10095 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (86731,245924,251678,256608,427710) 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 = '10095' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '10095' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 1958 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=10095 AND l.year in (2012,2013,2014) 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 (2563,2340) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 2563 AND teamId = 10095
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 2340 AND teamId = 10095
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 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 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 = '10095' 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 = '10095' 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 = '10095' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 events2013 e ON e.player_id = p.id AND e.league_id = 1958 WHERE rp.league_id = 1958 AND rp.teamId = 10095 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.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 events2013 e ON e.player_id = p.id AND e.league_id = 1958 WHERE rp.league_id = 1958 AND rp.teamId = 10095 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events2013 e ON e.player_id = p.id AND e.league_id = 1958 WHERE rp.league_id = 1958 AND rp.teamId = 10095 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 10095 AND l.year <= 2013 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 1450 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 = 814 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 144 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 = 21 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 `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 = 99 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 22126 AND t.round = 42 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 `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 = 175 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 `tables2004` 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 = 22091 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 `tables2003` 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 = 22075 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 `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 = 22059 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  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 = 5521 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 `tables2000` 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 = 22027 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 `tables1999` 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 = 22011 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0068  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 `tables1998` 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 = 21995 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 = 21956 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 `tables1995` 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 = 21936 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 `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 = 21914 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 1958 ORDER BY nameShow LIMIT 100