4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alcobendas
TEMPORADA 2023/2024
1ª REGIONAL MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 AD Esperanza Esperanza 0 0 0 0
2 Alcobendas Alcobendas 0 0 0 0
3 Carranza Carranza 0 0 0 0
4 CD Avance CD Avance 0 0 0 0
5 CD Canillas B Canillas 0 0 0 0
6 CD San Roque EFF Roque 0 0 0 0
7 CF Valdebebas Valdebebas 0 0 0 0
8 Chopera Alcobendas 04 Chopera 0 0 0 0
9 Complutense Alcala Complutense 0 0 0 0
10 Daganzo Daganzo 0 0 0 0
11 EM Cobeña EM Cobeña 0 0 0 0
12 Esc. de Futbol Concepcion B Esc. Futbol 0 0 0 0
13 Henares DIV Henares DIV 0 0 0 0
14 Juventud Sanse A Juventud 0 0 0 0
15 Racing Veracruz Racing 0 0 0 0
16 Rayo Ciudad Alcobendas Rayo Ciudad 0 0 0 0
17 Santos de la Humosa Santos 0 0 0 0
18 Sporting Hortaleza B Sporting 0 0 0 0
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 1
Equipo PJ GF GC Puntos
1 Galapagar Galapagar 19 44 16 45
2 CDF Tres Cantos Tres Cantos 19 41 15 45
3 CF San Agustín Agustín 19 35 19 35
4 Alcobendas Alcobendas 19 33 23 35
5 CD Moraleja Futbol Moraleja 19 34 22 34
6 Colmenar Viejo Colmenar 19 33 30 34
7 Aravaca Aravaca 19 39 20 32
8 San Sebastián Reyes B Sebastián 19 32 30 28
9 CD Canillas CD Canillas 19 28 22 27
10 Periso CF Periso CF 19 26 22 27
11 CUC Villalba Villalba 19 23 23 27
12 EF Concepción A Concepción 19 25 24 26
13 Sporting Hortaleza Sporting 19 31 32 26
14 CD Avance CD Avance 19 22 24 24
15 Rayo Ciudad Alcobendas Rayo Ciudad 19 23 21 23
16 AD Torrejon CF B Torrejon 19 21 34 18
17 Barrio Pilar Barrio Pilar 19 18 37 12
18 CD San Roque EFF Roque 19 30 48 11
19 Dosa Dosa 19 22 53 11
20 Atletico Villalba Atletico 19 10 55 4
TEMPORADA 2019/2020
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Complutense Alcala Complutense 23 37 23 46
2 Villanueva del Pardillo Villanueva 23 32 19 42
3 CD San Roque EFF Roque 23 34 28 42
4 CD Canillas CD Canillas 23 23 18 39
5 Periso CF Periso CF 23 40 24 37
6 CF San Agustín Agustín 23 39 27 37
7 Alcobendas Alcobendas 23 25 21 34
8 CDF Tres Cantos Tres Cantos 23 32 29 34
9 Galapagar Galapagar 23 33 23 33
10 Atletico Villalba Atletico 23 35 32 33
11 CD Moraleja Futbol Moraleja 23 28 25 33
12 Aravaca Aravaca 23 28 27 29
13 Rayo Ciudad Alcobendas Rayo Ciudad 23 20 23 26
14 Sporting Hortaleza Sporting 23 23 32 26
15 AD Torrejon CF B Torrejon 23 25 38 18
16 EF Concepción A Concepción 23 22 44 17
17 Dosa Dosa 23 22 43 16
18 Barrio Pilar Barrio Pilar 23 15 37 16
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
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Atlético B Atlético B 38 63 40 73
2 Unión Adarve Unión 38 55 41 66
3 Paracuellos Antamira Paracuellos 38 49 28 63
4 CD Móstoles Móstoles 38 62 41 62
5 Leganés B Leganés B 38 57 45 62
6 Getafe B Getafe B 38 54 35 60
7 Atlético de Pinto Atlético 38 36 30 58
8 RSD Alcalá RSD Alcalá 38 36 28 57
9 Internacional de Madrid Internaciona 38 52 40 56
10 DAV Santa Ana Santa 38 43 54 53
11 SAD Villaverde Villaverde 38 41 52 49
12 CD San Fernando Fernando 38 44 43 49
13 Alcorcón B Alcorcón B 38 40 46 48
14 CF Pozuelo CF Pozuelo 38 40 35 48
15 Rayo Vallecano B Rayo 38 57 49 47
16 Trival Valderas Trival 38 44 48 46
17 Alcobendas Alcobendas 38 29 37 44
18 Aravaca Aravaca 38 36 64 38
19 Villanueva del Pardillo Villanueva 38 21 57 31
20 AD Parla AD Parla 38 21 67 19
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
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Rayo Majadahonda Rayo 38 67 38 71
2 Paracuellos Antamira Paracuellos 38 59 39 64
3 CDA Navalcarnero Navalcarnero 38 43 37 64
4 Alcorcón B Alcorcón B 38 57 41 63
5 Unión Adarve Unión 38 40 31 63
6 UD Sanse UD Sanse 38 47 32 62
7 Internacional de Madrid Internaciona 38 48 42 60
8 RSD Alcalá RSD Alcalá 38 41 29 56
9 Real Madrid C Real Madrid 38 50 40 55
10 CF Pozuelo CF Pozuelo 38 46 45 54
11 AD Parla AD Parla 38 47 39 53
12 Atlético de Pinto Atlético 38 44 42 52
13 Atlético de Madrid C Atlético 38 53 66 49
14 Puerta Bonita Puerta 38 42 44 47
15 CD Móstoles Móstoles 38 44 46 46
16 CD San Fernando Fernando 38 35 42 44
17 Villanueva del Pardillo Villanueva 38 37 51 43
18 Alcobendas Alcobendas 38 35 49 36
19 Colmenar Viejo Colmenar 38 35 65 35
20 AD Torrejón CF Torrejón 38 22 74 20
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
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Vicálvaro Vicálvaro 34 62 30 72
2 Unión Adarve Unión 34 59 32 64
3 AD Torrejón CF Torrejón 34 65 43 61
4 Alcobendas Alcobendas 34 54 35 59
5 Dosa Dosa 34 73 50 57
6 CUC Villalba Villalba 34 63 50 57
7 Aravaca Aravaca 34 53 50 49
8 Villanueva del Pardillo Villanueva 34 56 60 49
9 DAV Santa Ana Santa 34 49 46 48
10 Unión Tres Cantos Unión Tres 34 40 44 45
11 CD Canillas CD Canillas 34 39 54 41
12 Torrelodones Torrelodones 34 36 36 40
13 RSD Alcalá B Alcalá 34 40 48 39
14 Cd Recuerdo Cd Recuerdo 34 55 61 37
15 San Sebastián Reyes B Sebastián 34 50 63 36
16 Brunete Brunete 34 48 61 36
17 Dehesa Luis Ii Dehesa Luis 34 37 74 24
18 AD Fundación Fundación 34 41 83 18
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 1994/1995
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 DAV Santa Ana Santa 42 69 42 56
2 Leganés B Leganés B 42 74 38 55
3 Rayo Majadahonda Rayo 42 69 50 54
4 RCD Carabanchel Carabanchel 42 67 49 54
5 Galáctico Pegaso Galáctico 42 60 56 50
6 Colmenar Viejo Colmenar 42 56 50 47
7 Fuencarral Fuencarral 42 69 49 46
8 Las Rozas Las Rozas 42 67 54 44
9 AD Parla AD Parla 42 72 56 43
10 SAD Villaverde Villaverde 42 48 49 43
11 Mejoreño Mejoreño 42 53 58 41
12 Rayo Vallecano B Rayo 42 51 52 41
13 CD San Fernando Fernando 42 51 60 41
14 Orcasitas Orcasitas 42 64 62 40
15 AD Torrejón CF Torrejón 42 53 54 39
16 Coslada Coslada 42 51 68 37
17 Getafe B Getafe B 42 59 59 37
18 Vicálvaro Vicálvaro 42 36 51 36
19 Puerta Bonita Puerta 42 47 61 35
20 Alcobendas Alcobendas 42 53 74 32
21 Alcorcón Alcorcón 42 51 76 31
22 El Álamo El Álamo 42 40 92 22

  USO DE MEMORIA  
7,385,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.7233
Total Execution Time  0.7253
  CADENA URL  
/historico/Soto-Alcobendas
  GET DATOS  
$_GET['/historico/Soto-Alcobendas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0153  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 = 'Soto-Alcobendas' 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.0145  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=2367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2367 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2367 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151  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 (93129,158332,166496,198783,455338) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '2367' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '2367' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '2367' 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 = 73664 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=2367 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 (73664) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73664 AND teamId = 2367
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 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 = 73664 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '2367' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2367' and rp.type = 4
0.0151  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 = '2367' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0172  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 = 73664 WHERE rp.league_id = 73664 AND rp.teamId = 2367 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.0155  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 = 73664 WHERE rp.league_id = 73664 AND rp.teamId = 2367 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 73664 WHERE rp.league_id = 73664 AND rp.teamId = 2367 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 2367 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73664 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.0297  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.0150  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 = 63727 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.0155  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 = 59963 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.0150  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 = 51262 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.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 `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.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 = 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.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 `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 = 33357 AND t.round = 38 ORDER BY team.conference 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 `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.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 `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 = 3917 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 `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.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 `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.0155  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.0150  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 = 1127 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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.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 `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.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 `tables1995` 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 = 21929 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC