4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
PRIMERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 34 69 32 78
2 Córdoba CF Córdoba CF 34 61 28 70
3 UD Ibiza UD Ibiza 34 53 31 63
4 Málaga Málaga 34 44 22 62
5 AD Ceuta FC AD Ceuta FC 34 46 34 56
6 Real Murcia Real Murcia 34 32 31 54
7 Antequera CF Antequera 34 44 40 53
8 Recreativo Recreativo 34 36 34 52
9 Atlético B Atlético B 34 50 40 48
10 Alcoyano Alcoyano 34 34 35 45
11 CF Intercity Intercity 34 36 41 45
12 RM Castilla RM Castilla 34 41 41 44
13 Algeciras CF Algeciras 34 37 38 42
14 At. Sanluqueño Sanluqueño 34 32 37 39
15 AD Mérida AD Mérida 34 29 41 39
16 San Fernando CD Fernando 34 32 45 35
17 Linares Deportivo Linares 34 30 46 35
18 UD Melilla UD Melilla 34 23 49 27
19 Atlético Baleares Atlético 34 18 54 23
20 Recreativo Granada Recreativo 34 24 52 21
TEMPORADA 2022/2023
PRIMERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 SD Amorebieta Amorebieta 38 48 29 69
2 Eldense Eldense 38 50 28 69
3 CD Castellón Castellón 38 46 32 62
4 Barça Atlètic Barça 38 45 38 61
5 Real Sociedad B Real 38 50 34 60
6 Real Murcia Real Murcia 38 49 33 56
7 Osasuna Promesas Osasuna 38 51 45 53
8 Gimnàstic Tarragona Gimnàstic 38 37 43 53
9 SD Logroñés Logroñés 38 40 43 51
10 CE Sabadell CE Sabadell 38 42 43 50
11 UE Cornellà Cornellà 38 34 42 49
12 CF Intercity Intercity 38 45 44 49
13 Real Unión Club Real Unión 38 39 48 48
14 Atlético Baleares Atlético 38 44 46 47
15 Alcoyano Alcoyano 38 36 41 47
16 Numancia Numancia 38 31 36 46
17 CF La Nucía Nucía 38 39 45 46
18 UD Logroñés Logroñés 38 25 33 36
19 CD Calahorra Calahorra 38 31 52 33
20 Bilbao Ath. Bilbao Ath. 38 27 54 26
TEMPORADA 2021/2022
SEGUNDA FEDERACIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CF Intercity Intercity 34 46 16 66
2 CF La Nucía Nucía 34 41 18 64
3 Real Murcia Real Murcia 34 42 27 58
4 Eldense Eldense 34 47 37 56
5 Hércules Hércules 34 41 31 56
6 Racing Cartagena Mar Menor Racing 34 34 29 55
7 UD Alzira UD Alzira 34 42 36 51
8 Recreativo Granada Recreativo 34 34 32 46
9 UD Melilla UD Melilla 34 36 39 45
10 Mancha Real Mancha Real 34 32 36 43
11 Pvo. El Ejido Pvo. Ejido 34 30 35 43
12 UD Yugo Socuéllamos Yugo 34 29 34 43
13 Águilas FC Águilas FC 34 32 36 41
14 At. Levante At. Levante 34 33 33 38
15 At. Pulpileño Pulpileño 34 23 48 34
16 CD Marchamalo Marchamalo 34 33 59 32
17 CS Puertollano Puertollano 34 38 50 29
18 CD Toledo CD Toledo 34 27 44 28
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
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 38 50 23 78
2 FC Cartagena Cartagena 38 62 27 75
3 UD Melilla UD Melilla 38 55 32 72
4 CD Badajoz CD Badajoz 38 44 31 66
5 UCAM Murcia UCAM Murcia 38 54 40 66
6 UD Ibiza UD Ibiza 38 41 31 63
7 Marbella FC Marbella FC 38 42 33 60
8 San Fernando CD Fernando 38 44 36 60
9 CF Talavera CF Talavera 38 34 34 50
10 Sevilla At. Sevilla At. 38 37 46 48
11 Real Murcia Real Murcia 38 32 32 48
12 RB Linense RB Linense 38 33 33 46
13 At. Sanluqueño Sanluqueño 38 32 48 46
14 Recreativo Granada Recreativo 38 37 42 45
15 CD Don Benito Benito 38 38 49 44
16 Jumilla Jumilla 38 31 42 43
17 Pvo. El Ejido Pvo. Ejido 38 29 47 39
18 Villanovense Villanovense 38 32 40 38
19 At. Malagueño Malagueño 38 27 54 29
20 Almería B Almería B 38 27 61 23
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 38 51 33 71
2 Marbella FC Marbella FC 38 49 27 70
3 Real Murcia Real Murcia 38 49 33 65
4 Extremadura Extremadura 38 59 38 60
5 UD Melilla UD Melilla 38 43 24 60
6 Villanovense Villanovense 38 29 33 54
7 UCAM Murcia UCAM Murcia 38 38 42 52
8 Recreativo Granada Recreativo 38 34 35 51
9 San Fernando CD Fernando 38 47 46 49
10 Pvo. El Ejido Pvo. Ejido 38 54 55 49
11 RB Linense RB Linense 38 44 37 48
12 CD Badajoz CD Badajoz 38 46 44 48
13 Jumilla Jumilla 38 30 42 47
14 Las Palmas At. Palmas 38 45 44 47
15 Recreativo Recreativo 38 33 36 47
16 AD Mérida AD Mérida 38 34 42 46
17 Écija Balompié Écija 38 38 56 45
18 Córdoba CF B Córdoba 38 40 51 43
19 Betis Deportivo Betis 38 47 61 40
20 Lorca Deportiva Lorca 38 33 64 32
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Lorca FC Lorca FC 38 52 39 73
2 Real Murcia Real Murcia 38 48 29 67
3 Villanovense Villanovense 38 55 32 66
4 FC Cartagena Cartagena 38 49 35 65
5 AD Mérida AD Mérida 38 51 33 64
6 UD Melilla UD Melilla 38 39 25 60
7 Marbella FC Marbella FC 38 46 45 58
8 Recreativo Granada Recreativo 38 60 48 53
9 RB Linense RB Linense 38 41 48 52
10 Jumilla Jumilla 38 32 37 48
11 Córdoba CF B Córdoba 38 43 42 48
12 Recreativo Recreativo 38 35 41 47
13 Extremadura Extremadura 38 37 48 46
14 Pvo. El Ejido Pvo. Ejido 38 40 47 46
15 San Fernando CD Fernando 38 42 52 46
16 Linares Deportivo Linares 38 40 46 45
17 At. Sanluqueño Sanluqueño 38 36 51 39
18 Mancha Real Mancha Real 38 44 64 38
19 Real Jaén Real Jaén 38 37 43 37
20 La Roda CF La Roda CF 38 36 58 28
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
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 38 77 31 80
2 Real Murcia Real Murcia 38 47 26 72
3 Racing Ferrol Racing 38 65 41 69
4 UD Logroñés Logroñés 38 49 37 66
5 Guijuelo Guijuelo 38 58 48 61
6 SD Compostela Compostela 38 45 39 61
7 Cultural Leonesa Cultural 38 52 43 59
8 Coruxo Coruxo 38 44 47 53
9 Real Valladolid Promesas Real 38 54 54 52
10 Somozas Somozas 38 44 43 52
11 Sporting Atlético Sporting 38 49 50 50
12 Burgos Burgos 38 37 40 49
13 Celta Fortuna Celta 38 49 58 48
14 Atl. Astorga Atl. Astorga 38 50 56 45
15 Lealtad Villaviciosa Lealtad 38 38 49 44
16 Real Avilés Industrial Real Avilés 38 36 53 43
17 Langreo Langreo 38 37 49 43
18 Zamora Zamora 38 38 51 39
19 Tropezón Tropezón 38 38 62 36
20 Marino de Luanco Marino 38 26 56 21
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Eibar Eibar 42 49 28 71
2 RC Deportivo Deportivo 42 48 36 69
3 Barça Atlètic Barça 42 60 47 66
4 Real Murcia Real Murcia 42 55 44 65
5 Real Sporting Real 42 63 51 64
6 Las Palmas Las Palmas 42 51 50 63
7 Córdoba CF Córdoba CF 42 46 43 61
8 Recreativo Recreativo 42 53 53 61
9 Alcorcón Alcorcón 42 46 40 59
10 CE Sabadell CE Sabadell 42 52 59 59
11 Tenerife Tenerife 42 46 49 54
12 CD Lugo CD Lugo 42 41 48 54
13 Numancia Numancia 42 42 41 54
14 Real Zaragoza Real 42 49 53 53
15 Girona Girona 42 52 50 51
16 Ponferradina Ponferradina 42 46 49 51
17 Mallorca Mallorca 42 46 57 51
18 Deportivo Alavés Deportivo 42 57 57 51
19 Mirandés Mirandés 42 39 56 50
20 RM Castilla RM Castilla 42 49 56 49
21 Real Jaén Real Jaén 42 43 49 48
22 Hércules Hércules 42 45 62 45
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Elche Elche 42 54 27 82
2 Villarreal Villarreal 42 68 38 77
3 Almería Almería 42 72 50 74
4 Girona Girona 42 74 56 71
5 Alcorcón Alcorcón 42 57 55 69
6 Las Palmas Las Palmas 42 62 55 66
7 Ponferradina Ponferradina 42 57 50 66
8 RM Castilla RM Castilla 42 80 62 59
9 Barça Atlètic Barça 42 76 71 57
10 Real Sporting Real 42 60 53 56
11 CD Lugo CD Lugo 42 46 54 56
12 Numancia Numancia 42 53 55 55
13 Recreativo Recreativo 42 46 57 54
14 Córdoba CF Córdoba CF 42 55 55 54
15 Mirandés Mirandés 42 35 51 52
16 CE Sabadell CE Sabadell 42 54 69 52
17 Hércules Hércules 42 43 53 50
18 CD Guadalajara Guadalajara 42 46 53 50
19 Real Murcia Real Murcia 42 43 56 47
20 Racing Racing 42 38 51 46
21 Huesca Huesca 42 46 58 45
22 Xerez CD Xerez CD 42 38 74 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 42 76 45 91
2 Celta Celta 42 83 37 85
3 Real Valladolid Real 42 69 37 82
4 Alcorcón Alcorcón 42 58 42 73
5 Hércules Hércules 42 62 43 72
6 Córdoba CF Córdoba CF 42 52 43 71
7 Almería Almería 42 63 43 70
8 Barça Atlètic Barça 42 63 53 59
9 Las Palmas Las Palmas 42 58 59 58
10 Numancia Numancia 42 54 52 57
11 Elche Elche 42 56 58 57
12 Villarreal B Villarreal 42 54 64 52
13 Huesca Huesca 42 49 63 51
14 Xerez CD Xerez CD 42 50 66 50
15 Girona Girona 42 58 61 49
16 CD Guadalajara Guadalajara 42 50 75 49
17 Recreativo Recreativo 42 49 52 47
18 Real Murcia Real Murcia 42 49 67 47
19 CE Sabadell CE Sabadell 42 45 64 46
20 FC Cartagena Cartagena 42 37 58 40
21 Alcoyano Alcoyano 42 46 78 37
22 Gimnàstic Tarragona Gimnàstic 42 37 58 31
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
Equipo PJ GF GC Puntos
1 Real Sociedad Real 42 53 37 74
2 Hércules Hércules 42 61 34 71
3 Levante Levante 42 63 45 71
4 Real Betis Real Betis 42 61 38 71
5 FC Cartagena Cartagena 42 58 49 65
6 Elche Elche 42 67 57 63
7 Villarreal B Villarreal 42 60 56 61
8 Numancia Numancia 42 55 53 59
9 Recreativo Recreativo 42 40 42 57
10 Córdoba CF Córdoba CF 42 40 46 55
11 Rayo Vallecano Rayo 42 67 58 53
12 Celta Celta 42 38 44 52
13 Huesca Huesca 42 36 40 52
14 Girona Girona 42 45 59 52
15 Albacete Albacete 42 60 62 52
16 UD Salamanca Salamanca 42 44 54 52
17 Las Palmas Las Palmas 42 49 49 51
18 Gimnàstic Tarragona Gimnàstic 42 42 55 51
19 Cádiz Cádiz 42 49 64 50
20 Real Murcia Real Murcia 42 49 51 50
21 Real Unión Club Real Unión 42 40 59 46
22 CD Castellón Castellón 42 37 62 33
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 42 73 42 82
2 Real Zaragoza Real 42 79 42 81
3 Tenerife Tenerife 42 79 47 81
4 Hércules Hércules 42 82 43 78
5 Rayo Vallecano Rayo 42 55 39 70
6 Real Sociedad Real 42 48 38 67
7 CD Castellón Castellón 42 55 42 65
8 Levante Levante 42 59 59 64
9 UD Salamanca Salamanca 42 59 50 60
10 Gimnàstic Tarragona Gimnàstic 42 60 50 57
11 Huesca Huesca 42 47 46 53
12 Elche Elche 42 52 50 53
13 Córdoba CF Córdoba CF 42 47 54 53
14 Real Murcia Real Murcia 42 48 58 52
15 Albacete Albacete 42 42 54 51
16 Girona Girona 42 43 54 49
17 Celta Celta 42 46 56 48
18 Las Palmas Las Palmas 42 46 51 47
19 Deportivo Alavés Deportivo 42 42 64 43
20 Alicante Alicante 42 38 69 35
21 Eibar Eibar 42 31 63 35
22 Sevilla At. Sevilla At. 42 29 89 19
TEMPORADA 2007/2008
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 38 84 36 85
2 Villarreal Villarreal 38 63 40 77
3 Barcelona Barcelona 38 76 43 67
4 Atlético Atlético 38 66 47 64
5 Sevilla Sevilla 38 75 49 64
6 Racing Racing 38 42 41 60
7 Mallorca Mallorca 38 69 54 59
8 Almería Almería 38 42 45 52
9 RC Deportivo Deportivo 38 46 47 52
10 Valencia Valencia 38 48 62 51
11 Athletic Athletic 38 40 43 50
12 Espanyol Espanyol 38 43 53 48
13 Real Betis Real Betis 38 45 51 47
14 Getafe Getafe 38 44 48 47
15 Real Valladolid Real 38 42 57 45
16 Recreativo Recreativo 38 40 60 44
17 Osasuna Osasuna 38 37 44 43
18 Real Zaragoza Real 38 50 61 42
19 Real Murcia Real Murcia 38 36 65 30
20 Levante Levante 38 33 75 26
TEMPORADA 2006/2007
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Valladolid Real 42 70 35 88
2 Almería Almería 42 73 49 80
3 Real Murcia Real Murcia 42 62 45 76
4 Ciudad de Murcia Ciudad 42 52 44 63
5 Cádiz Cádiz 42 53 45 61
6 Albacete Albacete 42 49 48 60
7 Tenerife Tenerife 42 48 51 60
8 Numancia Numancia 42 48 44 58
9 Xerez CD Xerez CD 42 47 42 58
10 Elche Elche 42 47 46 58
11 Poli Ejido Poli Ejido 42 52 50 58
12 UD Salamanca Salamanca 42 53 50 57
13 Real Sporting Real 42 53 53 56
14 CD Castellón Castellón 42 48 41 56
15 Málaga Málaga 42 49 50 55
16 Hércules Hércules 42 48 52 54
17 Deportivo Alavés Deportivo 42 51 60 52
18 Las Palmas Las Palmas 42 51 59 51
19 RM Castilla RM Castilla 42 55 67 49
20 Ponferradina Ponferradina 42 45 61 46
21 Lorca Deportiva Lorca 42 37 60 37
22 Vecindario Vecindario 42 42 81 34
TEMPORADA 2005/2006
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 42 67 32 78
2 Gimnàstic Tarragona Gimnàstic 42 48 38 76
3 Levante Levante 42 53 39 74
4 Ciudad de Murcia Ciudad 42 53 42 72
5 Lorca Deportiva Lorca 42 56 39 69
6 Almería Almería 42 54 43 67
7 Xerez CD Xerez CD 42 60 46 67
8 Numancia Numancia 42 50 55 63
9 Real Sporting Real 42 41 34 56
10 Real Valladolid Real 42 54 54 55
11 RM Castilla RM Castilla 42 55 50 55
12 CD Castellón Castellón 42 46 50 54
13 Albacete Albacete 42 44 57 54
14 Elche Elche 42 47 54 53
15 Poli Ejido Poli Ejido 42 43 50 53
16 Real Murcia Real Murcia 42 41 40 52
17 Hércules Hércules 42 39 49 52
18 Tenerife Tenerife 42 53 60 51
19 Lleida Lleida 42 43 53 46
20 Racing Ferrol Racing 42 44 63 37
21 At. Malagueño Malagueño 42 42 68 36
22 Eibar Eibar 42 28 45 35
TEMPORADA 2004/2005
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 42 68 30 76
2 Celta Celta 42 55 38 76
3 Deportivo Alavés Deportivo 42 62 47 76
4 Eibar Eibar 42 53 39 73
5 Recreativo Recreativo 42 48 32 71
6 Real Valladolid Real 42 56 56 63
7 Gimnàstic Tarragona Gimnàstic 42 49 45 60
8 Xerez CD Xerez CD 42 39 36 59
9 Tenerife Tenerife 42 42 45 57
10 Elche Elche 42 51 52 57
11 Real Sporting Real 42 41 39 57
12 Real Murcia Real Murcia 42 40 52 54
13 Poli Ejido Poli Ejido 42 41 45 52
14 Almería Almería 42 36 44 51
15 Lleida Lleida 42 46 54 50
16 Racing Ferrol Racing 42 55 54 49
17 At. Malagueño Malagueño 42 33 51 48
18 Ciudad de Murcia Ciudad 42 49 57 47
19 Córdoba CF Córdoba CF 42 43 52 46
20 Terrassa FC Terrassa FC 42 45 63 44
21 UD Salamanca Salamanca 42 50 63 44
22 Pontevedra Pontevedra 42 52 60 44

  USO DE MEMORIA  
9,001,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1822
Total Execution Time  0.1834
  CADENA URL  
/historico/Real-Murcia
  GET DATOS  
$_GET['/historico/Real-Murcia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0040  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 = 'Real-Murcia' 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.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=2113 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=2113 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=2113 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=2113 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2113 AND type_rel = 2
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2113 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1085,1155,1903,2372,2454) ORDER BY n.cover_points DESC, update_date DESC
0.0040  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 = '2113' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0032  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=2113 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,71759,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.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 72359 AND teamId = 2113
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 2113
0.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2113
0.0032  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 = '2113' 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 = '2113' and rp.type = 4
0.0056  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 = '2113' 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 = '2113' and rp.type = 4
0.0059  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 = 2113 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.0064  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 = 2113 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0057  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 = 2113 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0056  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 = 2113 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 67960 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.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 = 62384 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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.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 `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 = 44098 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 `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 = 33381 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3865 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 = 1901 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 `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 = 1335 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1103 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 `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 = 812 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 `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 = 105 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 `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 = 2 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 `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 = 81 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 `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 = 534 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 535 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC