4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lucena
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Albacete Albacete 38 62 30 82
2 Lorca FC Lorca FC 38 62 22 79
3 FC Cartagena Cartagena 38 59 35 73
4 Cádiz Cádiz 38 75 38 71
5 CD Guadalajara Guadalajara 38 57 33 69
6 Recreativo Granada Recreativo 38 65 47 58
7 RB Linense RB Linense 38 51 42 56
8 UD Melilla UD Melilla 38 47 45 55
9 Lucena Lucena 38 42 45 55
10 CP Cacereño Cacereño 38 43 49 53
11 Córdoba CF B Córdoba 38 42 50 45
12 El Palo FC El Palo FC 38 35 47 45
13 Almería B Almería B 38 42 49 43
14 Sevilla At. Sevilla At. 38 33 44 43
15 Arroyo Arroyo 38 38 47 43
16 Algeciras CF Algeciras 38 39 45 43
17 La Roda CF La Roda CF 38 39 46 40
18 San Fernando CD Fernando 38 36 60 39
19 At. Sanluqueño Sanluqueño 38 34 68 34
20 Écija Balompié Écija 38 28 87 23
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 38 44 24 70
2 FC Cartagena Cartagena 38 52 33 68
3 Albacete Albacete 38 45 32 61
4 Lucena Lucena 38 47 38 59
5 Almería B Almería B 38 52 46 59
6 RB Linense RB Linense 38 48 45 58
7 San Fernando CD Fernando 38 45 39 56
8 Écija Balompié Écija 38 47 38 53
9 UD Melilla UD Melilla 38 38 37 53
10 La Roda CF La Roda CF 38 39 36 52
11 At. Sanluqueño Sanluqueño 38 49 46 50
12 CP Cacereño Cacereño 38 40 36 48
13 Cádiz Cádiz 38 40 38 48
14 Sevilla At. Sevilla At. 38 42 53 46
15 Arroyo Arroyo 38 32 40 45
16 Villanovense Villanovense 38 32 46 43
17 UCAM Murcia UCAM Murcia 38 35 41 41
18 San Roque de Lepe Roque Lepe 38 47 58 38
19 Loja Loja 38 30 54 38
20 Betis Deportivo Betis 38 38 62 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 38 62 23 76
2 RB Linense RB Linense 38 57 33 72
3 Lucena Lucena 38 53 30 72
4 Real Jaén Real Jaén 38 48 31 70
5 UD Melilla UD Melilla 38 50 33 64
6 San Roque de Lepe Roque Lepe 38 43 35 61
7 CP Cacereño Cacereño 38 48 33 61
8 Betis Deportivo Betis 38 58 59 59
9 Villanovense Villanovense 38 53 52 58
10 Sevilla At. Sevilla At. 38 56 45 55
11 Puertollano Puertollano 38 46 49 51
12 CD Badajoz CD Badajoz 38 60 58 50
13 Almería B Almería B 38 50 60 50
14 AgD Ceuta AgD Ceuta 38 47 49 49
15 Écija Balompié Écija 38 33 36 46
16 Lorca Atlético CF Lorca 38 50 52 42
17 CD Roquetas CD Roquetas 38 34 55 41
18 Cfba Caravaca Cfba 38 33 49 38
19 Sp. Villanueva Promesas Villanueva 38 16 42 14
20 Poli Ejido Poli Ejido 38 13 86 7
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Real Murcia Real Murcia 38 68 21 82
2 Sevilla At. Sevilla At. 38 82 40 74
3 UD Melilla UD Melilla 38 53 28 72
4 Cádiz Cádiz 38 61 37 69
5 San Roque de Lepe Roque Lepe 38 42 35 63
6 AgD Ceuta AgD Ceuta 38 52 42 60
7 CD Roquetas CD Roquetas 38 48 36 59
8 Real Jaén Real Jaén 38 39 29 56
9 Écija Balompié Écija 38 41 45 54
10 Lucena Lucena 38 42 40 52
11 Cfba Caravaca Cfba 38 41 40 49
12 Puertollano Puertollano 38 40 50 48
13 Almería B Almería B 38 38 46 46
14 Poli Ejido Poli Ejido 38 41 51 44
15 Lorca Atlético CF Lorca 38 37 55 43
16 Betis Deportivo Betis 38 36 45 42
17 CD Alcalá CD Alcalá 38 30 52 40
18 Unión Estepona Unión 38 37 45 40
19 Yeclano Deportivo Yeclano 38 28 63 27
20 Jumilla Jumilla 38 16 72 19
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Granada Granada 38 74 37 76
2 UD Melilla UD Melilla 38 55 37 76
3 Real Jaén Real Jaén 38 58 32 69
4 Poli Ejido Poli Ejido 38 47 28 65
5 AgD Ceuta AgD Ceuta 38 56 44 61
6 Lucena Lucena 38 58 39 55
7 Atlético Ciudad Atlético 38 48 55 53
8 San Roque de Lepe Roque Lepe 38 54 47 53
9 Unión Estepona Unión 38 48 50 52
10 Écija Balompié Écija 38 54 52 52
11 Cfba Caravaca Cfba 38 47 44 52
12 Sangonera Sangonera 38 51 55 51
13 Real Murcia Imperial Real Murcia 38 45 45 51
14 Betis Deportivo Betis 38 39 37 51
15 Sevilla At. Sevilla At. 38 41 42 51
16 CD Roquetas CD Roquetas 38 44 46 50
17 Moratalla Moratalla 38 36 48 42
18 Jerez Industrial CF Jerez 38 33 73 35
19 Marbella FC Marbella FC 38 36 62 31
20 Águilas CF Águilas CF 38 28 79 21
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 38 71 42 79
2 Real Jaén Real Jaén 38 44 21 71
3 Poli Ejido Poli Ejido 38 60 39 66
4 Marbella FC Marbella FC 38 48 33 64
5 Puertollano Puertollano 38 56 36 63
6 UD Melilla UD Melilla 38 49 38 62
7 AgD Ceuta AgD Ceuta 38 59 40 58
8 UB Conquense Conquense 38 55 57 57
9 CD Guadalajara Guadalajara 38 39 29 56
10 Granada Granada 38 53 52 51
11 Betis Deportivo Betis 38 52 52 48
12 CD Roquetas CD Roquetas 38 44 40 47
13 CD Linares CD Linares 38 41 54 43
14 Écija Balompié Écija 38 37 50 43
15 Antequera CF Antequera 38 43 56 40
16 Lucena Lucena 38 47 62 40
17 CD San Fernando Fernando 38 46 66 38
18 Granada 74 Granada 74 38 34 61 36
19 RB Linense RB Linense 38 35 54 34
20 RC Portuense Portuense 38 26 57 30
TEMPORADA 2007/2008
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Écija Balompié Écija 38 54 29 72
2 CD Linares CD Linares 38 61 43 67
3 AgD Ceuta AgD Ceuta 38 48 30 66
4 Mérida UD Mérida UD 38 59 47 64
5 Granada Granada 38 52 36 63
6 Águilas CF Águilas CF 38 50 38 58
7 UD Melilla UD Melilla 38 47 36 58
8 FC Cartagena Cartagena 38 42 33 57
9 Real Jaén Real Jaén 38 30 28 56
10 Lucena Lucena 38 40 34 52
11 Lorca Deportiva Lorca 38 38 40 49
12 Betis Deportivo Betis 38 39 42 49
13 Puertollano Puertollano 38 36 42 47
14 RC Portuense Portuense 38 34 46 46
15 Marbella FC Marbella FC 38 29 42 46
16 Baza Baza 38 36 44 43
17 Mazarrón CF Mazarrón 38 37 55 42
18 CD Alcalá CD Alcalá 38 32 43 41
19 Talavera CF Talavera CF 38 37 62 35
20 Algeciras CF Algeciras 38 31 62 22
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 38 63 29 79
2 Betis Deportivo Betis 38 59 33 76
3 Lucena Lucena 38 51 30 68
4 CD San Fernando Fernando 38 61 35 68
5 RB Linense RB Linense 38 55 32 67
6 UD Los Palacios Palacios 38 45 37 64
7 Los Barrios Los Barrios 38 62 44 61
8 Arcos CF Arcos CF 38 67 60 59
9 Cádiz CF Mirandilla Cádiz 38 46 43 55
10 Mairena Mairena 38 44 44 53
11 Puerto Real CF Puerto Real 38 53 48 52
12 CD Pozoblanco Pozoblanco 38 40 50 50
13 Córdoba CF B Córdoba 38 37 47 45
14 Ayamonte Ayamonte 38 31 42 41
15 Jerez Industrial CF Jerez 38 35 56 38
16 Xerez B Xerez B 38 41 58 37
17 At. Sanluqueño Sanluqueño 38 36 53 36
18 Club Atlético De Ceuta Club 38 32 54 31
19 Cabecense Cabecense 38 32 66 29
20 Chiclana CF Chiclana CF 38 37 66 28
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 RC Portuense Portuense 38 55 26 76
2 CD San Fernando Fernando 38 59 27 75
3 Arcos CF Arcos CF 38 56 49 63
4 RB Linense RB Linense 38 55 42 63
5 At. Sanluqueño Sanluqueño 38 53 34 62
6 Betis Deportivo Betis 38 67 47 61
7 Xerez B Xerez B 38 62 43 56
8 Cádiz CF Mirandilla Cádiz 38 52 44 55
9 Lucena Lucena 38 42 43 54
10 Los Barrios Los Barrios 38 57 55 54
11 Chiclana CF Chiclana CF 38 49 62 49
12 UD Los Palacios Palacios 38 33 38 48
13 Puerto Real CF Puerto Real 38 43 54 48
14 Jerez Industrial CF Jerez 38 33 48 44
15 Dos Hermanas CF Hermanas 38 42 62 42
16 Mairena Mairena 38 38 53 42
17 Córdoba CF B Córdoba 38 37 42 41
18 CD Pozoblanco Pozoblanco 38 41 50 40
19 Coria CF Coria CF 38 32 63 34
20 Bollullos CF Bollullos 38 29 53 30
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD Villanueva Villanueva 40 72 36 82
2 Los Barrios Los Barrios 40 54 41 76
3 RC Portuense Portuense 40 47 37 67
4 RB Linense RB Linense 40 68 38 67
5 UD Los Palacios Palacios 40 63 44 65
6 CD Pozoblanco Pozoblanco 40 54 31 64
7 CD San Fernando Fernando 40 54 46 61
8 Betis Deportivo Betis 40 58 50 59
9 Lucena Lucena 40 46 43 52
10 Puerto Real CF Puerto Real 40 48 55 52
11 Chiclana CF Chiclana CF 40 56 63 51
12 Jerez Industrial CF Jerez 40 50 52 50
13 Dos Hermanas CF Hermanas 40 43 55 48
14 Bollullos CF Bollullos 40 49 51 48
15 Coria CF Coria CF 40 48 57 48
16 At. Sanluqueño Sanluqueño 40 45 54 48
17 Cádiz CF Mirandilla Cádiz 40 47 60 46
18 A. Cerro Águila Cerro 40 35 51 46
19 Atlético Antoniano Atlético 40 45 56 44
20 Nueva Sevilla Nueva 40 38 65 36
21 AD Cartaya AD Cartaya 40 37 72 29
TEMPORADA 2003/2004
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Alcalá de Guadaira Alcalá 38 51 24 70
2 CD San Fernando Fernando 38 73 43 68
3 Bollullos CF Bollullos 38 61 38 67
4 CD Villanueva Villanueva 38 72 41 64
5 RB Linense RB Linense 38 45 34 63
6 Jerez Industrial CF Jerez 38 47 34 62
7 Coria CF Coria CF 38 49 34 59
8 Los Barrios Los Barrios 38 45 44 57
9 At. Sanluqueño Sanluqueño 38 52 56 53
10 Dos Hermanas CF Hermanas 38 47 46 52
11 Chiclana CF Chiclana CF 38 35 44 51
12 Atlético Antoniano Atlético 38 50 52 48
13 RC Portuense Portuense 38 45 50 48
14 Lucena Lucena 38 37 55 47
15 Nueva Sevilla Nueva 38 37 54 42
16 A. Cerro Águila Cerro 38 38 60 41
17 Córdoba CF B Córdoba 38 43 51 39
18 Serrallo CF Serrallo CF 38 45 67 38
19 AD Cartaya AD Cartaya 38 37 64 36
20 Montilla Montilla 38 39 57 30
TEMPORADA 2002/2003
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD Villanueva Villanueva 42 70 35 86
2 UD Los Palacios Palacios 42 61 32 75
3 Lucena Lucena 42 65 48 75
4 Alcalá de Guadaira Alcalá 42 66 42 74
5 Dos Hermanas CF Hermanas 42 78 49 73
6 Coria CF Coria CF 42 64 49 70
7 Jerez Industrial CF Jerez 42 58 51 65
8 Córdoba CF B Córdoba 42 71 73 63
9 AD Cartaya AD Cartaya 42 52 42 58
10 RB Linense RB Linense 42 49 44 55
11 Atlético Antoniano Atlético 42 67 73 54
12 At. Sanluqueño Sanluqueño 42 53 52 53
13 CD San Fernando Fernando 42 45 55 53
14 Montilla Montilla 42 53 63 50
15 Bollullos CF Bollullos 42 49 49 49
16 Serrallo CF Serrallo CF 42 28 50 48
17 Los Barrios Los Barrios 42 50 61 47
18 Ayamonte Ayamonte 42 42 64 42
19 Atlético Onubense Atlético 42 45 55 42
20 AD San José José 42 48 62 42
21 Puerto Real CF Puerto Real 42 42 70 36
22 At. Cortegana Cortegana 42 37 74 31
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD Villanueva Villanueva 38 68 33 74
2 Jerez Industrial CF Jerez 38 67 26 73
3 Atlético Antoniano Atlético 38 80 51 71
4 Atlético Onubense Atlético 38 53 32 68
5 Lucena Lucena 38 55 37 64
6 Ayamonte Ayamonte 38 39 32 63
7 Córdoba CF B Córdoba 38 62 48 62
8 Montilla Montilla 38 46 37 57
9 Los Barrios Los Barrios 38 60 44 56
10 UD San José José 38 53 44 55
11 Puerto Real CF Puerto Real 38 55 54 52
12 Alcalá de Guadaira Alcalá 38 48 46 51
13 UD Los Palacios Palacios 38 45 40 50
14 AD Cartaya AD Cartaya 38 46 48 48
15 At. Sanluqueño Sanluqueño 38 39 61 47
16 RC Portuense Portuense 38 41 49 46
17 CD Pozoblanco Pozoblanco 38 44 65 39
18 UD Tomares UD Tomares 38 34 69 32
19 San Roque de Lepe Roque Lepe 38 36 74 24
20 Recreativo Linense Recreativo 38 27 108 12
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 84 25 86
2 Betis Deportivo Betis 38 55 34 67
3 Lucena Lucena 38 66 51 63
4 At. Sanluqueño Sanluqueño 38 67 51 61
5 Jerez Industrial CF Jerez 38 55 43 60
6 Atlético Onubense Atlético 38 37 34 57
7 Córdoba CF B Córdoba 38 46 37 55
8 UD San José José 38 54 46 55
9 UD Los Palacios Palacios 38 46 43 51
10 CD Pozoblanco Pozoblanco 38 44 50 50
11 Ayamonte Ayamonte 38 46 44 49
12 RC Portuense Portuense 38 37 45 47
13 CD Villanueva Villanueva 38 30 43 44
14 Puerto Real CF Puerto Real 38 40 54 42
15 Chiclana CF Chiclana CF 38 35 52 42
16 AD Cartaya AD Cartaya 38 40 59 41
17 Los Barrios Los Barrios 38 41 61 40
18 UD Tomares UD Tomares 38 33 50 39
19 La Palma La Palma 38 44 55 37
20 Serrallo CF Serrallo CF 38 36 59 35
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 38 64 32 73
2 CD San Fernando Fernando 38 58 31 68
3 Puerto Real CF Puerto Real 38 62 40 66
4 RC Portuense Portuense 38 44 41 65
5 UD Los Palacios Palacios 38 54 43 64
6 At. Sanluqueño Sanluqueño 38 61 47 63
7 CD Pozoblanco Pozoblanco 38 62 43 61
8 Lucena Lucena 38 45 37 55
9 Atlético Onubense Atlético 38 45 38 55
10 UD Tomares UD Tomares 38 55 52 55
11 CD Villanueva Villanueva 38 43 49 51
12 Córdoba CF B Córdoba 38 53 54 48
13 AD Cartaya AD Cartaya 38 49 54 47
14 La Palma La Palma 37 37 45 43
15 Ayamonte Ayamonte 38 35 53 41
16 Los Barrios Los Barrios 38 36 49 40
17 Chiclana CF Chiclana CF 38 42 58 39
18 Montilla Montilla 38 38 59 38
19 AD Ceuta FC B Ceuta 38 43 67 28
20 CD Rota CD Rota 37 32 66 26
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 38 56 19 81
2 Dos Hermanas CF Hermanas 38 67 28 80
3 Coria CF Coria CF 38 61 18 73
4 CD San Fernando Fernando 38 64 35 71
5 Lucena Lucena 38 52 21 64
6 RC Portuense Portuense 38 41 34 57
7 Chiclana CF Chiclana CF 38 44 36 56
8 At. Sanluqueño Sanluqueño 38 45 42 54
9 Montilla Montilla 38 35 35 53
10 UD Tomares UD Tomares 38 43 44 50
11 UD Los Palacios Palacios 38 52 46 47
12 CD Pozoblanco Pozoblanco 38 37 44 46
13 CD Rota CD Rota 38 42 55 46
14 Puerto Real CF Puerto Real 38 40 45 46
15 Ayamonte Ayamonte 38 36 51 43
16 Los Barrios Los Barrios 38 38 55 42
17 La Palma La Palma 38 40 50 38
18 Utrera Utrera 38 36 62 37
19 San Roque de Lepe Roque Lepe 38 34 68 29
20 Serrallo CF Serrallo CF 38 18 93 16
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 AgD Ceuta AgD Ceuta 38 81 27 82
2 CD San Fernando Fernando 38 91 31 78
3 San Roque de Lepe Roque Lepe 38 50 30 64
4 Algeciras CF Algeciras 38 54 46 64
5 Lucena Lucena 38 34 21 63
6 Coria CF Coria CF 38 57 36 63
7 Chiclana CF Chiclana CF 38 54 43 58
8 Utrera Utrera 38 48 48 53
9 La Palma La Palma 38 45 60 52
10 CD Rota CD Rota 38 53 65 50
11 RB Linense RB Linense 38 39 60 46
12 Ayamonte Ayamonte 38 46 48 46
13 Puerto Real CF Puerto Real 38 49 61 45
14 Montilla Montilla 38 35 47 45
15 At. Sanluqueño Sanluqueño 38 49 49 44
16 CD Pozoblanco Pozoblanco 38 43 48 44
17 UD Los Palacios Palacios 38 40 53 42
18 Cádiz CF Mirandilla Cádiz 38 35 47 40
19 La Rambla CF Rambla 38 38 74 34
20 Rayo Sanluqueño Rayo 38 36 83 24
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 UA. Ceutí UA. Ceutí 42 69 41 79
2 CD Isla Cristina Isla 42 76 40 76
3 Algeciras CF Algeciras 42 61 39 72
4 Ayamonte Ayamonte 42 64 38 71
5 Montilla Montilla 42 62 51 70
6 UD Los Palacios Palacios 42 60 44 66
7 CD San Fernando Fernando 42 67 57 66
8 At. Sanluqueño Sanluqueño 42 59 53 64
9 CD Pozoblanco Pozoblanco 42 55 49 61
10 CD Rota CD Rota 42 57 58 59
11 San Roque de Lepe Roque Lepe 42 57 56 57
12 RB Linense RB Linense 42 57 52 55
13 Cádiz CF Mirandilla Cádiz 42 51 55 54
14 La Palma La Palma 42 51 54 54
15 Utrera Utrera 42 71 49 54
16 Lucena Lucena 42 53 69 50
17 Chiclana CF Chiclana CF 42 45 59 50
18 Dos Hermanas CF Hermanas 42 53 60 50
19 Mairena Mairena 42 36 62 37
20 Conil Conil 42 30 77 33
21 Roteña Roteña 42 23 90 23
TEMPORADA 1994/1995
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD Pozoblanco Pozoblanco 42 90 35 63
2 Utrera Utrera 42 74 28 58
3 Chiclana CF Chiclana CF 42 63 40 55
4 CD Isla Cristina Isla 42 85 41 55
5 Montilla Montilla 42 54 27 51
6 RB Linense RB Linense 42 68 45 49
7 UD Los Palacios Palacios 42 63 52 47
8 San Juan San Juan 42 55 46 45
9 La Palma La Palma 42 55 65 45
10 Cádiz CF Mirandilla Cádiz 42 53 51 44
11 Mairena Mairena 42 55 46 42
12 At. Sanluqueño Sanluqueño 42 46 55 41
13 Coria CF Coria CF 42 58 51 40
14 Dos Hermanas CF Hermanas 42 60 59 39
15 Jerez Industrial CF Jerez 42 45 54 39
16 Conil Conil 42 46 55 39
17 At. Cortegana Cortegana 42 50 67 36
18 Lucena Lucena 42 40 59 34
19 Roteña Roteña 42 43 58 33
20 AgD Ceuta AgD Ceuta 42 43 96 24
21 Puente Genil Puente Genil 42 27 81 24
22 Atlético Sanlucar Atlético 42 30 92 21
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 84 21 57
2 UD Los Palacios Palacios 38 50 23 46
3 CD San Fernando Fernando 38 42 37 43
4 At. Cortegana Cortegana 38 52 44 41
5 AgD Ceuta AgD Ceuta 38 38 32 41
6 Cádiz CF Mirandilla Cádiz 38 44 40 40
7 At. Sanluqueño Sanluqueño 38 50 42 40
8 Atlético Sanlucar Atlético 38 49 40 40
9 Coria CF Coria CF 38 39 36 39
10 RB Linense RB Linense 38 35 36 39
11 San Juan San Juan 38 46 42 38
12 Mairena Mairena 38 49 44 38
13 Jerez Industrial CF Jerez 38 34 39 36
14 Puente Genil Puente Genil 38 40 52 36
15 Roteña Roteña 38 43 56 35
16 Lucena Lucena 38 42 56 35
17 Montilla Montilla 38 35 47 34
18 Egabrense Egabrense 38 31 59 30
19 CD Pozoblanco Pozoblanco 38 40 52 29
20 Lebrija Lebrija 38 35 80 23

  USO DE MEMORIA  
