4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Arces
TEMPORADA 2023/2024
1ª CASTILLA Y LEÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Villa de Simancas Villa 27 69 29 61
2 UD Sur UD Sur 27 79 50 60
3 CD Victoria CF Victoria 27 70 35 56
4 Atlético Tordesillas B Atlético 27 63 41 51
5 Boecillo Boecillo 26 70 46 45
6 La Pedraja La Pedraja 26 48 47 43
7 Unión Arroyo Unión 27 47 56 39
8 Rioseco Rioseco 27 57 48 38
9 Arces Arces 27 46 46 37
10 Universidad de Valladolid Universidad 27 47 54 33
11 CD Medinense Medinense 27 43 72 31
12 Betis CF B Betis CF B 27 55 58 31
13 Racing Valdestillas Racing 27 38 41 28
14 CD San Agustin Agustin 26 52 69 22
15 CD Laguna B CD Laguna B 26 35 77 20
16 Rayo Cenobia Rayo Cenobia 27 26 76 7
TEMPORADA 2022/2023
1ª CASTILLA Y LEÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Gimnástica Medinense Gimnástica 30 79 42 75
2 Universidad de Valladolid Universidad 30 86 28 66
3 Betis CF B Betis CF B 30 59 37 52
4 Rioseco Rioseco 30 57 51 47
5 Unión Arroyo Unión 30 70 58 46
6 Rayo Cenobia Rayo Cenobia 30 61 52 46
7 Boecillo Boecillo 30 61 57 45
8 Racing Valdestillas Racing 30 38 45 43
9 CD San Agustin Agustin 30 63 65 42
10 UD Sur UD Sur 30 60 62 42
11 Atlético Tordesillas B Atlético 30 50 52 38
12 Arces Arces 30 51 60 33
13 CD Don Bosco Bosco 30 55 79 30
14 M. Olmedo M. Olmedo 30 43 73 24
15 Parquesol Parquesol 30 30 69 21
16 San Pío X San Pío X 30 38 71 17
TEMPORADA 2021/2022
1ª CASTILLA Y LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Rioseco Rioseco 18 39 21 35
2 Universidad de Valladolid Universidad 18 37 21 35
3 CD San Agustin Agustin 18 40 23 33
4 CD Victoria CF Victoria 18 29 16 33
5 Parquesol Parquesol 18 38 25 31
6 Boecillo Boecillo 18 27 26 27
7 UD Sur UD Sur 18 39 45 27
8 Arces Arces 18 30 40 23
9 CD Don Bosco Bosco 18 25 42 13
10 Racing de Mayorga Racing 18 11 56 3
TEMPORADA 2019/2020
2ª CASTILLA Y LEÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Unión Arroyo Unión 23 40 19 45
2 San Jose Jesuitas Jose 22 56 32 43
3 CD Medinense Medinense 23 50 35 41
4 Arces Arces 22 34 25 39
5 San Nicolas San Nicolas 23 48 44 39
6 Rueda Rueda 21 50 37 35
7 Betis CF B Betis CF B 22 47 44 29
8 La Cisterniga B Cisterniga 21 35 45 29
9 Atlético Portillo Atlético 22 34 42 28
10 San Pío X San Pío X 22 40 30 26
11 Pedrajas Pedrajas 23 25 35 26
12 San Agustín Valladolid B Agustín 22 35 47 26
13 Rayo Cenobia Rayo Cenobia 22 35 48 26
14 Belen Belen 23 36 53 26
15 Santovenia Santovenia 21 35 39 24
16 Tudela Tudela 22 33 58 21
TEMPORADA 2018/2019
2ª CASTILLA Y LEÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Racing de Mayorga Racing 30 90 55 62
2 Racing Valdestillas Racing 30 61 36 59
3 CD Victoria CF Victoria 30 73 51 58
4 San Pío X San Pío X 30 64 42 49
5 San Jose Jesuitas Jose 29 72 50 48
6 Unión Arroyo Unión 30 58 50 48
7 La Cisterniga B Cisterniga 30 59 59 46
8 Pedrajas Pedrajas 30 52 55 40
9 San Nicolas San Nicolas 30 59 66 39
10 Atlético Portillo Atlético 30 38 55 39
11 Arces Arces 30 54 58 37
12 Santovenia Santovenia 29 45 55 37
13 Tudela Tudela 30 43 59 37
14 Renedo de Esgueva Renedo 30 55 68 33
15 Viana Cega Viana Cega 30 54 95 23
16 Juventud Rondilla B Juventud 30 33 56 21
TEMPORADA 2017/2018
2ª CASTILLA Y LEÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Villa de Simancas B Villa 30 68 18 70
2 Atlético Tordesillas B Atlético 30 88 42 65
3 CD Don Bosco Bosco 30 71 46 60
4 San Pío X San Pío X 30 59 38 58
5 Santovenia Santovenia 30 53 45 49
6 Racing de Mayorga Racing 30 81 69 46
7 Viana Cega Viana Cega 30 52 44 45
8 Atlético Portillo Atlético 30 46 40 43
9 Racing Valdestillas Racing 30 45 48 38
10 Tudela Tudela 30 53 62 36
11 Unión Arroyo Unión 30 51 60 36
12 Pedrajas Pedrajas 30 50 70 35
13 Arces Arces 30 47 72 28
14 Juventud Rondilla B Juventud 30 44 81 26
15 CD Victoria CF Victoria 30 52 70 23
16 San Isidro San Isidro 30 35 90 13
TEMPORADA 2016/2017
1ª CASTILLA Y LEÓN GRUPO 8
Equipo PJ GF GC Puntos
1 La Cisterniga Cisterniga 20 60 22 47
2 Gimnástica Medinense Gimnástica 20 46 17 41
3 Boecillo Boecillo 20 36 17 39
4 La Pedraja La Pedraja 20 59 26 37
5 CD San Agustin Agustin 20 54 27 36
6 Juventud Rondilla Juventud 20 56 33 35
7 Navarrés Navarrés 20 37 22 35
8 Rioseco Rioseco 20 33 22 35
9 M. Olmedo M. Olmedo 20 52 37 34
10 U.D.C. Sur U.D.C. Sur 20 31 35 27
11 Mojados B Mojados B 20 29 38 25
12 Belen Belen 20 39 53 20
13 Villa de Simancas B Villa 20 39 50 19
14 Arces Arces 20 34 46 16
15 Rueda Rueda 20 26 51 14
16 San Isidro San Isidro 20 12 147 0
TEMPORADA 2015/2016
1ª CASTILLA Y LEÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Universidad de Valladolid Universidad 29 90 17 77
2 CD San Agustin Agustin 30 94 34 65
3 La Pedraja La Pedraja 30 79 38 59
4 Gimnástica Medinense Gimnástica 29 63 42 53
5 Boecillo Boecillo 30 52 35 52
6 Arces Arces 30 48 46 47
7 Villa de Simancas B Villa 29 48 47 42
8 M. Olmedo M. Olmedo 30 52 65 38
9 La Cisterniga Cisterniga 29 46 49 36
10 Rueda Rueda 30 45 60 35
11 Belen Belen 30 47 57 35
12 Santovenia Santovenia 30 38 57 34
13 CD Victoria CF Victoria 30 56 75 31
14 Viana Cega Viana Cega 30 42 69 25
15 Parquesol Parquesol 30 33 65 23
16 Arroyo Pisuerga Arroyo 26 27 104 4
TEMPORADA 2014/2015
1ª CASTILLA Y LEÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Laguna CD Laguna CD 30 82 19 79
2 UD Sur UD Sur 30 82 44 58
3 Gatos Iscar Gatos Iscar 30 50 48 50
4 Parquesol Parquesol 30 62 42 49
5 Boecillo Boecillo 30 41 29 48
6 Arces Arces 30 57 50 45
7 CD Victoria CF Victoria 30 57 65 44
8 Belen Belen 30 65 63 41
9 Santovenia Santovenia 30 61 64 41
10 CD San Agustin Agustin 30 65 64 39
11 M. Olmedo M. Olmedo 30 45 65 37
12 Viana Cega Viana Cega 30 57 65 36
13 U. Zaratán U. Zaratán 30 52 81 30
14 San Nicolas San Nicolas 30 46 71 29
15 Cabezon Cabezon 30 44 67 28
16 Pedrajas Pedrajas 30 47 76 19

  USO DE MEMORIA  
5,829,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0996
Total Execution Time  0.1008
  CADENA URL  
/historico/Cd-Arces-Senior
  GET DATOS  
$_GET['/historico/Cd-Arces-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0031  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 = 'Cd-Arces-Senior' 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.0018  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=10529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=10529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73906
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10529 AND type_rel = 2
0.0022  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 = '10529' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '10529' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '10529' 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 = 73906 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=10529 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73906) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73906 AND teamId = 10529
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 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 = 73906 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '10529' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '10529' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027  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 = 73906 WHERE rp.league_id = 73906 AND rp.teamId = 10529 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.0026  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 = 73906 WHERE rp.league_id = 73906 AND rp.teamId = 10529 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 73906 WHERE rp.league_id = 73906 AND rp.teamId = 10529 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 10529 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032  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 = 73906 AND t.round = 28 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 `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 = 69054 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.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 `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 = 65692 AND t.round = 18 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 = 51498 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 44677 AND t.round = 30 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 `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 = 39820 AND t.round = 30 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 `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 = 34576 AND t.round = 20 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 `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 = 16932 AND t.round = 30 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 `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 = 7732 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC