4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Langa Langa 28 66 37 70
2 Golmayo Camaretas Golmayo 28 66 21 64
3 Tardelcuende Tardelcuende 28 65 23 58
4 Visontium Visontium 29 63 32 57
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 29 42 49 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 28 38 61 28
13 Castroviejo Castroviejo 28 39 65 25
14 CD Navaleno CD Navaleno 28 28 55 20
15 Abejar Abejar 28 38 73 20
16 Arcos Arcos 28 21 86 8
Ver
TEMPORADA 2022/2023
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
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Vista Alegre CD Vista Alegre 23 67 8 62
2 Belorado Belorado 23 58 15 59
3 CD Juventud CD Juventud 24 53 26 52
4 Gamonal Gamonal 24 49 27 46
5 Vadillos Vadillos 24 57 36 40
6 CD Raudense CD Raudense 23 39 29 37
7 Capiscol Capiscol 24 45 40 37
8 Aranda Riber Aranda Riber 24 57 58 27
9 Villarcayo Nela B Villarcayo 23 30 40 20
10 Alcazar CD Alcazar CD 24 25 53 19
11 San Felices San Felices 23 21 58 17
12 San Cristóbal Castilla Cristóbal 24 16 68 12
13 Montija Montija 23 20 79 6
14 Real Burgos CF SAD B Real Burgos 0 0 0 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Real Salamanca Monterrey Real 15 44 7 34
2 Guijuelo B Guijuelo B 15 34 21 33
3 Ribert B Ribert B 15 38 15 30
4 M. Pizarrales Pizarrales 15 34 21 30
5 Villares de La Reina Villares 15 29 28 25
6 Carbajosa De La Sagrada Carbajosa 15 29 20 24
7 Ciudad Rodrigo Cf B Ciudad 15 14 35 17
8 Villamayor Villamayor 14 26 34 16
9 Alba Tormes Alba Tormes 15 17 25 16
10 Jai Alai Bolivar Alai Bolivar 15 19 30 16
11 Helmántica B Helmántica 14 23 36 11
12 Atlético El Encinar Atlético 15 9 44 3
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Turégano Turégano 24 86 20 58
2 Monteresma Atalaya Monteresma 24 58 18 56
3 Cantimpalos Cantimpalos 24 47 37 46
4 Cantalejo Cantalejo 24 44 25 43
5 Villacastín Racing Villacastín 24 47 31 35
6 CP Carbonero Carbonero 24 25 29 32
7 Gimnastica Ayllonesa Gimnastica 24 37 50 29
8 Arcangel Arcangel 24 39 57 25
9 Sporting Nava Sporting 24 27 45 25
10 Sporting Riazano Sporting 24 30 54 24
11 Pradena Pradena 24 42 67 24
12 CD Coca CD Coca 24 37 64 21
13 Mozoncillo Mozoncillo 24 28 50 20
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Ribert Ribert 24 87 24 63
2 Salamanca UDS B Salamanca 24 94 23 62
3 CDF Helmántico Helmántico 24 65 26 49
4 CD Navega CD Navega 24 68 46 42
5 Helmántica B Helmántica 24 48 43 37
6 Real Salamanca Monterrey Real 24 33 41 34
7 Chamberi Chamberi 24 39 45 28
8 Guijuelo B Guijuelo B 24 38 53 26
9 Villares de La Reina Villares 24 34 56 26
10 Villamayor Villamayor 24 28 54 23
11 Capuchinos Capuchinos 24 41 73 19
12 M. Pizarrales Pizarrales 24 27 51 17
13 Jai Alai Bolivar Alai Bolivar 24 26 93 10
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Hergar Camelot Hergar 22 78 20 53
2 Salamanca UDS B Salamanca 22 76 19 53
3 Real Salamanca Monterrey Real 22 67 36 44
4 CDF Helmántico Helmántico 22 78 33 40
5 Helmántica B Helmántica 22 59 42 40
6 Villamayor Villamayor 22 54 38 39
7 Guijuelo B Guijuelo B 22 43 46 25
8 Villares de La Reina Villares 22 35 57 25
9 Alba Tormes Alba Tormes 22 36 51 23
10 M. Pizarrales Pizarrales 22 49 54 21
11 Capuchinos Capuchinos 22 32 75 15
12 Cristo Rey Barrio Vidal Cristo 22 20 156 4
13 Sporting Garrido de Salaman Sporting 0 0 0 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Salamanca UDS Salamanca 20 51 18 49
2 Hergar Camelot Hergar 20 46 26 40
3 CDF Helmántico Helmántico 20 51 27 35
4 Villamayor Villamayor 20 37 29 32
5 Unionistas Salamanca B Unionistas 20 44 42 30
6 Real Salamanca Monterrey Real 19 37 39 27
7 Villares de La Reina Villares 20 46 49 24
8 Alba Tormes Alba Tormes 19 34 56 17
9 M. Pizarrales Pizarrales 20 30 35 17
10 Guijuelo B Guijuelo B 20 27 48 17
11 Helmántica B Helmántica 20 33 67 11
12 Atlético El Encinar Atlético 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Unionistas CF Unionistas 20 66 9 53
2 CDF Helmántico Helmántico 20 49 22 38
3 Hergar Camelot Hergar 20 52 25 37
4 Real Salamanca Monterrey Real 20 35 27 32
5 Alba Tormes Alba Tormes 20 36 30 32
6 Villamayor Villamayor 20 42 40 29
7 M. Pizarrales Pizarrales 20 27 33 26
8 Guijuelo B Guijuelo B 20 20 38 21
9 Helmántica B Helmántica 20 30 66 17
10 Cantalapiedra Cantalapiedr 20 23 51 13
11 Carbajosa S. B Carbajosa 20 24 63 10
12 Monterrubio Monterrubio 0 0 0 0

  USO DE MEMORIA  
5,943,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1780
Total Execution Time  0.1800
  CADENA URL  
/primera_castilla_y_leon2024/grupo5/historico
  GET DATOS  
$_GET['/primera_castilla_y_leon2024/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_castilla_y_leon' AND (l.group_code = 5 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=5 DESC LIMIT 1
0.0019  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.0025  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.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1298 ORDER BY order_id ASC
0.0021  SELECT dt.nameShow,dt.basealias,t.id,t.teamId 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.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1298 AND group_code = 5 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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.0038  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 = 65696 AND t.round = 26 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 = 51313 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 45160 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 39780 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 34573 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 16923 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 7729 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 16:44:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 16:44:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 16:44:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 16:44:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0541  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73779 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73779 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0203  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73779 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73779 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0042  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73779 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73779 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  SELECT *,(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 = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC