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 CD Coca CD Coca 25 74 26 57
2 Cantimpalos Cantimpalos 25 63 37 53
3 CP Carbonero Carbonero 25 62 33 50
4 Real Sitio Real Sitio 27 69 37 49
5 Monteresma Atalaya Monteresma 24 67 41 49
6 El Espinar-San Rafael Espinar-San 25 70 41 47
7 Sporting Nava Sporting 25 58 44 43
8 Villacastín Racing Villacastín 26 58 65 37
9 CD Cuéllar Balompié Cuéllar 25 64 54 36
10 CD San Lorenzo Lorenzo 27 42 68 32
11 Mozoncillo Mozoncillo 25 44 46 28
12 Cantalejo Cantalejo 25 42 44 28
13 Turégano B Turégano B 25 44 67 27
14 Unami B Unami B 24 30 71 13
15 Cabezuela CP Cabezuela 25 30 95 8
16 Sporting Riazano Sporting 14 14 62 0
Ver
TEMPORADA 2022/2023
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
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CD Cervera CD Cervera 20 56 19 52
2 Carejas Paredes Carejas 20 73 8 51
3 Astudillo Astudillo 20 44 33 31
4 UD Alar UD Alar 20 26 38 31
5 Atlético Aguilar Atlético 20 37 27 30
6 Saldaña Saldaña 20 32 31 29
7 Villada Villada 20 39 42 23
8 Guardense Guardense 20 30 47 22
9 Carrion Carrion 20 28 47 22
10 Cd Velilla Cd Velilla 20 33 55 15
11 Barruelo Barruelo 20 22 73 6
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Piqueras Piqueras 26 52 16 61
2 San Esteban San Esteban 26 72 23 58
3 Sampedrana Sampedrana 26 62 22 53
4 Valeranica Valeranica 26 51 28 47
5 Norma Norma 26 67 30 46
6 CD San José B José 26 59 30 41
7 Abejar Abejar 26 46 26 40
8 Quintana Quintana 26 43 29 40
9 Arcos Arcos 26 37 52 31
10 Castroviejo Castroviejo 25 32 39 29
11 Langa Langa 26 32 47 27
12 Visontium Visontium 25 30 46 23
13 CD Navaleno CD Navaleno 26 23 107 8
14 Golmayo Camaretas Golmayo 26 14 125 7
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Turégano Turégano 26 77 19 65
2 CD Cuéllar Balompié Cuéllar 25 74 35 51
3 Monteresma Atalaya Monteresma 26 37 43 43
4 Sporting Riazano Sporting 26 47 48 41
5 Arcangel Arcangel 26 64 50 39
6 Cantalejo Cantalejo 26 42 32 39
7 CP Carbonero Carbonero 26 51 44 38
8 C.D. Quintanar Palacio C.D. 25 41 34 36
9 Pradena Pradena 26 63 70 32
10 Cantimpalos Cantimpalos 26 49 67 31
11 Mozoncillo Mozoncillo 26 32 42 30
12 Gimnastica Ayllonesa Gimnastica 26 39 61 28
13 R. Villacastin Villacastin 26 47 69 23
14 Cabezuela CP Cabezuela 26 35 84 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 C.D. Quintanar Palacio C.D. 26 73 31 59
2 Arcangel Arcangel 26 65 34 51
3 Cantalejo Cantalejo 26 60 39 50
4 Monteresma Atalaya Monteresma 26 72 34 47
5 Turégano Turégano 26 53 39 44
6 CP Carbonero Carbonero 26 41 37 37
7 Pradena Pradena 26 59 49 35
8 Mozoncillo Mozoncillo 26 37 41 34
9 R. Villacastin Villacastin 26 52 66 33
10 Cantimpalos Cantimpalos 26 56 53 31
11 Sporting Riazano Sporting 26 38 57 29
12 CD Cuéllar Balompié Cuéllar 26 39 66 23
13 IE University Athletics University 26 44 88 20
14 CD San Lorenzo Lorenzo 26 35 90 16
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Monteresma Atalaya Monteresma 24 82 25 59
2 Cantalejo Cantalejo 24 64 29 49
3 Arcangel Arcangel 23 68 32 47
4 Turégano Turégano 23 54 40 42
5 Sporting Nava Sporting 24 61 41 38
6 Pradena Pradena 24 54 45 37
7 C.D. Quintanar Palacio C.D. 24 53 49 35
8 Sporting Riazano Sporting 24 40 43 32
9 R. Villacastin Villacastin 23 37 48 28
10 Mozoncillo Mozoncillo 24 32 48 25
11 CP Carbonero Carbonero 23 35 47 24
12 CD Cuéllar Balompié Cuéllar 24 30 53 21
13 Polideportivo Sepúlveda Polideportiv 24 10 120 1
14 Unami B Unami B 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 San Rafael San Rafael 13 26 17 27
2 Monteresma Atalaya Monteresma 13 26 16 24
3 Sporting Nava Sporting 13 29 27 23
4 Segoviana B Segoviana B 12 28 20 21
5 Cantalejo Cantalejo 12 20 16 20
6 Pradena Pradena 13 19 21 18
7 Unami B Unami B 12 23 20 17
8 R. Villacastin Villacastin 12 23 22 15
9 Arcangel Arcangel 12 19 21 15
10 CP Carbonero Carbonero 12 17 21 13
11 Puentecanto Puentecanto 12 22 27 13
12 Turégano Turégano 12 19 25 13
13 Mozoncillo Mozoncillo 12 14 20 12
14 Polideportivo Sepúlveda Polideportiv 12 20 32 7

  USO DE MEMORIA  
5,973,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.4874
Total Execution Time  0.4903
  CADENA URL  
/primera_castilla_y_leon2024/grupo6/historico
  GET DATOS  
$_GET['/primera_castilla_y_leon2024/grupo6/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0145  SELECT type FROM routes WHERE alias = 'primera_castilla_y_leon2024'
0.0293  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 = 6 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=6 DESC LIMIT 1
0.0144  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1298 ORDER BY order_id ASC
0.0147  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 = 73780 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1298 AND group_code = 6 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 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.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 = 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.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 `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 = 65697 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.0155  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.0159  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 = 45161 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 39781 AND t.round = 26 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 = 34574 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 `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 = 16930 AND t.round = 26 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 `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 = 7730 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:58:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0273  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 = 73780 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73780 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.0273  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 = 73780 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73780 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0160  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 = 73780 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73780 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 = 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