8,629,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.2591
Total Execution Time  0.2603
  CADENA URL  
/historico/Lucena
  GET DATOS  
$_GET['/historico/Lucena']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (77)  
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 = 'Lucena' 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.0070  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 = 'Lucena' 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=1596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1596 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=1596 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=1596 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=1596 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=1596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=1596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=1596 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=1596 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=1596 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=1596 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=1596 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=1596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 2467
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1596 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1596 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0027  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 (31050,85739,85744) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '1596' ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '1596' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '1596' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = '1596' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0038  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=1596 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0030  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (3866,3804,2735,2339) 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.0042  SELECT count(id) as num_players from rel_players WHERE league_id = 3866 AND teamId = 1596
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 2735 AND teamId = 1596
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 2339 AND teamId = 1596
0.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 1596
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 `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 = 2735 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0027  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 = '1596' 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 = '1596' and rp.type = 4
0.0026  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 = '1596' 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 = '1596' and rp.type = 4
0.0038  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 events2014 e ON e.player_id = p.id AND e.league_id = 2735 WHERE rp.league_id = 2735 AND rp.teamId = 1596 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.0038  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 events2014 e ON e.player_id = p.id AND e.league_id = 2735 WHERE rp.league_id = 2735 AND rp.teamId = 1596 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2014 e ON e.player_id = p.id AND e.league_id = 2735 WHERE rp.league_id = 2735 AND rp.teamId = 1596 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 1596 AND l.year <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 2467 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 `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 = 95 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 22122 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 `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 = 22103 AND t.round = 42 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 = 22087 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 `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 = 22071 AND t.round = 42 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 `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 = 22055 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 22039 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 `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 = 22023 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 `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 = 22007 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 `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 = 21991 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 `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 = 21973 AND t.round = 42 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 `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 = 21932 AND t.round = 51 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 `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 = 21910 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC