4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Pozoblanco

CD Pozoblanco

Entrenador: Cobos

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 31 51 21 62
2 Ciudad de Lucena Ciudad 31 35 20 61
3 CD Pozoblanco Pozoblanco 31 41 30 58
4 Xerez Deportivo Xerez 31 44 21 55
5 AD Ceuta FC B Ceuta 31 45 25 52
6 Salerm Puente Genil Salerm 31 43 37 49
7 Utrera Utrera 31 44 40 43
8 CD Gerena CD Gerena 31 36 38 43
9 AD Cartaya AD Cartaya 31 30 28 39
10 Bollullos CF Bollullos 31 25 33 37
11 Córdoba CF B Córdoba 31 34 38 36
12 La Palma CF La Palma CF 31 42 47 35
13 Conil Conil 31 27 37 34
14 Coria CF Coria CF 31 38 50 33
15 Sevilla C Sevilla C 31 26 31 32
16 Atlético Espeleño Atlético 31 36 50 32
17 Ayamonte Ayamonte 31 28 45 28
18 Cabecense Cabecense 31 24 58 27
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Atlético Antoniano Atlético 30 47 24 60
2 Córdoba CF B Córdoba 30 44 19 58
3 CD Gerena CD Gerena 30 48 25 54
4 Sevilla C Sevilla C 30 35 26 49
5 Salerm Puente Genil Salerm 30 42 35 47
6 Ciudad de Lucena Ciudad 30 32 23 47
7 Xerez CD Xerez CD 30 36 29 41
8 Atlético Espeleño Atlético 30 40 40 40
9 Conil Conil 30 32 31 40
10 CD Pozoblanco Pozoblanco 30 29 37 40
11 AD Ceuta FC B Ceuta 30 25 29 39
12 Bollullos CF Bollullos 30 31 43 36
13 Ayamonte Ayamonte 30 31 43 33
14 AD Cartaya AD Cartaya 30 30 46 29
15 Coria CF Coria CF 30 26 40 24
16 CD Rota CD Rota 30 15 53 19
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 32 57 20 77
2 Utrera Utrera 32 59 26 67
3 Xerez CD Xerez CD 32 50 24 62
4 Ciudad de Lucena Ciudad 32 45 25 60
5 CD Gerena CD Gerena 32 53 31 58
6 Córdoba CF B Córdoba 32 54 33 58
7 Salerm Puente Genil Salerm 32 36 41 45
8 Sevilla C Sevilla C 32 40 48 43
9 AD Ceuta FC B Ceuta 32 26 39 37
10 Conil Conil 32 30 49 36
11 CD Rota CD Rota 32 31 45 36
12 CD Pozoblanco Pozoblanco 32 37 49 34
13 Atlético Antoniano Atlético 32 29 35 34
14 AD Cartaya AD Cartaya 32 26 30 33
15 UD Tomares UD Tomares 32 27 46 31
16 Cabecense Cabecense 32 25 51 23
17 Los Barrios Los Barrios 32 26 59 23
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 18 26 11 37
2 Xerez CD Xerez CD 18 23 11 35
3 AD Ceuta FC AD Ceuta FC 18 26 17 29
4 Los Barrios Los Barrios 18 18 17 24
5 CD Rota CD Rota 18 15 21 22
6 Atlético Antoniano Atlético 18 15 20 21
7 Conil Conil 18 19 18 20
8 Cabecense Cabecense 18 15 23 19
9 Arcos CF Arcos CF 18 10 19 17
10 Lebrijana Lebrijana 18 15 25 16
11 San Roque de Lepe Roque Lepe 20 30 18 45
12 Ciudad de Lucena Ciudad 20 35 16 40
13 Salerm Puente Genil Salerm 20 28 24 33
14 Córdoba CF B Córdoba 20 31 25 30
15 Utrera Utrera 20 26 26 30
16 CD Pozoblanco Pozoblanco 20 22 23 27
17 Sevilla C Sevilla C 20 17 20 26
18 CD Gerena CD Gerena 20 17 25 22
19 Castilleja Castilleja 20 25 27 21
20 Coria CF Coria CF 20 14 28 15
21 La Palma CF La Palma CF 20 14 27 13
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 29 68 28 59
2 Ciudad de Lucena Ciudad 29 46 24 55
3 Xerez Deportivo Xerez 29 44 24 55
4 Utrera Utrera 29 41 22 52
5 AD Ceuta FC AD Ceuta FC 29 50 22 51
6 Sevilla C Sevilla C 29 34 19 51
7 Atlético Antoniano Atlético 29 42 28 51
8 Salerm Puente Genil Salerm 29 48 35 50
9 CD Rota CD Rota 29 47 49 43
10 Coria CF Coria CF 29 39 36 42
11 San Roque de Lepe Roque Lepe 29 39 31 40
12 Conil Conil 29 34 37 40
13 Lebrijana Lebrijana 29 33 42 34
14 CD Gerena CD Gerena 29 31 37 33
15 Arcos CF Arcos CF 29 30 40 31
16 Los Barrios Los Barrios 29 25 35 30
17 Xerez CD Xerez CD 29 31 43 29
18 CD Pozoblanco Pozoblanco 29 32 51 26
19 Córdoba CF B Córdoba 29 30 54 23
20 Écija Balompié Écija 29 0 87 0
TEMPORADA 2018/2019
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Antoniano Atlético 34 62 34 66
2 CD Rota CD Rota 34 62 39 66
3 CD Pozoblanco Pozoblanco 34 56 32 65
4 Viso UP Viso UP 34 52 35 59
5 Atlético Onubense Atlético 34 46 29 58
6 Atlético Algabeño Atlético 34 61 45 58
7 Castilleja Castilleja 34 69 46 57
8 AD Cartaya AD Cartaya 34 44 32 55
9 CD Alcalá CD Alcalá 34 52 42 52
10 La Palma CF La Palma CF 34 56 64 43
11 Torreblanca CF Torreblanca 34 29 46 39
12 AD San José José 34 49 62 39
13 CD San Roque Roque 34 41 52 39
14 Isla Cristina Isla 34 41 51 35
15 Peñarroya Pueblonuevo Peñarroya 34 28 53 31
16 Ol. Valverdeña Valverdeña 34 41 60 31
17 Pinzón CD Pinzón CD 34 25 57 27
18 Roteña Roteña 34 28 63 21
TEMPORADA 2017/2018
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 34 58 18 72
2 Coria CF Coria CF 34 56 33 65
3 Conil Conil 34 51 30 62
4 Viso UP Viso UP 34 50 33 53
5 Atlético Antoniano Atlético 34 37 42 50
6 CD Pozoblanco Pozoblanco 34 41 44 49
7 Ol. Valverdeña Valverdeña 34 39 46 48
8 CD San Roque Roque 34 46 49 47
9 AD San José José 34 47 37 45
10 Isla Cristina Isla 34 43 55 44
11 CD Rota CD Rota 34 50 58 44
12 La Palma CF La Palma CF 34 53 58 44
13 Atlético Algabeño Atlético 34 38 43 44
14 AD Cartaya AD Cartaya 34 40 30 43
15 Montilla Montilla 34 42 53 34
16 Chiclana Industrial Chiclana 34 35 45 33
17 Estrella San Agustín Estrella 34 33 52 32
18 Ciudad Jardin CD Ciudad 34 26 59 27
TEMPORADA 2016/2017
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 83 28 82
2 Salerm Puente Genil Salerm 38 72 36 73
3 Xerez CD Xerez CD 38 74 37 72
4 Ciudad de Lucena Ciudad 38 60 39 71
5 Estrella San Agustín Estrella 38 59 46 68
6 Xerez Deportivo Xerez 38 65 43 63
7 Conil Conil 38 65 47 60
8 CD Pozoblanco Pozoblanco 38 39 36 58
9 La Palma CF La Palma CF 38 73 58 57
10 Viso UP Viso UP 38 47 38 54
11 AD Cartaya AD Cartaya 38 49 48 54
12 AD San José José 38 57 45 53
13 Ol. Valverdeña Valverdeña 38 55 74 45
14 CD Rota CD Rota 38 58 85 44
15 Chiclana CF Chiclana CF 38 46 62 42
16 Roteña Roteña 38 48 66 41
17 Lora CF Lora CF 38 48 71 39
18 San Juan San Juan 38 58 78 38
19 Pinzón CD Pinzón CD 38 45 71 28
20 Almodóvar del Río Almodóvar 38 25 118 13
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Espeleño Atlético 34 65 21 78
2 Atlético Antoniano Atlético 34 82 34 76
3 Estrella San Agustín Estrella 34 57 31 65
4 Lora CF Lora CF 34 55 38 62
5 CD Pozoblanco Pozoblanco 34 54 37 60
6 Salerm Puente Genil Salerm 34 61 34 59
7 Ciudad de Lucena Ciudad 34 47 26 59
8 AD San José José 34 61 50 55
9 Nervión Nervión 34 56 64 55
10 Moron Moron 34 57 48 49
11 PD Rociera PD Rociera 33 44 41 47
12 CD Pedrera CD Pedrera 34 49 55 40
13 Atco. Villanueva Atco. 34 39 49 38
14 La Barrera La Barrera 34 42 61 37
15 Mairena Mairena 33 33 58 28
16 Pilas Pilas 34 29 65 22
17 CD Montalbeño Montalbeño 34 26 88 14
18 Peñarroya Pueblonuevo Peñarroya 34 19 76 7
TEMPORADA 2014/2015
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Utrera Utrera 34 61 24 70
2 Castilleja Castilleja 34 65 34 69
3 Atlético Espeleño Atlético 34 66 36 68
4 Atlético Antoniano Atlético 34 65 31 67
5 CD Pozoblanco Pozoblanco 34 59 33 66
6 AD San José José 34 64 42 60
7 Lora CF Lora CF 34 61 48 57
8 Moron Moron 34 61 47 49
9 CD Pedrera CD Pedrera 34 46 59 43
10 Atco. Villanueva Atco. 34 37 56 43
11 La Barrera La Barrera 34 48 52 41
12 Estrella San Agustín Estrella 34 45 47 39
13 Peñarroya Pueblonuevo Peñarroya 34 47 54 37
14 Ciudad de Lucena Ciudad 34 43 52 37
15 Ciudad Jardin CD Ciudad 34 41 61 35
16 CD Coronil CD Coronil 34 32 69 25
17 Almodóvar del Río Almodóvar 34 27 73 22
18 La Voz La Voz 34 38 88 22
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 70 37 76
2 San Roque de Lepe Roque Lepe 38 60 29 75
3 CD Alcalá CD Alcalá 38 78 43 72
4 AD Ceuta FC AD Ceuta FC 38 54 33 69
5 Mairena Mairena 38 61 54 61
6 CD Gerena CD Gerena 38 64 40 60
7 Cabecense Cabecense 38 60 45 58
8 San Juan San Juan 38 54 53 56
9 Lebrijana Lebrijana 38 51 49 55
10 Conil Conil 38 41 43 55
11 Cádiz CF Mirandilla Cádiz 38 49 46 52
12 Coria CF Coria CF 38 48 53 51
13 Atlético Onubense Atlético 38 57 58 50
14 CD San Roque Roque 38 56 54 48
15 Sevilla C Sevilla C 38 43 58 45
16 La Palma CF La Palma CF 38 46 61 44
17 Arcos CF Arcos CF 38 36 53 42
18 CD Pozoblanco Pozoblanco 38 37 68 42
19 Xerez CD Xerez CD 38 41 65 32
20 Ayamonte Ayamonte 38 16 80 0
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
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 San Roque de Lepe Roque Lepe 37 64 38 74
2 Jerez Industrial CF Jerez 37 61 37 73
3 Los Barrios Los Barrios 37 58 39 67
4 CD Alcalá CD Alcalá 37 47 30 66
5 Sevilla C Sevilla C 37 68 48 65
6 Coria CF Coria CF 37 56 51 64
7 Puerto Real CF Puerto Real 37 56 35 62
8 Mairena Mairena 37 49 40 54
9 Ayamonte Ayamonte 37 51 54 51
10 CD Pozoblanco Pozoblanco 37 47 46 46
11 Atlético Onubense Atlético 37 41 39 45
12 AD Cartaya AD Cartaya 37 44 55 44
13 Cádiz CF Mirandilla Cádiz 37 38 49 44
14 UD Los Palacios Palacios 37 48 61 43
15 Dos Hermanas CF Hermanas 37 32 46 43
16 At. Sanluqueño Sanluqueño 37 29 49 38
17 Córdoba CF B Córdoba 37 45 69 30
18 Chiclana CF Chiclana CF 37 47 69 28
19 CD Villanueva Villanueva 19 26 20 26
20 Atlético Antoniano Atlético 37 29 61 25
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD San Fernando Fernando 38 64 36 78
2 Puerto Real CF Puerto Real 38 64 42 70
3 RB Linense RB Linense 38 63 32 69
4 CD Villanueva Villanueva 38 47 32 67
5 CD Pozoblanco Pozoblanco 38 52 38 66
6 At. Sanluqueño Sanluqueño 38 57 43 62
7 UD Los Palacios Palacios 38 54 34 61
8 Sevilla C Sevilla C 38 53 42 60
9 Los Barrios Los Barrios 38 45 39 54
10 Mairena Mairena 38 47 39 50
11 Cádiz CF Mirandilla Cádiz 38 54 56 49
12 San Roque de Lepe Roque Lepe 38 40 50 46
13 Córdoba CF B Córdoba 38 44 63 44
14 Jerez Industrial CF Jerez 38 35 49 41
15 Dos Hermanas CF Hermanas 38 34 49 40
16 Ayamonte Ayamonte 38 36 58 40
17 AD Cartaya AD Cartaya 38 39 61 39
18 A. Cerro Águila Cerro 38 35 53 38
19 Arcos CF Arcos CF 38 34 55 34
20 Xerez B Xerez B 38 30 56 28
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

  USO DE MEMORIA  
8,119,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1580
Total Execution Time  0.1593
  CADENA URL  
/historico/Pozoblanco
  GET DATOS  
$_GET['/historico/Pozoblanco']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0073  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 = 'Pozoblanco' 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.0024  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=2009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=2009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=2009 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2009 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2009 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (680432,822157,831531,886617,1070641) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '2009' ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '2009' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '2009' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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=2009 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 (72269,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72269 AND teamId = 2009
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2009
0.0023  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 = '2009' 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 = '2009' and rp.type = 4
0.0022  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 = '2009' 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 = '2009' and rp.type = 4
0.0032  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 = 72269 WHERE rp.league_id = 72269 AND rp.teamId = 2009 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 72269 WHERE rp.league_id = 72269 AND rp.teamId = 2009 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72269 WHERE rp.league_id = 72269 AND rp.teamId = 2009 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 2009 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67984 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 62394 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 `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 = 58589 AND t.round = 22 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 = 50278 AND t.round = 29 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 = 44941 AND t.round = 34 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 = 39236 AND t.round = 34 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 `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 = 34070 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 `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 = 16713 AND t.round = 34 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 = 4057 AND t.round = 34 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 = 2559 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.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 `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.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 `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.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 `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.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 `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 = 140 AND t.round = 38 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 = 17 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 `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.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 `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.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 `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