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

Castelldefels

Entrenador: Miki Carrillo

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Olot Olot 31 47 18 70
2 L´Hospitalet L´Hospitale 31 48 27 60
3 UE Vilassar de Mar Vilassar 31 39 25 57
4 Badalona Badalona 31 35 32 48
5 AE Prat AE Prat 31 30 24 45
6 L'Escala L'Escala 31 51 50 45
7 Tona Tona 31 44 40 44
8 Montañesa Montañesa 31 29 30 43
9 CF Peralada CF Peralada 31 31 29 41
10 Reus FC Reddis Reus Reddis 31 28 26 41
11 CFJ Mollerussa Mollerussa 31 28 40 41
12 FE Grama FE Grama 31 35 42 40
13 CP San Cristóbal Cristóbal 31 30 48 39
14 Girona FC B Girona FC B 31 42 37 37
15 CF Pobla de Mafumet Pobla 31 29 34 35
16 FC Vilafranca Vilafranca 31 28 46 32
17 Rapitenca Rapitenca 31 32 43 30
18 Castelldefels Castelldefel 31 27 42 27
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CE Europa CE Europa 30 42 21 60
2 UE Sant Andreu Sant Andreu 30 50 31 56
3 CP San Cristóbal Cristóbal 30 36 21 52
4 L´Hospitalet L´Hospitale 30 53 33 51
5 CF Peralada CF Peralada 30 41 33 49
6 Castelldefels Castelldefel 30 31 35 44
7 CF Pobla de Mafumet Pobla 30 40 35 43
8 Girona FC B Girona FC B 30 45 34 43
9 Montañesa Montañesa 30 38 38 40
10 FE Grama FE Grama 30 38 46 37
11 Tona Tona 30 36 51 33
12 Rapitenca Rapitenca 30 37 48 32
13 Badalona Badalona 30 32 35 31
14 FC Vilafranca Vilafranca 30 38 55 30
15 UE Vilassar de Mar Vilassar 30 33 47 28
16 UE Sants UE Sants 30 29 56 24
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CE Manresa CE Manresa 32 43 21 64
2 Olot Olot 32 53 32 61
3 CP San Cristóbal Cristóbal 32 43 25 59
4 Girona FC B Girona FC B 32 38 25 58
5 UE Sant Andreu Sant Andreu 32 47 33 53
6 L´Hospitalet L´Hospitale 32 43 37 49
7 CF Pobla de Mafumet Pobla 32 35 26 44
8 UE Vilassar de Mar Vilassar 32 29 24 44
9 FE Grama FE Grama 32 35 31 43
10 CF Peralada CF Peralada 32 39 31 42
11 FC Vilafranca Vilafranca 32 25 33 41
12 Castelldefels Castelldefel 32 33 39 40
13 UE Sants UE Sants 32 32 41 34
14 EC Granollers Granollers 32 32 48 34
15 UE Figueres UE Figueres 32 29 37 32
16 Ascó Ascó 32 23 60 25
17 Guineueta Guineueta 32 23 59 21
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CE Europa CE Europa 20 35 17 44
2 FC Vilafranca Vilafranca 20 33 16 40
3 Terrassa FC Terrassa FC 20 23 11 35
4 CP San Cristóbal Cristóbal 20 17 13 31
5 CE Manresa CE Manresa 20 21 16 29
6 Castelldefels Castelldefel 20 19 20 28
7 CF Pobla de Mafumet Pobla 20 27 25 26
8 Santfeliuenc FC Santfeliuenc 20 16 24 22
9 UE Valls UE Valls 20 12 24 17
10 Igualada Igualada 20 14 32 13
11 Montañesa Montañesa 20 10 29 12
12 Cerdanyola FC Cerdanyola 20 31 15 40
13 Girona FC B Girona FC B 20 29 12 37
14 EC Granollers Granollers 20 32 22 33
15 UE Sant Andreu Sant Andreu 20 24 21 31
16 UE Vilassar de Mar Vilassar 20 21 21 30
17 FE Grama FE Grama 20 22 28 27
18 CF Peralada CF Peralada 20 16 18 25
19 UE Sants UE Sants 20 17 25 24
20 UE Figueres UE Figueres 20 19 32 21
21 UA Horta UA Horta 20 20 26 18
22 Banyoles Banyoles 20 13 24 15
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 27 59 28 59
2 Terrassa FC Terrassa FC 27 42 19 53
3 CE Europa CE Europa 27 59 31 50
4 UE Sant Andreu Sant Andreu 27 45 28 50
5 CF Peralada CF Peralada 27 38 26 46
6 CF Pobla de Mafumet Pobla 27 37 26 45
7 FC Vilafranca Vilafranca 27 38 27 44
8 UE Vilassar de Mar Vilassar 27 44 34 44
9 EC Granollers Granollers 27 50 34 43
10 CE Manresa CE Manresa 27 37 28 39
11 Castelldefels Castelldefel 27 37 37 38
12 UA Horta UA Horta 27 39 48 36
13 Cerdanyola FC Cerdanyola 27 37 38 35
14 UE Figueres UE Figueres 27 43 48 31
15 CP San Cristóbal Cristóbal 27 31 38 31
16 Santfeliuenc FC Santfeliuenc 27 31 44 29
17 Banyoles Banyoles 27 22 35 28
18 Igualada Igualada 27 28 46 25
19 UE Sants UE Sants 27 29 50 22
20 Reus Deportiu Reus 27 0 81 0
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CF Badalona Futur Badalona 40 75 31 83
2 L´Hospitalet L´Hospitale 40 71 31 80
3 UA Horta UA Horta 40 57 32 79
4 AE Prat AE Prat 40 51 22 75
5 UE Sant Andreu Sant Andreu 40 65 34 71
6 CE Europa CE Europa 40 53 41 63
7 Reus Deportiu B Reus 40 58 41 63
8 Terrassa FC Terrassa FC 40 52 45 63
9 FC Vilafranca Vilafranca 40 53 42 62
10 EC Granollers Granollers 40 54 42 61
11 Cerdanyola FC Cerdanyola 40 40 46 50
12 UE Figueres UE Figueres 40 36 46 49
13 Santfeliuenc FC Santfeliuenc 40 56 58 49
14 CF Pobla de Mafumet Pobla 40 44 46 48
15 CP San Cristóbal Cristóbal 40 52 70 48
16 Castelldefels Castelldefel 40 39 56 43
17 UE Sants UE Sants 40 37 56 43
18 FE Grama FE Grama 40 30 57 33
19 Santboià Santboià 40 24 66 31
20 Ascó Ascó 40 31 65 30
21 Martinenc Martinenc 40 34 85 26
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Espanyol B Espanyol B 38 74 25 90
2 UE Sant Andreu Sant Andreu 38 61 24 71
3 L´Hospitalet L´Hospitale 38 61 31 71
4 Terrassa FC Terrassa FC 38 60 38 64
5 AE Prat AE Prat 38 57 35 63
6 CF Pobla de Mafumet Pobla 38 40 25 63
7 Ascó Ascó 38 47 41 60
8 CE Europa CE Europa 38 48 46 58
9 FC Vilafranca Vilafranca 38 48 42 54
10 UE Figueres UE Figueres 38 47 43 53
11 UA Horta UA Horta 38 47 52 50
12 Cerdanyola FC Cerdanyola 38 35 43 48
13 Santboià Santboià 38 35 37 48
14 Reus Deportiu B Reus 38 40 50 47
15 Santfeliuenc FC Santfeliuenc 38 43 42 46
16 Castelldefels Castelldefel 38 40 46 44
17 EC Granollers Granollers 38 32 54 38
18 Palamós Palamós 38 38 64 31
19 CF Gavá CF Gavá 38 28 87 21
20 UE Vilassar de Mar Vilassar 38 24 80 18
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Olot Olot 38 73 38 80
2 CF Peralada CF Peralada 38 68 27 77
3 Terrassa FC Terrassa FC 38 48 26 66
4 FC Vilafranca Vilafranca 38 60 37 64
5 UE Sant Andreu Sant Andreu 38 51 40 60
6 Ascó Ascó 38 44 37 57
7 CF Pobla de Mafumet Pobla 38 43 36 55
8 EC Granollers Granollers 38 47 54 50
9 UE Figueres UE Figueres 38 39 41 50
10 UE Vilassar de Mar Vilassar 38 40 44 50
11 Palamós Palamós 38 49 55 49
12 CE Europa CE Europa 38 28 32 47
13 Santfeliuenc FC Santfeliuenc 38 39 44 45
14 Cerdanyola FC Cerdanyola 38 43 51 45
15 Castelldefels Castelldefel 38 34 51 42
16 La Jonquera UE Jonquera 38 19 29 42
17 Montañesa Montañesa 38 32 48 42
18 Manlleu Manlleu 38 41 59 40
19 Júpiter Júpiter 38 32 52 35
20 Sabadell B Sabadell B 38 34 63 31
TEMPORADA 2015/2016
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Castelldefels Castelldefel 34 84 37 70
2 Santboià Santboià 34 77 26 70
3 Balaguer Balaguer 34 60 34 66
4 Vilanova Geltru CF Vilanova 34 69 41 64
5 Igualada Igualada 34 69 41 60
6 Lleida Esportiu B Lleida 34 60 41 56
7 Vista Alegre Vista Alegre 34 66 51 56
8 Suburense Suburense 34 64 51 55
9 Sant Ildefons Sant 34 68 48 50
10 Vilaseca Vilaseca 34 47 35 49
11 Jesus y Maria Jesus Maria 34 55 44 48
12 Rapitenca Rapitenca 34 59 53 47
13 Viladecans Viladecans 34 50 65 42
14 Terrassa FC 1906 Terrassa 34 30 52 36
15 Reus FC Reddis Reus Reddis 34 35 67 31
16 Amposta Amposta 34 49 77 27
17 Torredembarra Torredembarr 34 36 78 19
18 El Catllar El Catllar 34 19 156 3
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Ascó Ascó 38 61 34 72
2 CF Pobla de Mafumet Pobla 38 54 30 69
3 CE Europa CE Europa 38 53 32 68
4 UE Figueres UE Figueres 38 46 44 59
5 FC Vilafranca Vilafranca 38 57 56 59
6 AE Prat AE Prat 38 49 34 59
7 Terrassa FC Terrassa FC 38 56 42 59
8 Rubí Rubí 38 47 40 54
9 Masnou Masnou 38 40 48 51
10 Cerdanyola FC Cerdanyola 38 44 49 49
11 Palamós Palamós 38 52 53 49
12 CF Peralada CF Peralada 38 41 50 49
13 Montañesa Montañesa 38 41 40 48
14 CF Gavá CF Gavá 38 42 54 48
15 Sabadell B Sabadell B 38 46 49 47
16 Santfeliuenc FC Santfeliuenc 38 41 48 47
17 Manlleu Manlleu 38 51 54 45
18 Castelldefels Castelldefel 38 39 47 41
19 Martinenc Martinenc 38 49 70 37
20 UE Vilassar de Mar Vilassar 38 28 63 28
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 UE Cornellà Cornellà 38 58 40 73
2 Montañesa Montañesa 38 61 31 73
3 CE Europa CE Europa 38 52 29 69
4 Terrassa FC Terrassa FC 38 55 35 69
5 Rubí Rubí 38 58 37 69
6 Ascó Ascó 38 53 40 68
7 Palamós Palamós 38 62 53 61
8 CF Pobla de Mafumet Pobla 38 45 37 57
9 Santfeliuenc FC Santfeliuenc 38 46 41 57
10 Manlleu Manlleu 38 39 39 50
11 UE Figueres UE Figueres 38 51 52 47
12 Cerdanyola FC Cerdanyola 38 52 58 46
13 FC Vilafranca Vilafranca 38 41 50 44
14 Masnou Masnou 38 36 46 44
15 CF Gavá CF Gavá 38 43 52 42
16 Castelldefels Castelldefel 38 47 50 42
17 UE Vilassar de Mar Vilassar 38 35 49 42
18 Santboià Santboià 38 47 54 40
19 Rapitenca Rapitenca 38 31 67 31
20 UDA Gramanet Gramanet 38 25 77 18
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 UE Cornellà Cornellà 36 67 30 76
2 Olot Olot 36 62 28 73
3 CE Europa CE Europa 36 51 25 69
4 Manlleu Manlleu 36 43 27 61
5 UE Figueres UE Figueres 36 49 42 56
6 CF Pobla de Mafumet Pobla 36 48 48 51
7 Rapitenca Rapitenca 36 46 39 50
8 UDA Gramanet Gramanet 36 32 30 48
9 Palamós Palamós 36 46 51 45
10 Castelldefels Castelldefel 36 31 39 45
11 Rubí Rubí 36 56 50 44
12 CF Gavá CF Gavá 36 36 41 44
13 UE Vilassar de Mar Vilassar 36 42 43 43
14 Santboià Santboià 36 40 46 39
15 FC Vilafranca Vilafranca 36 34 52 39
16 Montañesa Montañesa 36 32 49 38
17 Júpiter Júpiter 36 39 54 37
18 UE Vic UE Vic 36 38 58 35
19 Balaguer Balaguer 36 33 73 23
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 AE Prat AE Prat 38 57 27 75
2 Espanyol B Espanyol B 38 68 30 70
3 Manlleu Manlleu 38 72 48 65
4 CF Pobla de Mafumet Pobla 38 52 27 64
5 UE Cornellà Cornellà 38 52 34 62
6 Santboià Santboià 38 47 42 58
7 Terrassa FC Terrassa FC 38 57 55 58
8 FC Vilafranca Vilafranca 38 50 59 54
9 CF Gavá CF Gavá 38 49 50 53
10 Olot Olot 38 53 54 51
11 Rubí Rubí 38 60 54 50
12 Balaguer Balaguer 38 36 52 49
13 Castelldefels Castelldefel 38 43 47 49
14 UE Vic UE Vic 38 44 49 47
15 Montañesa Montañesa 38 42 54 47
16 CE Europa CE Europa 38 37 46 44
17 UDA Gramanet Gramanet 38 45 52 43
18 Vilanova Geltru CF Vilanova 38 42 52 42
19 Amposta Amposta 38 47 84 29
20 Masnou Masnou 38 31 68 24
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CF Badalona Futur Badalona 38 65 36 73
2 Montañesa Montañesa 38 40 33 67
3 CF Pobla de Mafumet Pobla 38 60 36 67
4 Reus Deportiu Reus 38 52 26 65
5 Espanyol B Espanyol B 38 65 38 64
6 Manlleu Manlleu 38 58 40 61
7 CE Europa CE Europa 38 54 42 58
8 UE Cornellà Cornellà 38 58 44 55
9 AE Prat AE Prat 38 49 42 53
10 CF Gavá CF Gavá 38 42 45 52
11 FC Vilafranca Vilafranca 38 48 55 49
12 Terrassa FC Terrassa FC 38 58 53 47
13 Castelldefels Castelldefel 38 37 45 47
14 Amposta Amposta 38 45 65 45
15 Balaguer Balaguer 38 42 60 43
16 Masnou Masnou 38 51 60 41
17 Vilanova Geltru CF Vilanova 38 42 51 41
18 Palamós Palamós 38 35 45 41
19 Ascó Ascó 38 29 72 29
20 Premià Premià 38 24 66 27
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 38 75 16 86
2 Reus Deportiu Reus 38 69 23 83
3 Santboià Santboià 38 68 46 70
4 AE Prat AE Prat 38 60 33 67
5 UE Cornellà Cornellà 38 43 41 61
6 Manlleu Manlleu 38 53 39 60
7 CF Badalona Futur Badalona 38 58 42 56
8 CE Europa CE Europa 38 56 51 54
9 Balaguer Balaguer 38 55 48 52
10 Amposta Amposta 38 56 59 50
11 Castelldefels Castelldefel 38 52 60 48
12 CF Pobla de Mafumet Pobla 38 46 52 47
13 Vilanova Geltru CF Vilanova 38 50 54 46
14 Palamós Palamós 38 42 55 46
15 Ascó Ascó 38 48 69 43
16 Cassà Cassà 38 48 61 42
17 Premià Premià 38 35 53 36
18 Rapitenca Rapitenca 38 46 71 34
19 Blanes Blanes 38 43 85 27
20 Olesa Montserrat Olesa 38 30 75 26
TEMPORADA 2008/2009
PRIMERA CATALANA
Equipo PJ GF GC Puntos
1 Ascó Ascó 38 72 36 74
2 Castelldefels Castelldefel 38 59 40 70
3 CF Badalona Futur Badalona 38 62 40 68
4 Marianao Poblet Marianao 38 62 39 66
5 Masnou Masnou 38 64 46 66
6 Olesa Montserrat Olesa 38 61 49 66
7 Montañesa Montañesa 38 68 62 58
8 UE Vilassar de Mar Vilassar 38 48 46 55
9 Tàrrega Tàrrega 38 56 54 54
10 Tortosa Tortosa 38 54 45 53
11 Montcada Montcada 38 49 52 53
12 Unió Esportiva Poble Sec Unió 38 45 56 47
13 CF Peralada CF Peralada 38 51 61 46
14 CP San Cristóbal Cristóbal 38 45 56 46
15 Guíxols Guíxols 38 39 47 42
16 Igualada Igualada 38 54 67 42
17 FC Vilafranca Vilafranca 38 40 48 41
18 CE Manresa CE Manresa 38 45 71 39
19 Morell Morell 38 42 65 33
20 Martorell Martorell 38 34 70 27
TEMPORADA 2007/2008
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Girona Girona 38 61 28 72
2 Alicante Alicante 38 52 21 64
3 CF Gavá CF Gavá 38 46 33 63
4 Benidorm Benidorm 38 43 39 59
5 Orihuela CF Orihuela CF 38 51 32 56
6 Ontinyent CF Ontinyent 38 46 46 56
7 UD Ibiza UD Ibiza 38 43 42 53
8 UDA Gramanet Gramanet 38 43 46 52
9 Alcoyano Alcoyano 38 38 31 51
10 Badalona Badalona 38 38 40 50
11 Villarreal B Villarreal 38 37 39 49
12 Dénia Dénia 38 33 36 48
13 Lleida Lleida 38 38 44 48
14 CE Sabadell CE Sabadell 38 39 47 48
15 Terrassa FC Terrassa FC 38 44 46 46
16 Villajoyosa Villajoyosa 38 31 37 45
17 Castelldefels Castelldefel 38 42 54 44
18 Espanyol B Espanyol B 38 45 59 39
19 L´Hospitalet L´Hospitale 38 21 47 35
20 At. Levante At. Levante 38 33 57 24
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Reus Deportiu Reus 38 62 12 82
2 Girona Girona 38 64 34 80
3 CE Sabadell CE Sabadell 38 78 35 80
4 CF Gavá CF Gavá 38 69 41 72
5 Vilanova Geltru CF Vilanova 38 64 49 64
6 Mataró Mataró 38 54 46 62
7 Santboià Santboià 38 45 48 55
8 Balaguer Balaguer 38 55 59 51
9 Palamós Palamós 38 41 41 51
10 CE Manresa CE Manresa 38 32 50 46
11 Rapitenca Rapitenca 38 50 44 45
12 Castelldefels Castelldefel 38 44 59 45
13 Barcelona C Barcelona C 38 45 52 45
14 CE Europa CE Europa 38 51 48 44
15 Blanes Blanes 38 50 57 43
16 Premià Premià 38 40 58 43
17 Masnou Masnou 38 47 66 40
18 AE Prat AE Prat 38 42 62 40
19 CF Peralada CF Peralada 38 43 69 33
20 Palafrugell Palafrugell 38 29 75 26
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Girona Girona 38 86 40 84
2 Espanyol B Espanyol B 38 84 32 82
3 CF Gavá CF Gavá 38 72 44 67
4 Vilanova Geltru CF Vilanova 38 61 43 66
5 CE Manresa CE Manresa 38 45 37 59
6 Santboià Santboià 38 47 45 58
7 Rapitenca Rapitenca 38 44 44 55
8 CF Peralada CF Peralada 38 54 58 55
9 Balaguer Balaguer 38 49 46 54
10 Castelldefels Castelldefel 38 42 37 52
11 Mataró Mataró 38 52 53 52
12 AE Prat AE Prat 38 50 47 51
13 CE Europa CE Europa 38 38 49 50
14 Barcelona C Barcelona C 38 40 50 43
15 Palafrugell Palafrugell 38 39 59 41
16 Palamós Palamós 38 34 63 40
17 UE Cornellà Cornellà 38 39 63 38
18 F.E. Figueres F.E. 38 40 56 36
19 Rubí Rubí 38 38 57 33
20 EC Granollers Granollers 38 37 68 31
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 38 86 36 80
2 Mataró Mataró 38 70 31 72
3 UE Sant Andreu Sant Andreu 38 58 34 72
4 Reus Deportiu Reus 38 60 39 65
5 CF Peralada CF Peralada 38 57 43 64
6 Santboià Santboià 38 47 39 63
7 Balaguer Balaguer 38 53 45 61
8 EC Granollers Granollers 38 45 39 60
9 CF Gavá CF Gavá 38 44 48 54
10 F.E. Figueres F.E. 38 36 39 53
11 Castelldefels Castelldefel 38 52 54 51
12 Barcelona C Barcelona C 38 45 54 46
13 Palamós Palamós 38 33 46 46
14 Rubí Rubí 38 45 61 46
15 Vilanova Geltru CF Vilanova 38 45 39 45
16 UE Cornellà Cornellà 38 37 55 41
17 CE Manresa CE Manresa 38 43 68 36
18 UE Vilassar de Mar Vilassar 38 50 74 34
19 Banyoles Banyoles 38 32 63 29
20 Tàrrega Tàrrega 38 31 62 24

  USO DE MEMORIA  
8,340,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6851
Total Execution Time  0.6863
  CADENA URL  
/historico/Ue-Castelldefels
  GET DATOS  
$_GET['/historico/Ue-Castelldefels']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0137  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 = 'Ue-Castelldefels' 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=2575 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=2575 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=2575 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=2575 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=2575 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73224
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2575 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2575 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (93103,240479,246824,290539,527541) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '2575' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '2575' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0125  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73224 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72264 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=2575 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73224,72554,72264,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72264 AND teamId = 2575
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73224 AND teamId = 2575
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72554 AND teamId = 2575
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2575
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72264 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138  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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 2575 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.0138  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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 2575 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 2575 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 2575 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67979 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.0132  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 = 62389 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 `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 = 58583 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.0132  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 = 50273 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 44393 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 39029 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 33355 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 16584 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 3915 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 2555 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 1945 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 1402 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 836 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 290 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 `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 = 6 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 `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 = 90 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 `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 = 22117 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 22098 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC