4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del El Espinar-San Rafael
TEMPORADA 2023/2024
1ª CASTILLA Y LEÓN GRUPO 6
Equipo PJ GF GC Puntos
1 CD Coca CD Coca 27 78 29 61
2 Cantimpalos Cantimpalos 26 65 37 56
3 Real Sitio Real Sitio 28 73 38 52
4 El Espinar-San Rafael Espinar-San 27 78 45 50
5 CP Carbonero Carbonero 26 62 35 50
6 Monteresma Atalaya Monteresma 24 67 41 49
7 Sporting Nava Sporting 26 61 47 44
8 CD Cuéllar Balompié Cuéllar 26 68 54 39
9 Villacastín Racing Villacastín 27 59 67 37
10 Cantalejo Cantalejo 27 47 46 34
11 CD San Lorenzo Lorenzo 27 42 68 32
12 Mozoncillo Mozoncillo 27 45 51 28
13 Turégano B Turégano B 27 44 76 27
14 Unami B Unami B 26 32 74 16
15 Cabezuela CP Cabezuela 25 30 95 8
16 Sporting Riazano Sporting 14 14 62 0
TEMPORADA 2022/2023
1ª CASTILLA Y LEÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Monteresma Atalaya Monteresma 30 97 47 70
2 Real Sitio Real Sitio 29 87 38 62
3 Villacastín Racing Villacastín 30 57 34 57
4 CD Coca CD Coca 30 78 45 54
5 CP Carbonero Carbonero 30 60 34 54
6 El Espinar-San Rafael Espinar-San 28 75 57 50
7 Cantimpalos Cantimpalos 29 51 43 43
8 Mozoncillo Mozoncillo 30 44 46 43
9 CD San Lorenzo Lorenzo 28 39 35 42
10 Sporting Riazano Sporting 30 65 77 38
11 Cabezuela CP Cabezuela 29 68 81 37
12 Cantalejo Cantalejo 30 37 53 32
13 Gimnastica Ayllonesa Gimnastica 30 40 55 31
14 CD Claret CD Claret 30 34 60 25
15 Pradena Pradena 29 38 93 17
16 CD La Granja B Granja 30 31 103 9
TEMPORADA 2021/2022
1ª CASTILLA Y LEÓN GRUPO 12
Equipo PJ GF GC Puntos
1 CD Cuéllar Balompié Cuéllar 30 112 33 78
2 Real Sitio Real Sitio 30 81 39 65
3 El Espinar-San Rafael Espinar-San 29 71 38 65
4 CD Coca CD Coca 29 54 24 64
5 Villacastín Racing Villacastín 30 69 26 59
6 Gimnastica Ayllonesa Gimnastica 30 62 53 49
7 Sporting Riazano Sporting 28 61 77 43
8 CD Claret CD Claret 29 46 47 39
9 Cantimpalos Cantimpalos 30 52 64 38
10 Mozoncillo Mozoncillo 30 48 62 35
11 Cantalejo Cantalejo 30 38 53 34
12 Pradena Pradena 30 55 79 34
13 CP Carbonero Carbonero 30 35 35 33
14 Atlético Hontanares Atlético 30 38 78 19
15 Sierra de la Mujer Muerta Sierra Mujer 30 37 100 11
16 IE University Athletics University 29 47 98 10
TEMPORADA 2019/2020
1ª CASTILLA Y LEÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Monteresma Atalaya Monteresma 19 48 20 44
2 El Espinar-San Rafael Espinar-San 21 66 33 43
3 Villacastín Racing Villacastín 20 49 19 43
4 CD Cuéllar Balompié Cuéllar 21 66 37 41
5 CP Carbonero Carbonero 20 35 25 31
6 Cantalejo Cantalejo 20 31 38 30
7 Cantimpalos Cantimpalos 20 44 38 27
8 Pradena Pradena 21 43 48 27
9 Gimnastica Ayllonesa Gimnastica 20 36 41 25
10 Mozoncillo Mozoncillo 21 25 40 23
11 Sierra de la Mujer Muerta Sierra Mujer 21 37 55 21
12 Sporting Riazano Sporting 20 24 39 20
13 CD Coca CD Coca 21 32 66 20
14 Sporting Nava Sporting 20 22 41 15
15 IE University Athletics University 19 38 56 14
16 Arcangel Arcangel 0 0 0 0
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
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Burgos CF Real Burgos 34 86 22 85
2 Becerril Becerril 34 79 20 83
3 CD La Granja Granja 34 70 21 74
4 DiocesÁvila - UCAV DiocesÁvila 34 78 31 72
5 Unami CP Unami CP 34 67 31 69
6 Racing Lermeño CF Racing 34 54 41 58
7 CF Briviesca Briviesca 34 71 51 56
8 CD Univ. Burgos Univ. Burgos 34 45 42 45
9 Palencia CF Palencia CF 34 33 41 45
10 El Espinar-San Rafael Espinar-San 34 47 59 45
11 Norma Norma 34 48 65 36
12 Villarcayo Nela Villarcayo 34 46 60 35
13 Castilla Palencia Castilla 34 32 70 33
14 Polideportivo Salas Polideportiv 34 34 53 32
15 San Esteban San Esteban 34 42 74 32
16 Venta De Baños Venta Baños 34 32 77 23
17 Bosco Arévalo Bosco 34 35 104 22
18 Gamonal Gamonal 34 36 73 21
TEMPORADA 2015/2016
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Ávila Real Ávila 33 80 14 81
2 CD San José José 33 69 16 76
3 Unami CP Unami CP 33 72 19 70
4 CD La Granja Granja 33 61 25 67
5 Polideportivo Salas Polideportiv 33 56 37 65
6 CF Briviesca Briviesca 33 64 36 56
7 Real Burgos CF Real Burgos 33 41 42 50
8 Venta De Baños Venta Baños 33 38 45 48
9 Villarcayo Nela Villarcayo 33 42 47 44
10 Burgos CF B Burgos CF B 33 43 52 37
11 Racing Lermeño CF Racing 33 41 51 37
12 Palencia CF Palencia CF 33 44 48 34
13 Bosco Arévalo Bosco 33 27 62 32
14 San Esteban San Esteban 33 41 79 27
15 Arandina CF B Arandina 33 39 71 26
16 CD Sotillo CD Sotillo 33 47 81 26
17 El Espinar-San Rafael Espinar-San 33 43 75 25
18 Mombeltran Mombeltran 17 10 58 0
TEMPORADA 2008/2009
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Lermeño CF Racing 30 80 25 70
2 Venta De Baños Venta Baños 30 61 20 66
3 Atlético Candeleda Atlético 30 70 51 54
4 Polideportivo Salas Polideportiv 30 64 52 51
5 Palencia Cristo Atlético Palencia 30 50 27 50
6 El Espinar-San Rafael Espinar-San 30 66 52 50
7 Cuéllar Cuéllar 30 55 46 44
8 Vadillos Vadillos 30 50 41 42
9 CD Villamuriel Villamuriel 30 35 39 42
10 SC Uxama SC Uxama 30 41 52 42
11 CD Navaleno CD Navaleno 30 51 57 41
12 Bosco Arévalo Bosco 30 41 53 35
13 Unami CP Unami CP 30 43 44 34
14 Mirandés B Mirandés B 30 34 47 33
15 Castilla Dueñas Castilla 30 34 62 24
16 Real Ávila B Real Ávila 30 43 86 18
17 Las Navas Las Navas 30 22 93 6

  USO DE MEMORIA  
5,999,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1091
Total Execution Time  0.1103
  CADENA URL  
/historico/Espinar-San-Rafael
  GET DATOS  
$_GET['/historico/Espinar-San-Rafael']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0029  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 = 'Espinar-San-Rafael' 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=969 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=969 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 73780
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=969 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1298 AND type_rel = 3
0.0020  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.0024  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.0024  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 = '969' ORDER BY l.year DESC,cat.coefficient DESC
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 = '969' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '969' 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 = 73780 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=969 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 (73780) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73780 AND teamId = 969
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 = '969' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '969' and rp.type = 4
0.0021  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 = '969' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73780 WHERE rp.league_id = 73780 AND rp.teamId = 969 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.0029  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 = 73780 WHERE rp.league_id = 73780 AND rp.teamId = 969 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73780 WHERE rp.league_id = 73780 AND rp.teamId = 969 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 969 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73780 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.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 `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 = 69050 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.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 `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 = 65703 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.0029  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 = 51314 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.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 `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.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 = 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.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 `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 = 33974 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 = 16749 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 `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 = 292 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC