4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Valdoncina
TEMPORADA 2023/2024
1ª CASTILLA Y LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Toreno Toreno 26 69 11 71
2 Sariegos del Bernesca Sariegos 26 98 29 61
3 Arenas De Vega Arenas Vega 27 63 38 52
4 CDF Cubillos Cubillos 26 47 32 48
5 La Virgen del Camino B Virgen 26 47 31 46
6 Laciana Laciana 25 49 47 41
7 Atlético Pinilla Atlético 26 47 52 38
8 CDF San Andrés Andrés 26 48 46 38
9 CD Ejido CD Ejido 26 51 43 36
10 Naraya De Halterofilia Naraya 26 50 52 34
11 Santa Ana FS Santa 27 26 59 27
12 A. Paramés A. Paramés 26 37 56 26
13 La Valdoncina Valdoncina 25 37 57 24
14 Toralense Toralense 25 33 54 17
15 Lliones Lliones 26 37 93 17
16 Villadepalos Villadepalos 25 20 59 15
TEMPORADA 2022/2023
1ª CASTILLA Y LEÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Toreno Toreno 28 68 27 64
2 Laciana Laciana 28 82 46 63
3 CD La Bañeza Bañeza 28 61 36 57
4 Veguellina CF Veguellina 28 42 26 54
5 CD Ejido CD Ejido 28 81 45 51
6 Arenas De Vega Arenas Vega 28 66 46 48
7 Naraya De Halterofilia Naraya 28 69 48 45
8 La Virgen del Camino B Virgen 28 54 35 45
9 Atlético Pinilla Atlético 28 71 80 37
10 Santa Ana FS Santa 28 41 53 32
11 A. Paramés A. Paramés 28 48 60 30
12 La Valdoncina Valdoncina 28 43 63 30
13 Villadepalos Villadepalos 28 27 79 18
14 Toralense Toralense 28 23 75 14
15 Lliones Lliones 28 35 92 10
16 Benavides Benavides 0 0 0 0
TEMPORADA 2021/2022
1ª CASTILLA Y LEÓN GRUPO 8
Equipo PJ GF GC Puntos
1 CD Onzonilla Onzonilla 32 85 27 77
2 Toreno Toreno 32 76 35 71
3 Naraya De Halterofilia Naraya 32 77 45 64
4 A. Paramés A. Paramés 32 76 51 64
5 Laciana Laciana 32 78 59 61
6 Veguellina CF Veguellina 32 69 36 56
7 Atlético Pinilla Atlético 32 80 53 56
8 La Virgen del Camino B Virgen 31 65 48 55
9 Arenas De Vega Arenas Vega 32 64 65 46
10 Villadepalos Villadepalos 32 44 61 37
11 La Valdoncina Valdoncina 32 58 68 36
12 CD Ejido CD Ejido 32 59 74 31
13 Ribera Carrizo Ribera 32 48 86 26
14 Santa Ana FS Santa 32 45 79 25
15 Benavides Benavides 31 35 72 25
16 Toralense Toralense 32 52 86 18
17 CD Bosco CD Bosco 32 36 102 14
TEMPORADA 2019/2020
1ª CASTILLA Y LEÓN GRUPO 3
Equipo PJ GF GC Puntos
1 A. Mansillés Mansillés 22 55 20 57
2 Veguellina CF Veguellina 22 45 26 37
3 CD Bosco CD Bosco 22 43 35 37
4 Atlético Pinilla Atlético 22 39 20 36
5 La Virgen del Camino B Virgen 22 40 22 34
6 Villadepalos Villadepalos 22 33 36 34
7 A. Paramés A. Paramés 22 40 29 33
8 Toralense Toralense 22 37 36 33
9 Naraya De Halterofilia Naraya 22 35 39 32
10 CD Ejido CD Ejido 22 29 30 27
11 Toreno Toreno 22 27 29 26
12 Laciana Laciana 21 26 39 23
13 La Valdoncina Valdoncina 22 28 50 22
14 Arenas De Vega Arenas Vega 22 30 36 21
15 Benavides Benavides 22 29 46 21
16 Santa Ana FS Santa 23 12 55 13
TEMPORADA 2018/2019
2ª CASTILLA Y LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 La Valdoncina Valdoncina 24 61 29 49
2 Lliones Lliones 24 53 38 47
3 Boñar Boñar 23 48 42 39
4 Villabalter Villabalter 24 47 40 34
5 Onzonilla B Onzonilla B 24 47 50 29
6 Ribera Carrizo Ribera 24 47 62 23
7 Soto De La Vega Soto Vega 23 29 71 12
TEMPORADA 2017/2018
2ª CASTILLA Y LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Laciana Laciana 26 90 26 67
2 Atlético Pinilla Atlético 26 83 26 64
3 La Valdoncina Valdoncina 26 62 43 51
4 Ribera Carrizo Ribera 26 56 45 43
5 Boñar Boñar 26 56 70 35
6 Villabalter Villabalter 26 54 54 31
7 Lliones Lliones 26 47 55 26
8 Onzonilla B Onzonilla B 26 57 67 22
9 Caboalles De Abajo Caboalles 26 42 89 21
10 Soto De La Vega Soto Vega 26 36 108 12
TEMPORADA 2016/2017
2ª CASTILLA Y LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Benavides Benavides 26 109 34 62
2 Fútbol Eria Fútbol Eria 26 90 31 61
3 La Robla La Robla 26 87 39 61
4 Villabalter Villabalter 26 68 38 54
5 Atlético Pinilla Atlético 26 80 49 46
6 Lliones Lliones 25 69 52 46
7 La Valdoncina Valdoncina 26 59 43 42
8 Ribera Carrizo Ribera 26 53 49 39
9 Sahagún P. Sahagún P. 26 44 72 25
10 Soto De La Vega Soto Vega 26 47 85 22
11 Onzonilla B Onzonilla B 26 50 78 20
12 Garaballes Garaballes 25 31 120 15
13 Caboalles De Abajo Caboalles 26 50 88 14
14 Boñar Boñar 26 27 86 14
TEMPORADA 2015/2016
1ª CASTILLA Y LEÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Júpiter Leonés Júpiter 29 64 19 70
2 Ponferradina B Ponferradina 29 66 18 63
3 Fabero Fabero 30 54 33 58
4 Dehesas Dehesas 29 48 31 50
5 N. Halterofilia Halterofilia 29 57 42 50
6 CD Bosco CD Bosco 30 59 39 49
7 S. Francisco Francisco 29 61 44 45
8 Laciana Laciana 29 48 48 37
9 Toralense Toralense 29 52 56 36
10 Villadepalos Villadepalos 29 30 35 35
11 V. Espinareda Espinareda 29 38 51 33
12 Toreno Toreno 29 38 48 33
13 A. Mansillés Mansillés 29 43 66 32
14 La Robla La Robla 29 31 53 32
15 La Valdoncina Valdoncina 29 24 71 16
16 Matarrosa Matarrosa 29 27 86 15
TEMPORADA 2014/2015
1ª CASTILLA Y LEÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Laciana Laciana 30 75 31 64
2 La Virgen del Camino B Virgen 30 54 26 59
3 S. Francisco Francisco 30 60 28 58
4 V. Espinareda Espinareda 30 63 43 51
5 Toreno Toreno 30 52 33 51
6 Dehesas Dehesas 30 50 44 50
7 Fabero Fabero 30 48 35 49
8 A. Mansillés Mansillés 30 47 44 44
9 N. Halterofilia Halterofilia 30 48 50 44
10 CD Bosco CD Bosco 30 49 42 43
11 La Valdoncina Valdoncina 30 56 46 42
12 Toralense Toralense 30 39 54 30
13 La Robla La Robla 29 39 58 28
14 Matarrosa Matarrosa 29 29 71 22
15 Atlético Pinilla Atlético 30 33 76 19
16 C. Abajo C. Abajo 30 34 95 12

  USO DE MEMORIA  
5,724,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4200
Total Execution Time  0.4221
  CADENA URL  
/historico/C-D-Santovenia-De-La-Valdoncina-Senior
  GET DATOS  
$_GET['/historico/C-D-Santovenia-De-La-Valdoncina-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0114  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 = 'C-D-Santovenia-De-La-Valdoncina-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.0106  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=53347 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=53347 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0217  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 = 73777
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=53347 AND type_rel = 2
0.0111  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 = '53347' ORDER BY l.year DESC,cat.coefficient DESC
0.0110  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 = '53347' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '53347' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = 73777 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=53347 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (73777) 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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 73777 AND teamId = 53347
0.0109  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 = 73777 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0106  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 = '53347' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0115  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 = '53347' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0116  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 = 73777 WHERE rp.league_id = 73777 AND rp.teamId = 53347 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.0114  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 = 73777 WHERE rp.league_id = 73777 AND rp.teamId = 53347 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 73777 WHERE rp.league_id = 73777 AND rp.teamId = 53347 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 53347 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 = 73777 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.0113  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 = 69051 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.0112  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 = 65699 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.0113  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 = 51311 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.0107  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 = 45261 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 39818 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 34597 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 16921 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 7724 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73777 ORDER BY nameShow LIMIT 100