4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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 30 37 25 54
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 CF Peralada CF Peralada 31 31 29 41
9 Reus FC Reddis Reus Reddis 31 28 26 41
10 CFJ Mollerussa Mollerussa 31 28 40 41
11 FE Grama FE Grama 30 35 40 40
12 Montañesa Montañesa 30 28 30 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 30 27 41 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
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
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
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Barça Atlètic Barça 38 83 29 82
2 Alcoyano Alcoyano 38 56 32 67
3 Valencia Mestalla Valencia 38 59 45 65
4 Atlético Baleares Atlético 38 47 33 61
5 Badalona Badalona 38 48 34 60
6 Villarreal B Villarreal 38 57 40 60
7 Hércules Hércules 38 50 40 57
8 Lleida Esportiu Lleida 38 41 41 56
9 UE Cornellà Cornellà 38 44 46 52
10 CF Gavá CF Gavá 38 48 50 50
11 At. Saguntino Saguntino 38 42 40 49
12 CD Ebro CD Ebro 38 33 38 49
13 Mallorca B Mallorca B 38 34 35 48
14 CF Badalona Futur Badalona 38 40 47 47
15 CE Sabadell CE Sabadell 38 37 39 46
16 At. Levante At. Levante 38 33 34 42
17 L´Hospitalet L´Hospitale 38 33 58 38
18 Espanyol B Espanyol B 38 37 50 36
19 AE Prat AE Prat 38 27 43 35
20 Eldense Eldense 38 23 98 15
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Reus Deportiu Reus 38 52 31 73
2 Villarreal B Villarreal 38 62 32 71
3 Hércules Hércules 38 51 28 71
4 Lleida Esportiu Lleida 38 49 22 67
5 UE Cornellà Cornellà 38 46 36 63
6 Alcoyano Alcoyano 38 47 34 61
7 CE Sabadell CE Sabadell 38 49 40 55
8 Valencia Mestalla Valencia 38 45 39 53
9 Atlético Baleares Atlético 38 48 47 53
10 Eldense Eldense 38 48 63 51
11 Barça Atlètic Barça 38 40 40 51
12 Espanyol B Espanyol B 38 50 45 48
13 Badalona Badalona 38 32 39 46
14 At. Levante At. Levante 38 38 48 45
15 L´Hospitalet L´Hospitale 38 31 49 43
16 Olimpic Xátiva Olimpic 38 29 46 42
17 CF Pobla de Mafumet Pobla 38 34 47 38
18 Olot Olot 38 37 53 37
19 Llosetense Llosetense 38 26 54 35
20 Huracán Valencia Huracán 38 17 38 0
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Gimnàstic Tarragona Gimnàstic 38 51 30 73
2 Huracán Valencia Huracán 38 46 30 65
3 Reus Deportiu Reus 38 44 33 63
4 Hércules Hércules 38 41 29 63
5 Lleida Esportiu Lleida 38 45 34 61
6 Alcoyano Alcoyano 38 37 40 59
7 Badalona Badalona 38 37 37 56
8 Olimpic Xátiva Olimpic 38 38 37 55
9 L´Hospitalet L´Hospitale 38 41 36 54
10 Villarreal B Villarreal 38 51 45 53
11 Espanyol B Espanyol B 38 50 42 53
12 Atlético Baleares Atlético 38 48 45 49
13 Olot Olot 38 37 38 48
14 Valencia Mestalla Valencia 38 43 41 48
15 UE Cornellà Cornellà 38 41 50 45
16 Eldense Eldense 38 45 49 45
17 Mallorca B Mallorca B 38 40 58 44
18 UE Sant Andreu Sant Andreu 38 37 48 39
19 Ilicitano Ilicitano 38 38 60 35
20 Deportivo Aragón Deportivo 38 39 67 34
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 CF Badalona Futur Badalona 38 61 36 69
2 Lleida Esportiu Lleida 38 52 35 68
3 Gimnàstic Tarragona Gimnàstic 38 52 34 68
4 L´Hospitalet L´Hospitale 38 58 32 66
5 Ilicitano Ilicitano 38 60 41 64
6 Alcoyano Alcoyano 38 52 34 64
7 Atlético Baleares Atlético 38 50 36 64
8 Espanyol B Espanyol B 38 43 45 54
9 Huracán Valencia Huracán 38 40 38 52
10 Olimpic Xátiva Olimpic 38 37 35 52
11 Villarreal B Villarreal 38 45 42 51
12 Reus Deportiu Reus 38 38 49 51
13 Badalona Badalona 38 38 39 46
14 Olot Olot 38 47 60 45
15 UE Sant Andreu Sant Andreu 38 33 44 44
16 Valencia Mestalla Valencia 38 39 50 41
17 AE Prat AE Prat 38 31 45 38
18 At. Levante At. Levante 38 42 59 36
19 Constància Constància 38 23 52 34
20 Ontinyent CF Ontinyent 38 34 69 27
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 40 66 28 80
2 Huracán Valencia Huracán 40 52 24 80
3 At. Levante At. Levante 40 60 46 72
4 Alcoyano Alcoyano 40 56 33 72
5 Olimpic Xátiva Olimpic 40 41 25 71
6 Gimnàstic Tarragona Gimnàstic 40 53 35 60
7 UE Sant Andreu Sant Andreu 40 39 37 58
8 Espanyol B Espanyol B 40 44 42 55
9 Villarreal B Villarreal 40 59 57 54
10 CF Badalona Futur Badalona 40 45 44 50
11 Atlético Baleares Atlético 40 40 40 48
12 AE Prat AE Prat 40 36 35 48
13 Badalona Badalona 40 36 41 48
14 Reus Deportiu Reus 40 46 56 46
15 Ontinyent CF Ontinyent 40 34 46 46
16 Valencia Mestalla Valencia 40 41 55 45
17 Constància Constància 40 29 39 44
18 Mallorca B Mallorca B 40 34 53 44
19 Orihuela CF Orihuela CF 40 29 44 39
20 Yeclano Deportivo Yeclano 40 39 60 35
21 Binissalem Binissalem 40 22 61 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 38 65 39 72
2 Orihuela CF Orihuela CF 38 50 33 68
3 Huracán Valencia Huracán 38 48 30 66
4 Badalona Badalona 38 48 26 65
5 CF Badalona Futur Badalona 38 44 28 64
6 L´Hospitalet L´Hospitale 38 46 34 62
7 Lleida Esportiu Lleida 38 50 40 59
8 Reus Deportiu Reus 38 43 37 57
9 Olimpic Xátiva Olimpic 38 41 28 57
10 UE Sant Andreu Sant Andreu 38 47 44 53
11 CD Teruel CD Teruel 38 45 43 52
12 Mallorca B Mallorca B 38 49 47 51
13 Valencia Mestalla Valencia 38 52 54 50
14 Ontinyent CF Ontinyent 38 39 44 49
15 Dénia Dénia 38 39 38 47
16 Deportivo Aragón Deportivo 38 46 60 44
17 Andorra Andorra 38 40 55 40
18 CF Gandia CF Gandia 38 34 49 37
19 Manacor Manacor 38 39 74 24
20 Sp. Mahonès Mahonès 38 13 75 16
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 CE Sabadell CE Sabadell 38 42 24 69
2 Badalona Badalona 38 40 26 65
3 Alcoyano Alcoyano 38 46 32 63
4 Orihuela CF Orihuela CF 38 41 30 63
5 Lleida Lleida 38 46 30 60
6 L´Hospitalet L´Hospitale 38 58 34 60
7 UE Sant Andreu Sant Andreu 38 37 29 55
8 Dénia Dénia 38 34 38 55
9 Alicante Alicante 38 40 32 53
10 CD Castellón Castellón 38 39 42 53
11 Ontinyent CF Ontinyent 38 35 32 51
12 CD Teruel CD Teruel 38 37 32 50
13 Atlético Baleares Atlético 38 43 38 49
14 CF Gandia CF Gandia 38 36 45 49
15 Sp. Mahonès Mahonès 38 35 54 45
16 Benidorm Benidorm 38 32 45 42
17 UD Alzira UD Alzira 38 34 40 40
18 UDA Gramanet Gramanet 38 37 67 36
19 Mallorca B Mallorca B 38 36 48 34
20 Santboià Santboià 38 35 65 28
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
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Espanyol B Espanyol B 38 84 26 83
2 Reus Deportiu Reus 38 76 37 79
3 L´Hospitalet L´Hospitale 38 63 28 76
4 Santboià Santboià 38 58 39 66
5 Manlleu Manlleu 38 61 41 64
6 Premià Premià 38 70 53 64
7 Vilanova Geltru CF Vilanova 38 64 49 55
8 AE Prat AE Prat 38 46 45 55
9 CF Pobla de Mafumet Pobla 38 55 62 52
10 Amposta Amposta 38 62 66 49
11 CE Europa CE Europa 38 52 55 48
12 UE Cornellà Cornellà 38 47 59 48
13 Cassà Cassà 38 47 52 46
14 Rapitenca Rapitenca 38 44 55 43
15 Blanes Blanes 38 58 73 42
16 Balaguer Balaguer 38 49 58 39
17 Palamós Palamós 38 45 69 38
18 Mataró Mataró 38 44 68 36
19 Miapuesta Miapuesta 38 42 80 31
20 Banyoles Banyoles 38 30 82 18
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
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Alicante Alicante 38 51 36 65
2 Huesca Huesca 38 44 33 62
3 Alcoyano Alcoyano 38 45 34 62
4 L´Hospitalet L´Hospitale 38 43 36 61
5 Badalona Badalona 38 47 28 60
6 Terrassa FC Terrassa FC 38 46 34 59
7 Orihuela CF Orihuela CF 38 46 33 56
8 Villajoyosa Villajoyosa 38 39 40 54
9 Benidorm Benidorm 38 51 53 52
10 At. Levante At. Levante 38 33 35 52
11 UDA Gramanet Gramanet 38 39 41 52
12 UE Figueres UE Figueres 38 37 43 49
13 Espanyol B Espanyol B 38 45 47 49
14 Lleida Lleida 38 44 38 49
15 Osasuna Promesas Osasuna 38 34 43 45
16 Valencia Mestalla Valencia 38 32 46 45
17 UE Sant Andreu Sant Andreu 38 35 43 45
18 Eldense Eldense 38 32 44 42
19 Barça Atlètic Barça 38 33 47 37
20 Barbastro Barbastro 38 31 53 33
TEMPORADA 2005/2006
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Badalona Badalona 38 52 45 67
2 At. Levante At. Levante 38 43 26 66
3 Alicante Alicante 38 60 34 66
4 UDA Gramanet Gramanet 38 51 34 66
5 Alcoyano Alcoyano 38 43 29 64
6 Barça Atlètic Barça 38 60 41 63
7 Benidorm Benidorm 38 59 40 61
8 Villajoyosa Villajoyosa 38 49 40 58
9 Osasuna Promesas Osasuna 38 44 39 57
10 Terrassa FC Terrassa FC 38 48 43 56
11 UE Sant Andreu Sant Andreu 38 47 40 55
12 L´Hospitalet L´Hospitale 38 56 50 48
13 CD Alfaro CD Alfaro 38 26 38 44
14 UE Figueres UE Figueres 38 36 48 43
15 Logroñes CF Logroñes 38 24 39 42
16 Huesca Huesca 38 30 43 42
17 Reus Deportiu Reus 38 44 58 39
18 CE Sabadell CE Sabadell 38 39 54 37
19 Deportivo Aragón Deportivo 38 34 54 35
20 Azkoyen Azkoyen 38 27 77 24
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,578,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4319
Total Execution Time  0.4342
  CADENA URL  
/historico/Hospitalet
  GET DATOS  
$_GET['/historico/Hospitalet']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1606 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1606 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 (611,695,2832,11534,17593) ORDER BY n.cover_points DESC, update_date DESC
0.0144  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 = '1606' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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 = 1606 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.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 `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.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 `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.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 `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.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 `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 = 33380 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15377 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 3864 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 2468 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 1904 AND t.round = 42 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 = 1348 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 `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 = 1104 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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.0135  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 = 135 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 `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.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 `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 = 84 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 `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 = 170 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