4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tardelcuende
TEMPORADA 2023/2024
1ª CASTILLA Y LEÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Langa Langa 28 66 37 70
2 Golmayo Camaretas Golmayo 28 66 21 64
3 Tardelcuende Tardelcuende 27 61 22 55
4 Visontium Visontium 27 59 31 51
5 Valeranica Valeranica 28 58 43 49
6 Calasanz de Soria Calasanz 28 48 33 46
7 San Esteban San Esteban 28 49 34 45
8 Quintana Quintana 28 41 47 39
9 Norma San Leonardo Norma 28 55 65 36
10 CD San José B José 28 48 51 36
11 Piqueras Piqueras 28 42 38 34
12 Covaleda Covaleda 27 37 57 28
13 Castroviejo Castroviejo 27 39 63 25
14 CD Navaleno CD Navaleno 28 28 55 20
15 Abejar Abejar 28 38 73 20
16 Arcos Arcos 28 21 86 8
TEMPORADA 2022/2023
1ª CASTILLA Y LEÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Langa Langa 28 67 30 68
2 Valeranica Valeranica 28 63 30 57
3 Tardelcuende Tardelcuende 28 52 29 57
4 San Esteban San Esteban 28 68 36 56
5 Calasanz de Soria Calasanz 28 67 44 56
6 Golmayo Camaretas Golmayo 28 54 32 55
7 CD San José B José 28 67 56 40
8 Quintana Quintana 28 47 50 31
9 Castroviejo Castroviejo 28 38 45 30
10 Piqueras Piqueras 28 44 53 29
11 Visontium Visontium 28 43 54 27
12 Covaleda Covaleda 28 30 67 23
13 CD Navaleno CD Navaleno 28 39 64 22
14 Norma San Leonardo Norma 28 32 62 22
15 Arcos Arcos 28 31 90 18
16 Federado Soria de Fútbol Federado 0 0 0 0
TEMPORADA 2021/2022
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Becerril Becerril 30 59 12 75
2 Unami CP Unami CP 30 68 24 74
3 Turégano Turégano 30 53 28 59
4 Palencia Cristo Atlético B Palencia 30 72 42 56
5 CD San José José 30 55 44 54
6 CD Villamuriel Villamuriel 30 67 49 49
7 CD La Granja Granja 30 59 45 48
8 CF Briviesca Briviesca 30 45 36 46
9 Villarcayo Nela Villarcayo 30 37 39 42
10 Calasanz de Soria Calasanz 30 50 54 37
11 SC Uxama SC Uxama 30 46 53 37
12 Polideportivo Salas Polideportiv 30 35 55 29
13 Racing Lermeño CF Racing 30 37 58 29
14 Monteresma Atalaya Monteresma 30 35 87 23
15 CD Burgalés Burgalés 30 21 50 22
16 Tardelcuende Tardelcuende 30 10 73 5
17 Real Burgos CF Real Burgos 0 0 0 0
TEMPORADA 2020/2021
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Unami CP Unami CP 20 40 12 49
2 CD San José José 20 34 20 38
3 SC Uxama SC Uxama 20 30 16 35
4 Turégano Turégano 20 23 16 31
5 Calasanz de Soria Calasanz 20 37 33 28
6 Tardelcuende Tardelcuende 20 28 27 23
7 A. Candeleda Candeleda 20 24 37 23
8 Monteresma Atalaya Monteresma 20 28 33 22
9 Bosco de Arévalo Bosco 20 18 34 22
10 Abejar Abejar 20 12 30 13
11 San Esteban San Esteban 20 19 35 11
TEMPORADA 2019/2020
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 DiocesÁvila - UCAV DiocesÁvila 24 55 15 58
2 Cebrereña Cebrereña 24 50 20 53
3 SC Uxama SC Uxama 24 39 19 50
4 CF Briviesca Briviesca 24 41 20 47
5 Unami CP Unami CP 24 42 34 45
6 Castilla Palencia Castilla 24 47 23 42
7 CD San José José 24 28 20 40
8 Palencia CF Palencia CF 24 41 35 36
9 Turégano Turégano 24 39 32 32
10 Villarcayo Nela Villarcayo 24 27 23 32
11 Racing Lermeño CF Racing 24 34 41 29
12 CD Villamuriel Villamuriel 24 27 31 27
13 San Esteban San Esteban 24 29 46 26
14 Tardelcuende Tardelcuende 24 36 42 20
15 Carejas Paredes Carejas 24 28 42 20
16 Calasanz de Soria Calasanz 24 28 42 20
17 Vista Alegre CD Vista Alegre 24 29 61 17
18 A. Candeleda Candeleda 24 10 84 6
TEMPORADA 2018/2019
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Becerril Becerril 32 65 14 73
2 Mirandés B Mirandés B 32 71 26 72
3 DiocesÁvila - UCAV DiocesÁvila 32 97 25 70
4 Unami CP Unami CP 32 72 34 60
5 Villarcayo Nela Villarcayo 32 44 38 60
6 Castilla Palencia Castilla 31 77 47 55
7 CD Villamuriel Villamuriel 32 45 38 53
8 CD San José José 32 39 25 49
9 Racing Lermeño CF Racing 32 44 42 41
10 Tardelcuende Tardelcuende 32 54 58 41
11 Calasanz de Soria Calasanz 31 45 71 34
12 Palencia CF Palencia CF 32 39 50 33
13 CD Cuéllar Balompié Cuéllar 32 49 70 33
14 Venta De Baños Venta Baños 32 37 68 28
15 El Espinar-San Rafael Espinar-San 32 37 88 26
16 Arandina CF B Arandina 32 32 63 25
17 Bosco Arévalo Bosco 32 20 110 12
18 CD Palencia Balompié Palencia 0 0 0 0
TEMPORADA 2017/2018
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CF Briviesca Briviesca 34 78 30 79
2 CD La Granja Granja 34 86 29 78
3 Unami CP Unami CP 34 78 27 76
4 DiocesÁvila - UCAV DiocesÁvila 34 83 37 65
5 Mirandés B Mirandés B 34 66 37 61
6 Racing Lermeño CF Racing 34 52 43 55
7 Villarcayo Nela Villarcayo 34 44 39 53
8 CD Villamuriel Villamuriel 34 51 42 47
9 CD Palencia Balompié Palencia 34 53 56 47
10 Castilla Palencia Castilla 34 50 58 46
11 Tardelcuende Tardelcuende 34 44 70 46
12 El Espinar-San Rafael Espinar-San 34 41 70 38
13 Palencia CF Palencia CF 34 27 45 36
14 CD Univ. Burgos Univ. Burgos 34 42 57 35
15 CD Raudense CD Raudense 34 43 74 28
16 Carejas Paredes Carejas 34 24 56 25
17 Norma San Leonardo Norma 34 38 72 23
18 Polideportivo Salas Polideportiv 34 32 90 19
TEMPORADA 2016/2017
1ª CASTILLA Y LEÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Tardelcuende Tardelcuende 24 61 17 62
2 Abejar Abejar 24 57 22 51
3 Sampedrana Sampedrana 23 38 20 49
4 Piqueras Piqueras 24 37 26 38
5 Arcos Arcos 24 46 48 37
6 Quintana Quintana 23 36 36 35
7 Calasanz de Soria Calasanz 24 56 56 33
8 Castroviejo Castroviejo 24 33 44 33
9 CD San José B José 24 29 31 29
10 Valeranica Valeranica 24 41 53 24
11 Langa Langa 24 44 45 23
12 Visontium Visontium 24 26 55 14
13 CD Navaleno CD Navaleno 24 31 82 7
TEMPORADA 2015/2016
1ª CASTILLA Y LEÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Abejar Abejar 26 84 22 68
2 Norma Norma 26 74 26 67
3 Tardelcuende Tardelcuende 26 49 29 52
4 Piqueras Piqueras 26 47 31 48
5 Calasanz de Soria Calasanz 26 49 43 45
6 Langa Langa 26 52 51 42
7 Valeranica Valeranica 26 51 39 38
8 Sampedrana Sampedrana 26 35 31 33
9 CD Navaleno CD Navaleno 26 56 62 31
10 Quintana Quintana 26 41 55 28
11 Arcos Arcos 26 45 62 24
12 Visontium Visontium 26 31 73 19
13 Castroviejo Castroviejo 26 22 56 15
14 Covaleda Covaleda 26 16 72 12
TEMPORADA 2014/2015
1ª CASTILLA Y LEÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Arcos Arcos 28 93 35 70
2 Tardelcuende Tardelcuende 28 76 32 62
3 San Esteban San Esteban 26 72 42 54
4 Valeranica Valeranica 28 50 47 42
5 Langa Langa 28 46 54 41
6 Covaleda Covaleda 28 45 44 40
7 Abejar Abejar 24 41 33 39
8 Sampedrana Sampedrana 28 49 41 36
9 Calasanz de Soria Calasanz 28 54 59 36
10 Norma Norma 28 45 53 34
11 CD Navaleno CD Navaleno 28 51 65 31
12 Quintana Quintana 26 51 61 30
13 Visontium Visontium 28 41 60 29
14 Piqueras Piqueras 24 38 66 20
15 Castroviejo Castroviejo 28 28 88 9

  USO DE MEMORIA  
6,019,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4105
Total Execution Time  0.4117
  CADENA URL  
/historico/Cd-Tardelcuende-Senior
  GET DATOS  
$_GET['/historico/Cd-Tardelcuende-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0294  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 = 73779
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=53401 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1298 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1298 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0150  SELECT /*53 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 (1312772,1202745,912076,807251,716314) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = '53401' 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 = '53401' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73779 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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 = 53401 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73779 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.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 `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 = 69053 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.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 `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 = 63673 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.0148  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 = 59995 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.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 `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 = 51275 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 44674 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 = 39359 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 `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 = 34575 AND t.round = 26 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 `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 = 16931 AND t.round = 26 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 = 7731 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC