TEMPORADA 2023/2024
PRIMERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 32 67 32 72
2 Córdoba CF Córdoba CF 32 58 28 64
3 UD Ibiza UD Ibiza 32 52 27 63
4 Málaga Málaga 32 44 21 61
5 AD Ceuta FC AD Ceuta FC 32 44 32 53
6 Recreativo Recreativo 32 35 29 52
7 Real Murcia Real Murcia 32 31 31 50
8 Antequera CF Antequera 32 38 37 47
9 Alcoyano Alcoyano 32 33 31 45
10 Atlético B Atlético B 32 46 39 42
11 Algeciras CF Algeciras 32 34 32 42
12 CF Intercity Intercity 32 34 38 42
13 RM Castilla RM Castilla 32 35 39 38
14 AD Mérida AD Mérida 32 29 39 38
15 At. Sanluqueño Sanluqueño 32 31 37 35
16 San Fernando CD Fernando 32 31 37 35
17 Linares Deportivo Linares 32 26 44 32
18 UD Melilla UD Melilla 32 21 48 24
19 Atlético Baleares Atlético 32 16 50 23
20 Recreativo Granada Recreativo 32 18 52 15
TEMPORADA 2022/2023
PRIMERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 55 25 75
2 Alcorcón Alcorcón 38 53 23 74
3 RM Castilla RM Castilla 38 58 38 69
4 RC Deportivo Deportivo 38 53 29 67
5 Celta Fortuna Celta 38 48 38 59
6 Linares Deportivo Linares 38 53 53 59
7 Unionistas CF Unionistas 38 38 40 56
8 AD Mérida AD Mérida 38 40 37 54
9 Córdoba CF Córdoba CF 38 48 37 54
10 Cultural Leonesa Cultural 38 41 43 48
11 Fuenlabrada Fuenlabrada 38 32 51 46
12 AD Ceuta FC AD Ceuta FC 38 53 52 45
13 San Fernando CD Fernando 38 46 50 45
14 Rayo Majadahonda Rayo 38 42 51 45
15 Algeciras CF Algeciras 38 36 47 44
16 CD Badajoz CD Badajoz 38 35 52 43
17 UD Sanse UD Sanse 38 30 46 43
18 RB Linense RB Linense 38 31 34 42
19 Pontevedra Pontevedra 38 34 53 36
20 CF Talavera CF Talavera 38 36 63 33
TEMPORADA 2021/2022
PRIMERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 FC Andorra FC Andorra 38 61 38 71
2 Villarreal B Villarreal 38 65 36 67
3 Albacete Albacete 38 52 34 67
4 Gimnàstic Tarragona Gimnàstic 38 41 30 61
5 Linares Deportivo Linares 38 59 47 60
6 Atlético Baleares Atlético 38 52 35 59
7 Algeciras CF Algeciras 38 50 39 59
8 CE Sabadell CE Sabadell 38 44 33 58
9 Barça Atlètic Barça 38 59 51 57
10 RM Castilla RM Castilla 38 66 47 56
11 Alcoyano Alcoyano 38 41 40 52
12 RB Linense RB Linense 38 35 44 50
13 CD Castellón Castellón 38 37 50 50
14 UE Cornellà Cornellà 38 39 48 48
15 San Fernando CD Fernando 38 49 58 48
16 At. Sanluqueño Sanluqueño 38 39 56 46
17 Sevilla At. Sevilla At. 38 36 55 46
18 UCAM Murcia UCAM Murcia 38 42 56 35
19 CF Badalona Futur Badalona 38 26 51 33
20 Betis Deportivo Betis 38 23 68 21
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 18 21 17 32
2 San Fernando CD Fernando 18 22 15 31
3 At. Sanluqueño Sanluqueño 18 18 17 31
4 RB Linense RB Linense 18 17 12 28
5 Tamaraceite Tamaraceite 18 19 15 27
6 Cádiz CF Mirandilla Cádiz 18 20 19 23
7 Las Palmas At. Palmas 18 13 16 21
8 Recreativo Recreativo 18 29 27 20
9 Marbella FC Marbella FC 18 20 19 18
10 Marino Marino 18 11 33 10
11 UCAM Murcia UCAM Murcia 18 22 15 33
12 Linares Deportivo Linares 18 22 16 33
13 Betis Deportivo Betis 18 23 15 30
14 Sevilla At. Sevilla At. 18 27 19 30
15 Córdoba CF Córdoba CF 18 21 16 27
16 Real Murcia Real Murcia 18 22 21 25
17 Recreativo Granada Recreativo 18 20 19 23
18 Pvo. El Ejido Pvo. Ejido 18 17 21 19
19 Yeclano Deportivo Yeclano 18 13 27 11
20 Lorca Deportiva Lorca 18 15 33 9
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 28 33 19 54
2 Marbella FC Marbella FC 28 39 20 53
3 CD Badajoz CD Badajoz 28 37 22 49
4 Yeclano Deportivo Yeclano 28 42 33 47
5 Córdoba CF Córdoba CF 28 33 27 45
6 San Fernando CD Fernando 28 39 25 44
7 RB Linense RB Linense 28 27 26 41
8 Real Murcia Real Murcia 28 33 26 39
9 Sevilla At. Sevilla At. 28 31 33 36
10 UCAM Murcia UCAM Murcia 28 29 33 36
11 Cádiz CF Mirandilla Cádiz 28 23 27 36
12 Villarrubia CF Villarrubia 28 34 33 35
13 Recreativo Recreativo 28 30 31 33
14 CD Don Benito Benito 28 32 35 32
15 At. Sanluqueño Sanluqueño 28 20 28 30
16 Algeciras CF Algeciras 28 31 40 29
17 CF Talavera CF Talavera 28 23 33 29
18 Recreativo Granada Recreativo 28 21 35 29
19 AD Mérida AD Mérida 28 28 37 27
20 CP Villarrobledo Villarrobled 28 23 45 22
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 42 48 18 83
2 AD Ceuta FC AD Ceuta FC 42 68 42 80
3 Utrera Utrera 42 59 29 79
4 Algeciras CF Algeciras 42 64 35 77
5 Xerez Deportivo Xerez 42 49 24 77
6 Betis Deportivo Betis 42 93 40 76
7 Los Barrios Los Barrios 42 64 43 76
8 Córdoba CF B Córdoba 42 67 39 71
9 Ciudad de Lucena Ciudad 42 56 53 58
10 Xerez CD Xerez CD 42 45 42 57
11 Salerm Puente Genil Salerm 42 52 49 55
12 Lebrijana Lebrijana 42 47 65 52
13 Coria CF Coria CF 42 53 52 51
14 CD Gerena CD Gerena 42 43 68 50
15 Sevilla C Sevilla C 42 39 49 50
16 San Roque de Lepe Roque Lepe 42 52 61 49
17 Conil Conil 42 47 55 49
18 Arcos CF Arcos CF 42 45 53 49
19 Écija Balompié Écija 42 37 48 48
20 Cabecense Cabecense 42 39 80 30
21 Atlético Espeleño Atlético 42 45 91 29
22 CD Guadalcacín Guadalcacín 42 21 97 14
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 49 19 75
2 AD Ceuta FC AD Ceuta FC 38 54 24 74
3 Algeciras CF Algeciras 38 55 31 66
4 At. Sanluqueño Sanluqueño 38 51 27 64
5 Lebrijana Lebrijana 38 50 37 59
6 Sevilla C Sevilla C 38 62 48 59
7 CD Gerena CD Gerena 38 50 39 57
8 Salerm Puente Genil Salerm 38 47 44 53
9 Cabecense Cabecense 38 41 45 48
10 Ciudad de Lucena Ciudad 38 60 65 47
11 San Roque de Lepe Roque Lepe 38 50 60 45
12 Atlético Espeleño Atlético 38 53 65 45
13 Utrera Utrera 38 38 43 45
14 CD Guadalcacín Guadalcacín 38 38 46 45
15 Arcos CF Arcos CF 38 43 57 44
16 Xerez CD Xerez CD 38 50 66 43
17 Los Barrios Los Barrios 38 38 44 43
18 Atlético Onubense Atlético 38 42 54 41
19 CD Alcalá CD Alcalá 38 33 61 41
20 Castilleja Castilleja 38 41 70 34
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 81 35 78
2 Arcos CF Arcos CF 38 76 39 73
3 Écija Balompié Écija 38 69 39 71
4 Algeciras CF Algeciras 38 66 34 69
5 San Roque de Lepe Roque Lepe 38 68 52 66
6 Sevilla C Sevilla C 38 55 39 58
7 Atlético Espeleño Atlético 38 63 56 57
8 Lebrijana Lebrijana 38 45 48 56
9 AD Ceuta FC AD Ceuta FC 38 45 39 56
10 Utrera Utrera 38 49 50 51
11 CD Gerena CD Gerena 38 53 53 49
12 Los Barrios Los Barrios 38 31 44 47
13 CD Guadalcacín Guadalcacín 38 42 57 47
14 Cabecense Cabecense 38 47 64 43
15 Atlético Onubense Atlético 38 45 66 43
16 Castilleja Castilleja 38 44 55 41
17 CD Alcalá CD Alcalá 38 37 65 41
18 Atlético Antoniano Atlético 38 38 59 40
19 Coria CF Coria CF 38 48 66 36
20 CD San Roque Roque 38 37 79 21
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 UCAM Murcia UCAM Murcia 38 46 17 77
2 Real Murcia Real Murcia 38 56 30 71
3 Sevilla At. Sevilla At. 38 53 31 68
4 Cádiz Cádiz 38 53 31 63
5 Recreativo Granada Recreativo 38 56 40 58
6 Lorca FC Lorca FC 38 43 41 56
7 FC Cartagena Cartagena 38 40 35 53
8 AD Mérida AD Mérida 38 39 41 52
9 UD Melilla UD Melilla 38 34 44 49
10 Real Jaén Real Jaén 38 46 37 48
11 RB Linense RB Linense 38 47 51 48
12 Villanovense Villanovense 38 49 56 47
13 Recreativo Recreativo 38 27 38 45
14 Marbella FC Marbella FC 38 46 47 45
15 Jumilla Jumilla 38 36 57 43
16 Linares Deportivo Linares 38 39 46 43
17 Betis Deportivo Betis 38 47 53 41
18 Algeciras CF Algeciras 38 28 48 41
19 San Roque de Lepe Roque Lepe 38 42 55 39
20 Almería B Almería B 38 26 55 28
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 42 77 28 100
2 San Fernando CD Fernando 42 88 28 91
3 CD Gerena CD Gerena 42 89 38 87
4 At. Sanluqueño Sanluqueño 42 74 40 83
5 AD Ceuta FC AD Ceuta FC 42 50 32 72
6 Lebrijana Lebrijana 42 60 66 60
7 Conil Conil 42 51 60 60
8 Écija Balompié Écija 42 49 41 58
9 Sevilla C Sevilla C 42 42 45 58
10 Coria CF Coria CF 42 48 42 57
11 CD Alcalá CD Alcalá 42 40 52 57
12 CD San Roque Roque 42 47 49 56
13 San Juan San Juan 42 48 49 52
14 Los Barrios Los Barrios 42 45 50 52
15 CD Guadalcacín Guadalcacín 42 39 48 52
16 Cabecense Cabecense 42 36 54 49
17 Arcos CF Arcos CF 42 46 74 48
18 Mairena Mairena 42 42 55 44
19 PD Rociera PD Rociera 42 40 73 40
20 Cádiz CF Mirandilla Cádiz 42 45 54 38
21 La Palma CF La Palma CF 42 35 69 36
22 Atlético Onubense Atlético 42 34 78 33
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
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 38 65 27 76
2 Córdoba CF B Córdoba 38 59 22 75
3 Coria CF Coria CF 38 64 37 68
4 Mairena Mairena 38 47 28 65
5 AD Ceuta FC AD Ceuta FC 38 63 38 63
6 Cabecense Cabecense 38 52 35 59
7 CD Alcalá CD Alcalá 38 49 39 58
8 CD San Roque Roque 38 47 56 53
9 Atlético Onubense Atlético 38 57 57 50
10 RC Portuense Portuense 38 36 35 49
11 Cádiz CF Mirandilla Cádiz 38 36 47 47
12 Conil Conil 38 46 56 45
13 Sevilla C Sevilla C 38 40 46 44
14 San Juan San Juan 38 35 44 43
15 CD Pozoblanco Pozoblanco 38 30 50 41
16 Arcos CF Arcos CF 38 37 59 41
17 Ayamonte Ayamonte 38 35 61 40
18 Atlético Antoniano Atlético 38 34 51 40
19 Los Barrios Los Barrios 38 30 55 38
20 Montilla Montilla 38 37 56 33
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 At. Sanluqueño Sanluqueño 38 81 32 89
2 San Fernando CD Fernando 38 88 51 74
3 Mairena Mairena 38 64 32 71
4 Coria CF Coria CF 38 72 46 68
5 Sevilla C Sevilla C 38 67 46 66
6 Algeciras CF Algeciras 38 57 50 59
7 CD Alcalá CD Alcalá 38 57 52 57
8 Atlético Onubense Atlético 38 59 55 54
9 Cádiz CF Mirandilla Cádiz 38 53 53 50
10 Córdoba CF B Córdoba 38 35 37 45
11 Conil Conil 38 47 68 45
12 CD Pozoblanco Pozoblanco 38 47 49 45
13 Atlético Antoniano Atlético 38 31 45 43
14 CD San Roque Roque 38 53 67 42
15 Puerto Real CF Puerto Real 38 45 63 40
16 RC Portuense Portuense 38 41 53 39
17 Ayamonte Ayamonte 38 46 72 38
18 Jerez Industrial CF Jerez 38 34 51 38
19 UD Marinaleda Marinaleda 38 39 59 38
20 PD Rociera PD Rociera 38 40 75 35
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 38 65 32 76
2 San Fernando CD Fernando 38 61 33 72
3 CD Pozoblanco Pozoblanco 38 56 33 71
4 Mairena Mairena 38 41 29 63
5 Algeciras CF Algeciras 38 44 33 62
6 RC Portuense Portuense 38 44 38 61
7 Puerto Real CF Puerto Real 38 42 32 59
8 At. Sanluqueño Sanluqueño 38 47 42 56
9 Sevilla C Sevilla C 38 42 40 51
10 Córdoba CF B Córdoba 38 41 38 49
11 UD Los Palacios Palacios 38 40 44 49
12 Coria CF Coria CF 38 57 60 46
13 Jerez Industrial CF Jerez 38 36 58 45
14 Atlético Onubense Atlético 38 40 47 44
15 Conil Conil 38 44 47 43
16 Cádiz CF Mirandilla Cádiz 38 52 50 43
17 UD Marinaleda Marinaleda 38 36 53 42
18 Ayamonte Ayamonte 38 53 62 42
19 Peñarroya Pueblonuevo Peñarroya 38 35 60 34
20 Los Barrios Los Barrios 38 23 68 20
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD Alcalá CD Alcalá 38 68 21 80
2 Mairena Mairena 38 54 30 70
3 Ayamonte Ayamonte 38 63 33 69
4 UD Marinaleda Marinaleda 38 52 34 66
5 RB Linense RB Linense 38 50 32 63
6 CD Pozoblanco Pozoblanco 38 44 33 62
7 Los Barrios Los Barrios 38 42 41 57
8 Atlético Onubense Atlético 38 61 47 56
9 Córdoba CF B Córdoba 38 38 37 55
10 Cádiz CF Mirandilla Cádiz 38 42 41 54
11 UD Los Palacios Palacios 38 40 45 53
12 Coria CF Coria CF 38 56 47 50
13 Puerto Real CF Puerto Real 38 33 39 49
14 Sevilla C Sevilla C 38 42 39 49
15 Algeciras CF Algeciras 38 48 53 46
16 At. Sanluqueño Sanluqueño 38 36 41 44
17 RC Portuense Portuense 38 39 56 43
18 Murallas de Ceuta Murallas 38 28 42 39
19 Dos Hermanas CF Hermanas 38 24 92 19
20 AD Cartaya AD Cartaya 38 25 82 18
TEMPORADA 2008/2009
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 34 64 30 69
2 Conil Conil 34 64 39 69
3 Arcos CF Arcos CF 34 70 32 67
4 CD Rota CD Rota 34 55 48 54
5 Punta Umbria Punta Umbria 34 40 42 53
6 Roteña Roteña 34 59 48 50
7 La Palma La Palma 34 49 44 49
8 Xerez B Xerez B 34 47 45 47
9 Atl. Cortegana Atl. 34 46 48 42
10 San Roque de Lepe B Roque Lepe 34 31 42 41
11 Balón de Cádiz CF Balón 34 36 41 40
12 Isla Cristina Isla 34 34 41 39
13 Ol. Valverdeña Valverdeña 34 37 55 39
14 San Fernando CD Fernando 34 41 49 38
15 Atlético Tharsis Atlético 34 36 50 38
16 Ud Bornense Ud Bornense 34 45 60 32
17 Tesorillo Tesorillo 34 39 56 31
18 Chiclana Industrial Chiclana 34 24 47 31
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
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 38 54 33 73
2 Águilas CF Águilas CF 38 43 32 65
3 Sevilla At. Sevilla At. 38 48 30 60
4 CD Linares CD Linares 38 39 31 60
5 Écija Balompié Écija 38 46 34 56
6 Córdoba CF Córdoba CF 38 57 46 55
7 CD Badajoz CD Badajoz 38 36 34 54
8 CD Alcalá CD Alcalá 38 37 39 53
9 Mérida UD Mérida UD 38 40 43 52
10 AgD Ceuta AgD Ceuta 38 43 31 52
11 CF Extremadura Extremadura 38 52 48 52
12 Marbella FC Marbella FC 38 41 41 52
13 Real Jaén Real Jaén 38 41 41 51
14 Talavera CF Talavera CF 38 56 53 50
15 CD Villanueva Villanueva 38 47 58 46
16 Baza Baza 38 38 39 45
17 UD Almansa UD Almansa 38 35 43 43
18 UB Conquense Conquense 38 36 57 39
19 Algeciras CF Algeciras 38 38 55 36
20 Diter Zafra Diter Zafra 38 37 76 28
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

  USO DE MEMORIA  
8,524,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.1472
Total Execution Time  0.1488
  CADENA URL  
/historico/Algeciras-Cf
  GET DATOS  
$_GET['/historico/Algeciras-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 166 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1903,2601,2835,3254,4075) ORDER BY n.cover_points DESC, update_date DESC
0.0035  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 = '166' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033  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=166 AND l.year in (2023,2024,2025) 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 (72359,71432) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72359 AND teamId = 166
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 166
0.0026  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 = '166' 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 = '166' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '166' 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 = '166' and rp.type = 4
0.0037  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 166 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.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 166 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72359 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62379 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 58611 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50268 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44398 AND t.round = 42 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 `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39034 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33360 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15378 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 `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3919 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 `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.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1949 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 = 1406 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 `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1136 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 844 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 7 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 `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.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 `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 = 171 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 175 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC