4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Rápido de Bouzas Rápido 38 53 26 74
2 Negreira Negreira 38 52 24 72
3 CD Lugo CD Lugo 38 58 30 71
4 Coruxo Coruxo 38 47 26 68
5 Laracha Laracha 38 48 25 65
6 CCD Cerceda CCD Cerceda 38 71 45 64
7 Lalín Lalín 38 51 36 63
8 Deportivo Fabril Deportivo 38 54 36 56
9 Narón BP Narón BP 38 48 47 51
10 Betanzos CF Betanzos CF 38 47 52 50
11 Viveiro Viveiro 38 50 51 49
12 Bergantiños FC Bergantiños 38 46 54 47
13 Alondras CF Alondras CF 38 46 74 45
14 Portonovo Portonovo 38 32 48 43
15 Arosa Arosa 38 32 39 43
16 Villalonga FC Villalonga 38 40 60 39
17 O Val O Val 38 30 60 38
18 Porriño Industrial Porriño 38 36 53 35
19 CD Grove CD Grove 38 42 69 34
20 Verín Verín 38 31 59 33
TEMPORADA 2003/2004
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CCD Cerceda CCD Cerceda 38 65 31 76
2 At. Arteixo At. Arteixo 38 70 35 73
3 Deportivo Fabril Deportivo 38 65 37 71
4 Verín Verín 38 56 37 68
5 Lalín Lalín 38 49 34 65
6 CD Lugo CD Lugo 38 60 41 64
7 Compostela - Zona Vella B Compostela 38 39 37 57
8 Porriño Industrial Porriño 38 48 40 56
9 Coruxo Coruxo 38 44 50 50
10 Bergantiños FC Bergantiños 38 47 48 48
11 Negreira Negreira 38 34 42 47
12 Betanzos CF Betanzos CF 38 41 43 46
13 CD Grove CD Grove 38 53 56 45
14 Rápido de Bouzas Rápido 38 43 47 44
15 Portonovo Portonovo 38 34 48 44
16 Arosa Arosa 38 41 56 41
17 Narón BP Narón BP 38 44 68 37
18 Ponte Ourense Ponte 38 42 72 36
19 SP Guardes SP Guardes 38 34 59 35
20 UD Xove Lago Xove Lago 38 33 61 30
TEMPORADA 2002/2003
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Universidad LPGC Universidad 38 65 39 72
2 Zamora Zamora 38 58 43 66
3 Lanzarote Lanzarote 38 64 44 64
4 Pontevedra Pontevedra 38 70 54 64
5 Cultural Leonesa Cultural 38 53 39 63
6 RM Castilla RM Castilla 38 57 39 59
7 Alcorcón Alcorcón 38 56 47 56
8 Pájara Playas Jandía Pájara 38 47 44 52
9 CD Ourense CD Ourense 38 41 40 51
10 RSD Alcalá RSD Alcalá 38 46 41 51
11 Ponferradina Ponferradina 38 48 51 49
12 Atlético B Atlético B 38 38 37 48
13 Real Avilés Industrial Real Avilés 38 39 42 48
14 Celta Fortuna Celta 38 45 42 48
15 Corralejo Corralejo 38 37 42 46
16 Langreo Langreo 38 33 39 45
17 Marino de Luanco Marino 38 44 66 42
18 CD Lugo CD Lugo 38 38 51 42
19 Real Ávila Real Ávila 38 34 66 26
20 Ribadesella Ribadesella 38 22 69 25
TEMPORADA 2001/2002
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Barakaldo Barakaldo 38 61 19 79
2 Cultural Leonesa Cultural 38 64 43 67
3 SD Compostela Compostela 38 53 30 64
4 Pontevedra Pontevedra 38 41 30 63
5 Marino de Luanco Marino 38 54 46 59
6 Bilbao Ath. Bilbao Ath. 38 47 34 56
7 Amurrio Amurrio 38 46 34 55
8 CD Aurrera Vitoria Aurrera 38 38 33 54
9 CD Lugo CD Lugo 38 38 41 54
10 Deportivo Alavés B Deportivo 38 44 39 52
11 CD Ourense CD Ourense 38 55 61 50
12 SD Gernika SD Gernika 38 34 42 49
13 Celta Fortuna Celta 38 28 38 49
14 Ponferradina Ponferradina 38 44 43 49
15 Zamora Zamora 38 60 60 48
16 Gimnástica Torrelavega Gimnástica 38 38 50 42
17 Sporting Atlético Sporting 38 41 56 41
18 Real Oviedo Vetusta Real Oviedo 38 25 49 36
19 Caudal Deportivo Caudal 38 33 58 28
20 Universidad Oviedo Universidad 38 36 74 26
TEMPORADA 2000/2001
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético B Atlético B 38 63 27 74
2 CD Ourense CD Ourense 38 60 31 73
3 Zamora Zamora 38 65 37 71
4 CD Toledo CD Toledo 38 59 34 66
5 Sporting Atlético Sporting 38 52 45 63
6 Pájara Playas Jandía Pájara 38 51 45 61
7 RM Castilla RM Castilla 38 74 53 61
8 Vecindario Vecindario 38 65 65 58
9 Caudal Deportivo Caudal 38 40 38 52
10 CD Mensajero Mensajero 38 40 44 49
11 Ponferradina Ponferradina 38 45 50 47
12 Alcorcón Alcorcón 38 46 53 44
13 Universidad Oviedo Universidad 38 46 60 44
14 Pontevedra Pontevedra 38 41 65 44
15 CD Lugo CD Lugo 38 36 47 43
16 Fuenlabrada Fuenlabrada 38 40 47 42
17 Club Siero Club Siero 38 42 55 42
18 UD Sanse UD Sanse 38 42 59 38
19 Real Ávila Real Ávila 38 46 66 38
20 Deportivo Fabril Deportivo 38 36 68 34
TEMPORADA 1999/2000
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Universidad LPGC Universidad 38 40 17 72
2 CD Ourense CD Ourense 38 48 29 69
3 Racing Ferrol Racing 38 67 24 68
4 CD Mensajero Mensajero 38 53 35 66
5 RM Castilla RM Castilla 38 72 51 61
6 UD Sanse UD Sanse 38 51 42 58
7 Pontevedra Pontevedra 38 46 49 54
8 CD Lugo CD Lugo 38 42 46 52
9 Cultural Leonesa Cultural 38 52 50 51
10 Pájara Playas Jandía Pájara 38 52 51 51
11 Real Ávila Real Ávila 38 47 54 51
12 Sporting Atlético Sporting 38 48 51 51
13 Fuenlabrada Fuenlabrada 38 42 47 50
14 Caudal Deportivo Caudal 38 37 56 45
15 Ponferradina Ponferradina 38 34 55 44
16 Real Avilés Industrial Real Avilés 38 38 43 43
17 Lanzarote Lanzarote 38 47 54 42
18 Real Oviedo Vetusta Real Oviedo 38 37 50 39
19 Gimnástica Segoviana Gimnástica 38 20 47 35
20 Móstoles Móstoles 38 34 56 32
TEMPORADA 1998/1999
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Getafe Getafe 38 50 23 72
2 Universidad LPGC Universidad 38 49 35 65
3 RM Castilla RM Castilla 38 68 39 64
4 Racing Ferrol Racing 38 61 39 64
5 Talavera CF Talavera CF 38 46 35 62
6 CD Mensajero Mensajero 38 48 40 56
7 Sporting Atlético Sporting 38 46 48 56
8 Fuenlabrada Fuenlabrada 38 40 46 55
9 Real Avilés Industrial Real Avilés 38 48 40 51
10 Móstoles Móstoles 38 40 43 51
11 CD Lugo CD Lugo 38 48 48 50
12 Pontevedra Pontevedra 38 53 47 48
13 Real Oviedo Vetusta Real Oviedo 38 42 51 47
14 UD Sanse UD Sanse 38 42 53 47
15 Pájara Playas Jandía Pájara 38 42 52 46
16 Caudal Deportivo Caudal 38 33 46 43
17 Deportivo Fabril Deportivo 38 42 47 41
18 Langreo Langreo 38 34 60 40
19 Lalín Lalín 38 35 52 37
20 Lealtad Villaviciosa Lealtad 38 32 55 36
TEMPORADA 1997/1998
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 72 36 78
2 RM Castilla RM Castilla 38 70 40 72
3 Deportivo Fabril Deportivo 38 51 27 72
4 Talavera CF Talavera CF 38 65 46 71
5 Racing Ferrol Racing 38 59 38 71
6 CD Lugo CD Lugo 38 55 46 65
7 Getafe Getafe 38 45 40 57
8 Sporting Atlético Sporting 38 48 44 57
9 Fuenlabrada Fuenlabrada 38 54 55 54
10 Pontevedra Pontevedra 38 43 40 53
11 Langreo Langreo 38 49 49 50
12 Real Oviedo Vetusta Real Oviedo 38 51 53 48
13 Plasencia Plasencia 38 48 54 46
14 Moralo Moralo 38 38 55 43
15 Caudal Deportivo Caudal 38 43 57 42
16 Real Avilés Industrial Real Avilés 38 37 47 40
17 As Pontes As Pontes 38 38 56 39
18 Rayo Majadahonda Rayo 38 43 59 35
19 RCD Carabanchel Carabanchel 38 29 62 28
20 Leganés B Leganés B 38 35 69 26
TEMPORADA 1996/1997
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Atlético Sporting 38 57 40 68
2 Talavera CF Talavera CF 38 54 35 67
3 CD Manchego CD Manchego 38 52 36 66
4 Deportivo Fabril Deportivo 38 60 43 66
5 CD Lugo CD Lugo 38 71 34 64
6 Fuenlabrada Fuenlabrada 38 47 32 64
7 Racing Ferrol Racing 38 48 41 56
8 RCD Carabanchel Carabanchel 38 40 43 56
9 Pontevedra Pontevedra 38 49 48 54
10 Real Avilés Industrial Real Avilés 38 57 58 50
11 Mallorca B Mallorca B 38 52 59 48
12 Real Oviedo Vetusta Real Oviedo 38 51 45 48
13 Real Madrid C Real Madrid 38 48 60 48
14 Langreo Langreo 38 43 57 48
15 As Pontes As Pontes 38 39 52 46
16 Getafe Getafe 38 44 54 45
17 Real Aranjuez CF Real 38 42 55 45
18 CD Colonia Moscardó Colonia 38 48 64 45
19 Celta Fortuna Celta 38 36 51 37
20 Marino de Luanco Marino 38 19 50 23
TEMPORADA 1995/1996
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Las Palmas Las Palmas 38 80 22 77
2 Racing Ferrol Racing 38 59 29 68
3 CD Ourense CD Ourense 38 52 33 68
4 Atlético B Atlético B 38 58 41 64
5 Deportivo Fabril Deportivo 38 48 35 64
6 Talavera CF Talavera CF 38 55 42 57
7 CD Mensajero Mensajero 38 51 47 57
8 Real Aranjuez CF Real 38 43 37 57
9 Real Madrid C Real Madrid 38 63 60 55
10 CD Lugo CD Lugo 38 46 50 51
11 Fuenlabrada Fuenlabrada 38 44 42 50
12 Pontevedra Pontevedra 38 41 39 49
13 As Pontes As Pontes 38 57 56 48
14 CD Colonia Moscardó Colonia 38 45 61 47
15 Gáldar Gáldar 38 41 44 46
16 Leganés B Leganés B 38 31 50 45
17 UD Sanse UD Sanse 38 34 58 43
18 Tenerife B Tenerife B 38 44 57 42
19 Móstoles Móstoles 38 28 68 35
20 DAV Santa Ana Santa 38 30 79 23
TEMPORADA 1994/1995
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 71 27 54
2 CD Mensajero Mensajero 38 69 42 52
3 Las Palmas Las Palmas 38 81 38 51
4 Pontevedra Pontevedra 38 51 30 48
5 Sporting Atlético Sporting 38 50 43 45
6 UD Sanse UD Sanse 38 45 39 43
7 CD Colonia Moscardó Colonia 38 40 35 41
8 Langreo Langreo 38 40 43 40
9 Atlético B Atlético B 38 50 45 40
10 Real Avilés Industrial Real Avilés 38 54 42 39
11 CD Lugo CD Lugo 38 49 57 36
12 Móstoles Móstoles 38 33 51 35
13 Real Madrid C Real Madrid 38 60 57 34
14 Real Aranjuez CF Real 38 42 52 33
15 Real Valladolid Promesas Real 38 54 57 31
16 Fuenlabrada Fuenlabrada 38 52 64 31
17 Real Oviedo Vetusta Real Oviedo 38 50 63 31
18 Real Ávila Real Ávila 38 39 66 30
19 Corralejo Corralejo 38 28 64 26
20 Realejos Realejos 38 32 75 20
TEMPORADA 1993/1994
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 UD Salamanca Salamanca 38 71 26 56
2 Getafe Getafe 38 53 31 50
3 CD Ourense CD Ourense 38 64 53 48
4 Langreo Langreo 38 60 60 43
5 Pontevedra Pontevedra 38 51 41 41
6 Atlético B Atlético B 38 54 44 40
7 Real Madrid C Real Madrid 38 63 55 40
8 CD Lugo CD Lugo 38 38 42 38
9 Real Ávila Real Ávila 38 33 42 37
10 UD Sanse UD Sanse 38 49 48 37
11 Real Oviedo Vetusta Real Oviedo 38 39 38 37
12 Sporting Atlético Sporting 38 45 42 37
13 Racing Ferrol Racing 38 54 58 36
14 Talavera CF Talavera CF 38 41 44 35
15 Real Avilés Industrial Real Avilés 38 43 55 34
16 Arosa Arosa 38 42 48 33
17 Cultural Leonesa Cultural 38 38 53 32
18 Tomelloso Tomelloso 38 29 42 32
19 Ponferradina Ponferradina 38 39 56 28
20 Celta Fortuna Celta 38 45 73 26
TEMPORADA 1992/1993
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Lleida Lleida 38 56 20 57
2 Real Valladolid Real 38 50 30 52
3 Racing Racing 38 56 38 52
4 Mallorca Mallorca 38 57 34 50
5 Real Betis Real Betis 38 49 33 43
6 RM Castilla RM Castilla 38 57 41 42
7 Atlético Marbella Atlético 38 45 41 42
8 Barça Atlètic Barça 38 59 55 39
9 Mérida CP Mérida CP 38 43 42 39
10 CD Castellón Castellón 38 40 45 36
11 CD Badajoz CD Badajoz 38 37 36 36
12 SD Compostela Compostela 38 35 39 35
13 Villarreal Villarreal 38 38 51 34
14 Palamós Palamós 38 33 50 33
15 Bilbao Ath. Bilbao Ath. 38 33 34 33
16 Eibar Eibar 38 33 44 32
17 UE Figueres UE Figueres 38 41 59 32
18 CD Lugo CD Lugo 38 23 41 25
19 Sestao Sport Club Sestao Sport 38 29 54 24
20 CE Sabadell CE Sabadell 38 30 57 24
TEMPORADA 1991/1992
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 UD Salamanca Salamanca 38 65 22 53
2 CD Lugo CD Lugo 38 40 24 48
3 Sporting Atlético Sporting 38 38 22 47
4 As Pontes As Pontes 38 42 30 45
5 CD Ourense CD Ourense 38 42 27 44
6 Cultural Leonesa Cultural 38 38 26 44
7 Gimnástica Torrelavega Gimnástica 38 31 28 42
8 Real Valladolid Promesas Real 38 44 38 40
9 Pontevedra Pontevedra 38 40 41 39
10 Numancia Numancia 38 39 34 37
11 Real Oviedo Vetusta Real Oviedo 38 37 40 37
12 Palencia Palencia 38 39 45 35
13 Real Ávila Real Ávila 38 30 36 35
14 Ponferradina Ponferradina 38 45 58 34
15 Tudelano Tudelano 38 36 43 34
16 CD Logroñés B Logroñés 38 35 47 34
17 Lalín Lalín 38 38 44 34
18 Deportivo Fabril Deportivo 38 45 56 31
19 Cambados Cambados 38 23 47 26
20 Mosconia Mosconia 38 29 68 21
TEMPORADA 1990/1991
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 RM Castilla RM Castilla 38 44 25 53
2 CD Lugo CD Lugo 38 38 23 47
3 SD Compostela Compostela 38 44 31 47
4 Getafe Getafe 38 45 24 45
5 Leganés Leganés 38 38 27 43
6 Palencia Palencia 38 34 28 43
7 CD Ourense CD Ourense 38 40 36 41
8 Atlético B Atlético B 38 51 44 41
9 Cultural Leonesa Cultural 38 40 38 40
10 Real Oviedo Vetusta Real Oviedo 38 42 44 39
11 Real Ávila Real Ávila 38 32 26 39
12 Sporting Atlético Sporting 38 49 48 38
13 As Pontes As Pontes 38 42 36 38
14 Pontevedra Pontevedra 38 28 33 35
15 Ponferradina Ponferradina 38 32 38 35
16 Cambados Cambados 38 32 42 32
17 Galáctico Pegaso Galáctico 38 29 47 30
18 Langreo Langreo 38 31 51 29
19 Móstoles Móstoles 38 26 41 28
20 RSD Alcalá RSD Alcalá 38 22 57 17
TEMPORADA 1989/1990
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Real Avilés Industrial Real Avilés 38 46 24 55
2 Getafe Getafe 38 54 30 51
3 Leganés Leganés 38 53 25 48
4 Cambados Cambados 38 41 28 45
5 CD Lugo CD Lugo 38 48 40 43
6 Ponferradina Ponferradina 38 56 35 43
7 Cultural Leonesa Cultural 38 33 28 42
8 Real Ávila Real Ávila 38 52 46 41
9 CD Toledo CD Toledo 38 52 53 37
10 Pontevedra Pontevedra 38 38 45 36
11 Sporting Atlético Sporting 38 42 45 35
12 Langreo Langreo 38 39 52 34
13 CD Ourense CD Ourense 38 25 32 34
14 As Pontes As Pontes 38 39 53 34
15 RSD Alcalá RSD Alcalá 38 31 33 34
16 Galáctico Pegaso Galáctico 38 29 38 33
17 Racing Ferrol Racing 38 35 47 32
18 CD Colonia Moscardó Colonia 38 27 41 32
19 Lalín Lalín 38 34 45 31
20 Arosa Arosa 38 31 65 20
TEMPORADA 1988/1989
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Bilbao Ath. Bilbao Ath. 38 74 37 59
2 Barakaldo Barakaldo 38 56 32 51
3 CD Ourense CD Ourense 38 50 23 51
4 Real Avilés Industrial Real Avilés 38 48 25 50
5 CD Lugo CD Lugo 38 49 20 47
6 Pontevedra Pontevedra 38 45 34 43
7 As Pontes As Pontes 38 54 46 43
8 Cultural Leonesa Cultural 38 44 37 41
9 Arosa Arosa 38 41 33 40
10 Ponferradina Ponferradina 38 42 44 36
11 Langreo Langreo 38 43 49 34
12 Lalín Lalín 38 28 39 34
13 Racing Ferrol Racing 38 32 38 34
14 CD Basconia CD Basconia 38 36 48 34
15 Lemona Lemona 38 29 33 33
16 SCD Durango SCD Durango 38 29 40 33
17 Arenteiro Arenteiro 38 26 53 26
18 Santoña CF Santoña CF 38 19 49 25
19 Real Oviedo Vetusta Real Oviedo 38 31 68 24
20 Bergantiños FC Bergantiños 38 31 59 22
TEMPORADA 1987/1988
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Eibar Eibar 38 68 21 59
2 Real Avilés Industrial Real Avilés 38 60 28 53
3 CD Ourense CD Ourense 38 42 25 48
4 Ponferradina Ponferradina 38 64 44 45
5 Pontevedra Pontevedra 38 52 34 43
6 CD Basconia CD Basconia 38 44 34 42
7 Lemona Lemona 38 33 31 41
8 SCD Durango SCD Durango 38 33 37 40
9 CD Lugo CD Lugo 38 36 38 40
10 As Pontes As Pontes 38 40 42 39
11 Bergantiños FC Bergantiños 38 39 41 37
12 Lalín Lalín 38 39 43 37
13 Langreo Langreo 38 47 43 36
14 Cultural Leonesa Cultural 38 42 53 35
15 Arosa Arosa 38 38 48 34
16 Arenteiro Arenteiro 38 40 48 32
17 CD Laredo CD Laredo 38 41 58 29
18 Caudal Deportivo Caudal 38 35 51 28
19 Rayo Cantabria Rayo 38 32 60 23
20 Gimnástica Torrelavega Gimnástica 38 16 62 19
TEMPORADA 1986/1987
SEGUNDA DIVISIÓN B
Equipo PJ GF GC Puntos
1 Tenerife Tenerife 42 70 33 59
2 Lleida Lleida 42 71 32 57
3 Granada Granada 42 55 39 56
4 Burgos Burgos 42 45 20 54
5 UD Salamanca Salamanca 42 60 34 53
6 Pontevedra Pontevedra 42 44 38 47
7 Eibar Eibar 42 55 33 47
8 RB Linense RB Linense 42 43 36 44
9 Córdoba CF Córdoba CF 42 53 59 42
10 UD Alzira UD Alzira 42 41 56 41
11 CD Lugo CD Lugo 42 44 51 40
12 Alcoyano Alcoyano 42 56 65 40
13 CD Ourense CD Ourense 42 44 42 40
14 Atlético B Atlético B 42 50 47 39
15 Real Sociedad B Real 42 60 63 38
16 CF Gandia CF Gandia 42 49 51 38
17 Albacete Albacete 42 41 45 37
18 Deportivo Aragón Deportivo 42 35 50 36
19 AgD Ceuta AgD Ceuta 42 42 60 34
20 Poli Almería Poli 42 38 60 31
21 Mallorca B Mallorca B 42 35 70 26
22 Poblense Poblense 42 37 84 25
TEMPORADA 1985/1986
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo CD Lugo 38 57 18 58
2 As Pontes As Pontes 38 73 28 54
3 Deportivo Fabril Deportivo 38 57 33 46
4 Celta C – Gran Peña Celta Gran. 38 65 37 46
5 Viveiro Viveiro 38 44 32 43
6 Portonovo Portonovo 38 42 42 41
7 Alondras CF Alondras CF 38 47 34 41
8 Racing Ferrol Racing 38 40 32 41
9 Coruxo Coruxo 38 42 48 39
10 Barco Barco 38 32 31 39
11 Boiro Boiro 38 38 38 38
12 Vista Alegre SD Vista Alegre 38 46 53 37
13 Céltiga FC Céltiga FC 38 48 52 36
14 Arenteiro Arenteiro 38 31 40 35
15 Flavia Flavia 38 35 41 34
16 Tyde F.C. Tyde F.C. 38 31 46 34
17 Club Lemos Club Lemos 38 38 49 31
18 Marín CF Marín CF 38 29 44 29
19 Celta Fortuna Celta 38 33 65 24
20 San Martiño Martiño 38 14 79 14

  USO DE MEMORIA  
8,382,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1858
Total Execution Time  0.1878
  CADENA URL  
/historico/Lugo/2005
  GET DATOS  
$_GET['/historico/Lugo/2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0039  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 = 'Lugo' AND l.year = 2005 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=1598 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=1598 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 21001
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1598 AND type_rel = 2
0.0062  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1598 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (452,1007,1405,1657,1838) ORDER BY n.cover_points DESC, update_date DESC
0.0049  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 = '1598' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '1598' 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 = 21001 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=1598 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (21002) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 21002 AND teamId = 1598
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 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 = 21001 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0040  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 = '1598' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1598' and rp.type = 4
0.0046  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 = '1598' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1598' and rp.type = 4
0.0020  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 events2005 e ON e.player_id = p.id AND e.league_id = 21001 WHERE rp.league_id = 21001 AND rp.teamId = 1598 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.0020  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 events2005 e ON e.player_id = p.id AND e.league_id = 21001 WHERE rp.league_id = 21001 AND rp.teamId = 1598 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2005 e ON e.player_id = p.id AND e.league_id = 21001 WHERE rp.league_id = 21001 AND rp.teamId = 1598 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0048  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 = 1598 AND l.year <= 2005 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 21001 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 `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 = 21000 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 `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 = 5501 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 `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 = 5500 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 5499 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 5498 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 `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 = 5497 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 `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 = 5496 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 `tables1997` 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 = 5495 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 `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 = 21020 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 `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 = 21019 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 = 21018 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 `tables1993` 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 = 5489 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 `tables1992` 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 = 21053 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables1991` 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 = 21047 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 `tables1990` 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 = 21058 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 `tables1989` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21057 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 `tables1988` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21069 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1987` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21065 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 `tables1986` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 20982 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC