4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Peña Deportiva

Peña Deportiva

Entrenador: Alberto Gallego

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Hércules Hércules 33 51 29 62
2 CE Europa CE Europa 33 57 32 60
3 Lleida Esportiu Lleida 33 44 29 58
4 CF Badalona Futur Badalona 33 39 25 56
5 UE Sant Andreu Sant Andreu 33 50 33 55
6 Terrassa FC Terrassa FC 33 44 39 49
7 Espanyol B Espanyol B 33 40 38 46
8 Torrent Torrent 33 38 36 46
9 UD Alzira UD Alzira 33 39 41 45
10 Peña Deportiva Peña 33 48 57 44
11 Andratx Andratx 33 40 44 44
12 Valencia Mestalla Valencia 33 48 39 43
13 At. Saguntino Saguntino 33 32 42 41
14 SD Formentera Formentera 33 38 42 41
15 Cerdanyola FC Cerdanyola 33 35 43 37
16 Penya Independent Penya 33 31 50 34
17 CE Manresa CE Manresa 33 23 41 26
18 CF La Nucía Nucía 33 23 60 21
TEMPORADA 2022/2023
SEGUNDA FEDERACIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 CD Teruel CD Teruel 34 37 23 66
2 Peña Deportiva Peña 34 50 27 61
3 Valencia Mestalla Valencia 34 50 28 58
4 CE Manresa CE Manresa 34 40 32 54
5 Espanyol B Espanyol B 34 39 37 53
6 Terrassa FC Terrassa FC 34 44 37 49
7 Hércules Hércules 34 33 37 49
8 CF Badalona Futur Badalona 34 37 39 47
9 Lleida Esportiu Lleida 34 31 25 47
10 At. Saguntino Saguntino 34 36 33 46
11 SD Formentera Formentera 34 37 35 45
12 UD Alzira UD Alzira 34 41 44 45
13 Deportivo Aragón Deportivo 34 36 42 43
14 AE Prat AE Prat 34 34 43 41
15 Olot Olot 34 26 38 32
16 Ibiza I. Pitiusas Ibiza 34 32 50 29
17 Mallorca B Mallorca B 34 24 43 29
18 CD Ebro CD Ebro 34 25 39 24
TEMPORADA 2021/2022
SEGUNDA FEDERACIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Numancia Numancia 34 45 26 62
2 Espanyol B Espanyol B 34 54 46 57
3 Peña Deportiva Peña 34 45 33 56
4 CD Teruel CD Teruel 34 36 37 52
5 Lleida Esportiu Lleida 34 38 39 52
6 Ibiza I. Pitiusas Ibiza 34 47 37 50
7 SD Formentera Formentera 34 38 32 50
8 Terrassa FC Terrassa FC 34 49 42 47
9 CD Ebro CD Ebro 34 35 29 47
10 Brea Brea 34 32 34 45
11 SD Tarazona SD Tarazona 34 36 37 42
12 AE Prat AE Prat 34 33 36 42
13 Cerdanyola FC Cerdanyola 34 45 48 42
14 Andratx Andratx 34 37 36 41
15 Badalona Badalona 34 29 34 41
16 CE Europa CE Europa 34 33 50 38
17 Huesca B Huesca B 34 37 44 37
18 Ejea Ejea 34 28 57 23
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Gimnàstic Tarragona Gimnàstic 20 32 15 35
2 Barça Atlètic Barça 20 28 17 34
3 FC Andorra FC Andorra 20 23 19 31
4 CF Badalona Futur Badalona 20 19 19 29
5 UE Cornellà Cornellà 20 27 25 29
6 Badalona Badalona 20 16 16 28
7 Lleida Esportiu Lleida 20 24 23 27
8 Espanyol B Espanyol B 20 22 27 23
9 L´Hospitalet L´Hospitale 20 21 35 22
10 AE Prat AE Prat 20 13 20 21
11 Olot Olot 20 19 28 18
12 UD Ibiza UD Ibiza 18 26 5 40
13 Alcoyano Alcoyano 18 17 16 31
14 Villarreal B Villarreal 18 21 15 28
15 Hércules Hércules 18 15 14 24
16 CF La Nucía Nucía 18 15 19 23
17 At. Levante At. Levante 18 15 19 22
18 Atzeneta Atzeneta 18 20 18 21
19 Peña Deportiva Peña 18 10 13 21
20 Orihuela CF Orihuela CF 18 12 26 15
21 Valencia Mestalla Valencia 18 20 26 15
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 28 44 22 58
2 UD Ibiza UD Ibiza 28 41 18 56
3 Atlético B Atlético B 28 52 27 53
4 Peña Deportiva Peña 28 43 41 45
5 Coruxo Coruxo 28 32 30 41
6 Rayo Majadahonda Rayo 28 31 29 41
7 RM Castilla RM Castilla 28 42 35 40
8 Internacional de Madrid Internaciona 28 39 37 40
9 Pontevedra Pontevedra 28 38 40 38
10 Langreo Langreo 28 28 33 38
11 Racing Ferrol Racing 28 33 33 37
12 Real Oviedo Vetusta Real Oviedo 28 31 38 37
13 UD Melilla UD Melilla 28 29 37 36
14 Celta Fortuna Celta 28 41 45 35
15 Sporting Atlético Sporting 28 36 31 34
16 Las Palmas At. Palmas 28 20 35 34
17 Las Rozas Las Rozas 28 32 29 33
18 Marino de Luanco Marino 28 26 37 32
19 Getafe B Getafe B 28 25 37 28
20 UD Sanse UD Sanse 28 24 53 19
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Peña Deportiva Peña 40 88 28 98
2 Mallorca B Mallorca B 40 92 31 90
3 Poblense Poblense 40 93 33 86
4 SD Formentera Formentera 40 70 28 85
5 Ibiza I. Pitiusas Ibiza 40 75 28 83
6 Platges de Calvià Platges 40 51 30 72
7 UE Alcudia UE Alcudia 40 66 52 70
8 Santa Catalina Atlético Santa 40 47 54 51
9 CF Sant Rafel Sant Rafel 40 52 48 50
10 Constància Constància 40 40 45 48
11 Felanitx Felanitx 40 58 60 47
12 Llosetense Llosetense 40 41 72 45
13 Binissalem Binissalem 40 37 57 44
14 Soller Soller 40 43 72 44
15 Ferriolense Ferriolense 40 32 52 43
16 Santanyi Santanyi 40 37 54 43
17 Manacor Manacor 40 39 62 37
18 Esporles Esporles 40 41 71 36
19 CD Son Cladera Cladera 40 31 78 35
20 Mercadal Mercadal 40 35 56 33
21 Murense Murense 40 22 79 17
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Mallorca Mallorca 38 52 27 73
2 Villarreal B Villarreal 38 46 29 65
3 Elche Elche 38 56 32 63
4 UE Cornellà Cornellà 38 46 39 60
5 Ontinyent CF Ontinyent 38 30 37 56
6 CD Ebro CD Ebro 38 35 35 56
7 Lleida Esportiu Lleida 38 37 33 55
8 Badalona Badalona 38 38 36 55
9 CF Peralada CF Peralada 38 38 33 52
10 Hércules Hércules 38 39 31 51
11 Valencia Mestalla Valencia 38 60 53 50
12 CE Sabadell CE Sabadell 38 31 29 49
13 Alcoyano Alcoyano 38 32 29 49
14 Atlético Baleares Atlético 38 33 38 44
15 Olot Olot 38 34 38 43
16 CF Badalona Futur Badalona 38 31 41 42
17 SD Formentera Formentera 38 25 41 41
18 At. Saguntino Saguntino 38 35 46 40
19 Peña Deportiva Peña 38 26 41 36
20 Deportivo Aragón Deportivo 38 33 69 20
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 SD Formentera Formentera 38 88 19 86
2 Poblense Poblense 38 90 34 79
3 UE Alcudia UE Alcudia 38 55 30 77
4 Peña Deportiva Peña 38 63 35 74
5 Llosetense Llosetense 38 73 42 69
6 CF Sant Rafel Sant Rafel 38 52 28 66
7 Platges de Calvià Platges 38 55 39 62
8 Constància Constància 38 53 49 51
9 Binissalem Binissalem 38 47 38 50
10 Santa Catalina Atlético Santa 38 44 55 50
11 Ciudad de Ibiza Ciudad Ibiza 38 54 55 49
12 Ferriolense Ferriolense 38 54 68 49
13 Felanitx Felanitx 38 39 49 47
14 CD Son Cladera Cladera 38 37 67 41
15 Esporles Esporles 38 40 56 40
16 Mercadal Mercadal 38 44 55 39
17 UD Collerense Collerense 38 50 63 39
18 Rotlet Molinar Rotlet 38 40 98 32
19 Penya Ciutadella Penya 38 34 83 28
20 Campos Campos 38 28 77 21
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Mallorca B Mallorca B 38 79 29 80
2 SD Formentera Formentera 38 69 29 78
3 Peña Deportiva Peña 38 63 32 74
4 Constància Constància 38 58 30 65
5 Poblense Poblense 38 57 30 62
6 UE Alcudia UE Alcudia 38 52 39 61
7 Mercadal Mercadal 38 48 41 61
8 Binissalem Binissalem 38 49 37 60
9 Montuiri Montuiri 38 49 49 57
10 UD Collerense Collerense 38 52 51 55
11 CF Sant Rafel Sant Rafel 38 42 36 53
12 Ferriolense Ferriolense 38 36 42 45
13 Campos Campos 38 47 59 44
14 Penya Ciutadella Penya 38 46 61 43
15 Esporles Esporles 38 36 54 41
16 Rotlet Molinar Rotlet 38 42 70 38
17 Santa Catalina Atlético Santa 38 33 52 37
18 Platges de Calvià Platges 38 27 55 33
19 UD Alaró UD Alaró 38 18 55 22
20 Soller Soller 38 30 82 22
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 SD Formentera Formentera 38 41 13 73
2 Llosetense Llosetense 38 66 35 72
3 Peña Deportiva Peña 38 57 40 72
4 Mercadal Mercadal 38 64 32 67
5 Constància Constància 38 64 42 66
6 Poblense Poblense 38 64 37 66
7 Binissalem Binissalem 38 63 33 66
8 Soller Soller 38 52 54 53
9 Penya Ciutadella Penya 38 43 50 50
10 CF Sant Rafel Sant Rafel 38 45 43 48
11 Montuiri Montuiri 38 49 58 45
12 Campos Campos 38 34 44 43
13 UD Collerense Collerense 38 42 52 43
14 UD Alaró UD Alaró 38 44 55 42
15 UE Alcudia UE Alcudia 38 32 52 42
16 Ferriolense Ferriolense 38 39 50 41
17 Platges de Calvià Platges 38 32 41 41
18 CD Son Cladera Cladera 38 30 65 35
19 Manacor Manacor 38 36 65 31
20 Atletico Rafal Atletico 38 37 73 26
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Mallorca B Mallorca B 38 90 27 83
2 Peña Deportiva Peña 38 75 33 80
3 SD Formentera Formentera 38 58 27 80
4 Binissalem Binissalem 38 56 31 67
5 Mercadal Mercadal 38 55 53 65
6 Poblense Poblense 38 60 35 64
7 UE Alcudia UE Alcudia 38 59 41 60
8 Penya Ciutadella Penya 38 47 51 54
9 Llosetense Llosetense 38 54 53 54
10 Manacor Manacor 38 63 62 53
11 UD Collerense Collerense 38 60 60 53
12 Platges de Calvià Platges 38 41 40 49
13 Campos Campos 38 51 54 47
14 Ferriolense Ferriolense 38 41 50 45
15 Atletico Rafal Atletico 38 42 65 42
16 CF Sant Rafel Sant Rafel 38 47 60 40
17 Montuiri Montuiri 38 42 53 38
18 Rotlet Molinar Rotlet 38 43 84 37
19 Felanitx Felanitx 38 27 65 26
20 Santanyi Santanyi 38 26 93 13
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Peña Deportiva Peña 38 69 30 84
2 Poblense Poblense 38 53 29 72
3 SD Formentera Formentera 38 62 28 68
4 UE Alcudia UE Alcudia 38 47 28 66
5 Campos Campos 38 37 23 65
6 CF Sant Rafel Sant Rafel 38 48 37 55
7 Manacor Manacor 38 46 50 55
8 Llosetense Llosetense 38 56 47 55
9 Ud Collerense Collerense 38 38 41 51
10 Ferriolense Ferriolense 38 50 48 51
11 Penya Ciutadella Penya 37 45 38 50
12 Mercadal Mercadal 38 39 54 50
13 Montuiri Montuiri 38 39 37 49
14 Santanyi Santanyi 38 49 54 46
15 UD Atlético Isleño Atlético 38 39 45 43
16 CD España CD España 38 41 46 43
17 Andratx Andratx 37 53 58 43
18 Felanitx Felanitx 38 36 49 42
19 Soller Soller 38 48 62 36
20 Son Ferrer Son Ferrer 38 20 111 7
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Constància Constància 38 67 21 83
2 Binissalem Binissalem 38 59 26 80
3 Llosetense Llosetense 38 81 50 76
4 Montuiri Montuiri 38 66 28 75
5 CF Sant Rafel Sant Rafel 38 56 23 72
6 Santanyi Santanyi 38 65 38 68
7 Peña Deportiva Peña 38 61 35 67
8 Campos Campos 38 38 31 56
9 Poblense Poblense 38 46 39 53
10 Mercadal Mercadal 38 42 47 52
11 UD Collerense Collerense 38 46 58 45
12 CD España CD España 38 44 64 40
13 Felanitx Felanitx 38 35 60 40
14 Son Ferrer Son Ferrer 38 26 49 40
15 UD Atlético Isleño Atlético 38 45 58 39
16 UE Alcudia UE Alcudia 38 40 53 37
17 Ferriolense Ferriolense 38 44 60 36
18 Platges de Calvià Platges 38 41 65 34
19 CE Ferreries Ferreries 38 27 87 23
20 CE Alaior CE Alaior 38 36 73 23
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Poblense Poblense 38 73 44 78
2 Manacor Manacor 38 50 23 78
3 Binissalem Binissalem 38 63 30 76
4 Constància Constància 38 60 25 76
5 Llosetense Llosetense 38 69 43 75
6 Peña Deportiva Peña 38 54 23 72
7 Santanyi Santanyi 38 53 43 63
8 CF Sant Rafel Sant Rafel 38 47 38 54
9 Mercadal Mercadal 38 55 45 52
10 UD Collerense Collerense 38 42 48 48
11 Montuiri Montuiri 38 46 59 44
12 UE Alcudia UE Alcudia 38 43 61 43
13 CE Ferreries Ferreries 38 40 49 42
14 Campos Campos 38 41 51 42
15 Ferriolense Ferriolense 38 48 57 41
16 Felanitx Felanitx 38 36 58 40
17 CE Alaior CE Alaior 38 35 61 38
18 CF Norteño CF Norteño 38 26 56 30
19 Penya Arrabal Penya 38 45 78 27
20 UD Arenal UD Arenal 38 32 66 26
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 38 78 33 81
2 Peña Deportiva Peña 38 62 18 78
3 Constància Constància 38 79 37 74
4 Ferriolense Ferriolense 38 55 38 66
5 Binissalem Binissalem 38 58 45 64
6 Santanyi Santanyi 38 74 36 63
7 UE Alcudia UE Alcudia 38 60 45 60
8 Mercadal Mercadal 38 60 59 55
9 CF Sant Rafel Sant Rafel 38 36 36 55
10 UD Arenal UD Arenal 38 41 58 52
11 Montuiri Montuiri 38 48 51 51
12 CE Ferreries Ferreries 38 49 49 47
13 CE Alaior CE Alaior 38 54 61 47
14 Llosetense Llosetense 38 33 63 42
15 Poblense Poblense 38 49 56 40
16 Campos Campos 38 44 57 40
17 UD Collerense Collerense 38 52 71 37
18 Indep. Camp Redó Indep. Camp 38 32 70 37
19 Esporles Esporles 38 29 68 27
20 Atlètic De Ciutadella Atlètic 38 27 69 22
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 38 61 37 73
2 Villarreal B Villarreal 38 73 41 72
3 UE Sant Andreu Sant Andreu 38 45 34 62
4 CE Sabadell CE Sabadell 38 53 44 61
5 Barça Atlètic Barça 38 50 38 60
6 Ontinyent CF Ontinyent 38 46 35 58
7 UDA Gramanet Gramanet 38 52 47 57
8 Lleida Lleida 38 45 38 56
9 Badalona Badalona 38 46 43 53
10 CF Gavá CF Gavá 38 42 43 51
11 Orihuela CF Orihuela CF 38 47 54 49
12 Valencia Mestalla Valencia 38 55 51 48
13 Osasuna Promesas Osasuna 38 48 53 48
14 Benidorm Benidorm 38 37 36 45
15 Dénia Dénia 38 34 40 45
16 Terrassa FC Terrassa FC 38 42 64 42
17 UD Alzira UD Alzira 38 34 44 41
18 UD Ibiza UD Ibiza 38 46 64 35
19 Peña Deportiva Peña 38 35 55 34
20 Atlético Baleares Atlético 38 24 54 33
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 38 83 33 84
2 Mallorca B Mallorca B 38 72 25 83
3 Peña Deportiva Peña 38 65 34 77
4 Santanyi Santanyi 38 77 41 75
5 Ferriolense Ferriolense 38 66 39 67
6 Constància Constància 38 51 32 66
7 Binissalem Binissalem 38 65 42 66
8 UE Alcudia UE Alcudia 38 41 36 60
9 Sp. Mahonès Mahonès 38 38 33 53
10 Manacor Manacor 38 48 40 52
11 Atlètic De Ciutadella Atlètic 38 48 37 51
12 Poblense Poblense 38 62 53 49
13 Soledad Soledad 38 45 56 44
14 Cala d´Or Cala d´Or 38 49 69 43
15 Montuiri Montuiri 38 47 54 42
16 CE Alaior CE Alaior 38 40 64 42
17 Arta Arta 38 47 91 30
18 Margaritense Margaritense 38 34 91 26
19 Serverense Serverense 38 27 77 26
20 Atlético Villacarlos Atlético 38 28 86 14
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 UD Ibiza UD Ibiza 38 76 30 80
2 Mallorca B Mallorca B 39 86 33 75
3 Poblense Poblense 38 49 37 66
4 Margaritense Margaritense 38 61 39 66
5 Binissalem Binissalem 38 54 45 65
6 Atlético Baleares Atlético 38 66 44 65
7 Ferriolense Ferriolense 39 65 46 63
8 Peña Deportiva Peña 38 51 33 60
9 Manacor Manacor 37 47 49 56
10 Santanyi Santanyi 38 55 40 55
11 UE Alcudia UE Alcudia 38 51 45 55
12 Atlètic De Ciutadella Atlètic 39 40 42 51
13 Sp. Mahonès Mahonès 39 36 46 48
14 CE Alaior CE Alaior 37 53 57 45
15 Constància Constància 38 53 71 36
16 FC Vilafranca Vilafranca 38 33 55 35
17 UD Collerense Collerense 38 47 89 34
18 Montuiri Montuiri 37 41 62 32
19 Andratx Andratx 38 32 66 31
20 Soller Soller 37 27 94 15
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Peña Deportiva Peña 40 66 23 88
2 Mallorca B Mallorca B 40 94 34 86
3 Ferriolense Ferriolense 40 80 31 84
4 Sp. Mahonès Mahonès 40 67 31 83
5 UD Ibiza UD Ibiza 40 70 36 74
6 Montuiri Montuiri 40 59 46 72
7 Atlètic De Ciutadella Atlètic 40 61 48 66
8 Binissalem Binissalem 40 54 57 61
9 Santanyi Santanyi 40 60 55 56
10 Manacor Manacor 40 51 60 48
11 Margaritense Margaritense 40 49 59 47
12 UD Collerense Collerense 40 53 73 47
13 Constància Constància 40 50 60 46
14 CE Alaior CE Alaior 40 46 63 44
15 Soller Soller 40 47 67 44
16 Poblense Poblense 40 43 53 44
17 FC Vilafranca Vilafranca 40 33 50 42
18 Platges de Calvià Platges 40 36 66 38
19 Soledad Soledad 40 35 65 35
20 Felanitx Felanitx 40 34 72 31
21 UD Arenal UD Arenal 40 36 75 30
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Constància Constància 38 81 37 84
2 Manacor Manacor 38 62 31 73
3 Sp. Mahonès Mahonès 38 55 29 70
4 Peña Deportiva Peña 38 73 34 70
5 FC Vilafranca Vilafranca 38 57 43 66
6 Poblense Poblense 38 52 43 60
7 Binissalem Binissalem 38 52 53 58
8 Ferriolense Ferriolense 38 56 50 56
9 UD Ibiza UD Ibiza 38 52 40 55
10 Atlètic De Ciutadella Atlètic 38 50 51 52
11 Soller Soller 38 70 63 51
12 Santanyi Santanyi 38 62 73 48
13 UD Arenal UD Arenal 38 41 47 45
14 Platges de Calvià Platges 38 52 51 44
15 CE Alaior CE Alaior 38 41 67 43
16 Montuiri Montuiri 38 42 51 41
17 Atlético Baleares Atlético 38 38 76 34
18 UD Collerense Collerense 38 51 81 34
19 Campos Campos 38 40 70 33
20 SD Portmany SD Portmany 38 37 74 24

  USO DE MEMORIA  
8,373,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5996
Total Execution Time  0.6008
  CADENA URL  
/historico/Pena-Deportiva
  GET DATOS  
$_GET['/historico/Pena-Deportiva']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0149  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 = 'Pena-Deportiva' 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.0125  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=6003 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=6003 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=6003 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6003 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6003 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  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 (70823,94354,225942,228723,234064) ORDER BY n.cover_points DESC, update_date DESC
0.0143  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 = '6003' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '6003' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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=6003 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72364,71759,71617,67320) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72364 AND teamId = 6003
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 6003
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71617 AND teamId = 6003
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 6003
0.0143  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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6003 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.0149  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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6003 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6003 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 6003 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254  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 = 67967 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.0130  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 = 62382 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.0131  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 = 44399 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 38808 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 15452 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 3920 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 2560 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 1950 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 1407 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 1123 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 832 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 129 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 18 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 96 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 22123 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 22104 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC