4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Coslada
TEMPORADA 2023/2024
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Cala Pozuelo Cala Pozuelo 30 48 30 62
2 Aravaca Aravaca 30 54 23 60
3 CF San Agustín Agustín 30 55 33 57
4 Moratalaz Moratalaz 30 39 22 52
5 Las Rozas B Las Rozas B 30 47 34 50
6 Unión Zona Norte Unión Zona 30 48 35 48
7 Vicálvaro Vicálvaro 30 50 37 47
8 Colmenar Viejo Colmenar 30 47 38 46
9 Robledo Robledo 30 47 59 41
10 CD San Fernando Fernando 30 52 48 40
11 Coslada Coslada 30 37 45 38
12 AD Torrejon CF B Torrejon 30 37 42 38
13 CD Moraleja Futbol Moraleja 30 33 45 34
14 EF Concepción A Concepción 30 39 46 33
15 San Sebastián Reyes B Sebastián 30 35 40 33
16 Sporting Hortaleza Sporting 30 49 61 29
17 Alameda de Osuna Alameda 30 32 64 21
18 Unión Valdebernardo Unión 30 26 73 14
TEMPORADA 2022/2023
1ª REGIONAL MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 Alameda de Osuna Alameda 34 74 32 76
2 CD San Fernando Fernando 34 78 33 69
3 Coslada Coslada 34 64 41 63
4 Juventud Sanse A Juventud 34 67 59 57
5 Henares DIV Henares DIV 34 75 54 53
6 CD Avance CD Avance 34 62 50 52
7 Santos de la Humosa Santos 34 59 63 50
8 Sporting Hortaleza Sporting 34 53 44 49
9 CD Canillas B Canillas 34 44 35 48
10 Racing Veracruz Racing 34 48 54 48
11 Daganzo Daganzo 34 51 40 46
12 CD San Roque EFF Roque 34 40 49 45
13 Alcobendas Alcobendas 34 35 45 45
14 AD Esperanza Esperanza 34 54 59 42
15 Paracuellos Antamira-Alcobe Paracuellos 34 55 54 40
16 Futbol de Torres Futbol 34 37 68 34
17 Camarma Camarma 34 42 86 25
18 San Agustin Guadalix B Agustin 34 27 99 12
TEMPORADA 2021/2022
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CD Canillas CD Canillas 34 50 33 58
2 CUC Villalba Villalba 34 56 41 57
3 San Sebastián Reyes B Sebastián 34 54 39 56
4 Villanueva del Pardillo Villanueva 34 63 41 55
5 EF Concepción A Concepción 34 48 33 55
6 Colmenar Viejo Colmenar 34 66 55 52
7 CF San Agustín Agustín 34 42 38 52
8 CD Moraleja Futbol Moraleja 34 47 41 49
9 Periso CF Periso CF 34 50 55 49
10 Aravaca Aravaca 34 55 50 48
11 Unión Zona Norte Unión Zona 34 53 48 46
12 Moratalaz B Moratalaz B 34 60 60 45
13 Alcobendas Alcobendas 34 40 52 44
14 Coslada Coslada 34 52 52 44
15 CD San Fernando Fernando 34 46 44 42
16 Sporting Hortaleza Sporting 34 36 54 38
17 DAV Santa Ana Santa 34 32 65 28
18 AD Fundación Fundación 34 39 88 17
TEMPORADA 2020/2021
PREFERENTE MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 CD Ursaria CD Ursaria 19 34 15 41
2 Villaviciosa Odón Villaviciosa 19 26 12 41
3 CD Colonia Moscardó Colonia 19 29 9 40
4 Fuenlabrada B Fuenlabrada 19 28 22 31
5 Ciudad de Getafe SC Ciudad 19 29 24 31
6 CD Mostoles URJC B Mostoles 19 27 22 31
7 Moratalaz B Moratalaz B 19 27 23 30
8 Coslada Coslada 19 26 19 29
9 Ciudad Los Angeles Ciudad 19 19 13 29
10 CD Lugo Fuenlabrada Lugo 19 21 18 28
11 CD Los Yébenes-San Bruno Yébenes-San 19 23 21 28
12 Arganda Arganda 19 21 21 25
13 Vicálvaro Vicálvaro 19 16 21 24
14 CD Fortuna CD Fortuna 19 20 27 23
15 Internacional de Móstoles Internaciona 19 22 28 21
16 Humanes Humanes 19 14 26 16
17 UD Ciempozuelos Ciempozuelos 19 18 28 15
18 Sitio de Aranjuez Sitio 19 18 32 15
19 Fepe Getafe III Fepe Getafe 19 14 30 12
20 EMF Villarejo Villarejo 19 16 37 11
TEMPORADA 2019/2020
PREFERENTE MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 Móstoles CF Móstoles 23 43 18 55
2 Real Aranjuez CF Real 23 33 24 42
3 CD Colonia Moscardó Colonia 23 29 19 41
4 CD Mostoles URJC B Mostoles 23 23 14 36
5 Vicálvaro Vicálvaro 23 36 28 35
6 CD Lugo Fuenlabrada Lugo 23 31 29 33
7 CD Fortuna CD Fortuna 23 26 24 33
8 Coslada Coslada 23 37 35 32
9 Ciudad Los Angeles Ciudad 23 22 20 32
10 EMF Villarejo Villarejo 23 28 31 30
11 CD Ursaria CD Ursaria 23 26 29 29
12 Internacional de Móstoles Internaciona 23 26 31 29
13 Arganda Arganda 23 31 37 29
14 Villaviciosa Odón Villaviciosa 23 25 25 26
15 Sitio de Aranjuez Sitio 23 29 34 26
16 UD Ciempozuelos Ciempozuelos 23 16 25 25
17 Fepe Getafe III Fepe Getafe 23 26 44 18
18 CD Los Yébenes-San Bruno Yébenes-San 23 21 41 14
TEMPORADA 2018/2019
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Moratalaz Moratalaz 34 51 27 68
2 AD Torrejón CF Torrejón 34 46 25 63
3 Galapagar Galapagar 34 53 32 61
4 EF Concepción A Concepción 34 45 30 59
5 Alcobendas Alcobendas 34 48 36 55
6 Villanueva del Pardillo Villanueva 34 54 42 54
7 CD Moraleja Futbol Moraleja 34 45 37 51
8 Aravaca Aravaca 34 54 54 51
9 Complutense Alcala Complutense 34 46 42 47
10 Coslada Coslada 34 43 43 44
11 Sporting Hortaleza Sporting 34 56 61 44
12 CD San Roque EFF Roque 34 36 47 42
13 Periso CF Periso CF 34 38 45 40
14 Torrelodones Torrelodones 34 41 45 38
15 Barrio Pilar Barrio Pilar 34 31 43 38
16 San Agustin Guadalix B Agustin 34 33 46 35
17 CUC Villalba Villalba 34 25 56 34
18 Colmenar Viejo Colmenar 34 19 53 14
TEMPORADA 2017/2018
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Las Rozas Las Rozas 34 72 29 79
2 CD Canillas CD Canillas 34 63 34 62
3 Villanueva del Pardillo Villanueva 34 51 29 60
4 Periso CF Periso CF 34 53 46 57
5 AD Torrejón CF Torrejón 34 53 45 57
6 Galapagar Galapagar 34 53 43 54
7 Aravaca Aravaca 34 44 36 54
8 CUC Villalba Villalba 34 41 38 46
9 Coslada Coslada 34 42 43 46
10 Torrelodones Torrelodones 34 39 48 45
11 CD San Roque EFF Roque 34 33 39 43
12 EF Concepción A Concepción 34 46 61 41
13 Complutense Alcala Complutense 34 45 49 41
14 Alcobendas Alcobendas 34 42 51 40
15 Dosa Dosa 34 55 59 38
16 San Sebastián Reyes B Sebastián 34 50 47 37
17 RSD Alcalá B Alcalá 34 32 71 29
18 Camarma Camarma 34 31 77 18
TEMPORADA 2016/2017
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Colmenar Viejo Colmenar 34 59 33 67
2 CF San Agustín Agustín 34 58 35 66
3 CDF Tres Cantos Tres Cantos 34 59 36 64
4 San Sebastián Reyes B Sebastián 34 55 37 63
5 Coslada Coslada 34 62 38 61
6 Moratalaz Moratalaz 34 68 55 55
7 CD Canillas CD Canillas 34 47 42 52
8 Las Rozas Las Rozas 34 54 51 46
9 Periso CF Periso CF 34 63 60 45
10 CUC Villalba Villalba 34 54 60 40
11 RSD Alcalá B Alcalá 34 46 56 40
12 Complutense Alcala Complutense 34 36 39 39
13 AD Torrejón CF Torrejón 34 37 41 39
14 CD San Roque EFF Roque 34 31 49 39
15 Rayo Ciudad Alcobendas Rayo Ciudad 34 40 51 35
16 Sporting Hortaleza Sporting 34 40 53 35
17 CD Avance CD Avance 34 47 68 34
18 Siete Picos Colmenar Siete Picos 34 25 77 13
TEMPORADA 2015/2016
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Villanueva del Pardillo Villanueva 34 61 31 72
2 DAV Santa Ana Santa 34 80 34 65
3 Alcobendas Alcobendas 34 57 30 63
4 Las Rozas Las Rozas 34 73 43 63
5 Periso CF Periso CF 34 59 43 61
6 Coslada Coslada 34 64 45 59
7 CDF Tres Cantos Tres Cantos 34 59 37 56
8 Complutense Alcala Complutense 34 50 50 47
9 Moratalaz Moratalaz 34 41 56 47
10 Sporting Hortaleza Sporting 34 66 70 45
11 CD Canillas CD Canillas 34 49 51 45
12 San Sebastián Reyes B Sebastián 34 45 46 43
13 Siete Picos Colmenar Siete Picos 34 55 60 42
14 AD Torrejón CF Torrejón 34 47 59 39
15 Galapagar Galapagar 34 45 62 35
16 AD Esperanza Esperanza 34 47 78 32
17 Colmenar Viejo Colmenar 34 31 83 23
18 Alameda de Osuna Alameda 34 36 87 17
TEMPORADA 2014/2015
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca Aravaca 34 60 36 64
2 CUC Villalba Villalba 34 50 38 59
3 Siete Picos Colmenar Siete Picos 34 63 48 58
4 Complutense Alcala Complutense 34 55 41 58
5 Las Rozas Las Rozas 34 59 43 57
6 Periso CF Periso CF 34 54 47 53
7 Coslada Coslada 34 53 52 52
8 CDF Tres Cantos Tres Cantos 34 56 50 51
9 Galapagar Galapagar 34 50 44 49
10 Alameda de Osuna Alameda 34 53 53 47
11 Moratalaz Moratalaz 34 51 47 45
12 CD Canillas CD Canillas 34 45 42 45
13 Vicálvaro Vicálvaro 34 39 42 43
14 San Sebastián Reyes B Sebastián 34 41 52 42
15 Dosa Dosa 34 37 57 35
16 CF Pozuelo B Pozuelo 34 43 60 31
17 RSD Alcalá B Alcalá 34 36 64 28
18 CD San Roque EFF Roque 34 39 68 27
TEMPORADA 2013/2014
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Alcobendas Alcobendas 34 38 25 62
2 Villanueva del Pardillo Villanueva 34 51 32 60
3 RSD Alcalá B Alcalá 34 66 41 58
4 CDF Tres Cantos Tres Cantos 34 48 44 55
5 CD San Roque EFF Roque 34 50 38 54
6 CD Canillas CD Canillas 34 38 33 53
7 Periso CF Periso CF 34 45 46 49
8 Dosa Dosa 34 53 47 48
9 Moratalaz Moratalaz 34 53 43 48
10 Las Rozas Las Rozas 34 42 42 47
11 San Sebastián Reyes B Sebastián 34 49 49 46
12 Coslada Coslada 34 49 58 46
13 CF Pozuelo B Pozuelo 34 49 54 44
14 Futbol de Torres Futbol 34 58 55 44
15 Unión Adarve B Unión 34 46 47 43
16 Atlético Velilla CF Atlético 34 43 50 42
17 DAV Santa Ana Santa 34 39 55 36
18 At. Leones Castilla Leones 34 16 74 10
TEMPORADA 2012/2013
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca Aravaca 34 66 28 80
2 AD Torrejón CF Torrejón 34 63 36 65
3 Las Rozas Cf Rozas 34 56 37 63
4 Alcobendas Alcobendas 34 58 34 61
5 Juventud Sanse B Juventud 34 50 45 54
6 CD Canillas CD Canillas 34 57 49 49
7 RSD Alcalá B Alcalá 34 44 39 47
8 Dosa Dosa 34 58 61 45
9 At. Leones Castilla Leones 34 37 48 45
10 Coslada Coslada 34 33 36 44
11 Unión Adarve B Unión 34 41 46 44
12 CF Pozuelo B Pozuelo 34 54 63 43
13 Moratalaz Moratalaz 34 42 46 42
14 Periso CF Periso CF 34 43 46 41
15 Torrelodones Cf Torrelodones 34 55 54 37
16 Ef Madrid Oeste Madrid Oeste 34 38 49 31
17 CD La Resaca Resaca 34 38 80 29
18 CF Gandarío-Sanse Gandarío-Sa 34 40 76 25
TEMPORADA 2011/2012
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CUC Villalba Villalba 34 69 25 74
2 DAV Santa Ana Santa 34 65 28 73
3 CD San Fernando Fernando 34 69 26 72
4 AD Torrejón CF Torrejón 34 64 31 69
5 Alcobendas Alcobendas 34 49 44 51
6 Aravaca Aravaca 34 48 45 49
7 Dosa Dosa 34 49 55 47
8 RSD Alcalá B Alcalá 34 42 49 45
9 Las Rozas Las Rozas 34 46 53 42
10 Torrelodones Torrelodones 34 32 40 40
11 Coslada Coslada 34 36 47 40
12 Periso CF Periso CF 34 46 57 39
13 CD La Resaca Resaca 34 39 63 38
14 CD Canillas CD Canillas 34 38 50 37
15 CDF Tres Cantos Tres Cantos 34 37 44 36
16 Villanueva del Pardillo Villanueva 34 33 47 32
17 Complutense Nadador Complutense 34 41 69 30
18 Cd Recuerdo Cd Recuerdo 34 30 60 29
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Paracuellos Antamira Paracuellos 38 71 33 75
2 CF Pozuelo CF Pozuelo 38 52 44 65
3 Villaviciosa Odón Villaviciosa 38 43 30 63
4 Internacional de Madrid Internaciona 38 44 32 63
5 UD Sanse UD Sanse 38 57 36 63
6 Real Madrid C Real Madrid 38 54 36 61
7 Fuenlabrada Fuenlabrada 38 54 39 57
8 Rayo Majadahonda Rayo 38 62 52 55
9 Atlético de Pinto Atlético 38 46 47 54
10 Colmenar Viejo Colmenar 38 62 63 54
11 Trival Valderas Trival 38 55 51 53
12 Móstoles Móstoles 38 53 47 52
13 Puerta Bonita Puerta 38 53 59 52
14 AD Parla AD Parla 38 44 53 51
15 Atlético de Madrid C Atlético 38 52 52 50
16 CDA Navalcarnero Navalcarnero 38 44 46 49
17 CD San Fernando Fernando 38 45 49 47
18 Vallecas Vallecas 38 41 72 35
19 Las Rozas Las Rozas 38 42 79 24
20 Coslada Coslada 38 27 81 21
TEMPORADA 2009/2010
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Las Rozas Las Rozas 34 64 26 79
2 CF Pozuelo CF Pozuelo 34 61 18 74
3 Coslada Coslada 34 75 36 71
4 Alcobendas Alcobendas 34 65 42 62
5 AD Torrejón CF Torrejón 34 68 50 58
6 Unión Adarve Unión 34 53 41 54
7 Torrelodones Torrelodones 34 53 50 44
8 Villanueva del Pardillo Villanueva 34 52 53 44
9 Vicálvaro Vicálvaro 34 46 51 43
10 Aravaca Aravaca 34 36 48 43
11 Tres Cantos Tres Cantos 34 43 56 42
12 Dosa Dosa 34 47 55 41
13 Brunete Brunete 34 58 67 41
14 CUC Villalba Villalba 34 40 50 41
15 Moratalaz Moratalaz 34 42 58 35
16 Rayo Majadahonda Sub 19 B Rayo 34 37 44 32
17 EFMO Boadilla EFMO 34 33 59 30
18 Mejoreño Mejoreño 34 34 103 15
TEMPORADA 2008/2009
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CD San Fernando Fernando 34 69 23 79
2 Colmenar Viejo Colmenar 34 75 24 76
3 AD Torrejón CF Torrejón 34 70 34 66
4 Coslada Coslada 34 61 35 61
5 Unión Adarve Unión 34 59 46 58
6 Alcobendas Alcobendas 34 62 47 54
7 Aravaca Aravaca 34 57 51 52
8 Brunete Brunete 34 57 56 51
9 Vicálvaro Vicálvaro 34 47 51 45
10 Rayo Majadahonda Sub 19 B Rayo 34 52 61 42
11 Tres Cantos Tres Cantos 34 45 63 41
12 Moratalaz Moratalaz 34 49 55 40
13 Loeches Loeches 34 40 61 39
14 RSD Alcalá B Alcalá 34 45 51 37
15 Atl. León Castilla Atl. León C. 34 51 71 32
16 Gandarío Sanse Gandarío 34 54 95 29
17 Montijo Montijo 34 43 77 26
18 G. Pegaso B G. Pegaso B 34 34 69 26
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 RSD Alcalá RSD Alcalá 38 58 29 67
2 Getafe B Getafe B 38 52 33 67
3 CD San Fernando Fernando 38 37 28 62
4 AD Parla AD Parla 38 43 29 62
5 Atlético de Pinto Atlético 38 48 37 60
6 Ciempozuelos Ciempozuelos 38 61 42 60
7 Real Madrid C Real Madrid 38 53 38 59
8 CDA Navalcarnero Navalcarnero 38 58 54 58
9 Móstoles Móstoles 38 55 43 56
10 Rayo Majadahonda Rayo 38 41 32 52
11 Paracuellos Antamira Paracuellos 38 48 59 48
12 Atlético de Madrid C Atlético 38 43 47 47
13 Las Rozas Las Rozas 38 30 42 46
14 Rayo Vallecano B Rayo 38 38 41 46
15 Puerta Bonita Puerta 38 32 42 45
16 CUC Villalba Villalba 38 31 39 45
17 Pegaso Pegaso 39 37 45 42
18 Coslada Coslada 38 47 63 41
19 DAV Santa Ana Santa 38 40 54 39
20 Colonia Ofigevi Colonia 39 32 50 38
21 Colmenar Viejo Colmenar 38 38 75 32
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 38 80 31 80
2 AD Parla AD Parla 38 52 25 75
3 EM Cobeña EM Cobeña 38 49 40 66
4 Getafe B Getafe B 38 48 33 65
5 Atlético de Pinto Atlético 38 51 32 60
6 Galáctico Pegaso Galáctico 38 47 34 59
7 Ciempozuelos Ciempozuelos 38 42 38 56
8 Rayo Vallecano B Rayo 38 44 41 51
9 Rayo Majadahonda Rayo 38 37 37 50
10 Coslada Coslada 38 43 50 50
11 CD San Fernando Fernando 38 32 37 49
12 CDA Navalcarnero Navalcarnero 38 47 44 48
13 Las Rozas Las Rozas 38 28 29 48
14 DAV Santa Ana Santa 38 37 46 46
15 CUC Villalba Villalba 38 33 44 45
16 Atlético de Madrid C Atlético 38 39 46 44
17 RCD Carabanchel Carabanchel 38 35 46 44
18 CD Colonia Moscardó Colonia 38 28 53 38
19 Leganés B Leganés B 38 28 55 32
20 Real Aranjuez CF Real 38 27 66 25
TEMPORADA 2003/2004
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Móstoles Móstoles 38 64 31 71
2 Galáctico Pegaso Galáctico 38 56 39 69
3 Atlético de Pinto Atlético 38 72 36 68
4 Las Rozas Las Rozas 38 44 31 66
5 AD Torrejón CF Torrejón 38 73 53 65
6 CDA Navalcarnero Navalcarnero 38 55 36 64
7 CD San Fernando Fernando 38 50 46 59
8 Ciempozuelos Ciempozuelos 38 54 52 56
9 Rayo Vallecano B Rayo 38 51 47 53
10 AD Parla AD Parla 38 55 49 53
11 Leganés B Leganés B 38 52 49 50
12 DAV Santa Ana Santa 38 49 52 49
13 Atlético de Madrid C Atlético 38 56 55 48
14 Real Aranjuez CF Real 38 61 60 48
15 Orcasitas Orcasitas 38 43 46 48
16 Real Madrid C Real Madrid 38 48 44 47
17 Tornado Tornado 38 40 64 44
18 Coslada Coslada 38 34 67 30
19 RCD Carabanchel Carabanchel 38 34 85 24
20 Puerta Bonita Puerta 38 32 81 20
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 UD Sanse UD Sanse 40 70 39 78
2 Las Rozas Las Rozas 40 51 26 75
3 CDA Navalcarnero Navalcarnero 40 59 41 72
4 Móstoles Móstoles 40 58 42 69
5 Fuenlabrada Fuenlabrada 40 53 34 66
6 Atlético de Pinto Atlético 40 60 45 64
7 Rayo Vallecano B Rayo 40 70 50 62
8 Leganés B Leganés B 40 58 60 59
9 DAV Santa Ana Santa 40 57 52 58
10 Orcasitas Orcasitas 40 54 48 58
11 Real Madrid C Real Madrid 40 67 66 56
12 CD San Fernando Fernando 40 49 51 54
13 Puerta Bonita Puerta 40 44 41 53
14 Rayo Majadahonda Rayo 40 52 59 53
15 Galáctico Pegaso Galáctico 40 53 56 50
16 Mejoreño Mejoreño 40 47 48 47
17 AD Parla AD Parla 40 56 60 45
18 AD Torrejón CF Torrejón 40 47 64 45
19 Coslada Coslada 40 42 80 41
20 At. Valdemoro Valdemoro 40 40 60 34
21 Real Aranjuez CF Real 40 25 90 21

  USO DE MEMORIA  
7,920,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1277
Total Execution Time  0.1289
  CADENA URL  
/historico/Coslada
  GET DATOS  
$_GET['/historico/Coslada']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=843 AND type_rel = 2
0.0026  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 = '843' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '843' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73536 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=843 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73536,68740) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73536 AND teamId = 843
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68740 AND teamId = 843
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '843' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '843' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '843' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 843 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.0034  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 = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 843 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 843 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 843 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039  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 = 68740 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.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 59964 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 51263 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 44759 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 39190 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 33953 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 16701 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 3994 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2679 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 1990 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 1463 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 1117 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 852 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 291 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 92 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 22119 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 22084 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 22052 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC