4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Hércules Hércules 32 49 28 59
2 Lleida Esportiu Lleida 32 44 28 58
3 CE Europa CE Europa 32 56 32 57
4 CF Badalona Futur Badalona 32 38 23 56
5 UE Sant Andreu Sant Andreu 32 50 33 54
6 Terrassa FC Terrassa FC 32 42 38 46
7 Torrent Torrent 32 37 35 45
8 Andratx Andratx 32 39 43 43
9 Espanyol B Espanyol B 32 37 37 43
10 UD Alzira UD Alzira 32 37 41 42
11 Valencia Mestalla Valencia 32 48 39 42
12 Peña Deportiva Peña 32 44 56 41
13 At. Saguntino Saguntino 32 32 40 41
14 SD Formentera Formentera 32 35 42 38
15 Cerdanyola FC Cerdanyola 32 34 40 37
16 Penya Independent Penya 32 31 47 34
17 CE Manresa CE Manresa 32 22 39 26
18 CF La Nucía Nucía 32 22 56 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 5
Equipo PJ GF GC Puntos
1 CF Intercity Intercity 34 46 16 66
2 CF La Nucía Nucía 34 41 18 64
3 Real Murcia Real Murcia 34 42 27 58
4 Eldense Eldense 34 47 37 56
5 Hércules Hércules 34 41 31 56
6 Racing Cartagena Mar Menor Racing 34 34 29 55
7 UD Alzira UD Alzira 34 42 36 51
8 Recreativo Granada Recreativo 34 34 32 46
9 UD Melilla UD Melilla 34 36 39 45
10 Mancha Real Mancha Real 34 32 36 43
11 Pvo. El Ejido Pvo. Ejido 34 30 35 43
12 UD Yugo Socuéllamos Yugo 34 29 34 43
13 Águilas FC Águilas FC 34 32 36 41
14 At. Levante At. Levante 34 33 33 38
15 At. Pulpileño Pulpileño 34 23 48 34
16 CD Marchamalo Marchamalo 34 33 59 32
17 CS Puertollano Puertollano 34 38 50 29
18 CD Toledo CD Toledo 34 27 44 28
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 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 3
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 28 40 24 50
2 Barça Atlètic Barça 28 40 27 49
3 CE Sabadell CE Sabadell 28 38 25 49
4 UE Cornellà Cornellà 28 34 25 49
5 Lleida Esportiu Lleida 28 34 22 46
6 Villarreal B Villarreal 28 36 32 46
7 Olot Olot 28 34 19 44
8 Espanyol B Espanyol B 28 44 37 42
9 FC Andorra FC Andorra 28 31 28 41
10 CF La Nucía Nucía 28 30 29 39
11 CD Ebro CD Ebro 28 29 31 37
12 At. Levante At. Levante 28 29 34 35
13 CF Badalona Futur Badalona 28 28 33 33
14 Gimnàstic Tarragona Gimnàstic 28 33 38 31
15 Ejea Ejea 28 27 36 27
16 Valencia Mestalla Valencia 28 27 33 26
17 AE Prat AE Prat 28 25 40 26
18 Hércules Hércules 28 27 35 25
19 Badalona Badalona 28 17 34 24
20 Orihuela CF Orihuela CF 28 26 47 23
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 38 52 30 75
2 Hércules Hércules 38 36 24 67
3 Villarreal B Villarreal 38 54 39 62
4 UE Cornellà Cornellà 38 44 29 61
5 Espanyol B Espanyol B 38 55 38 60
6 Lleida Esportiu Lleida 38 46 39 56
7 Badalona Badalona 38 36 32 56
8 Barça Atlètic Barça 38 47 39 53
9 CD Ebro CD Ebro 38 30 34 52
10 Olot Olot 38 33 31 48
11 At. Levante At. Levante 38 41 43 45
12 CE Sabadell CE Sabadell 38 36 53 45
13 Valencia Mestalla Valencia 38 44 50 44
14 Ejea Ejea 38 30 36 44
15 CD Castellón Castellón 38 36 36 44
16 Alcoyano Alcoyano 38 33 45 43
17 CD Teruel CD Teruel 38 32 48 41
18 UB Conquense Conquense 38 31 44 39
19 CF Peralada CF Peralada 38 38 45 39
20 Ontinyent CF Ontinyent 38 23 42 0
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
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
Equipo PJ GF GC Puntos
1 Eibar Eibar 42 49 28 71
2 RC Deportivo Deportivo 42 48 36 69
3 Barça Atlètic Barça 42 60 47 66
4 Real Murcia Real Murcia 42 55 44 65
5 Real Sporting Real 42 63 51 64
6 Las Palmas Las Palmas 42 51 50 63
7 Córdoba CF Córdoba CF 42 46 43 61
8 Recreativo Recreativo 42 53 53 61
9 Alcorcón Alcorcón 42 46 40 59
10 CE Sabadell CE Sabadell 42 52 59 59
11 Tenerife Tenerife 42 46 49 54
12 CD Lugo CD Lugo 42 41 48 54
13 Numancia Numancia 42 42 41 54
14 Real Zaragoza Real 42 49 53 53
15 Girona Girona 42 52 50 51
16 Ponferradina Ponferradina 42 46 49 51
17 Mallorca Mallorca 42 46 57 51
18 Deportivo Alavés Deportivo 42 57 57 51
19 Mirandés Mirandés 42 39 56 50
20 RM Castilla RM Castilla 42 49 56 49
21 Real Jaén Real Jaén 42 43 49 48
22 Hércules Hércules 42 45 62 45
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Elche Elche 42 54 27 82
2 Villarreal Villarreal 42 68 38 77
3 Almería Almería 42 72 50 74
4 Girona Girona 42 74 56 71
5 Alcorcón Alcorcón 42 57 55 69
6 Las Palmas Las Palmas 42 62 55 66
7 Ponferradina Ponferradina 42 57 50 66
8 RM Castilla RM Castilla 42 80 62 59
9 Barça Atlètic Barça 42 76 71 57
10 Real Sporting Real 42 60 53 56
11 CD Lugo CD Lugo 42 46 54 56
12 Numancia Numancia 42 53 55 55
13 Recreativo Recreativo 42 46 57 54
14 Córdoba CF Córdoba CF 42 55 55 54
15 Mirandés Mirandés 42 35 51 52
16 CE Sabadell CE Sabadell 42 54 69 52
17 Hércules Hércules 42 43 53 50
18 CD Guadalajara Guadalajara 42 46 53 50
19 Real Murcia Real Murcia 42 43 56 47
20 Racing Racing 42 38 51 46
21 Huesca Huesca 42 46 58 45
22 Xerez CD Xerez CD 42 38 74 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 42 76 45 91
2 Celta Celta 42 83 37 85
3 Real Valladolid Real 42 69 37 82
4 Alcorcón Alcorcón 42 58 42 73
5 Hércules Hércules 42 62 43 72
6 Córdoba CF Córdoba CF 42 52 43 71
7 Almería Almería 42 63 43 70
8 Barça Atlètic Barça 42 63 53 59
9 Las Palmas Las Palmas 42 58 59 58
10 Numancia Numancia 42 54 52 57
11 Elche Elche 42 56 58 57
12 Villarreal B Villarreal 42 54 64 52
13 Huesca Huesca 42 49 63 51
14 Xerez CD Xerez CD 42 50 66 50
15 Girona Girona 42 58 61 49
16 CD Guadalajara Guadalajara 42 50 75 49
17 Recreativo Recreativo 42 49 52 47
18 Real Murcia Real Murcia 42 49 67 47
19 CE Sabadell CE Sabadell 42 45 64 46
20 FC Cartagena Cartagena 42 37 58 40
21 Alcoyano Alcoyano 42 46 78 37
22 Gimnàstic Tarragona Gimnàstic 42 37 58 31
TEMPORADA 2010/2011
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 38 95 21 96
2 Real Madrid Real Madrid 38 102 33 92
3 Valencia Valencia 38 64 44 71
4 Villarreal Villarreal 38 54 44 62
5 Sevilla Sevilla 38 62 61 58
6 Athletic Athletic 38 59 55 58
7 Atlético Atlético 38 62 53 58
8 Espanyol Espanyol 38 46 55 49
9 Osasuna Osasuna 38 45 46 47
10 Real Sporting Real 38 35 42 47
11 Málaga Málaga 38 54 68 46
12 Racing Racing 38 41 56 46
13 Real Zaragoza Real 38 40 53 45
14 Levante Levante 38 41 52 45
15 Real Sociedad Real 38 49 66 45
16 Getafe Getafe 38 49 60 44
17 Mallorca Mallorca 38 41 56 44
18 RC Deportivo Deportivo 38 31 47 43
19 Hércules Hércules 38 36 60 35
20 Almería Almería 38 36 70 30
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Sociedad Real 42 53 37 74
2 Hércules Hércules 42 61 34 71
3 Levante Levante 42 63 45 71
4 Real Betis Real Betis 42 61 38 71
5 FC Cartagena Cartagena 42 58 49 65
6 Elche Elche 42 67 57 63
7 Villarreal B Villarreal 42 60 56 61
8 Numancia Numancia 42 55 53 59
9 Recreativo Recreativo 42 40 42 57
10 Córdoba CF Córdoba CF 42 40 46 55
11 Rayo Vallecano Rayo 42 67 58 53
12 Celta Celta 42 38 44 52
13 Huesca Huesca 42 36 40 52
14 Girona Girona 42 45 59 52
15 Albacete Albacete 42 60 62 52
16 UD Salamanca Salamanca 42 44 54 52
17 Las Palmas Las Palmas 42 49 49 51
18 Gimnàstic Tarragona Gimnàstic 42 42 55 51
19 Cádiz Cádiz 42 49 64 50
20 Real Murcia Real Murcia 42 49 51 50
21 Real Unión Club Real Unión 42 40 59 46
22 CD Castellón Castellón 42 37 62 33
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 42 73 42 82
2 Real Zaragoza Real 42 79 42 81
3 Tenerife Tenerife 42 79 47 81
4 Hércules Hércules 42 82 43 78
5 Rayo Vallecano Rayo 42 55 39 70
6 Real Sociedad Real 42 48 38 67
7 CD Castellón Castellón 42 55 42 65
8 Levante Levante 42 59 59 64
9 UD Salamanca Salamanca 42 59 50 60
10 Gimnàstic Tarragona Gimnàstic 42 60 50 57
11 Huesca Huesca 42 47 46 53
12 Elche Elche 42 52 50 53
13 Córdoba CF Córdoba CF 42 47 54 53
14 Real Murcia Real Murcia 42 48 58 52
15 Albacete Albacete 42 42 54 51
16 Girona Girona 42 43 54 49
17 Celta Celta 42 46 56 48
18 Las Palmas Las Palmas 42 46 51 47
19 Deportivo Alavés Deportivo 42 42 64 43
20 Alicante Alicante 42 38 69 35
21 Eibar Eibar 42 31 63 35
22 Sevilla At. Sevilla At. 42 29 89 19
TEMPORADA 2007/2008
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Numancia Numancia 42 59 38 77
2 Málaga Málaga 42 58 42 72
3 Real Sporting Real 42 61 40 72
4 Real Sociedad Real 42 55 39 68
5 CD Castellón Castellón 42 42 37 61
6 Hércules Hércules 42 66 55 58
7 UD Salamanca Salamanca 42 52 44 57
8 Las Palmas Las Palmas 42 51 55 57
9 Sevilla At. Sevilla At. 42 43 48 56
10 Elche Elche 42 44 50 54
11 Tenerife Tenerife 42 51 57 53
12 Albacete Albacete 42 37 40 52
13 Eibar Eibar 42 42 51 52
14 Gimnàstic Tarragona Gimnàstic 42 49 51 52
15 Xerez CD Xerez CD 42 47 56 52
16 Celta Celta 42 56 55 52
17 Deportivo Alavés Deportivo 42 41 47 51
18 Córdoba CF Córdoba CF 42 50 56 50
19 Racing Ferrol Racing 42 46 51 50
20 Cádiz Cádiz 42 40 47 49
21 Granada 74 Granada 74 42 45 59 45
22 Poli Ejido Poli Ejido 42 37 54 44
TEMPORADA 2006/2007
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Valladolid Real 42 70 35 88
2 Almería Almería 42 73 49 80
3 Real Murcia Real Murcia 42 62 45 76
4 Ciudad de Murcia Ciudad 42 52 44 63
5 Cádiz Cádiz 42 53 45 61
6 Albacete Albacete 42 49 48 60
7 Tenerife Tenerife 42 48 51 60
8 Numancia Numancia 42 48 44 58
9 Xerez CD Xerez CD 42 47 42 58
10 Elche Elche 42 47 46 58
11 Poli Ejido Poli Ejido 42 52 50 58
12 UD Salamanca Salamanca 42 53 50 57
13 Real Sporting Real 42 53 53 56
14 CD Castellón Castellón 42 48 41 56
15 Málaga Málaga 42 49 50 55
16 Hércules Hércules 42 48 52 54
17 Deportivo Alavés Deportivo 42 51 60 52
18 Las Palmas Las Palmas 42 51 59 51
19 RM Castilla RM Castilla 42 55 67 49
20 Ponferradina Ponferradina 42 45 61 46
21 Lorca Deportiva Lorca 42 37 60 37
22 Vecindario Vecindario 42 42 81 34
TEMPORADA 2005/2006
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 42 67 32 78
2 Gimnàstic Tarragona Gimnàstic 42 48 38 76
3 Levante Levante 42 53 39 74
4 Ciudad de Murcia Ciudad 42 53 42 72
5 Lorca Deportiva Lorca 42 56 39 69
6 Almería Almería 42 54 43 67
7 Xerez CD Xerez CD 42 60 46 67
8 Numancia Numancia 42 50 55 63
9 Real Sporting Real 42 41 34 56
10 Real Valladolid Real 42 54 54 55
11 RM Castilla RM Castilla 42 55 50 55
12 CD Castellón Castellón 42 46 50 54
13 Albacete Albacete 42 44 57 54
14 Elche Elche 42 47 54 53
15 Poli Ejido Poli Ejido 42 43 50 53
16 Real Murcia Real Murcia 42 41 40 52
17 Hércules Hércules 42 39 49 52
18 Tenerife Tenerife 42 53 60 51
19 Lleida Lleida 42 43 53 46
20 Racing Ferrol Racing 42 44 63 37
21 At. Malagueño Malagueño 42 42 68 36
22 Eibar Eibar 42 28 45 35
TEMPORADA 2004/2005
SEGUNDA DIVISIÓN B GRUPO 3
Equipo PJ GF GC Puntos
1 Alicante Alicante 38 61 24 76
2 Hércules Hércules 38 45 36 65
3 At. Levante At. Levante 38 39 24 61
4 CD Castellón Castellón 38 34 24 61
5 Deportivo Aragón Deportivo 38 46 31 61
6 Villajoyosa Villajoyosa 38 47 42 58
7 Alcoyano Alcoyano 38 48 50 52
8 UE Figueres UE Figueres 38 39 40 51
9 Badalona Badalona 38 39 38 50
10 Huesca Huesca 38 36 40 49
11 Barça Atlètic Barça 38 42 39 49
12 Benidorm Benidorm 38 35 43 48
13 CE Sabadell CE Sabadell 38 43 49 46
14 Azkoyen Azkoyen 38 35 48 46
15 Osasuna Promesas Osasuna 38 31 47 45
16 UDA Gramanet Gramanet 38 30 34 45
17 Girona Girona 38 40 49 45
18 Espanyol B Espanyol B 38 56 47 45
19 Novelda CF Novelda CF 38 31 37 40
20 Peña Sport Peña Sport 38 17 52 28

  USO DE MEMORIA  
8,950,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4653
Total Execution Time  0.4665
  CADENA URL  
/historico/Hercules
  GET DATOS  
$_GET['/historico/Hercules']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0168  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 = '1311' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 72364 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161  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=1311 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (75879,72364,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.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 72364 AND teamId = 1311
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 75879 AND teamId = 1311
0.0250  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1311
0.0293  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 = 72364 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0168  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 = 1311 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.0164  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 = 1311 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162  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 = 1311 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 1311 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62384 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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.0154  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.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 812 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 105 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 81 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 534 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC